Bug 133978

Summary: AutoFill fails to autocomplete time paterns
Product: LibreOffice Reporter: antistress <anti-stress>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: anti-stress, himajin100000, miguelangelrv
Priority: medium    
Version: 6.4.4.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Sample file for test.

Description antistress 2020-06-14 09:38:40 UTC 
Description:
After 9h00 and 9h20, autofill should bring 9h40, 10h00 and so on

Steps to Reproduce:
On my french system :

Open a Spreadsheet
within a row, format cells with "Time"
They key :
8h40
9h00
9h20
9h40
10h00
Highlight both cells
Drag down


Actual Results:
8h40
9h00
9h20
9h40
10h00
8h41
9h01
9h21
9h41
10h01
8h42
9h02
9h22
9h42


Expected Results:
8h40
9h00
9h20
9h40
10h00
10h20
10h40
11h00
etc.


Reproducible: Always


User Profile Reset: No



Additional Info:
I'm using LibreOffice Flatpak 6.4.4.2 on GNU/Linux Debian Testing GNOME-Wayland system
The whole system is in french as I live in France
Comment 1 m_a_riosv 2020-06-14 13:56:40 UTC 
Created attachment 161986 [details]
Sample file for test.

That happens because the values to drag are not true time values.
Format a cell as time doesn't change their value, they are text times.
As text LibreOffice does like with any other text ending with a number, increasing that number.
Please do a test with the attached file on cells with true times column A and cells with text times column C
Comment 2 antistress 2020-06-14 15:19:52 UTC 
I've performed the test : indeed, thanks !