[Libreoffice-bugs] [Bug 135826] EDITING: Copy and paste a cell changes the content from '27-Jul-93' to '27-Jul-89'

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135826

--- Comment #6 from Eike Rathke <erack at redhat.com> ---
Yes, the attached source document has Nulldate 1904-01-01 while a new target
document has Nulldate 1899-12-31, thus 4 years and 1 day difference. As all
calendar dates are just numbers of days since nulldate, copying those numbers
between documents with different nulldates goes awry.

The only solution would be to detect different nulldates and in that case
inspect each and every cell copied whether it is date afflicted (i.e. a date or
date+time number format set) and if so do an adjustment (here +1462 days).

My recommendation for the use case here would be to change the nulldate of the
source document (Tools->Options->Calc->Calculate) to 1899-12-31 (which
temporarily gives wrong dates) and then add 1462 to all date cells in the
affected Date column. To do so enter 1462 in some other cell, copy that to
clipboard, select the Date column range and then Paste-Special (Shift+Ctrl+V)
with the Options Add being activated.

-- 
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/20200817/f9c752c9/attachment-0001.htm>