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.
Please can you attach a sample file with the issue.
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
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.
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
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.
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
Thank to you for report.