SpreadJS Documentation
removeSpan Method
The row index of the anchor cell for the span (at which spanned cells start).
The column index of the anchor cell for the span (at which spanned cells start).
The sheet area. If this parameter is not given, it defaults to viewport.
Removes the span that contains a specified anchor cell in the specified sheet area.
Syntax
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.
activeSheet.addSpan(0,0,3,3,GcSpread.Sheets.SheetArea.viewport);
//activeSheet.removeSpan(0, 0, GcSpread.Sheets.SheetArea.viewport);
This example removes the specified spans.
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);
 }
See Also

Reference

Sheet type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.