Bug 149909 - [FILEOPEN] NUMBERS Date values sometimes have erroneous time component
Summary: [FILEOPEN] NUMBERS Date values sometimes have erroneous time component
Status: NEEDINFO
Alias: None
Product: Document Liberation Project
Classification: Unclassified
Component: libetonyek (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Apple-iWork
  Show dependency treegraph
 
Reported: 2022-07-08 05:44 UTC by SheetJS
Modified: 2024-06-05 03:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description SheetJS 2022-07-08 05:44:13 UTC
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
Comment 1 Alex Thurgood 2024-06-04 11:00:29 UTC
When I try to open the uploaded file in 

Version: 24.2.3.2 (AARCH64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 8; OS: macOS 14.5; UI render: Skia/Metal; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

all I get is two tabs (Attendance, Attendance_1).

Attendance has no values in it whatsoever.

Attendance_1 only seems to have a Title/Heading and the green/yellow line objects.

I can't see any data anywhere else in this file, whereas opening the same file in Numbers displays dates in the lefthand column and Attendee names across the top of the table, and tick boxes to indicate presence/absence.

I can't reproduce the issue you are reporting unfortunately, as none of the data appears in the cells.

Is this data generated on the fly somehow ?