[Libreoffice-bugs] [Bug 116450] New: CONVERSION FORMAT DATE

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 116450
           Summary: CONVERSION FORMAT DATE
           Product: LibreOffice
           Version: 6.0.1.1 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: luuk34 at gmail.com

When looking at an old bug report
(https://bugs.documentfoundation.org/show_bug.cgi?id=33689) i found this:

It is possible to have DATE fields in different locales in 1 spreadsheet,
simply by pressing CTRL+1 , and choosing a different language.

Doing this it's possible to create a sheet with these two formulas (i.e.):
1) =TEXT(A2;"DD-MM-YYYY")
2) =TEXT(A2;"DD-MM-JJJJ")
The first with Language set to 'English', the second with language set to
'Dutch'

Above works correct in Openoffice, but saving this sheet as XLSX changes the
format of the English formatted date to '17-03-YYYY' 

This can be shown by opening this file in Excel, of in OpenOffice, which shows
the date as "17-03-YYYY"  (when the settings of the locale is set to Dutch)

-- 
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/20180317/e817de82/attachment.html>