[Libreoffice-bugs] [Bug 133389] Date & time functions in StarBasic and Calc return different results

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
The usual confusion of timestamp and duration. The example applies the
non-rounding MINUTE() wall clock / timestamp spreadsheet function on a time
difference or duration value with a slight imprecision.

  =A5*24     => 0.166666666388889
  =A5*24*60  => 9.99999998333333

I don't know if there is a standard definition (VBA?) for the BASIC Minute()
function, but the spreadsheet MINUTE() function is defined to not round, see
https://docs.oasis-open.org/office/OpenDocument/v1.3/cs01/part4-formula/OpenDocument-v1.3-cs01-part4-formula.html#MINUTE

The difference between not-/rounding is also visible by applying the HH:MM:SS
wall clock number format (00:09:59) instead of the correct [HH]:MM:SS duration
format (00:10:00) on A5.

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