https://bugs.documentfoundation.org/show_bug.cgi?id=94271
Bug ID: 94271
Summary: Calculation in Calc is wrong
Product: LibreOffice
Version: 5.0.1.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Hi,
I used *.xls files under Libre Calc, which worked fine so far. Since I updated
to Libre Office 5.0.1.2 many results in the old files were wrong. I checked and
found out that the reference to the cells is still correct, but not the
calculated result of the cell referred to is used.
Example:
A1: 100, B1: 15, C1: =D1-B1; D1: 30
A2: =A1-C1
The result in this example should be 85, sometimes it is. In many cases it is
70, i.e. A1-D1. To me it seems that the calculation in C1 has not been made
correctly.
The files I have are rather big and I had this mistake in several tables in one
file.
The correct calculation could be reached by copying the cell A2 and inserting
it again. But it did not help to copy A2 and insert it into all cells A2 to
A...n.
I saved the file as ods-file, which didn't help.
Do you know this issue, any solutions ?
Thanks
Ralf
--
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
