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.
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
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
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
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...]
@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