[]
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;
• empty = 0
Indicates whether the cell value is empty or null.
• error = 2
Indicates whether the cell value contains a calculation error.
• formula = 4
Indicates whether the cell value is a formula.
• nonEmpty = 1
Indicates whether the cell value is not empty or null.
• nonError = 3
Indicates whether the cell value does not contain a calculation error.