NumberCondition Constructor

SpreadJS Documentation

Collapse All

GcSpread.Sheets Namespace > NumberCondition type : NumberCondition Constructor

The number comparison type.

The expected number.

The expected formula.

Represents a number condition of the specified type with the specified expected value.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.NumberCondition(compareType, expected, formula);

function NumberCondition( 
   compareType : GeneralCompareType,
   expected : number,
   formula : string
) : NumberCondition;

Parameters

compareType: The number comparison type.
expected: The expected number.
formula: The expected formula.

Example

This example validates cell data.

Javascript

var nCondition = new GcSpread.Sheets.NumberCondition(GcSpread.Sheets.GeneralCompareType.GreaterThan, 5);
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition)
activeSheet.getCell(0, 0, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 0, 5);

Reference

NumberCondition type

Send comments on this topic.