This is an enhancement request for autofill to better sense data blocks with double click, as seen in MSO since 2013.
See examples in ODS attachment 152498 [details].
Double click on H1 fills up to H2, because previous column has some empty cells, instead of up to H10.
Double click on M1 doesn’t fill to M10, because previous column is empty.
Can't verify in Excel, I have 2010 version,
but I agree this enhancement.
While I can agree the autofill logic and its behavior handling empty cells needs consistency--and so requires ongoing review--it is not clear this "enhancement" (nor that of bug 66890) is merited to try to match MS Office 2013 (or later) nor any other spreadsheet offering.
IIUC it would require rework of what has been functional autofill logic inherited from OOo, that while conservative protects user sheet data.
Since from the LO perspective, we already do the correct thing, no need to chase other implementations. IMHO => WF
I don't think this enhancement is related to bug 66890 nor that it jeopardizes user sheet data. Per attached example, it simply better fill empty cells.
Enhancements like this one are better to have because they can be done sometimes and they can be found as noted, in case someone searches. They are still at Low.
Right now the autofill functions works transparently on the left column and fills data until the next empty cell (great example, btw). Any modification to this logic makes it hard to understand. For example, "if left column is empty take the next" or "if only one cell is empty take the next down". Users will not understand the logic behind. My take is WFM.
Just for completeness: if there is no data immediately to the left then autofill looks for data immediately to the right.
Double-checked MSO and the logic is simple: fill if either the left cell has content or the cell next to it (and as Eike mentioned right when left is empty).
This would be filled from C1:C4 (3 7):
A B C
Thanks for checking. What does it do if A1 is empty (assuming that we start filling with value x that is missing in your context/layout)
A B C
And what if B1 is empty instead?
A B C
(In reply to Eike Rathke from comment #7)
> What does it do if A1 is empty...
It's filled from C1:C4
> And what if B1 is empty instead?
No cells are filled in this case.
So the rule is: a) left (or right) is filled at the starting cell and b1) left (or right) and one more column has a value.
A B C D
is filled from C1:C6. Tested with more columns and it works as well unless there is a gap. So
A B C D
is just filled from C1:C2.
Created attachment 153702 [details]
Autofill test ODS
Au lieu of attachment 152498 [details], I attach ODS with all those examples.