[Libreoffice-bugs] [Bug 112428] New: After saving document, containing dates in cells, the document displays wrong date format if I open it in MS Office

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 112428
           Summary: After saving document, containing dates in cells, the
                    document displays wrong date format if I open it in MS
                    Office
           Product: LibreOffice
           Version: 5.4.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: fixer5 at yandex.ru

Description:
After saving document, containing dates in cells, the document displays wrong
date format if I open it in MS Office. For example, in a cell of Calc sheet I
have a date 31.08.2017. The format is "Date dd.MM.yyyy RU". I save the document
in xls or xlsx. Then I open this document in MS Office 2007-2010. I see that
date in that cell is displayed as 08.31.2017! The format is still "Date
dd.MM.yyyy RU". However, LibreOffice displays this cell correctly.

Steps to Reproduce:
1. Run the Calc
2. Type the value "31.08.2017" in a cell
3. Right click on that cell, make format "Date dd.MM.yyyy RU" (just choose from
the lists)
4. Save the file in xls or xlsx format.
5. Open the file in MS Office 2007, 2010 or just Excel Viewer.
6. You see that date in the cell looks like 08.31.2017

Actual Results:  
The date in a cell transforms from dd.MM.yyyy to MM.dd.yyyy format, when
looking through MS Office 2007-2010

Expected Results:
LibreOffice should keep the format of a cell in a right format. MS Office
should display theese cells with dates correctly.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:55.0) Gecko/20100101
Firefox/55.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/20170916/271c4779/attachment.html>