SpreadJS Documentation
reset Method
Resets this instance.
Syntax
var instance = new GcSpread.Sheets.ColorCondition(compareType, expected);
var value; // Type: any
value = instance.reset();
function reset() : any;
Example
This
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(GcSpread.Sheets.ColorCompareType.BackgroundColor, "yellow");
var filter = activeSheet.rowFilter();
filter.addFilterItem(0, nCondition);
filter.filter(0);
activeSheet.isPaintSuspended(false);
nCondition.reset();
See Also

Reference

ColorCondition type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.