Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetStyleModel Class / Clear Method
Starting model row index to clear
Starting model column index to clear
Number of rows to clear
Number of columns to clear
Example


In This Topic
    Clear Method (DefaultSheetStyleModel)
    In This Topic
    Removes all of the direct styles from the specified range.
    Syntax
    'Declaration
     
    Public Overridable Sub Clear( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer _
    ) 
    'Usage
     
    Dim instance As DefaultSheetStyleModel
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
     
    instance.Clear(row, column, rowCount, columnCount)
    public virtual void Clear( 
       int row,
       int column,
       int rowCount,
       int columnCount
    )

    Parameters

    row
    Starting model row index to clear
    column
    Starting model column index to clear
    rowCount
    Number of rows to clear
    columnCount
    Number of columns to clear
    Remarks
    This method removes the cell styles from the specified cell range.
    Example
    This example creates a new StyleInfo object, and changes the background color of the first cell. In a button click event the DefaultSheetStyleModel is cleared.
    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)
    End Sub
    
    Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles Button1.Click
    Dim model As FarPoint.Web.Spread.Model.DefaultSheetStyleModel=FpSpread1.Sheets(0).StyleModel
    model.Clear(0,0,1,1)
    End Sub
    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);
    }
    
    private void Button1_Click(object sender,System.EventArgs e)
    {
    FarPoint.Web.Spread.Model.DefaultSheetStyleModel model=(FarPoint.Web.Spread.Model.DefaultSheetStyleModel)FpSpread1.Sheets[0].StyleModel;
    model.Clear(0,0,1,1);
    }
    See Also