Bug 131967

Summary:	date format: month and day automatically reversed
Product:	LibreOffice	Reporter:	dolphis1 <dolphis1>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	minor	CC:	miguelangelrv
Priority:	medium
Version:	6.3.2.2 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	demonstration of the unwanted value reversal bug

Description dolphis1@hotmail.fr 2020-04-07 18:49:50 UTC

Description:
-systeme in french
libre office.
I set the date format in:
MM / JJ / AAAA
expected result:
date display in the format:
MM / JJ / AAAA
result obtained in display:
JJ / MM / AAAA
even setting the cell language for format to us.
(troubleshooting) solution:
replaces the letters in French formatting with the letters in English formatting.
by entering:
MM / DD / YYYY
so as not to have the French format inversion of the dates.

Steps to Reproduce:
1.I set the date format in:
MM / JJ / AAAA (french)
2.
3.

Actual Results:
date display in the format:
JJ / MM / AAAA (french)

Expected Results:
date display in the format:
MM / JJ / AAAA (french)


Reproducible: Always


User Profile Reset: No



Additional Info:
(troubleshooting) solution:
replaces the letters in French formatting with the letters in English formatting.
by entering:
MM / DD / YYYY
so as not to have the French format inversion of the dates.

Comment 1 m_a_riosv 2020-04-07 21:37:08 UTC

Please can you attach a sample file with the issue.

Comment 2 dolphis1@hotmail.fr 2020-04-08 17:56:30 UTC

Created attachment 159431 [details]
demonstration of the unwanted value reversal bug

in column F even the order of entry is reversed in the entry field, something that is not done in columns a-b-c, only the display reverses the values

Comment 3 m_a_riosv 2020-04-08 22:52:07 UTC

Perhaps I don't understand fine.

Dates on colum B are text not true dates, changes their format doesn't change the content it remains as test not as true dates.

To convert to true dates use Menu/Data/Text to column, click on the column head ans select the date type.

Comment 4 dolphis1@hotmail.fr 2020-04-09 03:30:35 UTC

The bug manifests itself in columns C and E.
as you can see on this video, because your system may not appear in English.

video :
https://youtu.be/b7wtG--BveY

Comment 5 m_a_riosv 2020-04-09 11:36:26 UTC

For the input bar shows the date according the language of the cell, not with the format of the cell, what I think it's fine. While cells are showed with their format.

Comment 6 dolphis1@hotmail.fr 2020-04-10 12:17:04 UTC

I instinctively expect a custom setting, take priority over the default setting. here the date form imposed by the language must therefore be canceled by the personalized setting.
thanks you

Comment 7 m_a_riosv 2020-04-10 21:06:41 UTC

Thank to you for report.