How do I print spreadsheet formulas?

[LionCecil]

I want a copy of the spreadsheet showing the formulas to help me trace mistakes in my budget spreadsheet but if I try to print the sheet showing the formulas it prints the numbers.

[JohnSUN]

Try to check “Formulas” in Format-Page menu, tab “Sheet”

You may need to set the appropriate column widths before this.

[PYS]

Hi

Two different needs, two procedures:

• to display the formulas: View▸Show Formula or Tools▸Options▸Calc▸View▸Formulas
• to print the formulas: Format▸Page▸Sheet tab▸Print▸tick Formulas

See also this extension (Warning: the extension seems not to display the text of the functions).

Regards