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).
(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.
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.
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
Created attachment 149283 [details] minimal broken example
Created attachment 149284 [details] screenshot of the above, in case the calculation ends up correct for you
*** This bug has been marked as a duplicate of bug 122991 ***