[Libreoffice-bugs] [Bug 144359] LibreOffice allows entry of wrong dates for format

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144359

Edward Redondo <tecknode at tecknode.digitalspacemail17.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|RESOLVED                    |REOPENED
         Resolution|NOTABUG                     |---

--- Comment #3 from Edward Redondo <tecknode at tecknode.digitalspacemail17.net> ---
(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210908/c9b07b7d/attachment.htm>