Removes all cell spans in the collection that cover the cell at the specified row and column.
Syntax
Parameters
- row
- Row index of cell
- column
- Column index of cell
Example
This example finds the span in the model with the specified row and column.
C# | Copy Code |
---|
FarPoint.Web.Spread.Model.BaseSheetSpanModel bss;
FarPoint.Web.Spread.Model.CellRange cr;
bss = (FarPoint.Web.Spread.Model.BaseSheetSpanModel)FpSpread1.ActiveSheetView.SpanModel;
bss.Add(0, 0, 2, 2);
bss.Add(1, 2, 2, 2);
Response.Write("<script>alert('Find Span?')</script>");
cr = bss.Find(1, 2);
Response.Write("<script>alert('Remove Span?')</script>");
bss.Remove(cr.Row, cr.Column);
|
Visual Basic | Copy Code |
---|
Dim bss As FarPoint.Web.Spread.Model.BaseSheetSpanModel
Dim cr As FarPoint.Web.Spread.Model.CellRange
bss = FpSpread1.ActiveSheetView.SpanModel
bss.Add(0, 0, 2, 2)
bss.Add(1, 2, 2, 2)
Response.Write("<script>alert('Find Span?')</script>")
cr = bss.Find(1, 2)
Response.Write("<script>alert('Remove Span?')</script>")
bss.Remove(cr.Row, cr.Column)
|
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also