compareType Field

Gets the type of comparison to perform.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.TextCondition(compareType, expected, formula);
var value; // Type: TextCompareType
value = instance.compareType;

var compareType : TextCompareType;

Example

This example creates a text condition.

Javascript

var nCondition = new GcSpread.Sheets.TextCondition();
nCondition.compareType = GcSpread.Sheets.TextCompareType.Contains;
nCondition.expected = "test";
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition)
activeSheet.getCell(0, 0, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 0, "testing");

Reference

TextCondition type

Send comments on this topic.