Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Macro idea works, but you have to do a number of "finger exercises" -- clicking or keystrokes -- to activate the macro (see my unanswered question on assigning a macro to a menu: click here).

I believe you are trying to copy formulas which have resulted in numbers. Perhaps...
A) The formula may be complicated, or B) You're pasting in another section of the sheet (or in a different workbook) where the formula references won't apply, or C) You simply want "hard" numbers to work with.

I do this all the time. I haven't found a way to change the PasteSpecial defaults in the current LibreOffice version, but there are some "best practices" you can apply which will simplify.

Probably you are too strict in choosing your criteria in the PasteSpecial dialog window. Leaving some of the items checked doesn't interfere with the hard-pasting of numbers. The only changes that really need to be made are 1) uncheck "Paste all" 2) check "Numbers" and 3) uncheck "Formulas." Click "OK" and you're done!

To ease your way further I'll emphasize key-strokes instead of mouse-clicks. This will save you from carpal tunnel agony in your clicking finger. Begin by using Ctrl-Shift-V to open the PasteSpecial dialog. Then press the following sequence of keys.

Space-Down-Down - Space-Down-Down - Space - Enter

"Space" is of course the Space bar. "Down" is DownArrow. "Enter" is itself. If you can do this musically (i.e. a drum pattern) it becomes almost fun. It's in 4/4 time, with two sets of triplets, then a beat, followed by a final downstroke. "Space" is the snare drum, "Down" is a tom-tom. "Enter" is a base drum or cymbal. It sounds like "Rum pah pah, Rum pah pah, Rum..Bam"

Spread the joy!

Macro idea works, but you have to do a number of "finger exercises" -- clicking or keystrokes -- to activate the macro (see my unanswered question on assigning a macro to a menu: click here).

I believe you are trying to copy formulas which have resulted in numbers. Perhaps...
A) The formula may be complicated, or B) You're pasting in another section of the sheet (or in a different workbook) where the formula references won't apply, or C) You simply want "hard" numbers to work with.

I do this all the time. I haven't found a way to change the PasteSpecial defaults in the current LibreOffice version, but there are some "best practices" you can apply which will simplify.

Probably you are too strict in choosing your criteria in the PasteSpecial dialog window. Leaving some of the items checked doesn't interfere with the hard-pasting of numbers. The only changes that really need to be made are 1) uncheck "Paste all" 2) check "Numbers" and 3) uncheck "Formulas." Click "OK" and you're done!

To ease your way further I'll emphasize key-strokes instead of mouse-clicks. This will save you from carpal tunnel agony in your clicking finger. Begin by using Ctrl-Shift-V to open the PasteSpecial dialog. Then press the following sequence of keys.

Space-Down-Down - Space-Down-Down - Space - Enter

"Space" Space is of course the Space bar. "Down" Down is DownArrow. "Enter" Enter is itself. If you can do this musically (i.e. a drum pattern) it becomes almost fun. It's in 4/4 time, with two sets of triplets, then a beat, followed by a final downstroke. "Space" is the snare drum, "Down" is a tom-tom. "Enter" is a base drum or cymbal. It sounds like "Rum pah pah, Rum pah pah, Rum..Bam"

Spread the joy!

Macro idea works, but you have to do a number of "finger exercises" -- clicking or keystrokes -- to activate the macro (see my unanswered question on assigning a macro to a menu: click here).

I believe you are trying to copy formulas which have resulted in numbers. Perhaps...
A) The formula may be complicated, or B) You're pasting in another section of the sheet (or in a different workbook) where the formula references won't apply, or C) You simply want "hard" numbers to work with.

I do this all the time. I haven't found a way to change the PasteSpecial defaults in the current LibreOffice version, but there are some "best practices" you can apply which will simplify.

Probably you are too strict in choosing your criteria in the PasteSpecial dialog window. Leaving some of the items checked doesn't interfere with the hard-pasting of numbers. The only changes that really need to be made are 1) uncheck "Paste all" 2) check "Numbers" and 3) uncheck "Formulas." Click "OK" and you're done!

To ease your way further I'll emphasize key-strokes instead of mouse-clicks. This will save you from carpal tunnel agony in your clicking finger. Begin by using Ctrl-Shift-V to open the PasteSpecial dialog. Then press the following sequence of keys.

Space-Down-Down - Space-Down-Down - Space - Enter

Space is of course the Space bar. Down is DownArrow. Enter is itself. If you can do this musically (i.e. a drum pattern) it becomes almost fun. It's in 4/4 time, with two sets of triplets, then a beat, followed by a final downstroke. "Space" is the snare drum, "Down" is a tom-tom. "Enter" is a base drum or cymbal. It sounds like "Rum pah pah, Rum pah pah, Rum..Bam"

Spread the joy!

Macro idea works, but you have to do a number of "finger exercises" -- clicking or keystrokes -- to activate the macro (see my unanswered question on assigning a macro to a menu: click here).

I believe you are trying to copy formulas which have resulted in numbers. Perhaps... A) The formula may be complicated, or B) You're pasting in another section of the sheet (or in a different workbook) where the formula references won't apply, or C) You simply want "hard" numbers to work with.

I do this all the time. I haven't found a way to change the PasteSpecial defaults in the current my version of LibreOffice version, Calc, but there are some "best practices" you can apply which will simplify.

Probably you are too strict in choosing your criteria in the PasteSpecial dialog window. Leaving some of the items checked doesn't interfere with the hard-pasting of numbers. The only changes that really need to be made are 1) uncheck "Paste all" 2) check "Numbers" and 3) uncheck "Formulas." Click "OK" and you're done!

To ease your way further I'll emphasize key-strokes instead of mouse-clicks. This will save you from carpal tunnel agony in your clicking finger. Begin by using Ctrl-Shift-V to open the PasteSpecial dialog. Then press the following sequence of keys.

Space-Down-Down - Space-Down-Down - Space - Enter

Space is of course the Space bar. Down is DownArrow. Enter is itself. If you can do this musically (i.e. a drum pattern) it becomes almost fun. It's in 4/4 time, with two sets of triplets, then a beat, followed by a final downstroke. "Space" is the snare drum, "Down" is a tom-tom. "Enter" is a base drum or cymbal. It sounds like "Rum pah pah, Rum pah pah, Rum..Bam"

Spread the joy!