The TabEmptyValuesTreatmentType enumeration contains operations that need to be performed to check formulas referring to empty cells.
It is used by the following property:
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: