https://bugs.documentfoundation.org/show_bug.cgi?id=123407
Bug ID: 123407
Summary: Copy&Paste-Error in Date-Cells from XLSX to ODS
Product: LibreOffice
Version: 6.1.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When copying cells with a date from a XLSX-File, that is saved in an "old"
Excel format ("1904") to a new ODS-File via Copy&Paste, the date gets
automatically transformed by 4 years and 1 day. Eg. 27.12.2018 changes to
26.12.2014 in new ODS. Correct: 27.12.2018 should not change.
In the XLSX document under Tools - Options - LibreOffice Calc - Calculate, the
date is set automatically at "01.01.1904". I suppose because the XLSX is a
spreadsheet "in a foreign format". A standard ODS is set at "30.12.1899", so
copy & pasting should honor the difference.
Steps to Reproduce:
1. Copy cell with Date from XLSX-file (Strg-C)
2. Paste in empty ODS or new spreadsheet
Actual Results:
Date cell with content "22.1.2018" changes to "21.1.2014"
Expected Results:
Content of Date cell should not change after paste to ODS-spreadsheet
Reproducible: Always
User Profile Reset: No
Additional Info:
Clipboard contains "22.1.2018"
--
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
