Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This question already has an answer here:

How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or simply a menu choice to paste values instead of the formulas, but this idea seems to be missing from Open Office, or called by some other name. Thanks for any help.

share|improve this question

marked as duplicate by DavidPostill, Ben N, mdpc, BlueBerry - Vignesh4303, Raystafarian Apr 11 at 17:39

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Use Edit-->Copy then Edit-->Paste Special (or Copy and Paste Special... from the context (right-click) menu).

In the dialog uncheck paste all, check numbers and uncheck formulas.

This is in every version of OO/LO, that I've used.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.