SpreadJS Documentation
getRule Method
The index from which to get the rule.
Gets the rule by index.
Syntax
var instance = new GcSpread.Sheets.ConditionalFormats(worksheet);
var value; // Type: object
value = instance.getRule(index);
function getRule( 
   index : number
) : object;

Parameters

index
The index from which to get the rule.

Return Value

The rule by index.
Example
This example uses the getRule method.
var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule = new GcSpread.Sheets.CellValueRule(GcSpread.Sheets.ComparisonOperator.Between,2,100,style);
rule.ranges=[new GcSpread.Sheets.Range(0,0,5,1)];
activeSheet.getConditionalFormats().addRule(rule);
activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,45,3);
var ruletest = activeSheet.getConditionalFormats().getRule(0);
alert(ruletest.style.backColor);
See Also

Reference

ConditionalFormats type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.