GcSpread.Sheets Namespace > TextCondition type : ignoreCase Field |
var instance = new GcSpread.Sheets.TextCondition(compareType, expected, formula); var value; // Type: boolean value = instance.ignoreCase;
var ignoreCase : boolean;
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");