https://bugs.documentfoundation.org/show_bug.cgi?id=95311
Bug ID: 95311
Summary: EDITING: Wrong result on calculation, ok when opening
file then changes value when adding new values, works
on v. 4.3.7.2 and earlier versions.
Product: LibreOffice
Version: 5.0.2.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 119934
--> https://bugs.documentfoundation.org/attachment.cgi?id=119934&action=edit
Calculation error after adding time data to next row.
I have a spreadsheet with four columns to present start and stop times and
fifth column to calculate the hours. All of the columns are formatted in
[HH]:MM format and calculated in the fifth column to get the time with formula
(=(C9-B9)+(E9-D9)). So this has worked as expected in 4.3.7.2 and earlier
versions, but after trying some 4.4 release version earlier and now 5.0.2 it
does not work like it should anymore.
When I open my file with a 4.4 or later version the file shows ok, but if I add
data to new row or edit existing ones the calculations go off on fifth column.
Not always on all rows. Rewriting one of the first 4 columns with the same time
makes it to calculate that row correctly again. If I have only first two
columns filled it seems to directly show the same time on the fifth column as
the second column instead of doing the calculation.
Attaching a file where the error occurs (managed to recreate the error without
the original file, altough in this file the calculations seem to go negative
instead).
--
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
