SpreadJS Documentation
ConditionalFormats type
Represents a format condition class.
Syntax
var instance = new GcSpread.Sheets.ConditionalFormats(worksheet);
function ConditionalFormats;
Inheritance Hierarchy

Object
   GcSpread.Sheets.ConditionalFormats

Constructors
 NameDescription
public ConstructorConditionalFormats ConstructorRepresents a format condition class.  
Top
Methods
 NameDescription
public Methodadd2ScaleRuleAdds the two scale rule to the rule collection.  
public Methodadd3ScaleRuleAdds the three scale rule to the rule collection.  
public MethodaddAverageRuleAdds an average rule to the rule collection.  
public MethodaddCellValueRuleAdds the cell value rule to the rule collection.  
public MethodaddDataBarRuleAdds a data bar rule to the rule collection.  
public MethodaddDateOccurringRuleAdds the date occurring rule to the rule collection.  
public MethodaddDuplicateRuleAdds a duplicate rule to the rule collection.  
public MethodaddFormulaRuleAdds the formula rule to the rule collection.  
public MethodaddIconSetRuleAdds an icon set rule to the rule collection.  
public MethodaddRuleAdds the rule.  
public MethodaddSpecificTextRuleAdds the text rule to the rule collection.  
public MethodaddTop10RuleAdds the top 10 rule or bottom 10 rule to the collection based on the Top10CondtionType.  
public MethodaddUniqueRuleAdds a unique rule to the rule collection.  
public MethodclearRuleRemoves all rules.  
public MethodcontainsRuleDetermines whether the specified cell contains a specified rule.  
public MethodcountGets the number of rule objects in the collection.  
public MethodgetRuleGets the rule by index.  
public MethodgetRulesGets the conditional rules from the cell at the specified row and column.  
public MethodremoveRuleRemoves a rule object from the ConditionalFormats object.  
public MethodremoveRuleByRangeRemoves the rules from a specified cell range.  
Top
See Also

Reference

GcSpread.Sheets Namespace
Using Conditional Formatting

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.