[Libreoffice-bugs] [Bug 138827] New: Validity - not possible to accept all possible whole numbers by leaving value field blank

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138827
           Summary: Validity - not possible to accept all possible whole
                    numbers by leaving value field blank
           Product: LibreOffice
           Version: 6.3.6.2 release
          Hardware: x86 (IA32)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: regeirs.forum at gmail.com

Description:
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:
Version: 6.3.6.2
Build ID: 6.3.6.2-4.fc31
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

-- 
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/20201211/f705d18d/attachment.htm>