Bug 67574 - EDITING: Shortcut to paste a link
Summary: EDITING: Shortcut to paste a link
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: All All
: lowest enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevEval, topicUI
Depends on:
Blocks: UNO-Command-New Shortcuts-Accelerators Paste
  Show dependency treegraph
 
Reported: 2013-07-31 10:28 UTC by boicottms
Modified: 2021-05-09 05:59 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description boicottms 2013-07-31 10:28:26 UTC
Problem description: 
to paste as link to an other cell, we have to 
1. copy
2. paste special
3. select "paste as link" and
4. deselect many other options
I would like a keyboard shortcut just to "paste as link"

              
Operating System: All
Version: 4.1.0.4 release
Comment 1 boicottms 2013-07-31 10:30:25 UTC
…and a menù line as well
Comment 2 Joel Madero 2013-08-01 19:24:50 UTC
Thank you for reporting this enhancement request! I can confirm that this is a valid enhancement request on:
Version: 4.2.0.0.alpha0+Build ID: 09a4c4d176ff97ab8ff4027af83a549991667baf
Date:   Tue Jul 30 19:05:34 2013 +0300 
Platform: Bodhi Linux 2.2 x64
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
As I've been able to confirm the enhancement request I am marking as:

New (confirmed)
Enhancement
Lowest - workaround exists - not a feature that is used very often, once you do one special paste as link - the option remains so any future special pastes during that session is easy (ctrl + shift + v)

Keywords - 

Whiteboard Status - proposedeasyhack

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link:
https://wiki.documentfoundation.org/QA/BugTriage

There are also other ways to get involved including with marketing, UX, documentation, and of course developing -  http://www.libreoffice.org/get-help/mailing-lists/. 

Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material
Comment 3 Robinson Tryon (qubit) 2013-10-23 18:43:39 UTC Comment hidden (obsolete)
Comment 4 Joel Madero 2014-02-27 23:03:42 UTC
In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval.

Thank you and apologies for the noise
Comment 5 Robinson Tryon (qubit) 2015-12-13 11:21:03 UTC Comment hidden (obsolete)
Comment 6 Yousuf Philips (jay) (retired) 2016-09-17 20:47:29 UTC
I would assume all the common paste special options that have uno commands (only text, only value, only formula) could benefit from shortcuts, as well as those that dont (link and transpose).

Would be useful to have one modifier sequence followed by a letter or number. The most available one i can find is Ctrl+Shift+Alt, though i would have preferred it be Ctrl+Shift, so the shortcuts would look something like this.

Text      - Ctrl+Shift+Alt+A
Numbers   - Ctrl+Shift+Alt+1 or Ctrl+Shift+Alt+N
Formulas  - Ctrl+Shift+Alt+F
Link      - Ctrl+Shift+Alt+L
Transpose - Ctrl+Shift+Alt+T
Comment 7 Heiko Tietze 2016-09-18 09:17:00 UTC
(In reply to Yousuf Philips (jay) from comment #6)
> Text      - Ctrl+Shift+Alt+A

I don't think its a good idea to predfine a lot of complex shortcuts. Rather we have to make sure that it's easy to bind shortcuts.
(When I have to press ctrl+shift+alt it takes more time than going to the menu.)

In respect to the question here the paste special dialog (shift+ctrl+V) has an option to paste as link (alt+O), which is 'sticky' so you have to change it only once. => WORKSFORME
Comment 8 Yousuf Philips (jay) (retired) 2016-09-18 16:08:42 UTC
(In reply to Heiko Tietze from comment #7)
> I don't think its a good idea to predfine a lot of complex shortcuts. Rather
> we have to make sure that it's easy to bind shortcuts.
> (When I have to press ctrl+shift+alt it takes more time than going to the
> menu.)

Predefining shortcuts for calc shortcut users is more useful than having them bind their own shortcuts to these commands. Calc shortcut users use shortcuts over opening the menu. @Cor: whats your take?

> In respect to the question here the paste special dialog (shift+ctrl+V) has
> an option to paste as link (alt+O), which is 'sticky' so you have to change
> it only once. => WORKSFORME

Yes the dialog will save your last used option, but that isnt always what you want to do next, and we dont even have a shortcut to apply the last set options in that dialog.

@Samuel: If you are interested in creating the uno commands, there are separate bug reports for that - link (bug 90101), transpose (bug 102255).
Comment 9 mahfiaz 2016-09-18 17:56:37 UTC
I would use those shortcuts (although I am not sure how I would like to learn these).
1) To get rid of links
2) To paste as text from anywhere (e-mails, web, etc to get rid of formatting).
Comment 10 Cor Nouws 2016-09-19 18:48:05 UTC
(In reply to Yousuf Philips (jay) from comment #8)

> Predefining shortcuts for calc shortcut users is more useful than having
> them bind their own shortcuts to these commands. Calc shortcut users use
> shortcuts over opening the menu. @Cor: whats your take?

[Does my scheme say it's time to agree to Jay or to Heiko .. ;) ]

I would do one thing without forgetting the other.

( Working with short cuts is a strange and interesting art. It really depends so much on: how easy do you remember something and how often do you use it - and of course those interact.)
Comment 11 Heiko Tietze 2016-09-19 20:11:49 UTC Comment hidden (no-value)
Comment 12 Cor Nouws 2016-10-20 08:02:04 UTC
(In reply to Cor Nouws from comment #10)
> (In reply to Yousuf Philips (jay) from comment #8)
> 
> > Predefining shortcuts for calc shortcut users is more useful than having
> > them bind their own shortcuts to these commands. Calc shortcut users use
> > shortcuts over opening the menu. @Cor: whats your take?
> 
> [Does my scheme say it's time to agree to Jay or to Heiko .. ;) ]
> 
> I would do one thing without forgetting the other.
> 
> ( Working with short cuts is a strange and interesting art. It really
> depends so much on: how easy do you remember something and how often do you
> use it - and of course those interact.)

Thus... for people doing certain tasks frequently, it would make sense to have the short cuts available, or at least the possibility to add them themselves .
Comment 13 Roland Kurmann 2021-05-05 18:53:54 UTC
I've submitted a patch for UNO command (.uno:PasteAsLink, bug 90101): https://gerrit.libreoffice.org/c/core/+/115137
Waiting for code review
Comment 14 Roland Kurmann 2021-05-09 05:59:42 UTC
There will be the UNO command .uno:PasteAsLink in LibreOffice 7.2. This means anyone can assign a shortcut or add this command to the menu or context menu.

(In reply to Heiko Tietze from comment #7)
> I don't think its a good idea to predfine a lot of complex shortcuts.

By solving bug 90101, no predefined shortcut or menu entries were made since "paste as link" seems not relevant for the majority of users.

Should we close this issue as DUPLICATE or WON'T FIX since adding shortcuts/menu entries is very unlikely to happen and the basic concern is solved by bug 90101?