Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

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.