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

            Bug ID: 149909
           Summary: [FILEOPEN] NUMBERS Date values sometimes have
                    erroneous time component
           Product: LibreOffice
           Version: 7.3.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: d...@sheetjs.com

Description:
Certain date values are off by < 10 minutes, leading to incorrect dates (e.g.
`10/03/2020 23:53:20` whereas `10/04/2020 00:00:00` is the actual value in the
files)

Steps to Reproduce:
1. Download and open
https://github.com/SheetJS/test_files/raw/master/Attendance.numbers

Actual Results:
cell A5 is `10/03/2020 23:53:20`

Expected Results:
cell A5 is `10/04/2020 00:00:00`


Reproducible: Always


User Profile Reset: Yes



Additional Info:
File was generated from icloud.com numbers export using the Education >
Attendance template

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to