SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / 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.
In This Topic
    removeSpan Method
    In This Topic
    Removes the span that contains a specified anchor cell in the specified sheet area.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: any
    value = instance.removeSpan(row, col, sheetArea);
    function removeSpan( 
       row : number,
       col : number,
       (optional) 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 the specified spans.
    sheet.addSpan(0,0,3,3,GC.Spread.Sheets.SheetArea.viewport);
    var spans =sheet.getSpans();
    for(var i=0;i<spans.length;i++)
     {
      sheet.removeSpan(spans[i].row,spans[i].col,GC.Spread.Sheets.SheetArea.viewport);
     }
    activeSheet.addSpan(0,0,3,3,GC.Spread.Sheets.SheetArea.viewport);
    //activeSheet.removeSpan(0, 0, GC.Spread.Sheets.SheetArea.viewport);
    See Also

    Reference

    Worksheet type