Finds the cell span with the specified cell in the collection.
Syntax
Parameters
- row
- Row index of the cell.
- column
- Column index of cell.
Return Value
CellRange object containing the range of cells spanned
Example
This example finds the cell span in the collection that includes the specified cell.
C# | Copy Code |
---|
FarPoint.Win.Spread.Model.ISheetSpanModel sp;
FarPoint.Win.Spread.Model.CellRange cr;
DialogResult dlg;
sp = (FarPoint.Win.Spread.Model.ISheetSpanModel)fpSpread1.ActiveSheet.Models.Span;
sp.Add(0, 0, 2, 2);
sp.Add(0, 3, 2, 2);
dlg = MessageBox.Show("Do you want to find the specified span??", "Find", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
cr = sp.Find(1, 3);
label1.Text = "The column index of the cell is " + cr.Column + " and the row index is " + cr.Row;
} |
Visual Basic | Copy Code |
---|
Dim sp As FarPoint.Win.Spread.Model.ISheetSpanModel
Dim cr As FarPoint.Win.Spread.Model.CellRange
Dim dlg As DialogResult
sp = FpSpread1.ActiveSheet.Models.Span
sp.Add(0, 0, 2, 2)
sp.Add(0, 3, 2, 2)
dlg = MessageBox.Show("Do you want to find the specified span??", "Find", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
cr = sp.Find(1, 3)
Label1.Text = "The column index of the cell is " & cr.Column & " and the row index is " & cr.Row
End If |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also