var instance = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule(ruleType, ranges, style, operator, value1, value2, text, formula, type, rank);
function NormalConditionRule;
var instance = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule(ruleType, ranges, style, operator, value1, value2, text, formula, type, rank);
function NormalConditionRule;
activeSheet.setArray(0,0,[1,2,3,4,5,6,7,8,9,10]); var cell = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule(); cell.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.cellValueRule); cell.operator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.greaterThan); cell.value1(5); cell.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]); var style = new GC.Spread.Sheets.Style(); style.backColor = "red"; cell.style(style); activeSheet.conditionalFormats.addRule(cell); //button $("#button1").click(function () { cell.reset(); activeSheet.suspendPaint(); activeSheet.resumePaint(); });
Object
GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule
Name | Description | |
---|---|---|
![]() | NormalConditionRule Constructor | Represents a normal conditional rule. |
Name | Description | |
---|---|---|
![]() | createCondition | Creates a condition for the rule. |
![]() | formula | Gets or sets the condition formula. |
![]() | operator | Gets or sets the comparison operator. |
![]() | rank | Gets or sets the number of top or bottom items to apply the style to. |
![]() | reset | Resets the rule. |
![]() | text | Gets or sets the text for comparison. |
![]() | type | Gets or sets the average condition type. |
![]() | value1 | Gets or sets the first value. |
![]() | value2 | Gets or sets the first value. |