Bug 123584 - [EDITING] `[HH]:MM` formatting has rounding problem (0:59 instead of 1:00 for example)
Summary: [EDITING] `[HH]:MM` formatting has rounding problem (0:59 instead of 1:00 for...
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: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-02-19 19:18 UTC by Wojtek
Modified: 2019-02-20 21:45 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Example spreadsheet (11.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-02-19 19:19 UTC, Wojtek 		Details
screenshot showings wrong calculations (279.17 KB, image/png)
2019-02-19 19:20 UTC, Wojtek 		Details
Example spreadsheet after reopening with correct data (300.08 KB, image/png)
2019-02-19 19:21 UTC, Wojtek 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Wojtek 2019-02-19 19:18:20 UTC 
Description:
For some reason LO Calc cell that calculates value from other cell (time-diff) that is configured with `[HH]:MM` formatting shows rounding error. After saving and re-opening the file cells are correctly re-calculated. It started with 6.2.x release and was warking correctly before..

Steps to Reproduce:
1. Create new spreadsheet
2. Create 3 columns formatted as _Time_ with `[HH]:MM` configuration, 3. column should be diff or column 2 and 1
3. enter a couple of values (15m rounding in my case showed the isssue) in columns 1 and 2

Actual Results:
Sometimes i see 0:59 or 0:14 instead of 1:00 and 0:15 respectively

Expected Results:
I should see 1:00 and 0:15


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.2.0.3
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU threads: 8; OS: Mac OS X 10.14.2; UI render: default; VCL: osx; 
Locale: pl-PL (es_PL.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Wojtek 2019-02-19 19:19:36 UTC 
Created attachment 149430 [details]
Example spreadsheet

It shows values correctly after (re-)opening.
Comment 2 Wojtek 2019-02-19 19:20:21 UTC 
Created attachment 149431 [details]
screenshot showings wrong calculations
Comment 3 Wojtek 2019-02-19 19:21:27 UTC 
Created attachment 149432 [details]
Example spreadsheet after reopening with correct data
Comment 4 m_a_riosv 2019-02-20 21:45:38 UTC 

*** This bug has been marked as a duplicate of bug 122991 ***