AverageCondition Constructor

SpreadJS Documentation

Collapse All

GcSpread.Sheets Namespace > AverageCondition type : AverageCondition Constructor

The expected average condition type.

The cell range array for the average condition whose item type is GcSpread.Sheets.Range.

Represents a new average condition of the specified type for the specified cell ranges.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.AverageCondition(type, ranges);

function AverageCondition( 
   type : AverageConditionType,
   ranges : Array
) : AverageCondition;

Parameters

type: The expected average condition type.
ranges: The cell range array for the average condition whose item type is GcSpread.Sheets.Range.

Example

This example validates cell data.

Javascript

var nCondition = new GcSpread.Sheets.AverageCondition(GcSpread.Sheets.AverageConditionType.Above, [new GcSpread.Sheets.Range(0, 0, 10, 3)]);
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);
activeSheet.setValue(1, 0, 15);

Reference

AverageCondition type

Send comments on this topic.