https://bugs.documentfoundation.org/show_bug.cgi?id=157466
Bug ID: 157466 Summary: autofill of ascending references fails with non-sequential cell references Product: LibreOffice Version: unspecified Hardware: All OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: e...@x84.org 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 Steps to Reproduce: Autofill of ascending references fails with non-sequential cell references. Example: Create 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. Actual Results: 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 Expected Results: 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 Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no Version: 7.4.0.3 (x64) / LibreOffice Community Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL -- You are receiving this mail because: You are the assignee for the bug.