How do I print spreadsheet formulas?

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.

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

PrintFormulas.png

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

BeforePrintFormulas.png

Hi

Two different needs, two procedures:

  • to display the formulas: ViewShow Formula or ToolsOptionsCalcViewFormulas
  • to print the formulas: FormatPageSheet tab▸Print▸tick Formulas

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

Regards