Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / BaseSheetStyleModel Class / GetDirectInfo Method
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
Destination StyleInfo object for getting the style; if null, then a new StyleInfo is created and used
Example


In This Topic
    GetDirectInfo Method (BaseSheetStyleModel)
    In This Topic
    Gets the direct style information for the specified cell, column, row, or model default.
    Syntax
    'Declaration
     
    Public Overridable Function GetDirectInfo( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal destInfo As StyleInfo _
    ) As StyleInfo
    'Usage
     
    Dim instance As BaseSheetStyleModel
    Dim row As Integer
    Dim column As Integer
    Dim destInfo As StyleInfo
    Dim value As StyleInfo
     
    value = instance.GetDirectInfo(row, column, destInfo)
    public virtual StyleInfo GetDirectInfo( 
       int row,
       int column,
       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
    destInfo
    Destination StyleInfo object for getting the style; if null, then a new StyleInfo is 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.

    Use this method to get the direct settings for the specified object. Use the SetDirectInfo methods to set the direct settings for an object.

    Direct cell styles override direct row styles, which override direct column styles, which override model default styles. Direct row styles use -1 for the column, direct column styles use -1 for the row, and model default styles use -1 for both the row and column.

    To return the composite information for an object, use the GetCompositeInfo method.

    This implementation does nothing and returns null.

    Example
    This example sets up the cell type for the style.
    FarPoint.Web.Spread.Model.BaseSheetStyleModel bs;
    FarPoint.Web.Spread.StyleInfo si = new FarPoint.Web.Spread.StyleInfo();
    si.CellType = new FarPoint.Web.Spread.CheckBoxCellType();
    bs = (FarPoint.Web.Spread.Model.BaseSheetStyleModel)FpSpread1.ActiveSheetView.StyleModel;
    bs.SetDirectInfo(0, 0, si);
    
    FarPoint.Web.Spread.StyleInfo gdi;
    gdi = bs.GetDirectInfo(-1, -1, si);
    Response.Write("The cell type for the style is " + Convert.ToString(gdi.CellType));
    
    Dim bs As FarPoint.Web.Spread.Model.BaseSheetStyleModel
    Dim si As New FarPoint.Web.Spread.StyleInfo
    si.CellType = New FarPoint.Web.Spread.CheckBoxCellType
    bs = FpSpread1.ActiveSheetView.StyleModel
    bs.SetDirectInfo(0, 0, si)
    
    Dim gdi As FarPoint.Web.Spread.StyleInfo
    gdi = bs.GetDirectInfo(-1, -1, si)
    Response.Write("The cell type for the style is " & Convert.ToString(gdi.CellType))
    See Also