UniqueCondition Constructor

SpreadJS Documentation

Collapse All

GcSpread.Sheets Namespace > UniqueCondition type : UniqueCondition Constructor

Whether to check for duplicate data.

The cell ranges whose item type is GcSpread.Sheets.Range.

Represents a unique condition and sets whether to check for duplicate data.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.UniqueCondition(duplicated, ranges);

function UniqueCondition( 
   duplicated : boolean,
   ranges : Array
) : UniqueCondition;

Parameters

duplicated: Whether to check for duplicate data.
ranges: The cell ranges whose item type is GcSpread.Sheets.Range.

Example

This example checks for duplicate items.

Javascript

var nCondition = new GcSpread.Sheets.UniqueCondition(true, 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.