Bug 149909 - [FILEOPEN] NUMBERS Date values sometimes have erroneous time component
Summary: [FILEOPEN] NUMBERS Date values sometimes have erroneous time component
Status: RESOLVED INSUFFICIENTDATA
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: 2025-01-03 04:10 UTC (History)
2 users (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 ?
Comment 2 QA Administrators 2024-12-03 03:11:26 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2025-01-03 03:11:12 UTC
Dear SheetJS,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp