ignoreBlank Field

Gets or sets a value that indicates whether to ignore the null value.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.FormulaCondition(customValueType, formula);
var value; // Type: boolean
value = instance.ignoreBlank;

var ignoreBlank : boolean;

Example

This example sets the ignoreBlank property.

Javascript

var nCondition = new GcSpread.Sheets.FormulaCondition(GcSpread.Sheets.CustomValueType.Formula, "A1>0");
nCondition.ignoreBlank = false;
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition)
activeSheet.getCell(0, 0, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 0, -4);

Reference

FormulaCondition type

Send comments on this topic.