Spread Windows Forms 9.0 Product Documentation
IsEmpty Method (BaseSheetSelectionModel)
Example 


Determines whether the model has no selections.
Syntax
'Declaration
 
Public Overridable Function IsEmpty() As Boolean
'Usage
 
Dim instance As BaseSheetSelectionModel
Dim value As Boolean
 
value = instance.IsEmpty()
public virtual bool IsEmpty()

Return Value

Boolean: true if no selections in the selection model; false otherwise
Example
This example changes the color of selections if the model is not empty.
FarPoint.Win.Spread.Model.BaseSheetSelectionModel selModel; 
selModel = (FarPoint.Win.Spread.Model.BaseSheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection; 
selModel.SetSelection(0, 0, 3, 3);

bool b;
b = selModel.IsEmpty();
if(b == false)
{
       fpSpread1.ActiveSheet.SelectionStyle = FarPoint.Win.Spread.SelectionStyles.SelectionColors;
       fpSpread1.ActiveSheet.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Range;
       fpSpread1.ActiveSheet.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Cell;
       fpSpread1.ActiveSheet.SelectionBackColor = Color.Yellow;
}
Dim selModel As FarPoint.Win.Spread.Model.BaseSheetSelectionModel
selModel = FpSpread1.ActiveSheet.Models.Selection
selModel.SetSelection(0, 0, 3, 3)

Dim b As Boolean
b = selModel.IsEmpty()
If b = False Then
       FpSpread1.ActiveSheet.SelectionStyle = FarPoint.Win.Spread.SelectionStyles.SelectionColors
       FpSpread1.ActiveSheet.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Range
       FpSpread1.ActiveSheet.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Cell
       FpSpread1.ActiveSheet.SelectionBackColor = Color.Yellow
End If
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

BaseSheetSelectionModel Class
BaseSheetSelectionModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.