Take a clean sheet with default formatting. Cell Enter Displayed A1 4-1 04-01-18 A2 4-1-17 2017-01-04 A3 4-1-18 2018-01-04 Now select A1 again 4-1-17 04-01-17 This feels a bit inconsistent. The previous behavior was always dd-mm-yy Solution could (also) be: always dd-mm-yyyy ? (sorry for noticing this now - typically something one sees shortly after New Year ..) Noticed in Version: 6.1.0.0.alpha0+ Build ID: fd3fc84e590fc84f62ce3bace668fe40a25f54b5 CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-01-02_06:47:05 Locale: nl-NL (nl_NL.UTF-8); Calc: group threaded First version with this issue is Version: 6.0.0.0.alpha0+ Build ID: 4b4ebb15456af443347679a7e7e8726c090a5bf5 CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-08-30_23:53:37 Locale: nl-NL (nl_NL.UTF-8); Calc: group obviously related to the work for bug 91758
Investigating.
cor, when i follow your description i have a text input, can this be a local problem. When i enter a date, i use 4/1; i get dd/mm/yyyy And my os is default language en; also libreoffice ui
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2448e6cfeb787ae37cdadd7d6181e723b7024d27 Resolves: tdf#114833 do not officiously force Y-M-D if D-M-Y is applicable It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
@xavier: yes it is related to the locale. @eike: thanks - leaving for a week soon, but will try to fetch a daily build sometime ;)
Pending review https://gerrit.libreoffice.org/49849 for 6-0 https://gerrit.libreoffice.org/49851 for 5-4
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ad3834b121e773364fdf640beadffdf42e0f3dae Unit test tdf#114833 do not officiously force Y-M-D if D-M-Y is applicable It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d1a4f50d686054b757320c0ef3f3dc4c724c685c&h=libreoffice-6-0 Resolves: tdf#114833 do not officiously force Y-M-D if D-M-Y is applicable It will be available in 6.0.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=51ab84a1e413d90a89dfc733e650d922a5dedd26&h=libreoffice-5-4 Resolves: tdf#114833 do not officiously force Y-M-D if D-M-Y is applicable It will be available in 5.4.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.