Bug 129980 - FILEOPEN: XLSX: wrong dates shown with weekdays ( see comment 11 )
Summary: FILEOPEN: XLSX: wrong dates shown with weekdays ( see comment 11 )
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2020-01-13 12:13 UTC by Wolfgang Schweitzer
Modified: 2022-09-05 17:38 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
I use descriptive filenames for the screenshots (7.56 KB, image/png)
2020-01-13 12:15 UTC, Wolfgang Schweitzer
Details
I use descriptive filenames for the screenshots (7.25 KB, image/png)
2020-01-13 12:16 UTC, Wolfgang Schweitzer
Details
I use descriptive filenames for the screenshots (95.19 KB, image/png)
2020-01-13 12:18 UTC, Wolfgang Schweitzer
Details
I use descriptive filenames for the screenshots (107.27 KB, image/png)
2020-01-13 12:18 UTC, Wolfgang Schweitzer
Details
I use descriptive filenames for the screenshots (38.65 KB, image/png)
2020-01-13 12:19 UTC, Wolfgang Schweitzer
Details
I use descriptive filenames for the screenshots (302.40 KB, image/jpeg)
2020-01-13 12:20 UTC, Wolfgang Schweitzer
Details
file 1 (13.27 KB, application/zip)
2020-01-13 12:27 UTC, Wolfgang Schweitzer
Details
file 2 (11.83 KB, application/zip)
2020-01-13 12:27 UTC, Wolfgang Schweitzer
Details
file 1 PDF (122.42 KB, application/pdf)
2020-01-13 12:28 UTC, Wolfgang Schweitzer
Details
file 2 PDF (120.49 KB, application/pdf)
2020-01-13 12:28 UTC, Wolfgang Schweitzer
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Wolfgang Schweitzer 2020-01-13 12:13:31 UTC
Description:
I received 2 .xlsx files via email (I'm using Thunderbird) that show weekdays in column A and dates in column B, where the dates appear 1 line shifted down. In other words, the dates are wrong (by 1 line) relative to the whole rest of the spreadsheet. 

I don't know which software was used to create these files, but when I open the same .xlsx-file from the email-attachment on my smartphone (Samsung Galaxy Note 8 with Android 9) with the mobile MS Excel, weekdays match the dates. 

I also received PDFs showing the same spreadsheets from the sender of the email, which I assume were generated from the same .xlsx-files. There, dates and weekdays match properly. 

Steps to Reproduce:
1. Open any of the 2 .xlsx files using LibreOffice 6.3.3.2 (x64)
2.
3.

Actual Results:
All weekdays in column A appear 1 line shifted up. They don't match the dates shown in column B - look up a calendar to verify. 13 Jan 2020 is a Monday, not a Tuesday as shown, etc.. 

Expected Results:
Weekdays shown in column A match the dates shown in column B.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
When I first noticed this, I was using an earlier version of LibreOffice. I think it was 6.3.0, but I'm not sure. I then downloaded the 6.3.3 (today, 13 Jan 2020), but it didn't change. 

OpenGL was not enabled (see screenshot).

When I restarted LibreOffice in safe mode, the bug reproduced, but I was presented error messages Error when loading BASIC in document, see Screenshot Safe Mode Error Message 1.png and Screenshot Safe Mode Error Message 2.png.
Comment 1 Wolfgang Schweitzer 2020-01-13 12:15:16 UTC
Created attachment 157109 [details]
I use descriptive filenames for the screenshots
Comment 2 Wolfgang Schweitzer 2020-01-13 12:16:51 UTC
Created attachment 157110 [details]
I use descriptive filenames for the screenshots
Comment 3 Wolfgang Schweitzer 2020-01-13 12:18:21 UTC
Created attachment 157111 [details]
I use descriptive filenames for the screenshots
Comment 4 Wolfgang Schweitzer 2020-01-13 12:18:57 UTC
Created attachment 157112 [details]
I use descriptive filenames for the screenshots
Comment 5 Wolfgang Schweitzer 2020-01-13 12:19:34 UTC
Created attachment 157113 [details]
I use descriptive filenames for the screenshots
Comment 6 Wolfgang Schweitzer 2020-01-13 12:20:15 UTC
Created attachment 157114 [details]
I use descriptive filenames for the screenshots
Comment 7 Wolfgang Schweitzer 2020-01-13 12:27:19 UTC
Created attachment 157116 [details]
file 1
Comment 8 Wolfgang Schweitzer 2020-01-13 12:27:51 UTC
Created attachment 157117 [details]
file 2
Comment 9 Wolfgang Schweitzer 2020-01-13 12:28:19 UTC
Created attachment 157118 [details]
file 1 PDF
Comment 10 Wolfgang Schweitzer 2020-01-13 12:28:49 UTC
Created attachment 157119 [details]
file 2 PDF
Comment 11 Oliver Brinzing 2020-01-13 17:54:12 UTC
(In reply to Wolfgang Schweitzer from comment #0)
> Actual Results:
> All weekdays in column A appear 1 line shifted up. They don't match the
> dates shown in column B - look up a calendar to verify. 13 Jan 2020 is a
> Monday, not a Tuesday as shown, etc.. 
> Expected Results:
> Weekdays shown in column A match the dates shown in column B.

Cells in column A do not reference date values in column B, they contain static text, e.g. Di,Mi,Do.

Cells in column B contain dates, but 13.01.1900 instead 13.01.2020.

What i noticed opening the file with:
Excel:  cell A2:B2 -> Di 14. Jan
LO6402: cell A2:B2 -> Di 13. Jan
Comment 12 Xisco Faulí 2020-02-17 15:12:11 UTC
(In reply to Oliver Brinzing from comment #11)
> (In reply to Wolfgang Schweitzer from comment #0)
> > Actual Results:
> > All weekdays in column A appear 1 line shifted up. They don't match the
> > dates shown in column B - look up a calendar to verify. 13 Jan 2020 is a
> > Monday, not a Tuesday as shown, etc.. 
> > Expected Results:
> > Weekdays shown in column A match the dates shown in column B.
> 
> Cells in column A do not reference date values in column B, they contain
> static text, e.g. Di,Mi,Do.
> 
> Cells in column B contain dates, but 13.01.1900 instead 13.01.2020.
> 
> What i noticed opening the file with:
> Excel:  cell A2:B2 -> Di 14. Jan
> LO6402: cell A2:B2 -> Di 13. Jan

Yep, same problem here. Reproduced back to

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 13 QA Administrators 2022-02-17 03:40:03 UTC Comment hidden (obsolete)
Comment 14 Roman Kuznetsov 2022-02-22 20:37:57 UTC
So strange problem. And it is still rerpo

Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: b438854a0b5148880e455cbeeff14d4e3d825711
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL Jumbo