I have a cell where any attempt to enter a value gives “Invalid value”. I can clear the direct formatting and so it returns back to normal, but I am curious what format gives that behaviour (or where to look at, except to clear all formatting) ?
The cell was part of a bigger spreadsheet, but I reduced it to just one cell in a hope to be able to understand better the problem.
(the orange cell at A1 in the attached file)
locked_cell.ods (9.9 KB)