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

Good afternoon,

I'm trying to copy a page of formulas to a text document (final target will be scribus - but this is irrelevant). What I'm wanting is to copy the actual formulas - create a table containing the formulas and not, instead, their values.

I've looked through Paste Special to try to come to a solution, but can't seem to find one. Has anybody successfully done this, or does anybody know how to successfully do this?


share|improve this question
up vote 3 down vote accepted

Toggle on OOo Calc Tools > Options > OpenOffice.orgCalc > View > Display > Formulas. Then your cut&paste will be copying the text of the formulas rather than the results. Toggle off that Display > Formulas for normal operations.


share|improve this answer
Accepted - with one reservation. Works with Unformatted Text output, but not the formatted ones. But works for my needs - thanks – lochok Oct 24 '10 at 11:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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