SpreadJS Documentation
useWildCards Field
Gets or sets whether to compare strings using wildcards.
Syntax
var instance = new GcSpread.Sheets.TextCondition(compareType, expected, formula);
var value; // Type: boolean
value = instance.useWildCards;
var useWildCards : boolean;
Example
This example creates a text condition.
var nCondition = new GcSpread.Sheets.TextCondition();
nCondition.compareType = GcSpread.Sheets.TextCompareType.Contains;
nCondition.expected = "te?t";
nCondition.ignoreBlank = true;
nCondition.ignoreCase = true;
nCondition.useWildCards = true;
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");
See Also

Reference

TextCondition type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.