Bug 123924 - TIme formatting/precision unreliable
Summary: TIme formatting/precision unreliable
Status: RESOLVED DUPLICATE of bug 122991
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-03-07 13:10 UTC by schopdiedwaas
Modified: 2019-03-07 13:50 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description schopdiedwaas 2019-03-07 13:10:53 UTC
Description:
When I used Calc to add up logged hours, I noticed some inaccuracies in the way LibreOffice formats and adds time values.

Steps to Reproduce:
- Format any field as a time value with format '[UU]:MM'
- Enter the value '01:55' or '2305:11' in the field (other values may behave the same).

Actual Results:
01:55 will be displayed as 01:54 in the spreadsheet, but the input line correctly shows 01:55:00.
2305:11 will be displayed as 2305:10, and the input line shows 2305:10:59.

When using these values in formulas later on, I get some unexpected results as well. For example adding 26:07 and 1763:35, with the former being the sum of 01:55 and some other values, results in 1789:41.

Expected Results:
All time values should be displayed and calculated as entered.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 6.2.0.3
Build ID: 6.2.0-3
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; 
Locale: nl-NL (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Aron Budea 2019-03-07 13:35:59 UTC
Seems like bug 122991, please retest with version 6.2.1.

*** This bug has been marked as a duplicate of bug 122991 ***
Comment 2 schopdiedwaas 2019-03-07 13:50:14 UTC
Looks like the same issue indeed. I'm on Arch Linux, which has 2 versions of libreoffice in the repos. Changing from libreoffice-fresh (6.2.0) to libreoffice-still (6.1.5) fixed the issue for me.