[Libreoffice-bugs] [Bug 125109] Calc inverts typed dates

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed May 8 10:58:27 UTC 2019


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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|NOTABUG                     |---
     Ever confirmed|0                           |1
             Status|RESOLVED                    |REOPENED

--- Comment #12 from Eike Rathke <erack at redhat.com> ---
This
"1. Set locale to en-US"
and this
"2. Format a cell with a locale that has DD/MM/YYYY dates"
explains it. The cell input is parsed according to the system locale (or the
locale set under Tools->Options) in its M/D/Y order and then displayed using
the date order of the applied date format. That is expected. At least for so
far empty cells there is no indication what input would be accepted so using
the system locale is logical.

The problem here is editing an existing date in such constellation, because
after F2 the date is presented in the edit format of the applied format in 
D/M/Y order but again parsed as M/D/Y of the system locale.

To be investigated.

-- 
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/20190508/bb833e1d/attachment-0001.html>


More information about the Libreoffice-bugs mailing list