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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also