Bug 124444 - FORMATTING: Time format difference between [UU]:MM and UU:MM
Summary: FORMATTING: Time format difference between [UU]:MM and UU:MM
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 All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-03-30 10:08 UTC by Luuk
Modified: 2019-03-30 15:10 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
time rounding (8.71 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-03-30 15:10 UTC, Oliver Brinzing 		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 Luuk 2019-03-30 10:08:52 UTC 
To reproduce this
- Enter 17:00:00 in A1
- Enter 17:30:00 in A2
- Enter this formula in B2:  =A2-A1
- Enter this formula in C2:  =A2-A1
- change format of B2 to UU:MM:SS
- change format of B3 to [UU]:MM:SS

The value shown in B2 is 00:30:00, while in C2 00:29:59 is shown.

This is not an acceptable rounding error!
Comment 1 Luuk 2019-03-30 10:16:51 UTC 
"This is not an acceptable rounding error!"
should have been:
This is not an acceptable way of formatting data!"
Comment 2 Oliver Brinzing 2019-03-30 15:10:10 UTC 
not reproducible with:

Version: 6.2.2.2 (x64)
Build-ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: 

Version: 6.1.5.2 (x64)
Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: de-DE (de_DE); Calc: 

i think, this is a duplicate of:

Bug 122991 - FORMATTING: Regression from 6.1 to 6.2 in displaying 
times formatted as Time 876613:37:46 (edit)

*** This bug has been marked as a duplicate of bug 122991 ***
Comment 3 Oliver Brinzing 2019-03-30 15:10:40 UTC 
Created attachment 150413 [details]
time rounding