https://bugs.documentfoundation.org/show_bug.cgi?id=127334
--- Comment #1 from Eike Rathke <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
