var value; // Type: DefaultDataValidator value = GC.Spread.Sheets.DataValidation.createFormulaValidator(formula);
function createFormulaValidator( formula : string ) : DefaultDataValidator;
パラメータ
- formula
- 数式条件。
戻り値の型
バリデーター。
var value; // Type: DefaultDataValidator value = GC.Spread.Sheets.DataValidation.createFormulaValidator(formula);
function createFormulaValidator( formula : string ) : DefaultDataValidator;
spread.options.highlightInvalidData = true; //The formula validator is valid if the formula condition returns true. var dv = GC.Spread.Sheets.DataValidation.createFormulaValidator("A1>0"); dv.showInputMessage(true); dv.inputMessage("Enter a value greater than 0 in A1."); dv.inputTitle("Tip"); activeSheet.setDataValidator(0, 0, 1, 1, dv, GC.Spread.Sheets.SheetArea.viewport);