Description: Double click on the fill-handle, - on a cell with a Formula involving references to cells in other columns- should fill till the last row where still have references in the respective columns, so that that Formula can still work. Use-case: in sheet1.A1:A500 have data. In sheet2, in A1 have a formula depending on sheet1.A1. You want to autofill downwards. You cannot even have a "column to the left" to make double-click on the fill handle work. Yet I don't see other good options, as: - dragging would be too hard if have thousands of rows - grouping and/or hiding a chunk of rows in sheet2 makes autofill not work on the hidden rows at all Steps to Reproduce: 1. in a new sheet, say sheet1, in range A1:A5 put the numbers 1...5 2. in a new sheet, say sheet2, in A1, put: =sheet1.A1 and "enter" 3. double-click the right-down corner of A1 for autofill Actual Results: Nothing. Expected Results: Fill sheet2.A1:A5 with the numbers 1..5 Reproducible: Always User Profile Reset: No Additional Info: Version: 25.2.5.2 (X86_64) / LibreOffice Community Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022 CPU threads: 2; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
I suggest that the requested behaviour also be done when the 2 columns in question are in the same sheet and non-adjacent, and regardless of which is to the left of which. Moreover, IMO, that (the extent of the columns on which the formula depends) should be the First criterion to decide the extent of the autofill - even if there are other columns right next to it. If the formula/expression does not depend on other columns - then it makes sense to pay attention to the non-emptiness of cells in adjacent columns.
Perhaps also take into consideration the impact of auto-filtered or Data>Group>Hide. F12 in either sheet
(In reply to vic from comment #0) > > Steps to Reproduce: > 1. in a new sheet, say sheet1, in range A1:A5 put the numbers 1...5 > 2. in a new sheet, say sheet2, in A1, put: =sheet1.A1 and "enter" > 3. double-click the right-down corner of A1 for autofill > That would be a serious contender for Excel's Array Spilling functionality