.xlsx dates 1/19/2021 and 1/20/2021 are shown correctly both by MS Excel and Google Office.
LibreOffice shows them as 44215 and 44216.
Steps to Reproduce:
User Profile Reset: No
Build ID: 00(Build:2)
CPU threads: 8; OS: Linux 5.9; UI render: default; VCL: gtk3
Locale: cs-CZ (en_US.UTF-8); UI: en-US
Created attachment 169169 [details]
Created attachment 169170 [details]
.csv correct from GoogleOffice
Created attachment 169171 [details]
.csv incorrect from LibreOffice
In your xlsx file the dates are saved as number, and not as dates.
A number is exported to a csv file as a number.
(In reply to BogdanB from comment #4)
> In your xlsx file the dates are saved as number, and not as dates.
So why MS Excel + Google Office show those "numbers" as dates?
I tested with import in Google Drive, indeed it transform the number into dates.
Created attachment 169220 [details]
Comparison LibreOffice 7.2 master and MSO 2010
Version: 184.108.40.206.alpha0+ / LibreOffice Community
Build ID: f2389a70da606768a39ee599de6a5b24058734aa
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 5.7; Render: default;
Version 220.127.116.11.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
@Eike, I thought you might be interested in this issue
The .xlsx attached here is in the old Excel interim XML file format that LibreOffice only partially supports, and number formats given as some default format IDs with cellXfs
<xf numFmtId="..." ...>
apparently are not supported by this filter.
To solve the problem, save the file in Excel once in the standard OOXML .xlsx format and it likely will work also in LibreOffice. Or apply the date format in LibreOffice and save as Excel 2007-365 .xlsx, which should fix things as well.
This format is "Excel export" from https://www.workday.com (which is now being deployed inside Red Hat company). So I do not have an option to choose a different format. Except for using other offices to convert it afterwards.
There are many workarounds but at the end of the day LibreOffice is incompatible while MS Excel + Google Office are compatible.