[Libreoffice-bugs] [Bug 114551] New: Date format not stored properly in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 114551
           Summary: Date format not stored properly in Calc
           Product: LibreOffice
           Version: 5.4.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mitja.masten at gmail.com

Description:
If Calc spreadsheet contains Date values, formatted eg. 'DD.MM.YY', then
opening the same file in older versions of Libre Office or Excel shows Date
values as 'MM.DD.YY'. So Day and Month figures are switched.

That happens every time the file is saved, even though values are not changed
at all.
Only if the same file is opened in LibreOffice ver. 5.4.3 then date format
looks ok.

Steps to Reproduce:
1. System and LO date format setting is DD.MM.YY
2. Store date value in a cell in format DD.MM.YY (or DD.MM.YYYY or DD.MM.YYYY
HH:MM:SS)
3. Save file as ODS or XLS or XLSX.

Actual Results:  
If the file in opened in LO ver. < 5.4.0 or Excel the date value is in format
MM.DD.YY.

Expected Results:
Date value should be always in format DD.MM.YY!


Reproducible: Always


User Profile Reset: No



Additional Info:
This bug appeared in Libre Office ver. 5.4.


User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:57.0)
Gecko/20100101 Firefox/57.0

-- 
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/20171219/f83a0184/attachment-0001.html>