== Comment: #0 - Leonardo Augusto Guimaraes Garcia <lagarcia.com> - 2019-05-16 18:18:24 == When doing simple math with two dates, the result is being rounded in the wrong way. If I open a new spreadsheet and type the following values on the following cells: A1: 16/05/19 12:10 B1: 16/09/19 16:00 C1: =B1-A1 The result in C1 will be 03:49:59 instead of 03:50:00 as it should be expected. == Comment: #3 - Leonardo Augusto Guimaraes Garcia <lagarcia.com> - 2019-05-16 18:20:17 == I am using Fedora 30 and libreoffice-calc-6.2.3.2-1.fc30.x86_64.
Created attachment 1569926 [details] Example file showing the problem.
Fixed upstream for 6.2.5, see https://bugs.documentfoundation.org/show_bug.cgi?id=125099 I guess we should cherry-pick https://gerrit.libreoffice.org/71936 that is pending for 6-2-4 review but probably won't make it anymore. Meanwhile, the workaround is to apply the correct duration format [HH]:MM:SS instead of a wall clock time format.
The bug is logged against RHEL-7, which has LibreOffice 5.3.7 (RHEL-8 has 6.0.6), and the text speaks about Fedora 30 and LibreOffice 6.2. Upstream bug suggests this is ok in 6.0. So, is this really a fedora only bug, or does it affect a RHEL ?, i.e. is it just necessary to fix this in Fedora 30 ?
libreoffice-6.2.3.2-5.fc30 has been submitted as an update to Fedora 30. https://bodhi.fedoraproject.org/updates/FEDORA-2019-f2e3a7654e
libreoffice-6.2.3.2-5.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report. See https://fedoraproject.org/wiki/QA:Updates_Testing for instructions on how to install test updates. You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-f2e3a7654e
libreoffice-6.2.3.2-5.fc30 has been pushed to the Fedora 30 stable repository. If problems still persist, please make note of it in this bug report.
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 1000 days