Ask Your Question

How do I print spreadsheet formulas?

asked 2018-12-26 16:25:46 +0200

LionCecil gravatar image

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.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-12-26 17:18:44 +0200

JohnSUN gravatar image

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


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


edit flag offensive delete link more

answered 2018-12-26 17:21:30 +0200

pierre-yves samyn gravatar image


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).


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-26 16:25:46 +0200

Seen: 97 times

Last updated: Dec 26 '18