[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Apr 14 15:02:58 UTC 2020


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

--- Comment #13 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to jarko from comment #12)

which is again offtopic here, since representation of times as fractions of day
is industry standard, that is directly used in billions of spreadsheets (e.g.
in formulas that take fractional parts to strip days), etc. This is not
something to be changed into some integer number of some basic time unit.

Or did you mean that the whole user input should be kept as "integer for years,
integer for months, integer for days, integer for hours, integers for minutes,
integers for seconds, integer for ..."? Then you seem to have a secret recipe
how to operate with such a monster (e.g., subtract two such datetimes)
efficiently.

-- 
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/20200414/dc3b2980/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list