SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / TextComparisonOperators Enumeration
In This Topic
    TextComparisonOperators Enumeration
    In This Topic
    Specifies the text comparison operator.
    Members
    MemberDescription
    beginsWithDetermines whether a cell value begins with the parameter value.
    containsDetermines whether a cell value contains the parameter value.
    doesNotContainDetermines whether a cell value does not contain the parameter value.
    endsWithDetermines whether a cell value ends with the parameter value.
    Example
    This example creates a rule.
    var style = new GC.Spread.Sheets.Style();
    style.backColor = "red";
    var ranges=[new GC.Spread.Sheets.Range(0,0,10,1)];
    activeSheet.conditionalFormats.addSpecificTextRule(GC.Spread.Sheets.ConditionalFormatting.TextComparisonOperators.contains, "test", style, ranges);
    activeSheet.setValue(0, 0, "testing");
    activeSheet.setValue(1, 0, "test");
    activeSheet.setValue(2, 0, "a");
    activeSheet.setValue(3, 0, "t");
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.ConditionalFormatting.TextComparisonOperators

    See Also