Display rules
- Last UpdatedSep 09, 2025
- 1 minute read
Datasheets can include display rules. A display rule can specify, for example, that the cell on which it is applied displays only values that are between specified limits. Display rules are defined in datasheet templates and are applied in datasheet instances created from those templates.
In a datasheet instance, right-click a cell containing a display rule and select Display Rule. You are given these options:
|
Option |
Description |
|
Show Editor |
Opens the Display Rule Editor. You can specify a new display rule or modify an existing rule. For information about the editor settings, see Continuation Area. |
|
Disable and Enable |
Prevents application of the rule until you select Display Rule>Enable.This option is persistent across sessions. |
|
Remove |
Removes the rule from the datasheet instance for the current session. |
|
Copy Rule |
Copies the rule so that it can be pasted to another cell. |
|
Paste Rule |
Pastes a copied rule into another cell during the current session. You can independently enable and disable copied and pasted rules. |
A separate context menu option, Precision, is also enabled if a cell has, or could have, a display rule defined on it.

Select the number of decimals to display for values returned by the display rule. Optionally, choose to remove trailing values.