[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 #12 from Eyal Rozenberg <eyalroz1 at gmx.com> ---
(In reply to ady from comment #7)
> FWIW, [CTRL]+DOUBLE_CLICK on the bottom-right corner is already used for
> filling (based on the left-side column, without modifying the initial value).

So this is a 'bikeshedding' point IMHO, but I would go for a right-click on the
corner-square handle. Right now, that behaves like a regular right-click on a
cell.

> 0. From cell B1, [CTRL]+[C]
> 1. [RIGHT] (go to C1)
> 2. [CTRL]+[DOWN]
> 3. [LEFT]
> 4. [CTRL]+[SHIFT]+[UP] (or move the scroll bar up and [SHIFT]+click on cell
> B1)
> 5. [CTRL]+[V]

Lots of acrobatics. I'm lazy and want to be coddled :-)


> Another alternative:
> 
> 1. Fill in column D
> 2. Re-arrange the columns as needed (there are several ways to do this, some
> more efficient than others.

Requiring an auxiliary column is clunky, and remember - column D may be filled
with other things, so we would need to insert a column, then work with it, then
delete the column; and if we have objects that are not anchored the right way,
they may be hiding column D (like a chart maybe?) ... so, not good enough.

> The question is whether adding a specific by-default shortcut for this case
> is wise.

That's not the main question... the functionality is useful, whether there's a
keyboard shortcut for it or not. (And I don't even care much for a keyboard
shortcut for this.)

-- 
You are receiving this mail because:
You are on the CC list for the bug.