Finds the cell span in the collection that includes the cell at the specified row and column.
Syntax
Parameters
- row
- Row index of cell
- column
- Column index of cell
Return Value
CellRange object containing the cell range that has the cell at the specified row and column
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