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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also