ignoreBlank Field

Specifies whether to ignore the blank cell.

Syntax

Javascript (Usage)
Javascript (Specification)

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

var ignoreBlank : boolean;

Example

This example creates an area condition.

Javascript

var nCondition = new GcSpread.Sheets.AreaCondition();
nCondition.expected = 4;
nCondition.formula = "$C$1";
nCondition.ignoreBlank = true;
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition);
activeSheet.getCell(1, 2, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 2, 3);
activeSheet.setValue(1, 2, 5);

Reference

AreaCondition type

Send comments on this topic.