[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

Wolfgang Jäger <jag at psilosoph.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jag at psilosoph.de

--- Comment #12 from Wolfgang Jäger <jag at psilosoph.de> ---
(In reply to Eike Rathke from comment #6)
> ...
> 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).
> ...
I would doubt if this helps reliably. There is no value-type Date or DateTime
in Calc, and the the related NumbrFormat types (2 through 7) are no safe
surrogate, because any user can use different NumberFormat types suitable for
the purposes. Unfortunately a fomula like ="2001-11-18" - 14878 is accepted by
Calc, and neither Calc's automatisms nor the supposed user will format the
result as date. The result will depend on the .NullDate setting, however. 

Without going into the Tokens of every formula cell there is no way to solve
the prpoblem technically. And what about value-only-copies of such cells?

Since there is no satisfying solution to the problem itself, there should be at
least an enhancement helping to avoid serious errors which may occur if the
mentioned behaviour lead to an unnoticed offset of 1462 days.  

When copying cell ranges from sheet to sheet and also when moving or copying
complete sheets from one document to a different one, Calc should check the
.NullDate settings of both documents and warn the user.  

See also https://ask.libreoffice.org/en/question/300357/.

-- 
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/20210324/aa4e0d49/attachment.htm>