CustomValueType Enumeration

Specifies the custom value type.

Members

Member	Description
Empty	Indicates whether the cell value is empty or null.
Error	Indicates whether the cell value contains a calculation error.
Formula	Indicates whether the cell value is a formula.
NonEmpty	Indicates whether the cell value is not empty or null.
NonError	Indicates whether the cell value does not contain a calculation error.

Example

The examples validate the cell data.

Javascript

var nCondition = new GcSpread.Sheets.FormulaCondition(GcSpread.Sheets.CustomValueType.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);

Javascript

var nCondition = new GcSpread.Sheets.FormulaCondition(GcSpread.Sheets.CustomValueType.NonEmpty);
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition);
validator.IgnoreBlank(false);
activeSheet.getCell(0, 0, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);

Inheritance Hierarchy

Object
GcSpread.Sheets.CustomValueType

Reference

GcSpread.Sheets Namespace