SpreadJS Documentation
ignoreBlank Field
Specifies whether to ignore the blank cell.
Syntax
var instance = new GcSpread.Sheets.AverageCondition(type, ranges);
var value; // Type: boolean
value = instance.ignoreBlank;
var ignoreBlank : boolean;
Example
This example creates an average condition.
var nCondition = new GcSpread.Sheets.AverageCondition();
nCondition.ignoreBlank = false;
nCondition.ranges = [new GcSpread.Sheets.Range(0, 0, 10, 3)];
nCondition.type = GcSpread.Sheets.AverageConditionType.Above;
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition)
activeSheet.getCell(0, 0, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 0, 5);
activeSheet.setValue(1, 0, 15);
See Also

Reference

AverageCondition type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.