Bug 137653 - EDITING Autofill user list items with more than 1 item difference does not work
Summary: EDITING Autofill user list items with more than 1 item difference does not work
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Attila Szűcs
Whiteboard: target:7.1.0
Depends on:
Blocks: AutoFill
  Show dependency treegraph
Reported: 2020-10-21 13:00 UTC by NISZ LibreOffice Team
Modified: 2020-12-30 10:09 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Example file from Calc (11.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-21 13:00 UTC, NISZ LibreOffice Team
Screenshot of the problem in Calc (29.99 KB, image/png)
2020-10-21 13:00 UTC, NISZ LibreOffice Team

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2020-10-21 13:00:07 UTC
Created attachment 166583 [details]
Example file from Calc

Calc can autofill cells with user list items such as days, months. 
This works if two selected cells contain adjacent items from a user list, but not if the items are 2 or more positions apart in the list.
Excel can detect non-adjacent user list items so migrating users can expect this feature from Calc too.

Steps to reproduce:
    1. Open attached file
    2. The A2:B2 range contains January and March
    3. C2:F2 was autofilled by selecting A2:B2 and pulling right. Month names are autofilled starting from March in B2 and increasing by one instead of two.
    4. A3:C3 range contains January, April and July, and it was selected and pulled to the right to autofill D3:G3 range. Month names are autofilled starting from July in C3 and are increased by one instead of three.
    5. C5:F5 and D6:H6 ranges demonstrates what Excel would do with a similar setup.

Actual results:
As above.

Expected results:
Calc should detect non-subsequent user list items when autofilling with two or more selected cells and apply user list items according to the difference between items found in the selected cells.

LibreOffice details:
Version: (x64)
Build ID: e0c72e31c1d455c26110c35e8780d420e17cdea6
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL
Comment 1 NISZ LibreOffice Team 2020-10-21 13:00:25 UTC
Created attachment 166584 [details]
Screenshot of the problem in Calc
Comment 2 Commit Notification 2020-11-05 16:28:12 UTC
Attila Szűcs committed a patch related to this issue.
It has been pushed to "master":


tdf#137653 tdf#137624 sc: fix autofill user list sequences

It will be available in 7.1.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:

Affected users are encouraged to test the fix and report feedback.
Comment 3 NISZ LibreOffice Team 2020-12-30 10:09:25 UTC
Verified in:

Version: (x64)
Build ID: 368c56144aab5794c39d5bc2082d9b3d6d7cebdb
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: threaded

Thanks for fixing!