[Libreoffice-ux-advise] [Bug 149356] Choose which adjacent column of a "double clicked" formula dictates the extent of the fill

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=149356

--- Comment #11 from Eyal Rozenberg <eyalroz1 at gmx.com> ---
(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 on the CC list for the bug.