https://bugs.documentfoundation.org/show_bug.cgi?id=139681
--- Comment #6 from antifascist <[email protected]> --- I accidentally added a duplicate of this bug as bug 157466 - autofill of ascending references fails with non-sequential cell references. In case my different wording of this bug is helpful, here it is, copied from my duplicate bug: Description: Working example, followed by non-working example: Autofill function works correctly with sequential ascending cell references. Example: Create spreadsheet as follows: A1: meow A2: woof A3: cluck A4: moo A5: bark B1: =A1 B2: =A2 You may now select B1 and B2, and then you may drag the the fill handle in the bottom right corner of the selection across the cells B3, B4, and B5, and release the mouse button. Result: The cells B3, B4, and B5 will auto-fill correctly, showing values of "cluck", "moo", and "bark" respectively. Column B now contains these cell references: B1: =A1 B2: =A2 B3: =A3 B4: =A4 B5: =A5 Autofill of ascending references fails with non-sequential cell references. Example: Creat spreadsheet as follows: A1: cat says A2: meow A3: dog says A4: woof A5: chicken says A6: cluck A7: cow says A8: moo A9: dog says A10: bark B1: =A2 B2: =A4 You may now select B1 and B2, and then you may drag the the fill handle in the bottom right corner of the selection across the cells B3, B4, and B5, and release the mouse button. Result: The cells B3, B4, and B5 will auto-fill incorrectly, showing values of "woof", "cluck", and "cluck" respectively. Column B now contains these cell references: B1: =A2 B2: =A4 B3: =A4 B4: =A6 B5: =A6 The expected behavior would have been for column B to instead contain these cell references: B1: =A2 B2: =A4 B3: =A6 B4: =A8 B5: =A10 -- You are receiving this mail because: You are the assignee for the bug.
