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 - Libreoffice Calc not rounding time calculation correctly
Summary: Libreoffice Calc not rounding time calculation correctly
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: libreoffice
Version: 30
Hardware: x86_64
OS: Linux
high
high
Target Milestone: ---
Assignee: Caolan McNamara
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2019-05-17 05:40 UTC by IBM Bug Proxy
Modified: 2023-09-12 01:47 UTC (History)
7 users (show)

Fixed In Version: libreoffice-6.2.3.2-5.fc30
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-05-30 12:51:41 UTC
Type: ---
Embargoed:

Attachments (Terms of Use)
Example file showing the problem. (8.65 KB, application/octet-stream)
2019-05-17 05:40 UTC, IBM Bug Proxy 		no flags Details
View All


Links
System ID Private Priority Status Summary Last Updated
IBM Linux Technology Center 177696 0 None None None 2019-06-14 20:30:35 UTC

Description IBM Bug Proxy 2019-05-17 05:40:13 UTC
Comment 2 IBM Bug Proxy 2019-05-17 05:40:25 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.
Comment 3 IBM Bug Proxy 2019-05-17 05:40:34 UTC 
Created attachment 1569926 [details]
Example file showing the problem.
Comment 4 Eike Rathke 2019-05-17 10:45:13 UTC 
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.
Comment 5 Caolan McNamara 2019-05-17 19:10:21 UTC 
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 ?
Comment 6 Fedora Update System 2019-05-28 08:35:57 UTC 
libreoffice-6.2.3.2-5.fc30 has been submitted as an update to Fedora 30. https://bodhi.fedoraproject.org/updates/FEDORA-2019-f2e3a7654e
Comment 7 Fedora Update System 2019-05-29 01:35:43 UTC 
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
Comment 8 Fedora Update System 2019-05-30 12:51:41 UTC 
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.
Comment 9 Red Hat Bugzilla 2023-09-12 01:47:29 UTC 
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 1000 days
Note You need to log in before you can comment on or make changes to this bug.