[Libreoffice-bugs] [Bug 122991] New: FORMATTING: Regression from 6.1 to 6.2 in displaying times formatted as Time 876613:37:46

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122991

            Bug ID: 122991
           Summary: FORMATTING: Regression from 6.1 to 6.2 in displaying
                    times formatted as Time 876613:37:46
           Product: LibreOffice
           Version: 6.2.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ks at ub.uni-mainz.de

Created attachment 148674
  --> https://bugs.documentfoundation.org/attachment.cgi?id=148674&action=edit
Example for wrong Time data in 6.2/6.3, correct in 6.0/1

Loading a spread sheet for calculating work hours createt w/ LO 6.0.xxx in
6.2.xxx or 6.3.xxx some values are shown as f.e. 08:47:59 instead of 08:48:00
and all further calculations are done with the wrong values. I've to stay with
6.1.xxx until this is fixed.

How to repeat: Open a new spreadsheet, format some cells as Time 876613:37:46
and just type 8:47, you'll see 8:46:59.

Worse: After saving the sheet in 6.2.xxx/6.3.xxx to file and opening the file
again, you'll see more values beeing shown as X:YZ-1:59 instead of Z:YZ:00.

BUT: Open the same File in LO 6.1.xxx an all values are OK!

See attached example file.

(FWIW: I've removed all extensions)

-- 
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/20190126/4b08fc8a/attachment.html>