SpreadJS Documentation
ColorCompareType Enumeration
Specifies the color compare type.
Members
MemberDescription
BackgroundColorIndicates whether the cell background color is equal to a specified color.
ForegroundColorIndicates whether the cell foreground color is equal to a specified color.
Example
This example filters using colors.
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);
Inheritance Hierarchy

Object
   GcSpread.Sheets.ColorCompareType

See Also

Reference

GcSpread.Sheets Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.