Ask Your Question

In Calc, what is the Paste Only function (Tools > Customize)? [closed]

asked 2014-02-05 23:32:23 +0200

dg1727 gravatar image

updated 2016-02-19 07:16:05 +0200

Alex Kemp gravatar image

In Tools > Customize... > Keyboard tab > under Category "Edit," there is a function called PasteOnly.

In LO, I bound this to an unused key combination; copied (Ctrl+C) a range of cells that contained text, formatting, & formulas; clicked on an unused cell elsewhere; and pressed the key combination ... nothing seemed to happen.

What is PasteOnly supposed to do when bound to a key combination?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 07:16:19.541354

2 Answers

Sort by » oldest newest most voted

answered 2014-02-06 01:04:33 +0200

oweng gravatar image

updated 2014-02-06 10:14:14 +0200

It appears to be a sub-menu for gathering the Paste Only Text, Paste Only Value, and Paste Only Formula functions. It may have some use in macro code, but probably not as a key binding. It is mentioned as not being useful in this post on the OOo forum. Comment 15 in bug fdo#50746 also makes a passing mention of these four functions.

EDIT: Some basic tests showing behaviour in an ODS. Screenshot of what I see here.

edit flag offensive delete link more


Hi @oweng, past values (text+numbers) would be very useful, what I not have found useful is Paste Only Text an Only Value, because they overwrite each other (for me very annoying). What is possible to do it through Paste Special (Shift+Ctrl+V) with the proper selections or with the paste icon selecting in the arrow ·unformatted text·.

m.a.riosv gravatar imagem.a.riosv ( 2014-02-06 01:19:13 +0200 )edit

@mariosv, yes, Paste Only Value equates to selecting Numbers in the Paste Special... dialog, which is not very clear to me either. I think a value can be either a string or a number. Even date/time values are treated as a special case (not as a number) which seems odd.

oweng gravatar imageoweng ( 2014-02-06 02:41:04 +0200 )edit

answered 2014-02-06 04:26:09 +0200

ROSt52 gravatar image

updated 2014-02-06 12:40:01 +0200

As I am using the 3 "paste only..." functions very often in the contex menu and never observed a problem and triggered by this interesting discusion, I made a test

I copied a formula, which is behind the 4 with the yellow background and a bold text with a yellow background, pasted in each case only formular, text and value. This is the result:
image description

Concerning the term Value (in Paste only) and Number (in Paste-Special) I feel this should be the same term. Both funtions paste only result of a formula.

It would further be good if all the default short cut would all be standardized. ideally ctrl+shift+... or Alt+...

edit flag offensive delete link more


Yes, I made the same sort of test prior to providing my original answer. I will attach it to my answer as a link, but feel free to download it and use the results in your answer. It covers a few more data types.

oweng gravatar imageoweng ( 2014-02-06 10:12:20 +0200 )edit

@oweng - Very interesting to see the extended table. What is an UNO function? Linux related?

ROSt52 gravatar imageROSt52 ( 2014-02-06 12:44:24 +0200 )edit

@ROSt52, Universal Network Objects (UNO) is the component model used by LO. When functions are assigned to a key combination, pressing that key initiates a direct call to the UNO API e.g., please do X, to this document, here (like a macro). CTRL+SHIFT+V is similar, but I wanted to distinguish the two in the spreadsheet for clarity.

oweng gravatar imageoweng ( 2014-02-06 15:12:20 +0200 )edit

@oweng - Thanks for the explanation. I got a rough understanding now and hopefully more in the future.

ROSt52 gravatar imageROSt52 ( 2014-02-06 15:21:37 +0200 )edit

Question Tools

1 follower


Asked: 2014-02-05 23:32:23 +0200

Seen: 968 times

Last updated: Feb 06 '14