Openoffice spreadsheet keyboard shortcut paste special

Post by legalnan » Fri Oct 09, 2020 4:58 am

Edit: Split from [Solved] Linking cells on same spreadsheet
Is there a short cut for copy/paste special/formula? It used to be control D. Thanks

Last edited by MrProgrammer on Tue Oct 13, 2020 6:17 pm, edited 2 times in total.
Reason: Unrelated post split from solved topic; Tagged ✓ [Solved]

Open Office 4.1.6 on Windows 10 MrProgrammer Moderator Posts: 5037 Joined: Fri Jun 04, 2010 7:57 pm Location: Wisconsin, USA

Re: Short cut for copy/paste special/formula?

Post by MrProgrammer » Fri Oct 09, 2020 4:41 pm

legalnan wrote: Is there a short cut for copy/paste special/formula?

I believe you are asking about Edit → Paste Special → Selection:Formulas. See PasteFormulas (or perhaps Duplicate) in [Tutorial] Favorite Recorded Calc Macros. Then assign a a keyboard shortcut of your choice. I created shortcuts for both on my system years ago and use then often.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.

Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.7, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).

legalnan Posts: 29 Joined: Tue Jul 07, 2020 8:10 pm

Re: Short cut for copy/paste special/formula?

Post by legalnan » Mon Oct 12, 2020 6:26 am

I was able to record a macro but had no luck running it much less assigning a shortcut key. The instructions are a bit advanced for me. I can manage with copy/paste special/formula for the time being. Thanks very much for trying.

Open Office 4.1.6 on Windows 10 3 posts • Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited