Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetStyleModel Class / GetCompositeInfo Method
Example


In This Topic
    GetCompositeInfo Method (DefaultSheetStyleModel)
    In This Topic
    Gets the composite style for the specified cell, column, row, or model default.
    Overload List
    OverloadDescription
    Gets the composite style for the specified cell, column, row, or model default.  
    Gets the style information for a cell, column, row, or model as a composite of settings. Some styles can be ignored when composing by setting excludeInfo and excludeNs Style properties with excludeNs are ignored if they are set to excludeInfo  
    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.

    Example
    This example sets the background color of the cell A1 to yellow and sets the foreground color of the first row to red. The composited style of the cell A1 then has yellow background color and red foreground color.
    private void Page_Load(object sender,System.EventArgs e)
    {
    if(this.IsPostBack)return;
    
    FarPoint.Web.Spread.Model.DefaultSheetStyleModel model=(FarPoint.Web.Spread.Model.DefaultSheetStyleModel)FpSpread1.Sheets[0].StyleModel;
    FarPoint.Web.Spread.StyleInfo style=new FarPoint.Web.Spread.StyleInfo();
    style.BackColor=Color.Yellow;
    model.SetDirectInfo(0,0,style);
    
    FarPoint.Web.Spread.StyleInfo style1=new FarPoint.Web.Spread.StyleInfo();
    style1.ForeColor=Color.Red;
    model.SetDirectInfo(0,-1,style1);
    
    FpSpread1.Sheets[0].SetValue(0,0,"Style");
    
    style=model.GetCompositeInfo(0,0,-1,null);
    ListBox1.Items.Add("BackColor"+style.BackColor.ToString());
    ListBox1.Items.Add("ForeColor"+style.ForeColor.ToString());
    }
    Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load
    If(IsPostBack)Then Return
    
    Dim model As FarPoint.Web.Spread.Model.DefaultSheetStyleModel=FpSpread1.Sheets(0).StyleModel
    Dim style As New FarPoint.Web.Spread.StyleInfo()
    style.BackColor=Color.Yellow
    model.SetDirectInfo(0,0,style)
    
    Dim style1 As New FarPoint.Web.Spread.StyleInfo()
    style1.ForeColor=Color.Red
    model.SetDirectInfo(0,-1,style1)
    
    FpSpread1.Sheets(0).SetValue(0,0,"Style")
    
    style=model.GetCompositeInfo(0,0,-1,Nothing)
    ListBox1.Items.Add("BackColor"&style.BackColor.ToString())
    ListBox1.Items.Add("ForeColor"&style.ForeColor.ToString())
    End Sub
    See Also