[Libreoffice-bugs] [Bug 143132] New: FILEOPEN XLSX Second values are incorrectly not rounded

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 143132
           Summary: FILEOPEN XLSX Second values are incorrectly not
                    rounded
           Product: LibreOffice
           Version: 6.2.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: bibisected, bisected, regression
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: erack at redhat.com, nemeth at numbertext.org,
                    varga.balazs3 at nisz.hu
            Blocks: 108897

Created attachment 173290
  --> https://bugs.documentfoundation.org/attachment.cgi?id=173290&action=edit
Screenshot of the attachment 170433 side by side in Excel and Calc

When a time value of hours:minutes:seconds is stored in Excel and opened in
Calc, there is a small rounding error: Excel stores hundredth seconds as well,
but displays the value rounded to whole seconds.
Calc does not round these values but truncates them, as can be seen with
attachment 170433 of bug 140978.

Steps to reproduce:
    1. Open attachment 170433

Actual results:
Observe that the value in A6 is 8:17:40 in Excel but 8:17:39 in Calc.
This also causes the autofilter condition set to display the 8:17:40 value to
not match the 8:17:39 value presented by Calc.

Expected results:
The value in A6 should be rounded to 8:17:40 in Calc as well.

LibreOffice details:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 9c15dea0b2192d231b65175291a7655122c2e24c
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL

Also in 7.0, 6.2. 

Not yet in
Version: 6.1.0.3
Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: en-US (hu_HU); Calc: group threaded

Additional Information:
Bibisected using bibisect-win32-6.2 to:
URL:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=e2e47898180e547cad7ccde1e5890385d573e551 

author  Eike Rathke <erack at redhat.com>  2018-08-31 11:21:03 +0200
committer       Eike Rathke <erack at redhat.com>  2018-08-31 12:50:52 +0200

Use tools::Time::GetClock() in number formatter for wall clock time

Adding CC to: Eike Rathke


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
-- 
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/20210630/4be3ae36/attachment-0001.htm>