[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 #7 from ady <adylo811517 at gmail.com> ---
Which exactly is the proposal?

Having some new configurable setting?

Adding some by-default shortcut?

Changing some currently-used shortcut?

Adding the desired action to the Customize > Keyboard > Function (list) but
without setting a shortcut by default? (I would "vote" for this, if this
alternative would be available/possible in said dialogue.)


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).

Generic statement (not limited to this particular case): Please be aware of
"randomly" setting by-default shortcuts that are used differently in other LO
modules or even in alternative spreadsheet tools. Such seemingly-intuitive
shortcuts will trigger difficulties for users of other modules (who assume the
shortcuts work "consistently" within LO) or for users that are already used to
the same shortcut with a different effect in other spreadsheet tools.

Now, for the example presented in comment 0, there are several alternatives
(which takes longer to describe in steps than it takes to completely execute
them in practice), such as (one of many possibilities, similar to comment 3):

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]

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.

I am very much aware that shortcuts can improve efficiency. I wished there
would be shortcuts in many cases for Calc usage that have been available in
other spreadsheet tools for decades (making them far more efficient).

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

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