Note: This is a public test instance of Red Hat Bugzilla. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback at bugzilla.redhat.com.
Bug 1711143
| Summary: | Libreoffice Calc not rounding time calculation correctly | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | IBM Bug Proxy <bugproxy> | ||||
| Component: | libreoffice | Assignee: | Caolan McNamara <caolanm> | ||||
| Status: | CLOSED ERRATA | QA Contact: | Fedora Extras Quality Assurance <extras-qa> | ||||
| Severity: | high | Docs Contact: | |||||
| Priority: | high | ||||||
| Version: | 30 | CC: | bugproxy, caolanm, dtardon, erack, hannsj_uhl, jkachuck, sbergman | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | x86_64 | ||||||
| OS: | Linux | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | libreoffice-6.2.3.2-5.fc30 | Doc Type: | If docs needed, set a value | ||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2019-05-30 12:51:41 UTC | Type: | --- | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Attachments: |
|
||||||
|
Description
IBM Bug Proxy
2019-05-17 05:40:13 UTC
== 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 |