AreaCondition Constructor

SpreadJS Documentation

Collapse All

GcSpread.Sheets Namespace > AreaCondition type : AreaCondition Constructor

The expected source that separates each data item with a comma (",").

The formula that specifies a range that contains data items.

Represents an area condition using the expected source or formula.

Syntax

Javascript (Usage)
Javascript (Specification)

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

function AreaCondition( 
   expected : string,
   formula : string
) : AreaCondition;

Parameters

expected: The expected source that separates each data item with a comma (",").
formula: The formula that specifies a range that contains data items.

Example

This example creates an area condition.

Javascript

var nCondition = new GcSpread.Sheets.AreaCondition(4, "$C$1");
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition);
activeSheet.getCell(1, 2, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 2, 3);
activeSheet.setValue(1, 2, 5);

Reference

AreaCondition type

Send comments on this topic.