Created attachment 166548 [details] Example file from Calc with merged cells filled with user list items When autofilling adjacent merged cells containing user list items in Calc, the results are incorrect compared to non-merged cell results. Steps to reproduce: 1. Open attached file 2. In A2:A3 is the first two month names in the Hungarian default user list, also in the merged cells in A5:D5. 3. C2:F2 is autofilled after selecting A2:A3 and the user list is detected correctly, subsequent month names are filled. 4. E5:L5 is autofilled after selecting A5:D5, and the cell merging now happens correctly but the user list items are not detected, so only the first two month names repeat. Actual results: As above. Expected results: Series detection should work in merged cells, giving the same results as with non-merged cells. Cell range E8:L8 illustrates this. LibreOffice details: Version: 7.1.0.0.alpha0+ (x64) Build ID: 586f6abee92af3cdabdce034b607b9a046ed3946 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: CL
Created attachment 166549 [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/e8a88d6129948227b46d734a7eba999ec9d1a025 tdf#137625 sc: autofill user list sequences in merged cells 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.1.0.0.alpha1+ (x64) Build ID: 72056f39e01e36afac36c62988331b6813c8214f 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!
I too has the same problem, and it still persists, any comments? https://hometone.com/making-it-all-come-together-with-an-interior-concrete-block-wall-finish.html
It’s clear that the autofill logic handles user list detection correctly when working with normal cells, but fails once merged cells are involved. The fact that the merged cells repeat only the initial entries instead of recognizing the full list sequence shows that series detection isn’t being triggered in that context. Hopefully this can be improved in future updates so that merged cells behave the same way as regular ones during autofill. After struggling with small Calc bugs like this, it’s sometimes refreshing to take a quick break with a fun https://trafficridermodapk.me to reset the mind!