Download it now!
Bug 123407 - Copy&Paste-Error in Date-Cells from XLSX to ODS
Summary: Copy&Paste-Error in Date-Cells from XLSX to ODS
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: dataLoss, filter:xlsx
Depends on:
Blocks: Paste-From-MSO
  Show dependency treegraph
Reported: 2019-02-12 15:07 UTC by amersdorfer
Modified: 2019-02-13 11:57 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

XLSX-File (48.69 KB, application/zip)
2019-02-12 15:08 UTC, amersdorfer

Note You need to log in before you can comment on or make changes to this bug.
Description amersdorfer 2019-02-12 15:07:26 UTC
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"
Comment 1 amersdorfer 2019-02-12 15:08:43 UTC
Created attachment 149226 [details]
Comment 2 Roman Kuznetsov 2019-02-12 16:10:43 UTC
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
Comment 3 Xisco Faulí 2019-02-13 11:57:00 UTC
Also reproduced in

Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.15; Render: default; 

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-

@Eike, I thought you could be interested in this issue...