Bug 106852 - no keyboard shortcut for 'paste values' in Calc
Summary: no keyboard shortcut for 'paste values' in Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.5.1 release
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 120032 (view as bug list)
Depends on:
Blocks: Shortcuts-Accelerators
  Show dependency treegraph
 
Reported: 2017-03-29 11:17 UTC by john
Modified: 2020-06-09 06:36 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Paste special with GTK3 (and Breeze icon set) (43.94 KB, image/png)
2017-03-30 18:51 UTC, Aron Budea
Details
PasteSpecial dialog on Windows builds at 6.3.2, accelerators assigned (63.76 KB, image/png)
2019-10-02 15:25 UTC, V Stuart Foote
Details

Note You need to log in before you can comment on or make changes to this bug.
Description john 2017-03-29 11:17:50 UTC
Description:
The nice new buttons in the Paste Special dialog in Calc are great, but they have not keyboard binding of any kind.

I note that LibreOffice is boasting 'full keyboard navigation and control' (which I completely support), but this is apparently a gap. https://www.libreoffice.org/get-help/accessibility/

(Note that there are numerous menu shortcuts in Calc that also don't have keyboard accelerators, ie like Alt+F+O in Ubuntu 16.04 with Unity. I won't list those here now though)

Steps to Reproduce:
Type Alt-E-S to paste special.
Click '$0' button with the mouse. Ouch! I wanted to use the keyboard, but I can't see how to do that except with the keybaord.

Actual Results:  
Reach for the mouse

Expected Results:
Some way should exist to allow me to stay on the keyboard if I wish to.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0
Comment 1 V Stuart Foote 2017-03-29 13:56:49 UTC
This works correctly for me on Windows 10 Pro 64-bit en-US.

Either the <Ctrl>+<Shift>+v shortcut, or the <Alt>, <E>dit, <S>pecial accelerator sequence (or as localized) launches the Paste Special dialog.

Keyboard selection in the dialog for format.

Enter to complete the paste.

Something missing?  Linux only? Ubuntu/Unity only?

=-=-=


Version: 5.4.0.0.alpha0+
Build ID: 522e9c65faef684a22151ddf009a5a192838b522
CPU threads: 8; OS: Windows 6.19; UI render: GL; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-03-24_00:32:45
Locale: en-US (en_US); Calc: CL
Comment 2 Aron Budea 2017-03-30 18:51:43 UTC
Created attachment 132290 [details]
Paste special with GTK3 (and Breeze icon set)

For clarification, as I understand it is about the paste special dialog you get if you paste cell values.

I can navigate using Tab/Shift-Tab in the dialog just fine.
However, with GTK3 backend it is impossible/very hard to see where I'm at:
-for the buttons there's a very thin orange outline if they're selected,
-for the checkboxes/radio buttons there's no indication at all.

I guess that confirms there is an issue, but not exactly what is reported.
John, can you confirm/clarify?

Version: 5.4.0.0.alpha0+
Build ID: e604ddfd1196c877ddce603dca15f9a5228497e0
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group
Comment 3 V Stuart Foote 2017-03-30 19:24:42 UTC
OK, so with copy/cut of cell value the Paste Special dialog in Calc changes. 

It behaves the same on Windows and offers the additional options including the row of buttons with "Values Only", "Values & Formulas" and "Transpose"

And all the buttons on the dialog can be reached via keyboard--<Tab> and <Shift>+<Tab> in Windows OS. 

The keyboard button focus in this OS includes the thin outline--but more obvious blue highlight on mouse-over.

Lack of accelerators/short-cut for the buttons is annoying (and inconsistent with the other check box widgets) but does not prevent keyboard navigation as suggested.

"Implementation Error" OR "Enhancement"?
Comment 4 Chris Sherlock 2017-04-05 22:12:38 UTC
My 2c - I'd say this is an implentation issue. Consistency in things like buttons is pretty important, I'm not sure I'd consider this an enhancement given it's something we should just do!
Comment 5 Caolán McNamara 2017-04-10 12:54:56 UTC
There now seems to be two things mangled in here together. The initial bug which is that the buttons at the top of the Paste Special dialog don't have any visible keyboard shortcuts.

Then there's an additional complaint that its difficult to see which widget has keyboard focus under a theme, presumably Ubuntu's default theme, under GTK3 and has make this a blocker on the GTK3 metabug.

I'm going to remove this from the GTK3 metabug, because that's more of an aside than the main initially reported problem. If the GTK3 connection is because the GTK3 theme's focus rectangle is not sufficiently indicative of what element has focus then either the theme is at fault or our use of the theme is bad, a comparison against a native button with an image only on that theme would identify the blame there, and a new bug about that if necessary with the details of the gtk3 version and theme.
Comment 6 john 2018-03-19 22:39:15 UTC
Having to tab through options in a dialog box does not count as keyboard accessibility IMHO (especially when the GTK theme makes it difficult to clearly see which button in highlighted).

These buttons need a shortcut character which should appear on the button when the user presses the 'ALT' key, as is normal for all (normal) dialogs.
Comment 7 john 2018-07-10 02:02:44 UTC
My suggestion:

* modify the dialog so that the 'values only' and 'values and formats' buttons are accompanied by text labels with the 'V' and 'O' shortcuts.

* remove the 'Transpose' button; there is already a 'transpose' checkbox, and this is an occasional-use operation, I suspect. This makes space for the larger required buttons with text labels

Example of button with image + label:
https://developer.gnome.org/gtk3/stable/GtkLockButton.html

I believe this problem, would also help usability, as the meaning of those icons in the new dialog is not very intuitive -- most users would need to mouse over them to see the label anyway, in order to be sure they understood the meaning of them.
Comment 8 john 2018-07-10 02:03:26 UTC
PS the shortcut for the 'divide' operation in the dialog would also need to be removed/changed.
Comment 9 Buovjaga 2018-10-13 13:57:48 UTC
*** Bug 120032 has been marked as a duplicate of this bug. ***
Comment 10 john 2019-09-19 14:37:07 UTC
This issue is still present, although there are now additional options in the Edit->Paste Special sub-menu, making it easier to quickly paste values (Alt-E-S-V), but making it harder to get the more complete set of options (Alt-E-S no longer presents the dialog). There are still no key-bindings on the graphical buttons at the top of the Paste Special dialog.

Version: 6.2.6.2
Build ID: 1:6.2.6-0ubuntu0.18.04.1~lo1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded
Comment 11 V Stuart Foote 2019-09-19 15:38:37 UTC
(In reply to john from comment #10)
> (Alt-E-S no longer presents the dialog). There are still no key-bindings on
> the graphical buttons at the top of the Paste Special dialog.
> 
At 6.3.1.2 on Windows builds, the Paste Special reuses the 'S': 

So keyboard accelerators of <Alt>+E+S+S open the 'Paste Special' dialog with focus control on the list box.

=> WFM
Comment 12 john 2019-10-02 14:51:16 UTC
Comment 11 is not correct. To see the problematic behaviour, you have to first select a range of cells in Calc. Then you will see the problematic dialog box, for which there is NO selection list, and no keybinding to paste values.

This new Paste Special dialog/menu is a complete hodgepodge. Compare with the simplicity of this dialog:
https://is.gd/cFnOKG

Ctrl-V -- default paste behaviour
Alt-E-S -- paste special behaviour

Just one more Alt-XXX keystroke to select which special paste you want, all of them are visually discoverable, only one path to each option, no multiple paths.

The current solution needlessly breaks the Alt-E-S keystroke, and unnecessarily provides multiple paths to achieving the same results.

PS "paste numbers" is not the same as "paste values".
Comment 13 V Stuart Foote 2019-10-02 15:25:32 UTC
Created attachment 154712 [details]
PasteSpecial dialog on Windows builds at 6.3.2, accelerators assigned

(In reply to john from comment #12)
> Comment 11 is not correct. To see the problematic behaviour, you have to
> first select a range of cells in Calc. Then you will see the problematic
> dialog box, for which there is NO selection list, and no keybinding to paste
> values.
> 
> This new Paste Special dialog/menu is a complete hodgepodge. Compare with
> the simplicity of this dialog:
> https://is.gd/cFnOKG
> 

Current 6.3.2 release PasteSpecial dialog. Not seeing your issue.

Launch'd by shortcut with <Ctr><Shift>+V

Or alternatively via Main menu Accelerators <Alt>+E,S,S

Dialog is fully populated with accelerators. Just the 3 action buttons "Values only", "Values & Formulas", "Transpose" have no accelerators in the GUI.  But they are eye candy for pointer or touch use.

=> WFM
Comment 14 john 2020-06-08 11:15:34 UTC
@V Stuart Foote
I see no reason why the "values only" and "values and formats" options, which deserve a (needlessly graphical) button for some reason don't get a keyboard accelerator. Those options are common, typical things that we need. Why can't they also be easy to use with the keyboard?

Still a bug!
Comment 15 George S. 2020-06-09 00:37:03 UTC
I don't have it installed right now, but I think Ctrl+Alt+Shift+V was added months ago as a shortcut for paste values.