Determines whether the row in the model contains style settings.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overrides Function IsRowUsed( _
ByVal row As Integer _
) As Boolean |
Parameters
- row
- Index of row in the model
Return Value
Boolean:
true if the specified row contains style settings;
false otherwise
Example
This example returns whether the row in the model contains style settings.
| C# |  Copy Code |
|---|
FarPoint.Win.Spread.StyleInfo sInfo = new FarPoint.Win.Spread.StyleInfo();
sInfo.BackColor = Color.LightBlue;
FarPoint.Win.Spread.Model.DefaultSheetStyleModel ds = (FarPoint.Win.Spread.Model.DefaultSheetStyleModel)fpSpread1.ActiveSheet.Models.Style;
int i;
for (i = 0; i <= 5; i++)
{
ds.SetDirectInfo(i, 0, sInfo);
}
bool b;
b = ds.IsRowUsed(2);
if (b == true)
{
MessageBox.Show("The row is used");
}
|
| Visual Basic | Copy Code |
|---|
Dim sInfo As New FarPoint.Win.Spread.StyleInfo
sInfo.BackColor = Color.LightBlue
Dim ds As FarPoint.Win.Spread.Model.DefaultSheetStyleModel = FpSpread1.ActiveSheet.Models.Style
Dim i As Integer
For i = 0 To 5
ds.SetDirectInfo(i, 0, sInfo)
Next
Dim b As Boolean
b = ds.IsRowUsed(2)
If b = True Then
MessageBox.Show("The row is used")
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
