[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 bugzilla-daemon at bugs.documentfoundation.org
Wed Jul 12 13:14:15 UTC 2023


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

--- Comment #17 from ady <adylo811517 at gmail.com> ---
The request has to be more clear and precise. It cannot be in one comment to
use [CTRL], later to use [SHIFT], and then to use [ALT], or to keep changing
the scenarios. This is why I mentioned that "by-default" shortcuts have to be
thought slightly deeper than whatever pops up first.

I think that a more precise request could be (mentioned as one of those almost
random thoughts in a prior comment):

* Instead of only considering the "left-side" column (or "prior" column or
however it would be called for RTL/CTL cases), consider both
immediately-adjacent columns and execute Autofill according to the "longest" of
the two columns when double-clicking the Autofill corner.

* The Autofill action will remain the same; the difference is that both-sides
adjacent columns are considered instead of the "prior" column only. This would
be consistent for RTL layout.

* To be determined: what happens when hidden columns are adjacent, at either or
both sides of the relevant column.

* No new shortcuts.


For future independent evaluation (i.e. another report): Since Calc lacks an
"Autofill icon" next to the autofill corner (available in other spreadsheet
tools), new alternative shortcuts+mouse_clicks could show the Fill Series (or a
Fill Options if you want) dialogue; or add an equivalent "Autofill icon" to the
Autofill corner (as Excel has).

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


More information about the Libreoffice-ux-advise mailing list