Changing default settings for Paste Special

Discuss the spreadsheet application

Changing default settings for Paste Special

Postby kerflop » Sun Dec 09, 2007 1:40 am

When I use the Paste Special command for the first time after starting Calc, it defaults to a selection of "Paste all". Since I almost invariably change the selection to Numbers, I'd like to make that the default setting. Is there any way to do that? Of course, once I've changed the setting, it remembers for the duration of that session, but I'd like to make it permanent.
--
kerflop
kerflop
 
Posts: 6
Joined: Sun Dec 09, 2007 1:29 am

Re: Changing default settings for Paste Special

Postby acknak » Sun Dec 09, 2007 4:04 am

Annoying isn't it? It's a really strange dialog too--it took me some head-scratching to figure out how to use it.

Unfortunately, there's no way to change the defaults except to use it.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Changing default settings for Paste Special

Postby kerflop » Mon Dec 10, 2007 10:36 pm

Bummer. I guess I'll just have to learn to live with it.

Thanks.
--
Kerflop
kerflop
 
Posts: 6
Joined: Sun Dec 09, 2007 1:29 am

Re: Changing default settings for Paste Special

Postby JohnV » Tue Dec 11, 2007 5:43 pm

You can record a macro, of say, Edit > Paste Special > Unformatted Text, and attach it to a keyboard combo or an icon on a toolbar.
JohnV
Volunteer
 
Posts: 1585
Joined: Mon Oct 08, 2007 1:32 am
Location: Kentucky, USA

Re: Changing default settings for Paste Special

Postby kerflop » Wed Dec 12, 2007 12:56 am

Excellent idea. Thanks!
--
kerflop
kerflop
 
Posts: 6
Joined: Sun Dec 09, 2007 1:29 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 14 guests