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: 7.1.0.0.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 Calc: CL
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": https://git.libreoffice.org/core/commit/d64bd977a430182826252695f041a6ddd62e45ef 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.2.0.0.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 Calc: threaded Thanks for fixing!