[Libreoffice-bugs] [Bug 142974] EDITING: Hourly time series not calculated correctly

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|FIXED                       |NOTABUG

--- Comment #8 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Felix Collins from comment #7)
> I guess it would be a horrible backward compatibility issue though.

True. There are billions of spreadsheets that do calculations like
"DATEVALUE("2021-06-22")+1/1440" to mean "add 1 minute to the date", or add 1
to add 1 day, etc.

> It would be interesting to know why the original design decision went this way.

I suppose that back in the day, in 1980s, computers didn't have a reasonable
integer type capable of holding such numbers like *milli*seconds (the minimal
reasonable resolution for time in spreadsheets, since people often need
sub-second precision) since epoch - even seconds already approach unsigned
32-bit limit, and spreadsheets started even before 32-bit era.

-- 
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/20210622/5667eb1d/attachment.htm>