Bug 119375 - Can not autofill time with Calc
Summary: Can not autofill time with Calc
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-08-20 00:25 UTC by tadanet3
Modified: 2018-08-26 14:20 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Video showing the error (560.15 KB, video/mp4)
2018-08-20 05:57 UTC, BogdanB 		Details
"Fill Series" dialog (22.36 KB, image/png)
2018-08-25 19:02 UTC, Shinji Enoki 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description tadanet3 2018-08-20 00:25:01 UTC 
Description:
Can not autofill time with Calc

Steps to Reproduce:
1.Input 01:00 to cell
2.autofill 3 lines
  01: 00: 00 is displayed in the tooltip and cell
3.Select each cell
  25:00:00
  49:00:00
  73:00:00
  is displayed
  24:00:00 is added

decimal or weekday or date can autofill.
Comment 1 BogdanB 2018-08-20 05:57:36 UTC 
Created attachment 144318 [details]
Video showing the error

Confirm it. 
Version: 6.1.1.0.0+
Build ID: 5a56b72413d5f555c854e36d3bd2fd50ec21644c
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:libreoffice-6-1, Time: 2018-08-15_02:45:13
Locale: ro-RO (ro_RO.UTF-8); Calc: group threaded
Comment 2 Xavier Van Wijmeersch 2018-08-20 13:50:50 UTC 
When standard number is used then yes no correct filling, but selecting time like [UU]:MM:SS in exp D1 and then drag down with the mouse then there is the correct value in the cell's

01:00:00
25:00:00
49:00:00
73:00:00
97:00:00

So for me not a bug

Version: 6.1.1.0.0+
Build ID: 2b52e332b7d6cd18cb024295c1218517cf6d27d9
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group threaded

if you not agree then you can reopen the report as unconfirmed
Comment 3 Shinji Enoki 2018-08-25 18:50:01 UTC 
I reproduced it in the following environment.

Debian jessie
Version: 6.1.0.3
Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU threads: 4; OS:Linux 3.16; UI render: default; VCL: gtk2; 
Local: ja-JP (ja_JP.utf8); Calc: group threaded


I think that addition of 24 hours in each row is not expected result.
I think that expected result is to add each row by 1 hour or 1 second.

01:00:00
02:00:00
03:00:00

or 

01:00:00
01:00:01
01:00:02
Comment 4 Shinji Enoki 2018-08-25 19:02:04 UTC 
Created attachment 144438 [details]
"Fill Series" dialog

I tried looking for a workaround.

But, It seems that it can not set hour, minutes, seconds by "Fill Series" dialog.

Menu [Sheet]-[Fill Cells]-[Series...]
Comment 5 Xavier Van Wijmeersch 2018-08-26 14:20:46 UTC 
@Shinji Eniko

With the fill series, yes you cannot set it per hour or minutes
The mp4 shows dragging with a mouse and i mist the point of the reporter
Workaround is exp in A1 type 1:00 and then in A2 2:00 select them and drag with the mouse down, then you will have a fill by hour etc.
Maybe a future request for filling per hours in Sheet -> fill cells -> series

Version: 6.1.2.0.0+
Build ID: f675adc55e9dee1185b57d8e51df7ad3c9364753
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group threaded