Clear Method (DefaultSheetAxisModel)

In This Topic

Removes the values from the specified rows or columns.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Sub Clear( _
   ByVal index As Integer, _
   ByVal count As Integer _
)

'Usage
 
Dim instance As DefaultSheetAxisModel
Dim index As Integer
Dim count As Integer
 
instance.Clear(index, count)

public virtual void Clear( 
   int index,
   int count
)

Parameters

index: Index before which to clear the rows or columns
count: Number of rows or columns to clear

Example

This example sets the size of the first two column headers, then in a button click event, the Clear method is called to clear the settings.

Visual Basic

Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load

If(Me.IsPostBack)Then Return

Dim dm As FarPoint.Web.Spread.Model.DefaultSheetAxisModel=CType(FpSpread1.ActiveSheetView.ColumnAxisModel,FarPoint.Web.Spread.Model.DefaultSheetAxisModel)
dm.SetSize(0,140)
dm.SetSize(1,50)
End Sub

Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles Button1.Click
Dim dm As FarPoint.Web.Spread.Model.DefaultSheetAxisModel=CType(FpSpread1.ActiveSheetView.ColumnAxisModel,FarPoint.Web.Spread.Model.DefaultSheetAxisModel)
dm.Clear(0,2)
End Sub

private void Page_Load(object sender,System.EventArgs e)
{
if(this.IsPostBack)return;

FarPoint.Web.Spread.Model.DefaultSheetAxisModel dm=(FarPoint.Web.Spread.Model.DefaultSheetAxisModel)FpSpread1.ActiveSheetView.ColumnAxisModel;
dm.SetSize(0,140);
dm.SetSize(1,50);
}

private void Button1_Click(object sender,System.EventArgs e)
{
FarPoint.Web.Spread.Model.DefaultSheetAxisModel dm=(FarPoint.Web.Spread.Model.DefaultSheetAxisModel)FpSpread1.ActiveSheetView.ColumnAxisModel;
dm.Clear(0,2);
}

Reference

DefaultSheetAxisModel Class
DefaultSheetAxisModel Members
Copy Method
Move Method
Swap Method

Product Support Forum | Print this page