https://bugs.documentfoundation.org/show_bug.cgi?id=144359
Uwe Auer <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution|--- |NOTABUG --- Comment #4 from Uwe Auer <[email protected]> --- (In reply to Edward Redondo from comment #3) > > "This is the correct behavior, and should not change." You HAVE to be > kidding?! > Incorrect data being allowed IS a problem, and at the very lest should > prompt a warning. "09/081/2021" is a valid text string an not incorrect data. Imagine you are a manufacturer and you spare parts are numbered this way. What bug report will you write if you - every time you enter such value getting a warning that your part number (text) is an invalid date --or-- - you get it turned into a date without notice You have been explained that formatting a cell is not an *input* filter and that there is a functionality called "data validity" (Data -> Validity), which allows to create a customized validity check of data entered into cells. -- You are receiving this mail because: You are the assignee for the bug.
