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!
This is an interesting case — it clearly shows how merged cells behave differently in Calc compared to non-merged ones when using autofill. Hopefully the detection logic for user list items can be improved in future updates. On another note, for those who enjoy exploring digital tools for entertainment and customization, you might want to check out https://thelulubox.com/.
The example makes it very clear how Calc handles merged cells differently during autofill — it’s definitely something that could use refinement in future releases. While software bugs can be frustrating, technology also offers amazing tools that improve our daily lives, like apps for enhancing photo quality. You can https://proreminiapp.com/ about one such tool here.
This report highlights a useful detail about how merged cells behave in Calc — it’s always interesting to see where software features still need improvement. Technology, however, isn’t only about work; it can also support personal routines, like staying consistent with daily prayers. For those who need a reliable resource for prayer schedules, you can https://muslimprayertimes.info/ here.
The issue with autofill in merged cells is well described here — it shows how even small details in software can affect productivity. Beyond work, technology can also help in personal life, like keeping track of prayer times no matter where you are in the US. If you’d like a reliable resource for that, you can https://muslimprayertimes.us/.
This bug report is a good example of how small details in software can impact the overall user experience. Just like in technology, paying attention to details is also important when preparing for careers and job applications. For tips and useful resources on how to improve your applications, you can https://thesolicituddeempleo.com/.