[Libreoffice-bugs] [Bug 125652] New: Date format not respected while editing cells

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Jun 3 09:17:33 UTC 2019


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

            Bug ID: 125652
           Summary: Date format not respected while editing cells
           Product: LibreOffice
           Version: 6.1.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: herman.viaene at edpnet.be

Description:
Create empty calc file, select first column and take "Format cells". Opt for
language "Dutch Belgium" and select format "31/12/1999".
Now type in a cell "1/5/2019" and see that you get in the cell "05/01/2019".
Type "23/4/2019" and you get the correct "23/04/2019".
Selecting format "31 dec 1999" and do the same input as above, and you get in
the cells "5 jan 2019" and "23 apr 2019"

Actual Results:
Date format is only respected if the first number is greater than 12, i.e. it
cannot be a month. When the first number is 12 or less, then this number is
taken for month.

Expected Results:
The date info in the cells is not recorded correctly.


Reproducible: Always


User Profile Reset: No



Additional Info:
My system (Mageia 6) is configured in English with Belgian keyboard. This
problem I never had on previous LO versions.

-- 
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/20190603/051f5dac/attachment.html>


More information about the Libreoffice-bugs mailing list