Bug 123423 - Time range calculation sometimes off by one
Summary: Time range calculation sometimes off by one
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-02-13 00:56 UTC by documentfoundation.org
Modified: 2019-02-13 20:55 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
minimal broken example (8.82 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-02-13 20:54 UTC, documentfoundation.org
Details
screenshot of the above, in case the calculation ends up correct for you (6.19 KB, image/png)
2019-02-13 20:55 UTC, documentfoundation.org
Details

Note You need to log in before you can comment on or make changes to this bug.
Description documentfoundation.org 2019-02-13 00:56:36 UTC
Description:
Time range calculations in cells formatted as [HH]:MM are sometimes wrong. Confirmed working as expected in 6.1.4.2, broken in 6.2.0.3

Steps to Reproduce:
1. Create a new sheet.
2. Format all cells with Format code [HH]:MM
3. Set A1: 01:30 B1: 01:15 C1: =A1-B1
4. I used rows 2-24 to do the same thing with 02:30/02:15, 03:30/03:15, ...

Actual Results:
All cells in column C show 00:15

Expected Results:
Some (but not all) cells in column C show 00:14


Reproducible: Always


User Profile Reset: No



Additional Info:
Occurs only after upgrading from 6.1.4.2 to 6.2.0.3. Which rows show 00:15 and 00:14 is different when doing the same steps on two devices (both running arch linux, both 6.2.0.3).
Comment 1 documentfoundation.org 2019-02-13 00:58:15 UTC
(In reply to documentfoundation.org from comment #0)
> Actual Results:
> All cells in column C show 00:15
> 
> Expected Results:
> Some (but not all) cells in column C show 00:14

Mixed expected/actual result fields there, sorry.
Comment 2 Xisco Faulí 2019-02-13 10:03:40 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 3 Oliver Brinzing 2019-02-13 17:44:11 UTC
this issue could be a duplicate of:

https://bugs.documentfoundation.org/show_bug.cgi?id=123365
Calculation of time values of by one with custom formating

https://bugs.documentfoundation.org/show_bug.cgi?id=122991
FORMATTING: Regression from 6.1 to 6.2 in displaying times 
formatted as Time 876613:37:46
Comment 4 documentfoundation.org 2019-02-13 20:54:31 UTC
Created attachment 149283 [details]
minimal broken example
Comment 5 documentfoundation.org 2019-02-13 20:55:10 UTC
Created attachment 149284 [details]
screenshot of the above, in case the calculation ends up correct for you
Comment 6 documentfoundation.org 2019-02-13 20:55:45 UTC

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