[Libreoffice-bugs] [Bug 131916] New: CALC, editing: 'select data area' option (ctrl+*) keybinding does not work; menu use is ok

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Apr 5 21:32:59 UTC 2020


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

            Bug ID: 131916
           Summary: CALC, editing:  'select data area' option (ctrl+*)
                    keybinding does not work; menu use is ok
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: casapr at jumplink.org

Description:
There is a command to select a contiguous area in calc (adjacent cells that are
not empty).  This command selects a rectangular block of cells starting from
the active cell and going out in all directions until it hits whitespace or
edge of sheet.

The command can be executed with:
Edit->Select->Select Data Area
or by typing ctrl+*

PROBLEM/BUG:
The use of the menu option (with mouse) works fine, however trying to use
the keyboard shortcut ctrl+* instead does nothing.
(This shortcut, on US keyboard, is typed as ctrl+shift+8 in order to get
ctrl+*)

REPRODUCTION:
Open or create a spreadsheet with data.  Put the cursor somewhere within
multiple rows and columns that are filled in.  If you execute this command
(using menu) it will select all contiguous cells that are non-empty around the
cursor.  If you try the same with keyboard shortcut it does nothing.

ADDITIONAL INFO:
-I have not (to my knowledge) changed any hotkey bindings in either Calc or
elsewhere in windows to grab this key combination.

-This is proven also by opening Excel on the same machine - the ctrl+* key
command works as intended (Excel uses the same shortcut).  If Windows or
another program was hijacking this key combination then Excel wouldn't work
either.

-This key combination will not work on an entirely different computer running
an older version of Calc v6.2.5.2 (x86)  (I can't remember this key combination
ever working on ANY version of Calc).



Actual Results:
see description

Expected Results:
see description


Reproducible: Always


User Profile Reset: No



Additional Info:
see description

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200405/c755fb86/attachment.htm>


More information about the Libreoffice-bugs mailing list