Class: CellStateManager

Sheets.CellState.CellStateManager

Table of contents

Constructors

• constructor

Methods

• add
• clear

Constructors

constructor

• new CellStateManager(sheet)

Represents a cellstate manager that can manage all cell state in a sheet.

Parameters

Methods

add

▸ add(range, state, style, sheetArea?): void

description Add cell state instance for range , which will apply style of cellState when the state of range cell matched.

example

var style = new  GC.Spread.Sheets.Style();
style.backColor = 'blue';
style.foreColor = 'red';
var range = new GC.Spread.Sheets.Range(1,2,3,3);
sheet.cellStates.add(range,GC.Spread.Sheets.CellStatesType.hover,style,101);

Parameters

Returns

void

clear

▸ clear(range, sheetArea): void

description Clear all style by range, after clear there are no style will be applied when the cell state is matched.

example

var range = new GC.Spread.Sheets.Range(1,2,3,3);
sheet.cellStates.clear(range, GC.Spread.Sheets.SheetArea.viewport);

Parameters

Returns

void