https://bz.apache.org/ooo/show_bug.cgi?id=127640
Issue ID: 127640
Issue Type: DEFECT
Summary: Calculations are randomly incorrect when 'Precision as
shown' is Off
Product: Calc
Version: 4.1.4
Hardware: PC
OS: Windows 8, 8.1
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: ui
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 86301
--> https://bz.apache.org/ooo/attachment.cgi?id=86301&action=edit
Example of when Calc randomly introduces a calculation error.
I created a simple Ledger to monitor my bank account. In one column, I enter
the End of Day (EOD) balance shown in my online account and compare it to the
calculated balance of the ledger. If they match, both numbers should appear in
Bold Blue type.
Calc is apparently calculating and comparing two-decimal digits as digits with
more than 20 decimals (the maximum allowed to be displayed), as the first error
displays when the numbers match up to 20 decimals.
There are more explanatory notes in the spreadsheet itself; however, the error
continues for several rows and then corrects itself for subsequent rows.
"Precision as shown" is OFF.
If it matters, Excel doesn't reproduce the error. In that program, "Precision
as displayed" is OFF.
There is a simple workaround using ROUND(); but one shouldn't have to round
numbers that are never more than two decimals to two decimals.
--
You are receiving this mail because:
You are the assignee for the issue.
