ranges Field

The cell range array for the condition.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.UniqueCondition(duplicated, ranges);
var value; // Type: ranges
value = instance.ranges;

var ranges : ranges;

Example

This example creates a unique condition.

Javascript

var nCondition = new GcSpread.Sheets.UniqueCondition();
nCondition.expected = true;
nCondition.ranges = GcSpread.Sheets.Range(0, 5, 1, 1);
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

UniqueCondition type

Send comments on this topic.