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

--- Comment #14 from ady <[email protected]> ---
I think there might be some misunderstandings, and enhancements to make in this
ticket.

First, LibreOffice Calc's documentation, help files, wiki pages and *tool tips*
should be as clear as possible when a keyboard shortcut refers to keys on the
numeric keypad only.

For example, in:


https://help.libreoffice.org/7.5/en-US/text/scalc/04/01020000.html?&DbPAR=CALC&System=WIN

we read:
----
Ctrl+ *
where (*) is the multiplication sign on the numeric key pad

Selects the data range that contains the cursor. A range is a contiguous cell
range that contains data and is bounded by empty row and columns.
----

Interestingly enough, Calc's users can go to menu Tools > Customize > Keyboard
and modify the default key bindings, but using:
 "['*_math_operator_key_but_not_from_numeric_pad']" 
is not available as a combination with either of [CTRL], [SHIFT], [ALT], or a
combination between them.

As said, in this customization dialog, the simple "Ctrl+ *" seems to be not
explicit or clear enough regarding the "*" (among other) key(s) being from the
numeric key pad exclusively.

Having said that, you could assign:
 "[CTRL]+[SHIF]+[8]" (matching the US keyboard) to the command you want. So, in
some sense, the request to be able to assign such keyboard combination is
already available. Available, yes; being _default_ built-in, that's another
thing.

OTOH, there is still some _additional_ valid RFE here, the first one being
improved documentation (e.g. tool tip) regarding the numeric key pad
exclusivity when it is relevant.

In Excel, there is (although, containing partially confusing or inaccurate info
in some places):

https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f

in its section:
"Keyboard shortcuts for making selections and performing actions"

----
Ctrl+A or Ctrl+Shift+Spacebar
Select the current region if the worksheet contains data. Press a second time
to select the current region and its summary rows. Press a third time to select
the entire worksheet.
----

Such key binding seems useful, and a valid RFE for developers to evaluate, for
either or both combinations.

Additionally, is there some way of binding this in Tools > Customize >
Keyboard? The ability to bind keys "depending on how many times the user
presses the key combination" also seems a valid RFE (i.e. a third RFE; each
should have its own ticket).

Hoping some developer would comment here, so perhaps we would / should end up
with three independent individual RFE tickets.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to