[Libreoffice-bugs] [Bug 111447] Calc FORMATTING Date YYYY-MM-DD is wrong in Dutch

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Aug 8 14:55:53 UTC 2017


https://bugs.documentfoundation.org/show_bug.cgi?id=111447

--- Comment #8 from rdiependaele at netscape.net ---
Created attachment 135295
  --> https://bugs.documentfoundation.org/attachment.cgi?id=135295&action=edit
Calc Format Date JJJJ-MM-DD Local Date Delimiter Displays Not

In calc, options, I changed the Dutch (BE) Local Date Delimiter
from D/M/J into D-M-J
formatted a cell to JJJJ-MM-DD
entered 7-8-2017
expected 2017-08-07
result 7-8-2017

This is very confusing, even if it shouldn't be a bug.

See:
LibreOffice_Calc_FormatDate_JJJJ-MM-DD_Local-DateDelimiter_DisplaysNot.pdf
and
LibreOffice_Calc_FormatDate_JJJJ-MM-DD_Local-DateDelimiter_DisplaysNot.ods

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170808/e85f4150/attachment-0001.html>


More information about the Libreoffice-bugs mailing list