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 with the specified cell
Example
This example finds the cell span in the collection that includes the specified cell.
C# | Copy Code |
---|
private void menuItem1_Click(object sender, System.EventArgs e)
{
FarPoint.Win.Spread.Model.BaseSheetSpanModel spanModel;
spanModel = (FarPoint.Win.Spread.Model.BaseSheetSpanModel)fpSpread1.ActiveSheet.Models.Span;
spanModel.Add(0, 0, 2, 2);
}
private void menuItem2_Click(object sender, System.EventArgs e)
{
FarPoint.Win.Spread.Model.BaseSheetSpanModel spanModel;
FarPoint.Win.Spread.Model.CellRange cr;
spanModel = (FarPoint.Win.Spread.Model.BaseSheetSpanModel)fpSpread1.ActiveSheet.Models.Span;
cr = spanModel.Find(1, 1);
listBox1.Items.AddRange(new Object[] {cr.Column.ToString(), cr.Row.ToString(), cr.ColumnCount.ToString(), cr.RowCount.ToString()});
} |
Visual Basic | Copy Code |
---|
Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click
Dim spanModel As FarPoint.Win.Spread.Model.BaseSheetSpanModel
spanModel = FpSpread1.ActiveSheet.Models.Span
spanModel.Add(0, 0, 2, 2)
End Sub
Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem2.Click
Dim spanModel As FarPoint.Win.Spread.Model.BaseSheetSpanModel
Dim cr As FarPoint.Win.Spread.Model.CellRange
spanModel = FpSpread1.ActiveSheet.Models.Span
cr = spanModel.Find(1, 1)
ListBox1.Items.AddRange(New Object() {cr.Column.ToString(), cr.Row.ToString(), cr.ColumnCount.ToString(), cr.RowCount.ToString()})
End Sub |
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