Spread for ASP.NET 11 Product Documentation
GetDirectAltRowInfo Method (ISheetStyleModel)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > ISheetStyleModel Interface : GetDirectAltRowInfo Method
Index of the alternating row style to get; must be between 0 and AltRowCount-1
Style set (StyleInfo object) to use for composing the styles; if destInfo is null then a new StyleInfo is created and used
Gets the specified alternating row style in the model.
Syntax
'Declaration
 
Function GetDirectAltRowInfo( _
   ByVal index As Integer, _
   ByVal destInfo As StyleInfo _
) As StyleInfo
'Usage
 
Dim instance As ISheetStyleModel
Dim index As Integer
Dim destInfo As StyleInfo
Dim value As StyleInfo
 
value = instance.GetDirectAltRowInfo(index, destInfo)
StyleInfo GetDirectAltRowInfo( 
   int index,
   StyleInfo destInfo
)

Parameters

index
Index of the alternating row style to get; must be between 0 and AltRowCount-1
destInfo
Style set (StyleInfo object) to use for composing the styles; if destInfo is null then a new StyleInfo is created and used

Return Value

StyleInfo object containing the style information
Example
FarPoint.Web.Spread.Model.ISheetStyleModel iss;
iss = (FarPoint.Web.Spread.Model.ISheetStyleModel)FpSpread1.ActiveSheetView.StyleModel;
iss.AltRowCount = 2;
Dim si As New FarPoint.Web.Spread.StyleInfo;
si.BackColor = Color.Yellow;
iss.SetDirectAltRowInfo(1, si);
FarPoint.Web.Spread.StyleInfo ret = iss.GetDirectAltRowInfo(1, null);
string msg = "The background color of the style is " + si.BackColor.ToString();
Response.Write("<script language='javascript'>alert('" + msg + "')</script>");
Dim iss As FarPoint.Web.Spread.Model.ISheetStyleModel
iss = FpSpread1.ActiveSheetView.StyleModel
iss.AltRowCount = 2
Dim si As New FarPoint.Web.Spread.StyleInfo
si.BackColor = Color.Yellow
iss.SetDirectAltRowInfo(1, si)
Dim ret As FarPoint.Web.Spread.StyleInfo = iss.GetDirectAltRowInfo(1, Nothing)
Dim msg As String = "The background color of the style is " + si.BackColor.ToString()
Response.Write("<script language='javascript'>alert('" & msg & "')</script>")
See Also

Reference

ISheetStyleModel Interface
ISheetStyleModel Members