Show Formula

Tool

Built-in

The Show Formula property controls the visibility of the calculation in formula.

When Show Formula is set to No for a dynamic expression, spreadsheet cell, or other object that holds formulas, the calculation part of the formula is not shown. This can be useful to hide bulky formulas in reports where you still want to show the name and result.

Show formula

Hide formula

Show or hide formula:
  1. Select the dynamic expression or other object.
  2. Open the properties window.
  3. Under Formula near the bottom of the window, change Show Formula to Yes or No.
Notes:
  • If Show Formula is set to No, the formula will still calculate.
  • For spreadsheet cells, Show Formula defaults to No.
See also: