https://bugs.documentfoundation.org/show_bug.cgi?id=170416
--- Comment #1 from ady <[email protected]> --- I am not convinced that dealing with #FMT should be the same as with ###. Example: 1. On a new spreadsheet, narrow down the width of column A so only 4 characters could be seen (e.g. cell A1: 1234 and then narrow down the width of the column). 2. Cell A2: 12345 [enter]; the ### "error" is displayed on cell A2, while the numeric value is still usable. 3. Cell A3: 123456789 [enter]; the ### "error" is displayed on cell A3, while the numeric value is still usable. 4. Click once on the column A header, so all the cells in it are now selected. 5. Change the cell format to Date. 5.1. Cells A1 and A2 still show the same "###", whereas cell A3 shows "#FMT". While, in theory, all those numeric values are still "usable", the value in A3 (123456789) has no valid meaning as a Date (the internal serial number would be out of the valid range for a date). So, in theory, you could still use the value in cell A3, but the #FMT error is telling you that something else is probably "not quite correct". Showing the numeric value in the status bar instead of showing #FMT would "provide a misleading hint", instead of actually providing a real hint (as currently intended). -- You are receiving this mail because: You are the assignee for the bug.
