https://bugs.documentfoundation.org/show_bug.cgi?id=148223
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #3 from Mike Kaganski <[email protected]> --- (In reply to Jonny Grant from comment #2) > Why is "36/04/2021" not rejected, as it is formatted as a Date? The format > doesn't change to Text. Because Calc does not insist on converting any string that you type into the cell into a number, no matter how the cell is formatted. You may format a cell as Date, and type "Lorem ipsum" into it, and it will not turn into an error. Any entered string is *checked* if it's convertible into a number, if the cell formatting allows; but when the detection tells that no, it's not possible to convert, then the string is accepted as is, as a string. And no, Calc does not "show "Err:511" etc" when you "type something invalid"; only produces errors when *a formula* is erroneous or produces an error. And then, the same logic applies - the entered string it attempted to be converted into a formula; and when it starts with specific characters (= or - or +), it *can*, so then the error handling and display is appropriate. This is the correct behavior. Closing NOTABUG. -- You are receiving this mail because: You are the assignee for the bug.
