[Libreoffice-bugs] [Bug 127334] New: Regression: Incompatible changes in date/time arithmetic introduced between Version: 6.0.4.2 (x64) and version 6.2.6.2 (ubuntu)

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: albrecht.mueller at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190904/0b1f74fc/attachment-0001.html>