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.