https://bugs.documentfoundation.org/show_bug.cgi?id=127334
Bug ID: 127334
Summary: Regression: Incompatible changes in date/time
arithmetic introduced between Version: 6.0.4.2 (x64)
and version 6.2.6.2 (ubuntu)
Product: LibreOffice
Version: 6.2.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: albrecht.muel...@astrail.de
Created attachment 153864
--> https://bugs.documentfoundation.org/attachment.cgi?id=153864&action=edit
Different versions of Calc show different results of a few trivial date/time
calculations
Description:
To my knowledge no agreed upon specification exists which describes how
LibreOffice shall handle time and date calculations (see bug 127170).
Unexpected behaviour seem to get fixed on an "ad hoc" basis, see bug 125099
which should be "RESOLVED FIXED" from version 6.2.5 on. However, I observed
this problem with version 6.2.6.2.
The attached example file reflects a situation where you have some kind of log
which contains date and time as separate entities. Time resolution is one
minute. In order to calculate durations you have to combine (= add) these date
and time values. The file contains 20 entries whose times differ by one minute
giving 19 time spans of one minute. These durations are formatted as time
values. An additional column uses the minutes function to calculate the minutes
count compares these values with the expected value which is always one. A cell
(D25) labeled "Errors:" sums up the differences between expected an calculated
values. This value should be zero.
How to reproduce:
Open attachment with different versions of Calc and observe the error count.
Actual results:
I observed that version 6.0.4.2 (x64) of Calc showed an error count of zero
while version 6.2.6.2 (ubuntu) gave 10.
Expected results:
Simple date/time calculations should show the same and correct results no
matter which version is used to open the spreadsheet file.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
