Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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?

Lachlan

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.

Ref http://www.tech-recipes.com/rx/2350/openoffice_org_calc_show_formulas/

share|improve this answer
1  
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .