SpreadJS Documentation
ignoreBlank Field
Whether to ignore the blank cell.
Syntax
var instance = new GcSpread.Sheets.ColorCondition(compareType, expected);
var value; // Type: boolean
value = instance.ignoreBlank;
var ignoreBlank : boolean;
Example
This example sets the ignoreBlank property.
activeSheet.isPaintSuspended(true);
var rowFilter = new GcSpread.Sheets.HideRowFilter(new GcSpread.Sheets.Range(-1, 0, -1, 1));
activeSheet.rowFilter(rowFilter);
activeSheet.getCell(0, 0).value("A1").backColor("blue");
activeSheet.getCell(1, 0).value("A2").backColor("yellow");
activeSheet.getCell(2, 0).value("A3").backColor("red");
activeSheet.getCell(3, 0).value("A4").backColor("green");
activeSheet.getCell(4, 0).value("A5").backColor("yellow");
var nCondition = new GcSpread.Sheets.ColorCondition();
nCondition.compareType = GcSpread.Sheets.ColorCompareType.BackgroundColor;
nCondition.expected = "yellow";
nCondition.ignoreBlank = true;
var filter = activeSheet.rowFilter();
filter.addFilterItem(0, nCondition);
filter.filter(0);
activeSheet.isPaintSuspended(false);
See Also

Reference

ColorCondition type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.