https://bugs.documentfoundation.org/show_bug.cgi?id=157856
Bug ID: 157856
Summary: BASIC macro not recognising sum 0.05+0.90 equals 0.95
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: cppj...@hotmail.com
Description:
It looks like I've found a bug when running a BASIC macro on LibreOffice Calc
(7.6.2.1 x86_64), which doesn't fault when I run it the same macro on Apache
OpenOffice calc (4.1.5 Build 9789 Rev 1817496 2017-12-11 17:25).
Two cells are summed; values 0.05 and 0.9, giving a sum of 0.95.
When LibreOffice runs the macro it returns a false to [0.05 plus 0.9 equaling
0.95], whereas OpenOffice returns true.
All involved cells are formatted as Category > Number and Format > General.
I tried changing “Decimal places:” under Options but that didn't make any
difference.
The workaround solution I found was changing the first cell value from “0.05”
to “=0.95-0.9” (not including the “” ofcourse).
I also tried “=1-0.95” which interestingly did not work.
The following might be a clue to the underlying bug: for the entries that
didn't work (“0.5” and “=1-0.95”), down the bottom right hand side of the
window it says “Sum: 0.05” as you'd expect, but for the entry that made it work
(“=0.95-0.9”) it says “Average: 0.0499999999999999; Sum: 0.0499999999999999”.
The “Sum:” value for “=0.95-0.9” on OpenOffice calc is 0.05 instead of
0.0499999999999999.
Steps to Reproduce:
1.Create 3 number cells with the following values: 0.05, 0.9, 0.95.
2.Run a BASIC macro to report if the first two cells equal the third cell.
3.It incorrectly behaves as if the 0.95 cell is not equal to 0.05 + 0.9
(returns false).
(More info in Description.)
Actual Results:
The only way I could get the macro to work was by changing the cell value from
"0.05" to "=0.95-0.9".
Expected Results:
OpenOffice's Calc's BASIC macro's "if" statement to return true regardless of
the first cell being "0.05" or "=0.95-0.9", as it does in OpenOffice calc.
OpenOffice's Calc's "Sum: " value should return "0.05" to "=0.95-0.9", as it
does in OpenOffice calc.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
