The new updates seem to have broken the date format. I change all the dates to 1999-12-31 format and save the file. Next time i load it, they’ve all changed back to something like xx/xx/xx.
Edit: Also, i used to be able to type something like “2-1” and it would automatically change that to “2023-02-01”. Now it just stays “2-1”.
Please edit your question, and add the information in Menu/Help/About LibreOffice (there is a button to copy it)
And also, please attach a sample file to test the issue.
Version: 7.3.7.2 (x64) / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
When I booted the other PC to get the above info, it told me there is a Java update available. I installed that, and now the first part of my problem seems to have gone away. Is it really possible that a Java update fixed that?
The second part of problem persists. I typed “2-7” into a cell formatted for date 1999-12-31 and I just got “2-7”. One sheet of spreadsheet attached.
debug date format2.ods (42.9 KB)
Looks like your locale changed (to maybe en-US). Either the system or desktop environment locale and that is inherited by LibreOffice using the Default - English (USA) locale, or it is fixed to one, e.g. English (USA); under Tools → Options → Language Settings → Languages, Formats, Locale setting.
1 Like
Wildly guessing, I suspect you need to set Locale back to Canada
Yes! That fixed it. Thank you.