https://bugs.documentfoundation.org/show_bug.cgi?id=162330
Bug ID: 162330
Summary: Calc claims A = B, and B = C, but A != C
Product: LibreOffice
Version: 24.2.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In the attached spreadsheet, stripped from a more complex one, there's a few
calculations, which finally "end" in two cells C11 / C12, containing the same
value.
Well, "same value" is something which seems to be difficult to decide for Calc:
It claims that the first cell's value is equal to -22,67 (shown in E11), and it
claims that the second cell's value is equal to -22,67 (shown in E12).
However, as shown in E13, it claims that the first cell's value does *not*
equal the second cell's value. This is... surprising, isn't it?
Note:
- If you replace the formula in C7 with its value, the problem disappears.
- If you replace the "C$8 + C$9" in the formula in cell C12 with its result
value, the problem disappears.
Steps to Reproduce:
1. open the attached file
2. go to the second sheet
Actual Results:
- cell C12 is not empty (which should only happen in case of two calculated
values being different)
Expected Results:
cell C12 is empty
Reproducible: Always
User Profile Reset: No
Additional Info:
no other information available
--
You are receiving this mail because:
You are the assignee for the bug.
