SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / ConditionalFormats type / removeRuleByRange Method
The row index of the first cell in the range.
The column index of the first cell in the range.
The number of rows in the range.
The number of columns in the range.
In This Topic
    removeRuleByRange Method
    In This Topic
    Removes the rules from a specified cell range.
    Syntax
    var instance = new GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats(worksheet);
    var value; // Type: any
    value = instance.removeRuleByRange(row, column, rowCount, columnCount);
    function removeRuleByRange( 
       row : number,
       column : number,
       rowCount : number,
       columnCount : number
    ) : any;

    Parameters

    row
    The row index of the first cell in the range.
    column
    The column index of the first cell in the range.
    rowCount
    The number of rows in the range.
    columnCount
    The number of columns in the range.
    Example
    This example uses the removeRuleByRange 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);
    activeSheet.conditionalFormats.removeRuleByRange(0, 0, 5, 1);
    See Also