Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to Paste Special without 8 clicks the 1st time

I hope I'm not missing something obvious here, but this behavior annoys me enough that somebody else just ~Must~ have brought it up before, but I can find no reference to it, so here it goes.

I frequently use Paste Special, mostly to paste only numbers, and also often only formating. The first time I choose Paste Special, the first thing I have to do is un-click Paste All. (I don't really understand why that is the initial default anyway, since it is not a Paste Special at all, but a regular Paste, but I digress...) After that, the 7 choices are now active, and all are selected except for Numbers, which is typically the one I want, so I have to unclick 6 of them and click Numbers, before I can click Okay. That's 8 clicks, and the way I see it, 7 of them are unnecessary. When the Paste Special dialog is first presented, it ought to default to only one, I prefer Numbers, but Text or what ever would be fine too. If it must be Paste All, then unclicking Paste All ought to deselect all the other choices too, that way you can choose the one you want without having to deselect 6 others too.

Is there a way to change this default? Should I make a feature request? Or just suck it up and live with it? Thanks, Carl

How to Paste Special without 8 clicks the 1st time

I hope I'm not missing something obvious here, but this behavior annoys me enough that somebody else just ~Must~ have brought it up before, but I can find no reference to it, so here it goes.

Working within Calc, I frequently use Paste Special, mostly to paste only numbers, and also often only formating. The first time I choose Paste Special, the first thing I have to do is un-click Paste All. (I don't really understand why that is the initial default anyway, since it is not a Paste Special at all, but a regular Paste, but I digress...) After that, the 7 choices are now active, and all are selected except for Numbers, which is typically the one I want, so I have to unclick 6 of them and click Numbers, before I can click Okay. That's 8 clicks, and the way I see it, 7 of them are unnecessary. When the Paste Special dialog is first presented, it ought to default to only one, I prefer Numbers, but Text or what ever would be fine too. If it must be Paste All, then unclicking Paste All ought to deselect all the other choices too, that way you can choose the one you want without having to deselect 6 others too.

Is there a way to change this default? Should I make a feature request? Or just suck it up and live with it? Thanks, Carl

click to hide/show revision 3
retagged

How to Paste Special without 8 clicks the 1st time

I hope I'm not missing something obvious here, but this behavior annoys me enough that somebody else just ~Must~ have brought it up before, but I can find no reference to it, so here it goes.

Working within Calc, I frequently use Paste Special, mostly to paste only numbers, and also often only formating. The first time I choose Paste Special, the first thing I have to do is un-click Paste All. (I don't really understand why that is the initial default anyway, since it is not a Paste Special at all, but a regular Paste, but I digress...) After that, the 7 choices are now active, and all are selected except for Numbers, which is typically the one I want, so I have to unclick 6 of them and click Numbers, before I can click Okay. That's 8 clicks, and the way I see it, 7 of them are unnecessary. When the Paste Special dialog is first presented, it ought to default to only one, I prefer Numbers, but Text or what ever would be fine too. If it must be Paste All, then unclicking Paste All ought to deselect all the other choices too, that way you can choose the one you want without having to deselect 6 others too.

Is there a way to change this default? Should I make a feature request? Or just suck it up and live with it? Thanks, Carl

click to hide/show revision 4
retagged

How to Paste Special without 8 clicks the 1st time

I hope I'm not missing something obvious here, but this behavior annoys me enough that somebody else just ~Must~ have brought it up before, but I can find no reference to it, so here it goes.

Working within Calc, I frequently use Paste Special, mostly to paste only numbers, and also often only formating. The first time I choose Paste Special, the first thing I have to do is un-click Paste All. (I don't really understand why that is the initial default anyway, since it is not a Paste Special at all, but a regular Paste, but I digress...) After that, the 7 choices are now active, and all are selected except for Numbers, which is typically the one I want, so I have to unclick 6 of them and click Numbers, before I can click Okay. That's 8 clicks, and the way I see it, 7 of them are unnecessary. When the Paste Special dialog is first presented, it ought to default to only one, I prefer Numbers, but Text or what ever would be fine too. If it must be Paste All, then unclicking Paste All ought to deselect all the other choices too, that way you can choose the one you want without having to deselect 6 others too.

Is there a way to change this default? Should I make a feature request? Or just suck it up and live with it? Thanks, Carl