[Libreoffice-bugs] [Bug 141609] New: LibreCalc IF function incorrectly evaluates negative numbers

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 141609
           Summary: LibreCalc IF function incorrectly evaluates negative
                    numbers
           Product: LibreOffice
           Version: 7.0.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: chuckarnett2008 at gmail.com

Description:
My IF statement, comparing a negative sum in one cell to the sum of two
negative numbers from other cells, returns a false response when it should
return a true response. The IF statement is:
=IF(B18=B39+B59,"OK","No Match")
where B18 contains the formula =B8-B17 equal to (1,629.93), with B8 containing
=SUM(B3:B7) equal to 137,962.60, and B17 containing =SUM(B10:B16) equal to
139,592.53;
where B39 contains the formula =B29-B38 equal to (1,230.69), with B29
containing =SUM(B24:B28) equal to 136,936.06, and B38 containing =SUM(B31:B37)
equal to 138,166.75;
and where B59 contains the formula =B49-B58 equal to (399.24), with B49
containing =SUM(B44:B48) equal to 1,026.54, and B58 containing =SUM(B51:B57)
equal to 1,425.78.
So,B18=B39+B59 is (1,629.93)=(1,230.69)+(399.24), and is true. The IF statement
should return "OK" but it doesn't. Instead, it returns "No Match".
If I change the IF to read =IF(B18=B39+B59,"OK",B39+B59), it returns
(1,629.93). So it is doing the simple arithmetic correctly, but it does not
recognize that (1,629.93) is equal to (1,629.93). 

Steps to Reproduce:
1.See the attached Calc spreadsheet. The formula is in B79. The modified
version is in B80.
2.
3.

Actual Results:
The IF statement is evaluated as false. Similar statements (in cells B64
through B79) evaluating components are all true. It appears that the problem
only occurs when negative numbers are compared.

Expected Results:
The software should recognize that B18=B39+B59 is
(1,629.93)=(1,230.69)+(399.24) and is true.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.0.5.2 (x64)
Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a
CPU threads: 20; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

-- 
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/20210410/ea89cfb6/attachment.htm>