Bug 133978 - AutoFill fails to autocomplete time paterns
Summary: AutoFill fails to autocomplete time paterns
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-06-14 09:38 UTC by antistress
Modified: 2020-06-14 15:19 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample file for test. (9.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-06-14 13:56 UTC, m_a_riosv 		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 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 !