Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / SetStyleInfo Method
Row index
Column index
StyleInfo object with cell style settings
Example


In This Topic
    SetStyleInfo Method
    In This Topic
    Sets the style for a cell, a column, a row, or an entire sheet.
    Syntax
    'Declaration
     
    Public Overridable Sub SetStyleInfo( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal info As StyleInfo _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim info As StyleInfo
     
    instance.SetStyleInfo(row, column, info)
    public virtual void SetStyleInfo( 
       int row,
       int column,
       StyleInfo info
    )

    Parameters

    row
    Row index
    column
    Column index
    info
    StyleInfo object with cell style settings
    Remarks

    Use this method to specify the cell style for a cell, a column, a row, or the entire sheet. Set the column and row parameters as follows to set the style:

    To set the style    
    for a . . .
    col setting         row setting    
    Cell Column index Row index
    Column Column index -1
    Row -1 Row index
    Sheet -1 -1

    Use the GetStyleInfo method to return the style for a cell.

    Example
    This example illustrates the use of this member by setting the style for the specified cell.
    FarPoint.Web.Spread.SheetView sv;
    FarPoint.Web.Spread.StyleInfo si = new FarPoint.Web.Spread.StyleInfo();
    si.Border = New FarPoint.Web.Spread.Border(BorderStyle.Dotted, Color.Red);
    sv = FpSpread1.ActiveSheetView;
    sv.SetStyleInfo(0, 0, si);
    
    Dim sv As FarPoint.Web.Spread.SheetView
    Dim si As New FarPoint.Web.Spread.StyleInfo
    si.Border = New FarPoint.Web.Spread.Border(BorderStyle.Dotted, Color.Red)
    sv = FpSpread1.ActiveSheetView
    sv.SetStyleInfo(0, 0, si)
    See Also