SpreadJS Documentation
customValueType Field
Gets or sets the type of the custom value.
Syntax
var instance = new GcSpread.Sheets.FormulaCondition(customValueType, formula);
var value; // Type: CustomValueType
value = instance.customValueType;
var customValueType : CustomValueType;
Example
This example sets the customValueType property.
var nCondition = new GcSpread.Sheets.FormulaCondition();
nCondition.customValueType = GcSpread.Sheets.CustomValueType.Formula;
nCondition.formula = "A1>0";
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition)
activeSheet.getCell(0, 0, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 0, -4);
See Also

Reference

FormulaCondition type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.