https://bugs.documentfoundation.org/show_bug.cgi?id=149356
--- Comment #11 from Eyal Rozenberg <[email protected]> --- (In reply to Heiko Tietze from comment #3) > go to the end (ctrl+down) Actually, going "down" is not so easy. If you go "down" within the empty column, you don't get the the highest-index row with any content in the sheet, you get to row 1048576. > Personally I would copy, move (left/right), go to the end (ctrl+down), move > (left/right), select upwards (shift+ctrl+up) 1. That doesn't work if you want to autofill based on a selection of multiple cells. 2. That's a rather contrived sequence of actions. And even if a user thought of something like that, they would be deterred by the select-upwards selecting the (last) copied cell. 3. I would rather not need to have to view the bottom of the sheet in order to effect this. (In reply to Colin from comment #0) > it will only ever fill-down to row 50 I was actually surprised to find out that if, in your example, you switch the order of the columns, i.e. column A has 500 rows and column C has 50, then autofill in column B will fill down to 500 rather than 50. i.e. the fact that the end of column C is _not_ an obstruction is IMHO a bug. Perhaps I should file it separately? I should also note that in RTL, autofill currently fills to the end of the column to the right, i.e. it only looks for obstruction in the preceding column (whether you're in RTL or LTR), never the succeeding column. ---- My bottom line: I would like to be able to open a "context menu" for auto-filling for choices regarding: * Choice of rule for autofill content (copy last element, repeat sequence, continue sequence linearly, etc.) * Choice of rule for stopping the autofill (i.e. what constitutes an 'obstruction') Also, I would change the default to consider obstructions on both sides. -- You are receiving this mail because: You are the assignee for the bug.
