SpecificTextRule class

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;

Example

This example creates a specific text 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)];
sheet.getConditionalFormats().addRule(rule);
sheet.setValue(0, 0, "testing");
sheet.setValue(1, 0, "test");
sheet.setValue(2, 0, "a");
sheet.setValue(3, 0, "t");

Inheritance Hierarchy

Object
GcSpread.Sheets.ConditionRuleBase
GcSpread.Sheets.SpecificTextRule

Constructors

	Name	Description
	SpecificTextRule Constructor	Represents a specific text rule based on the specified cell.

Top

Fields

	Name	Description
	operator	The operator.
	ranges	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	style	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	text	The text.

Top

Methods

	Name	Description
	contains	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	evaluate	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	getExpected	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	intersects	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	priority	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	reset	Resets the rule.
	stopIfTrue	(Inherited from GcSpread.Sheets.ConditionRuleBase)

Top

Reference

GcSpread.Sheets Namespace
Using the Specific Text Rule