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@lists.freedesktop.org
Reporter: luu...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs