Spread Windows Forms 8.0 Product Documentation
IsRowUsed Method (ISheetStyleModel)
Example 


Row index in the model
Gets whether the row in the model contains style settings.
Syntax
'Declaration
 
Function IsRowUsed( _
   ByVal row As Integer _
) As Boolean
'Usage
 
Dim instance As ISheetStyleModel
Dim row As Integer
Dim value As Boolean
 
value = instance.IsRowUsed(row)
bool IsRowUsed( 
   int row
)

Parameters

row
Row index in the model

Return Value

Boolean: true if the row contains style settings; false otherwise

Example
This example returns whether the specified row contains any styles.
FarPoint.Win.Spread.Model.ISheetStyleModel ssm;
FarPoint.Win.Spread.NamedStyle ns = new FarPoint.Win.Spread.NamedStyle("StyleData");
FarPoint.Win.Spread.StyleInfo si;
bool b;
ssm = (FarPoint.Win.Spread.Model.ISheetStyleModel)fpSpread1.ActiveSheet.Models.Style;
ns.BackColor = Color.Yellow;
fpSpread1.NamedStyles.Add(ns);
ssm.SetDirectInfo(0, 0, ns);
b = ssm.IsRowUsed(0);
label1.Text = "Does row 0 have a style set =  " + b.ToString();
Dim ssm As FarPoint.Win.Spread.Model.ISheetStyleModel
Dim ns As New FarPoint.Win.Spread.NamedStyle("StyleData")
Dim b As Boolean
ssm = FpSpread1.ActiveSheet.Models.Style
ns.BackColor = Color.Yellow
FpSpread1.NamedStyles.Add(ns)
ssm.SetDirectInfo(0, 0, ns)
b = ssm.IsRowUsed(0)
Label1.Text = "Does row 0 have a style set =  " & b.ToString()
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

Reference

ISheetStyleModel Interface
ISheetStyleModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.