Bug 138827 - Validity - not possible to accept all possible whole numbers by leaving value field blank
Summary: Validity - not possible to accept all possible whole numbers by leaving value...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86 (IA32) All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
Reported: 2020-12-11 16:51 UTC by Grobe
Modified: 2020-12-12 12:44 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Grobe 2020-12-11 16:51:03 UTC
The use of Validity doesn't simply restrict the cell to only accept whole numbers.
Easy workaround: In the Validity dialog box - Define any additional filter (less than or equal - and then insert a very big negative number).

The computer have two separate user accounts, the behaviour is the same for both.

Steps to Reproduce:
1. Select any range - eg. B2:B8
2. Open Validity
3. In the Criteria tab, select Allow = "Whole numbers" and mark "Allow empty cels". Don't touch anything else.
4. Click OK and back to spreadsheet
5. Select any cell in the range B2:B8 - say B2.
6. Enter any whole number, say 5.

Actual Results:
Error message "Invalid value" pops up.

Expected Results:
Should accept number 5 to be entered

Reproducible: Always

User Profile Reset: No

Additional Info:
Build ID:
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3; 
Locale: nb-NO (en_GB.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 m.a.riosv 2020-12-12 10:59:16 UTC
Sorry, but I don't think it is a bug, it could be a request for enhancement.
Maybe 'not equal' '0'
Comment 2 b. 2020-12-12 12:44:01 UTC
not tested with linux but same behaviour with below win ver., imho notabug, 

in the dialog box you define 'whole numbers' and additional! which 'whole numbers', the standard proposal is 'equal zero', and that works, after the steps from OP you can key in '0', 

if you change the definition below 'whole numbers' to e.g. 'valid range' and define 0 as minimum and 5 as maximum you can key in '5', but '6' or '4,5' produce error messages, 

with definition of a wider range also numbers like +/-8E307 will be accepted, 

this is understandable, comprehensible and sensible behavior, 

setting notabug, 

Version: (x64)
Build ID: 761a672d62df1891b9f4f367a499b220ab2b33fa
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win
Locale: de-DE (de_DE); UI: en-US