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
Created attachment 189842 [details] spreadsheet demonstrating the reported bug attached is a spreadsheet demonstrating the reported bug
I found this bug is a duplicate of 139681. will update bug 139681 with the info from this bug.
NOT A BUG Use in B1: =OFFSET(A1;ROW();0) and pull down
Werner, I disagree because the behavior is inconsistent. For numbers, the autofill works one way, but when the same numbers are present as cell references, then the autofill produces chaotic results. I appreciate the workaround method you have shared, however, this autofill should be fixed. It is normal to be able to produce the same result with different methods, however in this case, the autofill method seems to be malfunctioning. There can not seem to be a rational explanation to explain why the autofill function should produce the behavior that we see here. If there is an explanation for it, I would be curious to know about it? Thank you! *** This bug has been marked as a duplicate of bug 139681 ***