Created attachment 161605 [details] Example file from Excel Attached example document was made in Excel, I entered some dates in the 05-10 06-12 etc. format. Excel recognized this and set the cell type to Date with DD-MMM format, so that it appears as: day.mon (month is localized and abbreviated). Format code is nn.hhh (or DD.MMM in English). This format is imported incorrectly in Calc, depending on locale: - With en-US it appears as D-MMM so that separator is dash instead of dot (no big deal, just interesting) - With hu-HU it appears as DD.MMM but here the month appears with Roman numerals instead of the abbreviated form. I also added a chart with the example values as data row labels and upon import all X axis labels are now 1-XII and the drawn line is completely broken. Steps to reproduce: 1. Open attached document and observe date format differences in A2:A5) Actual results: Roman numerals instead of abbreviated localized month name. Expected results: Abbreviated localized month name, just like in Excel. LibreOffice details: Version: 7.1.0.0.alpha0+ (x64) Build ID: 68095e63a8ad8f6079b15e475179a14a64da36d3 CPU szálak: 4; OS: Windows 6.3 Build 9600; Felületmegjelenítés: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: CL Also happens in: Verzió: 6.0.0.3 Build az.: 64a0f66915f38c6217de274f0aa8e15618924765 CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: alapértelmezett; Területi beállítások: hu-HU (hu_HU); Calc: CL Version: 5.0.0.5 Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b Locale: hu-HU (hu_HU) Verzió: 4.0.0.3 (Build az.: 7545bee9c2a0782548772a21bc84a9dcc583b89)
Created attachment 161606 [details] Screenshot of the original document side by side in Excel and Calc / hu-HU locale
Created attachment 161607 [details] Screenshot of the original document side by side in Excel and Calc / en-US locale
No hu-HU locale here but moving to NEW. NISZ team knows what they are doing
The chart problem is independent from the date format inconsistency, filed as separate bug.
Created attachment 162997 [details] Example file from Excel 2013 with all default preset date formats To generalize the problem a bit, here is an example file with all the default format options Excel 2013 offers
Created attachment 162998 [details] The example file in Excel and Calc master nigthly
Created attachment 163588 [details] Screenshot oft the Excel file after the fix and in Calc 6.0 This is how it looks after the proposed patch: https://gerrit.libreoffice.org/c/core/+/99340 On the left there is the attachment #162998 [details] as an image.
Created attachment 163589 [details] All default Writer date fields This file contains all default Writer date fields. The patch has a side effect on the display of date formats in Writer.
Created attachment 163590 [details] How the date formats look after the patch in Writer
Created attachment 165705 [details] Latest version of the patch looks like this
Dear NISZ LibreOffice Team, 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