SpecificTextRule Constructor

SpreadJS Documentation

Collapse All

GcSpread.Sheets Namespace > SpecificTextRule class : SpecificTextRule Constructor

The operator.

The text.

The style for the rule.

Represents a specific text rule based on the specified cell.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.SpecificTextRule(operator, text, style);

function SpecificTextRule( 
   operator : TextComparisonOperator,
   text : string,
   style : Style
) : SpecificTextRule;

Parameters

operator: The operator.
text: The text.
style: The style for the rule.

Example

This example creates a rule.

Javascript

var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule = new GcSpread.Sheets.SpecificTextRule(GcSpread.Sheets.TextComparisonOperator.Contains,"test",style);
rule.ranges=[new GcSpread.Sheets.Range(0,0,10,1)];
activeSheet.getConditionalFormats().addRule(rule);
activeSheet.setValue(0, 0, "testing");
activeSheet.setValue(1, 0, "test");
activeSheet.setValue(2, 0, "a");
activeSheet.setValue(3, 0, "t");

Reference

SpecificTextRule class

Send comments on this topic.