Description: .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: Open Jan_Kratochvil.xlsx Actual Results: 44215 Expected Results: 1/19/2021 Reproducible: Always User Profile Reset: No Additional Info: libreoffice-calc-7.0.4.2-3.fc33.x86_64 Version: 7.0.4.2 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 Calc: threaded
Created attachment 169169 [details] .xlsx
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
Reproduced in Version: 7.2.0.0.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 Calc: threaded Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53 Threads 4; Ver: 5.7; Render: default; and Version 4.1.0.0.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.
Dear Jan Kratochvil, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
still valid for: 7.3.7.2 libreoffice-calc-7.3.7.2-2.fc36.x86_64 (I have tried to download and install your 7.5 but it did not start for me on Fedora 36 x86-64.)
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/909a25d30b09ebd3a023105a9c3cc4d20add094a Resolves: tdf#139934 always apply cellXfs xf explicits (tdf#123139 related) It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/c/core/+/146533 for 7-5 https://gerrit.libreoffice.org/c/core/+/146614 for 7-4
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d367cefb0281767762b1671c03b3852cf3d1b7ab tdf#139934: sc_subsequent_filters_test: Add unittest It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thanks Eike for fixing this one and Jan for reporting. Verified. OK now in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 9d44236a62bf59d120dda89924d0d1407b2bd52b CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
Thanks for the fix. Unfortunately the nightly builds do not work for me on either Fedora 36 or Debian 12 (x86_64). It looks the next release with native distro packaging will be fixed already.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/e53c02eac4b3d231fef7a6156321edfdea1fbb27 Resolves: tdf#139934 always apply cellXfs xf explicits (tdf#123139 related) It will be available in 7.4.6. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-5": https://git.libreoffice.org/core/commit/321c1a6db442a6d2afee25d1d1256ff36bdb004e Resolves: tdf#139934 always apply cellXfs xf explicits (tdf#123139 related) It will be available in 7.5.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-5-1": https://git.libreoffice.org/core/commit/58c84f408c4a2d5f1067b4ca5e7c204d6a9c9372 Resolves: tdf#139934 always apply cellXfs xf explicits (tdf#123139 related) It will be available in 7.5.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.