Bug 131029 - When the time is autofilled, the integer part is incremented
Summary: When the time is autofilled, the integer part is incremented
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: AutoFill
  Show dependency treegraph
 
Reported: 2020-02-29 13:38 UTC by Jun Nogata
Modified: 2020-09-28 08:41 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Reproduction steps (90.47 KB, image/gif)
2020-02-29 13:40 UTC, Jun Nogata
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jun Nogata 2020-02-29 13:38:51 UTC
Description:
When autofilling a cell with a time entered, the integer part is incremented to the wrong value.

Steps to Reproduce:
1. Enter "1:" in cell A1.
2. Drag the autofill handle.(The time display does not change. but, the integer part has been incremented.)
3. Change the number format in the sidebar from time to general.


Actual Results:
The integer part has increased as in the following example.

0.041666666666667
1.04166666666667
2.04166666666667
3.04166666666667
4.04166666666667

or If the number format is time.

01:00:00 AM
02:00:00 AM
03:00:00 AM
04:00:00 AM
05:00:00 AM


Expected Results:
The decimal part increases and the integer part does not change as follows.

0.041666666666667
0.083333333333333
0.125
0.166666666666667
0.208333333333333



Reproducible: Always


User Profile Reset: No



Additional Info:
The time display does not change. So I do not notice.

Version: 6.4.1.2
Build ID: 4d224e95b98b138af42a64d84056446d09082932
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: en-US (C); UI-Language: en-US
Calc: threaded
Comment 1 Jun Nogata 2020-02-29 13:40:25 UTC
Created attachment 158275 [details]
Reproduction steps
Comment 2 Jun Nogata 2020-02-29 13:44:19 UTC
(In reply to nogajun from comment #0)
> or If the number format is time.
> 
> 01:00:00 AM
> 02:00:00 AM
> 03:00:00 AM
> 04:00:00 AM
> 05:00:00 AM

Sorry, misstake. it part is Expected Results.
Comment 3 Oliver Brinzing 2020-03-01 13:09:12 UTC
reproducible, LO adds 24 hours, while excel adds 1 hour:

LO            Excel
[HH]:MM:SS    HH:MM:SS
01:00:00      01:00:00
25:00:00      02:00:00
49:00:00      03:00:00