addSpan Method

Adds a span of cells to this sheet in the specified sheet area.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: any
value = instance.addSpan(row, column, rowCount, colCount, sheetArea);

function addSpan( 
   row : number,
   column : number,
   rowCount : number,
   colCount : number,
   sheetArea : SheetArea
) : any;

Parameters

row: The row index of the cell at which to start the span.
column: The column index of the cell at which to start the span.
rowCount: The number of rows to span.
colCount: The number of columns to span.
sheetArea: The sheet area. If this parameter is not given, it defaults to viewport.

Example

This example creates cell spans.

Javascript

sheet.setRowCount(4,1);
sheet.setColumnCount(4,2);
sheet.addSpan(0,0,3,3,GcSpread.Sheets.SheetArea.colHeader);
sheet.addSpan(0,0,3,3,GcSpread.Sheets.SheetArea.rowHeader);
sheet.addSpan(0,0,3,3,GcSpread.Sheets.SheetArea.viewport);

Reference

Sheet type