[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

--- Comment #3 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Aron Budea from comment #2)
> Interestingly it displayed 0:10 in both cases before the following commit
> (just noting here):
> 
> Use tools::Time::GetClock() in number formatter for wall clock time

Yes, that was the intended change. The idea is this: when people talk about
datetimes, and want to express that in hours and minutes, they say "2020-04-13
23:59" even when it's "2020-04-13 23:59:58". They will not say that it's
tomorrow's day when it's still 2 seconds to it left. Outputting that as "00:00"
is wrong. Thus, when formatting wall clock times, it doesn't get rounded up,
but truncated. This makes tiny floating-point inaccuracies (when the nearest
floating-point value is slightly less than exact value) to result in this. See
also bug 127334 comment 8, where I suggest to limit the precision of time
formatting, to avoid this.

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