Page 1 of 1

Changing default settings for Paste Special

PostPosted: Sun Dec 09, 2007 1:40 am
by kerflop
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

Re: Changing default settings for Paste Special

PostPosted: Sun Dec 09, 2007 4:04 am
by acknak
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.

Re: Changing default settings for Paste Special

PostPosted: Mon Dec 10, 2007 10:36 pm
by kerflop
Bummer. I guess I'll just have to learn to live with it.

Thanks.
--
Kerflop

Re: Changing default settings for Paste Special

PostPosted: Tue Dec 11, 2007 5:43 pm
by JohnV
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.

Re: Changing default settings for Paste Special

PostPosted: Wed Dec 12, 2007 12:56 am
by kerflop
Excellent idea. Thanks!
--
kerflop