Ask Your Question
0

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
0

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

JohnSUN gravatar image

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

edit flag offensive delete link more
0

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

pierre-yves samyn gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 97 times

Last updated: Dec 26 '18