[Libreoffice-bugs] [Bug 123889] New: When I type in certain times the get changed to a lesser time, i.e. 0:13 gets changed to 0:12 (0:12:59.99).

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123889

            Bug ID: 123889
           Summary: When I type in certain times the get changed to a
                    lesser time, i.e. 0:13 gets changed to 0:12
                    (0:12:59.99).
           Product: LibreOffice
           Version: 6.2.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: redwdc at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190305/b2c9357f/attachment-0001.html>