Spread for ASP.NET 8.0 Product Documentation
GetCompositeInfo Method (BaseSheetStyleModel)
Example 


Row index of the cell in the model, or -1 to specify an entire column or the model default
Column index of the cell in the model, or -1 to specify an entire row or the model default
Alternating row index of the cell, or -1 to skip composing any alternating style
Destination StyleInfo object for composing the styles; if null, then a new StyleInfo should be created and used
Gets the style information as a composite of settings for the specified cell, column, row, or model default.
Syntax
'Declaration
 
Public Overridable Function GetCompositeInfo( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal altIndex As Integer, _
   ByVal destInfo As StyleInfo _
) As StyleInfo
'Usage
 
Dim instance As BaseSheetStyleModel
Dim row As Integer
Dim column As Integer
Dim altIndex As Integer
Dim destInfo As StyleInfo
Dim value As StyleInfo
 
value = instance.GetCompositeInfo(row, column, altIndex, destInfo)
public virtual StyleInfo GetCompositeInfo( 
   int row,
   int column,
   int altIndex,
   StyleInfo destInfo
)

Parameters

row
Row index of the cell in the model, or -1 to specify an entire column or the model default
column
Column index of the cell in the model, or -1 to specify an entire row or the model default
altIndex
Alternating row index of the cell, or -1 to skip composing any alternating style
destInfo
Destination StyleInfo object for composing the styles; if null, then a new StyleInfo should be created and used

Return Value

This implementation does nothing and returns null.
Remarks

Spread uses a composite of style settings to paint the spreadsheet. For example, for a cell, the component looks at the style settings for the column and row for the cell, and the cell's own settings.

To get or set direct setting information, use the GetDirectInfo and SetDirectInfo methods.

Do not use this method to return the style information for alternating rows. Alternating rows styles are handled directly. Use the GetDirectAltRowInfo method.

This implementation does nothing and returns null.

Example
This example returns the font for the style.
FarPoint.Web.Spread.Model.BaseSheetStyleModel bs;
bs = (FarPoint.Web.Spread.Model.BaseSheetStyleModel)FpSpread1.ActiveSheetView.StyleModel;
FarPoint.Web.Spread.StyleInfo si;
FpSpread1.ActiveSheetView.DefaultStyle.Font.Name = "Comic Sans MS";

si = bs.GetCompositeInfo(0, 0, -1, null);
Response.Write(si.Font.ToString());
Dim bs As FarPoint.Web.Spread.Model.BaseSheetStyleModel
bs = FpSpread1.ActiveSheetView.StyleModel
Dim si As FarPoint.Web.Spread.StyleInfo
FpSpread1.ActiveSheetView.DefaultStyle.Font.Name = "Comic Sans MS"

si = bs.GetCompositeInfo(0, 0, -1, Nothing)
Response.Write(si.Font.ToString())
Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

BaseSheetStyleModel Class
BaseSheetStyleModel Members
GetDirectAltRowInfo Method
GetDirectInfo Method
SetDirectInfo Method

 

 


Copyright © GrapeCity, inc. All rights reserved.