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