Ask Your Question
1

Calc - Shortcuts for pasting actions [closed]

asked 2012-10-26 16:16:11 +0100

Gunnar_Freyr gravatar image

updated 2013-10-21 22:06:38 +0100

manj_k gravatar image

Hi all. I'm trying to make the switch from MS Office but I'm having some issues with my workflow in Calc. In excel 2010 I have mapped a few things to keyboard shortcuts and two of the ones I use the most are paste values and paste formatting. I have these mapped to Alt + 2 and Alt + 3. This makes it easy to copy large areas with formulas and special formatting and just selecting the destination and quickly hitting those 2 shortcuts. I have not found a way to do this in Calc. I have only found the very time consuming way of selecting "paste special" and choosing which properties of the copied cell I wish to paste. This is very inefficient in my opinion. In the customize option I can map commands to keyboard shortcuts but these 2 commands are not available, only the paste special is. Is it possible to map those 2 commands to keyboard shortcuts?

Thanks Gunnar

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-25 05:36:33.033306

5 Answers

Sort by » oldest newest most voted
2

answered 2012-10-28 02:33:27 +0100

horst gravatar image

In CALC Customize/Keyboard check CALC not LibreOffice at the radiobuttons on top. Categorie-Edit, the first few Functions start with .uno:PasteonlyValues I saw. Not the whole nine yard but at least half of it.

There are also 2 "Paste Special" ?????

edit flag offensive delete link more

Comments

@horst - thanks this is an excellent hint!!1

ROSt52 gravatar imageROSt52 ( 2013-03-02 13:38:08 +0100 )edit
1

answered 2012-10-26 22:36:09 +0100

horst gravatar image

Try this: Menu -> Tools -> Customize, tab: Keyboard. Select the shortcut you want in the shortcut keys Window/List, then find Edit in Category and the paste function in Function, click modify.

You got it!

edit flag offensive delete link more
0

answered 2012-10-28 16:16:19 +0100

Gunnar_Freyr gravatar image

I have calc selected at the radio buttons. When the edit category is selected I can't see the .uno:PasteonlyValues function you mentioned. I did see the 2 instances of Paste special though. Maybe it's a build version thing? I'm currently running 3.5.4.2 which was preinstalled on Ubuntu 12.04. It's a pity really, I truly wanted to abandon MS software at the office except for when I need the Adobe programs. I installed Office 2010 through PlayOnLinux and I guess I'll use that for now.

Thanks,

Gunnar

edit flag offensive delete link more

Comments

I used LO 3.6.2.2 on Win 7.

horst gravatar imagehorst ( 2012-10-28 20:58:09 +0100 )edit
0

answered 2012-10-28 02:44:43 +0100

Gunnar_Freyr gravatar image

Thanks for your help but I had already tried this but in the list of available functions under the Edit category, there is only Paste and Paste special. There is no function for paste values or paste formatting. As far as I can see there is no way to skip the middle step of selecting the desired paste special option.

Thanks Gunnar

edit flag offensive delete link more
0

answered 2013-03-02 08:21:49 +0100

qubit gravatar image

Hi @Gunnar_Freyr,

Please try using the latest release of LibreOffice and see how that works for you.

edit flag offensive delete link more

Comments

@Gunnar_Freyr -- Still interested in an answer here?

qubit gravatar imagequbit ( 2013-03-17 19:33:08 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2012-10-26 16:16:11 +0100

Seen: 3,817 times

Last updated: Mar 02 '13