[Libreoffice-bugs] [Bug 123407] New: Copy&Paste-Error in Date-Cells from XLSX to ODS

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: amersdorfer at argekultur.at

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190212/92e6d685/attachment-0001.html>