https://bugs.documentfoundation.org/show_bug.cgi?id=91503
Bug ID: 91503
Summary: Spurious values when subtracting via IF-THEN function
Product: LibreOffice
Version: 4.4.3.2 rc
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 115864
--> https://bugs.documentfoundation.org/attachment.cgi?id=115864&action=edit
PrintScreen of Calc with spurious numbers
I'm doing some calculation based in value status and when subtracting via
IF-THEN function I received spurious numbers. See below:
Column D Column E
Line 6 0,96000000000000000000 0,01000000000000000000
Line 7 0,96000000000000000000 0,00000000000000000000
Line 8 0,95000000000000000000 0,04999999999999990000
Function in Column E is:
In pt-BR (my lang) or in en-US (I suppose)
Line 7 SE(E6;E6-0,01;1-D7) IF(E6;E6-0.01;1-D7)
Line 8 SE(E7;E7-0,01;1-D8) IF(E7;E7-0.01;1-D8)
PS: same data in a PrintScreen attachment.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
