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