Enumeration: CustomValueType

Sheets.ConditionalFormatting.CustomValueType

Specifies the custom value type.

example

var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.formulaCondition, {compareType: GC.Spread.Sheets.ConditionalFormatting.CustomValueType.nonEmpty});
var validator = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(nCondition);
validator.ignoreBlank(false);
activeSheet.getCell(0, 0, GC.Spread.Sheets.SheetArea.viewport).validator(validator);
spread.options.highlightInvalidData = true;

Table of contents

Enumeration members

• empty
• error
• formula
• nonEmpty
• nonError

Enumeration members

empty

• empty = 0

Indicates whether the cell value is empty or null.

error

• error = 2

Indicates whether the cell value contains a calculation error.

formula

• formula = 4

Indicates whether the cell value is a formula.

nonEmpty

• nonEmpty = 1

Indicates whether the cell value is not empty or null.

nonError

• nonError = 3

Indicates whether the cell value does not contain a calculation error.