[Libreoffice-bugs] [Bug 127334] Regression: Incompatible changes in date/time arithmetic introduced between Version: 6.0.4.2 (x64) and version 6.2.6.2 (ubuntu)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #1 from Eike Rathke <erack at redhat.com> ---
Created attachment 153865
  --> https://bugs.documentfoundation.org/attachment.cgi?id=153865&action=edit
Test file with added floating-point calculations to demonstrate why this is the
case.

The MINUTE() function was changed to return the integer wall clock minute not
rounded, as specified by ODF OpenFormula
https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#MINUTE

Applying MINUTE() to a calculated duration is problematic if rounded values are
expected. For this rather use ROUND(duration*24*60). In the attached document I
added column E with the underlying duration floating-point duration values,
column F with calculated minutes, and column G with the MINUTE() value
calculated from the duration, which illustrates the unexpected but correct
results. Column H uses ROUND() for the here expected calculation.

-- 
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/20190904/8da2626c/attachment.html>