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": https://git.libreoffice.org/core/commit/dff729704687889f960562f0ac6fa62b47897cf9 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.