Apache OpenOffice (AOO) Bugzilla – Issue 92785
[Data][Validity] dialog []Allow Blank Cells checkbox mislabeled
Last modified: 2022-10-28 12:54:33 UTC
When Allow = Cell Range the check box [] "Allow Blank Cells" should be identified as [] "Allow Empty Cells" Since... Ranges which contain character blanks pass validation and *ARE* allowed to be entered, even with check box cleared! Nothing dramatic. Simply more meaningful user interface. Blank not equal Empty. Empty not equal Blank.
When Cell range = a,b,c. Allow blank cells is checked: Tools - Detective - Mark Invalid Data -> doesn't mark an empty cell, marks a cell with space. Allow blank cells is unchecked: Tools - Detective - Mark Invalid Data -> marks both empty cell and cell with space. So Allow blank cells -> Allow empty cells. AOO410m1(Build:9750) - Rev. 1551264 2013-12-17_04:10:52 - Rev. 1551455 Debian
Created attachment 82127 [details] Patch for changing blank to empty in the label According to comments above.
"hanya" committed SVN revision 1559347 into trunk: #i92785# fix label from Allow blank cells to Allow empty cells on Criteria ta...
The label and related help paragraph was fixed on trunk.
Thank you hanya