Bug 123889 - When I type in certain times they get changed to a lesser time, i.e. 0:13 gets changed to 0:12 (0:12:59.99).
Summary: When I type in certain times they get changed to a lesser time, i.e. 0:13 get...
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) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-03-05 23:16 UTC by redwdc
Modified: 2019-03-07 15:25 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
a copy of the test sheet I made (26.91 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-03-07 14:33 UTC, redwdc
Details

Note You need to log in before you can comment on or make changes to this bug.
Description redwdc 2019-03-05 23:16:10 UTC
Description:
When I type in certain times they get changed to a lesser time, i.e. 0:13 gets changed to 0:12 (0:12:59.99). But only in certain times and formats.

0:13, 0:26, 0,33, 0:49, and 0:52. I only went from 0:01 to 1:00

Formatted       Customized   Event
To              To           Occurred
01:37 PM                     No
13:37                        No
13:37           [H]:MM       Yes but only 0:26
876613:37:45                 Yes
876613:37                    Yes
876613:37       [H]:MM       Yes *
876613:37:45.99              Yes
876612:37       [H]:MM       Yes

Using the format with the * I did:

row 1  0:01
row 2 =sum(h1+"0:01")

Then copied it down to 1:00. it repeated 0:12 (row 12 and row 13)got errors this was also.

It happens on any spread sheet in any location in a spread sheet, and on three different computers.

I saved a copy if the table I made as an HTML and posted it to:

http://web.newsguy.com/redwdc/time_test.html

My main computer is running Win 10 build 17763.348
Laptop is running win 10 build 17763.316
Third system win 10 build 17134.619

Steps to Reproduce:
1.Just type in any of the following times, 0:13, 0:26, 0,33, 0:49, and 0:52.
2.
3.

Actual Results:
the wrong times came up

Expected Results:
The right times


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 6.2.0.3 (x64)
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 1 Aron Budea 2019-03-06 23:00:29 UTC
This looks like bug 122991, please test again with version 6.2.1.2.

*** This bug has been marked as a duplicate of bug 122991 ***
Comment 2 redwdc 2019-03-07 14:33:39 UTC
Created attachment 149795 [details]
a copy of the test sheet I made
Comment 3 Aron Budea 2019-03-07 15:25:41 UTC
Please test again with version 6.2.1.2, it's available on the website.