Bug 142568 - Cell validation allowing a blank cell even with the option unchecked
Summary: Cell validation allowing a blank cell even with the option unchecked
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-05-30 15:14 UTC by joaoemanuel1981
Modified: 2021-05-31 23:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description joaoemanuel1981 2021-05-30 15:14:38 UTC 
Cell validation allowing a blank cell even with the option unchecked. And with that, a cell that has defined validation and with the blank cell option unchecked may exist, something that should not be allowed, if the option was working.
Comment 1 m_a_riosv 2021-05-31 11:44:28 UTC 
Please attach a sample file.
Comment 2 [REDACTED] 2021-05-31 13:25:26 UTC 
(In reply to joaoemanuel1981 from comment #0)
> Cell validation allowing a blank cell even with the option unchecked. And
> with that, a cell that has defined validation and with the blank cell option
> unchecked may exist, something that should not be allowed, if the option was
> working.

According to LibreOffice help page [1] the option about "empty cells / blank cells" (documentation inaccuracy here) seems to be designed to have a different meaning than one may expect. This option assures, if used in conjunction with "Tools - Detective - Mark invalid Data", being marked as invalid data. It seems not to be designed to cause an "invalid data" error message (popup). 


[1] LibreOffice Help - Criteria: https://help.libreoffice.org/latest/en-US/text/scalc/01/12120100.html?&DbPAR=CALC&System=UNIX
Comment 3 joaoemanuel1981 2021-05-31 23:58:44 UTC 
(In reply to Uwe Auer from comment #2)
> (In reply to joaoemanuel1981 from comment #0)
> > Cell validation allowing a blank cell even with the option unchecked. And
> > with that, a cell that has defined validation and with the blank cell option
> > unchecked may exist, something that should not be allowed, if the option was
> > working.
> 
> According to LibreOffice help page [1] the option about "empty cells / blank
> cells" (documentation inaccuracy here) seems to be designed to have a
> different meaning than one may expect. This option assures, if used in
> conjunction with "Tools - Detective - Mark invalid Data", being marked as
> invalid data. It seems not to be designed to cause an "invalid data" error
> message (popup). 
> 
> 
> [1] LibreOffice Help - Criteria:
> https://help.libreoffice.org/latest/en-US/text/scalc/01/12120100.
> html?&DbPAR=CALC&System=UNIX

Well if you need Detective for that, then I'll close the bug. However, they could change this mentality of using the Detective and put the popup window.

Thanks for the reply.