Bug 133672 - FILEOPEN XLSX Default Hungarian month-day date format imported incorrectly
Summary: FILEOPEN XLSX Default Hungarian month-day date format imported incorrectly
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-06-04 12:05 UTC by NISZ LibreOffice Team
Modified: 2022-09-06 20:36 UTC (History)
3 users (show)

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


Attachments
Example file from Excel (12.92 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-06-04 12:05 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc / hu-HU locale (120.17 KB, image/png)
2020-06-04 12:06 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc / en-US locale (128.33 KB, image/png)
2020-06-04 12:06 UTC, NISZ LibreOffice Team
Details
Example file from Excel 2013 with all default preset date formats (10.40 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-07-14 06:31 UTC, NISZ LibreOffice Team
Details
The example file in Excel and Calc master nigthly (174.22 KB, image/png)
2020-07-14 06:32 UTC, NISZ LibreOffice Team
Details
Screenshot oft the Excel file after the fix and in Calc 6.0 (400.55 KB, image/png)
2020-07-27 06:32 UTC, NISZ LibreOffice Team
Details
All default Writer date fields (10.19 KB, application/vnd.oasis.opendocument.text)
2020-07-27 06:34 UTC, NISZ LibreOffice Team
Details
How the date formats look after the patch in Writer (294.99 KB, image/png)
2020-07-27 06:35 UTC, NISZ LibreOffice Team
Details
Latest version of the patch looks like this (545.92 KB, image/png)
2020-09-21 05:41 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2020-06-04 12:05:43 UTC
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)
Comment 1 NISZ LibreOffice Team 2020-06-04 12:06:00 UTC
Created attachment 161606 [details]
Screenshot of the original document side by side in Excel and Calc / hu-HU locale
Comment 2 NISZ LibreOffice Team 2020-06-04 12:06:14 UTC
Created attachment 161607 [details]
Screenshot of the original document side by side in Excel and Calc / en-US locale
Comment 3 Xisco Faulí 2020-07-03 09:45:26 UTC
No hu-HU locale here but moving to NEW. NISZ team knows what they are doing
Comment 4 NISZ LibreOffice Team 2020-07-10 08:39:01 UTC
The chart problem is independent from the date format inconsistency, filed as separate bug.
Comment 5 NISZ LibreOffice Team 2020-07-14 06:31:47 UTC
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
Comment 6 NISZ LibreOffice Team 2020-07-14 06:32:58 UTC
Created attachment 162998 [details]
The example file in Excel and Calc master nigthly
Comment 7 NISZ LibreOffice Team 2020-07-27 06:32:20 UTC
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.
Comment 8 NISZ LibreOffice Team 2020-07-27 06:34:41 UTC
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.
Comment 9 NISZ LibreOffice Team 2020-07-27 06:35:36 UTC
Created attachment 163590 [details]
How the date formats look after the patch in Writer
Comment 10 Gabor Kelemen (allotropia) 2020-09-21 05:41:33 UTC
Created attachment 165705 [details]
Latest version of the patch looks like this