var instance = new GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats(worksheet);
function ConditionalFormats;
var instance = new GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats(worksheet);
function ConditionalFormats;
Object
GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats
Name | Description | |
---|---|---|
![]() | ConditionalFormats Constructor | Represents a format condition class. |
Name | Description | |
---|---|---|
![]() | add2ScaleRule | Adds the two scale rule to the rule collection. |
![]() | add3ScaleRule | Adds the three scale rule to the rule collection. |
![]() | addAverageRule | Adds an average rule to the rule collection. |
![]() | addCellValueRule | Adds the cell value rule to the rule collection. |
![]() | addDataBarRule | Adds a data bar rule to the rule collection. |
![]() | addDateOccurringRule | Adds the date occurring rule to the rule collection. |
![]() | addDuplicateRule | Adds a duplicate rule to the rule collection. |
![]() | addFormulaRule | Adds the formula rule to the rule collection. |
![]() | addIconSetRule | Adds an icon set rule to the rule collection. |
![]() | addRule | Adds the rule. |
![]() | addSpecificTextRule | Adds the text rule to the rule collection. |
![]() | addTop10Rule | Adds the top 10 rule or bottom 10 rule to the collection based on the Top10CondtionType object. |
![]() | addUniqueRule | Adds a unique rule to the rule collection. |
![]() | clearRule | Removes all rules. |
![]() | containsRule | Determines whether the specified cell contains a specified rule. |
![]() | count | Gets the number of rule objects in the collection. |
![]() | getRule | Gets the rule using the index. |
![]() | getRules | Gets the conditional rules from the cell at the specified row and column. |
![]() | removeRule | Removes a rule object from the ConditionalFormats object. |
![]() | removeRuleByRange | Removes the rules from a specified cell range. |