TabEmptyValuesTreatmentType

Description

The TabEmptyValuesTreatmentType enumeration contains operations that need to be performed to check formulas referring to empty cells.

It is used by the following properties and methods:

Available values

Value Brief description
-1 Undefined. Treat empty value as zero.
0 AsZero. Replace empty value with zero and calculate formula.
1 AsZeroWithInfo. Replace empty value with zero and calculate formula, show error indicator and output context button to manage the error in the formula when focusing on the cell.
2 ThrowException. Do not calculate formula, output an error message as a cell text.

See also:

Tab Assembly Enumerations