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

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #5 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Albrecht Müller from comment #4)
> I think this is a bug. Look at the problem from a users point of view: The
> essential part is that you subtract two numbers containing only integral
> multiples of time units, you get an integral result and this result is
> obviously wrong. As only integral numbers are involved there is no room for
> round off errors. If this is not a bug what else can count as bug?
> 
> And I think it is a pretty serious one: How can I trust the results of more 
> complicated calculations if I can easily demonstrate that LibreOffices does
> not even get simple integer calculations right?

It's a misconception. You are making arithmetics with times. And time in
LibreOffice is just a fraction of a base unit, which is a day. 12:00:00 in
LibreOffice is 0.5 (half a day). You are *not* doing simple integer
calculations. Just try to format your cells as numbers.

And you may see the bug I linked as See Also that you might want to track. This
is either NOTABUG or duplicate of that one, in any case it should be closed.

-- 
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/20200413/1d862836/attachment.htm>