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.
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.
Version: 18.104.22.168.alpha0+ (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
Created attachment 166584 [details]
Screenshot of the problem in Calc
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.
Version: 22.214.171.124.alpha0+ (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
Thanks for fixing!