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

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?

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.

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·.

@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.

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+…

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 - Very interesting to see the extended table. What is an UNO function? Linux related?

@ROSt53, 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 - Thanks for the explanation. I got a rough understanding now and hopefully more in the future.