SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / ConditionalFormats type / getRules Method
The row index.
The column index.
In This Topic
    getRules Method
    In This Topic
    Gets the conditional rules from the cell at the specified row and column.
    Syntax
    var instance = new GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats(worksheet);
    var value; // Type: any
    value = instance.getRules(row, column);
    function getRules( 
       row : number,
       column : number
    ) : any;

    Parameters

    row
    The row index.
    column
    The column index.

    Return Value

    The conditional rules.
    Example
    This example uses the getRules method.
    var style = new GC.Spread.Sheets.Style();
    style.backColor = "red";
    var rule = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
    rule.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.cellValueRule);
    rule.ranges([new GC.Spread.Sheets.Range(0,0,5,1)]);
    rule.operator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between);
    rule.style(style);
    rule.value1(2);
    rule.value2(100);
    activeSheet.conditionalFormats.addRule(rule);
    activeSheet.setValue(0,0,1,3);
    activeSheet.setValue(1,0,45,3);
    var ruletest = activeSheet.conditionalFormats.getRules();
    alert(ruletest[0].style().backColor);
    Remarks
    If all parameters are omitted, returns all conditional rules.
    See Also