Determines whether any cell in a specified column is in the selection.
Syntax
| Visual Basic (Declaration) | |
|---|
Function IsAnyCellInColumnSelected( _
ByVal column As Integer _
) As Boolean |
Parameters
- column
- Index of column to check
Return Value
Boolean:
true if any cell in the specified column is selected;
false otherwise
Example
This example returns if any cell in the specified column and row are in the selection.
| C# |  Copy Code |
|---|
FarPoint.Win.Spread.Model.ISheetSelectionModel sel;
bool bc, br;
sel = (FarPoint.Win.Spread.Model.ISheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection;
sel.AddSelection(0, 0, 2, 2);
bc = sel.IsAnyCellInColumnSelected(2);
br = sel.IsAnyCellInRowSelected(2);
label1.Text = "Is there a cell in column 2 selected = " + bc.ToString() + ". Is there a cell in row 2 selected = " + br.ToString()
+ "."; |
| Visual Basic | Copy Code |
|---|
Dim sel As FarPoint.Win.Spread.Model.ISheetSelectionModel
Dim bc, br As Boolean
sel = FpSpread1.ActiveSheet.Models.Selection
sel.AddSelection(0, 0, 4, 4)
bc = sel.IsAnyCellInColumnSelected(2)
br = sel.IsAnyCellInRowSelected(2)
Label1.Text = "Is there a cell in column 2 selected = " & bc.ToString() & ". Is there a cell in row 2 selected = " & br.ToString()
& "." |
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
