GcSpread.Sheets Namespace > TextCondition type : formula Field |
var instance = new GcSpread.Sheets.TextCondition(compareType, expected, formula); var value; // Type: string value = instance.formula;
var formula : string;
var nCondition = new GcSpread.Sheets.TextCondition(); nCondition.compareType = GcSpread.Sheets.TextCompareType.Contains; nCondition.formula = "$C$1"; 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"); activeSheet.setValue(0, 2, "test");