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
Date cell with content "22.1.2018" changes to "21.1.2014"
Content of Date cell should not change after paste to ODS-spreadsheet
User Profile Reset: No
Clipboard contains "22.1.2018"
Created attachment 149226 [details]
Confirm with file from attach in
Build ID: 1:6.1.4-0ubuntu0.18.10.1
CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5;
Locale: ru-RU (ru_RU.UTF-8); Calc: group threaded
Also reproduced in
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.15; Render: default;
@Eike, I thought you could be interested in this issue...