https://bugs.documentfoundation.org/show_bug.cgi?id=142974
Mike Kaganski <mikekagan...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|FIXED |NOTABUG
--- Comment #8 from Mike Kaganski <mikekagan...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs