SpreadJS 13
GC.Spread.Sheets.DataValidation Namespace / DefaultDataValidator type / ignoreBlank Method
Indicates whether to ignore the empty value.
In This Topic
    ignoreBlank Method
    In This Topic
    Gets or sets whether to ignore an empty value.
    Syntax
    var instance = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(condition);
    var returnValue; // Type: any
    returnValue = instance.ignoreBlank(value);
    function ignoreBlank( 
       value : boolean
    ) : any;

    Parameters

    value
    Indicates whether to ignore the empty value.

    Return Value

    If no value is set, returns whether to ignore the empty value; otherwise, returns the data validator.
    Example
    This example uses the IgnoreBlank method.
    var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.cellValueCondition);
    nCondition.compareType(GC.Spread.Sheets.ConditionalFormatting.GeneralComparisonOperators.equalsTo);
    nCondition.expected(0);
    //When the option is false, the validation fails and the red alert is displayed.
    //When the option is true, the blank cell is treated as zero and the validation is successful.
    nCondition.treatNullValueAsZero(false);
    var validator = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(nCondition);
    validator.type(GC.Spread.Sheets.DataValidation.CriteriaType.custom);
    validator.ignoreBlank(false);
    activeSheet.getCell(0, 0, GC.Spread.Sheets.SheetArea.viewport).validator(validator);
    spread.options.highlightInvalidData = true;
    activeSheet.setValue(0, 0, null);
    See Also