https://bugs.documentfoundation.org/show_bug.cgi?id=173250
Bug ID: 173250
Summary: Calc: Polish MMM date format uses Roman numerals
instead of abbreviated month names
Product: LibreOffice
Version: 26.2.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Localization
Assignee: [email protected]
Reporter: [email protected]
Description:
When using LibreOffice Calc with the Polish (pl-PL) locale, the MMM date format
displays the month as a Roman numeral instead of the abbreviated Polish month
name.
For example:
Date:
2023-03-15
Format:
MMM
LibreOffice Calc displays:
'III'
The expected result is:
'mar'
# LibreOffice locale data
The Polish locale data is defined in:
https://github.com/LibreOffice/core/blob/master/i18npool/source/localedata/data/pl_PL.xml
The system Polish locale provides the expected abbreviated month names through
LC_TIME:
$ locale -k LC_TIME
abmon="sty;lut;mar;kwi;maj;cze;lip;sie;wrz;paź;lis;gru"
The problem therefore appears to be related to the Polish locale data used
internally by LibreOffice rather than to missing or incorrect system locale
information.
# Format code semantics
The LibreOffice documentation describes MMM as the abbreviated month name. In
the Polish documentation it is explicitly described as:
Miesiące jako sty - gru
Therefore, using Roman numerals (I–XII) for MMM appears to be inconsistent with
the documented meaning of the format code.
The Roman-numeral representation may be a valid Polish convention for writing
dates, e.g. 15 III 2023, but it should not be used as the meaning of the
generic MMM format code.
If Roman-numeral month formatting is desired for Polish dates, it would be
preferable to provide it as a separate date format rather than using it for
MMM.
# Environment
Version: 26.2.5.2 (X86_64)
Build ID: cd7284b4cbbfeb507e630c1aac019f4157393acb
CPU threads: 12; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: pl-PL (pl_PL); UI: pl-PL
Calc: CL threaded
Steps to Reproduce:
Set the LibreOffice locale to Polish (pl-PL).
Open Calc.
Enter a date, for example 2023-03-15.
Format the cell using the MMM date format.
Observe the displayed month.
Actual Results:
The month is displayed as a Roman numeral:
III
The same happens for other months:
I
II
III
IV
V
VI
VII
VIII
IX
X
XI
XII
Expected Results:
MMM should display the abbreviated Polish month names:
sty
lut
mar
kwi
maj
cze
lip
sie
wrz
paź
lis
gru
This is also how MMM behaves in Microsoft 365 with the Polish locale. For
example, March is displayed as mar, not III.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
This behavior appears to be caused by the Polish locale definition shipped with
LibreOffice.
Could the Polish locale data be corrected so that MMM uses the standard
abbreviated Polish month names (sty, lut, mar, etc.)?
--
You are receiving this mail because:
You are the assignee for the bug.
