Created attachment 166546 [details] Example file from Calc When autofilling adjacent merged cells containing mixed strings of letters and numbers in Calc, the results are incorrect compared to non-merged cell results. Steps to reproduce: 1. Open attached file 2. In A2:B2 there are letter-number strings with a difference of 3 between the number values. A3:B3 is similar but the difference is -2. 3. In A7:D8 the same letter-number strings are placed in merged cells. 4. In C2:F2 the A2:B2 range is autofilled, causing the numbers to grow with a difference of 3 5. In C3:F3 the A3:B3 range is autofilled, causing the numbers to reduce by 2. 6. In the E7:L7 range the A7:D7 range is autofilled, the merging now happens correctly, but the numbers in the contents don’t grow as a series by 3, instead by 1: a1 – a2 – a3 and a4 – a5 – a6 7. Similarly in the E8:L8 range the A8:D8 range is autofilled but series detection does not work correctly: the numbers grow separately as two series: B12 – B13 – B14 and B10 – B11 – B12. Actual results: As above. Expected results: Series detection should work in merged cells, giving the same results as with non-merged cells. Cell range E11:L12 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 166547 [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.
Wrong commit notification. That patch was intended to solve bug #137654.
Attila Szűcs committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/09eccdc87db5258ea779e2bcc12437f802624ee5 tdf#137624 sc: autofill mixed 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.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!