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. |