[]
        
(Showing Draft Content)

GC.Spread.Sheets.ConditionalFormatting.CustomValueType

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

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.