removeSpan Method

Removes the span that contains a specified anchor cell in the specified sheet area.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: any
value = instance.removeSpan(row, col, sheetArea);

function removeSpan( 
   row : number,
   col : number,
   sheetArea : SheetArea
) : any;

Parameters

row: The row index of the anchor cell for the span (at which spanned cells start).
col: The column index of the anchor cell for the span (at which spanned cells start).
sheetArea: The sheet area. If this parameter is not given, it defaults to viewport.

Example

This example removes a span.

Javascript

activeSheet.addSpan(0,0,3,3,GcSpread.Sheets.SheetArea.viewport);
//activeSheet.removeSpan(0, 0, GcSpread.Sheets.SheetArea.viewport);

This example removes the specified spans.

Javascript

sheet.addSpan(0,0,3,3,GcSpread.Sheets.SheetArea.viewport);
var spans =sheet.getSpans();
for(var i=0;i<spans.length;i++)
 {
  sheet.removeSpan(spans[i].row,spans[i].col,GcSpread.Sheets.SheetArea.viewport);
 }

Reference

Sheet type