https://bugs.documentfoundation.org/show_bug.cgi?id=144359
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from Mike Kaganski <[email protected]> --- 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 -- You are receiving this mail because: You are the assignee for the bug.
