Created attachment 153649 [details]
Sample file on CODE
When cells contains formatted date string, showing in offline (i.e. LibreOffice) version is correct but when opening it on LOOL or CODE the date format will become MM/DD/YYYY.
Created attachment 153650 [details]
The same file opened by LibreOffice Calc (offline)
This is the correct setting YYYY/MM/DD. However when opening the same file the date format would become MM/DD/YYYY automatically.
Created attachment 153805 [details]
Sample ODS with a couple of dates
Confirmed in a master build when using the attached sample.
The different columns have dates in different locale formats (Chinese (traiditional), English (USA), German (Germany), French (France)), and apparently only the Chinese one isn't displayed correctly.
Created attachment 153806 [details]
Screenshot of sample in LOOL
Created attachment 153807 [details]
Screenshot of sample in LO
Dennis Francis committed a patch related to this issue.
It has been pushed to "master":
tdf#127158 :lokit: preload liblocaledata_others.so
It will be available in 7.0.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.