https://bugs.documentfoundation.org/show_bug.cgi?id=144359
Edward Redondo <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Status|RESOLVED |REOPENED Resolution|NOTABUG |--- --- Comment #3 from Edward Redondo <[email protected]> --- (In reply to Mike Kaganski from comment #1) > Calc does *not* filter the entry based on cell format string. When your > input data does not match any numeric format, it is simply considered a > text. This is the correct behavior, and should not change. > > To filter input, there is a dedicated "validity" function [1], and you may > set your cells values to match some criteria, like being between some date > range (which would make sure that the input was numeric). > > Closing NOTABUG. > > [1] > https://help.libreoffice.org/latest/en-US/text/scalc/guide/validity. > html?DbPAR=CALC "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. -- You are receiving this mail because: You are the assignee for the bug.
