DefaultSheetAxisModel Constructor(Int32,SheetAxisOrientation,ISheetAxisModel)

In This Topic

Creates an axis model (DefaultSheetAxisModel object) with the specified parent model and number of rows or columns.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal count As Integer, _
   ByVal orientation As SheetAxisOrientation, _
   ByVal parent As ISheetAxisModel _
)

'Usage
 
Dim count As Integer
Dim orientation As SheetAxisOrientation
Dim parent As ISheetAxisModel
 
Dim instance As New DefaultSheetAxisModel(count, orientation, parent)

public DefaultSheetAxisModel( 
   int count,
   SheetAxisOrientation orientation,
   ISheetAxisModel parent
)

Parameters

count: Number of rows or columns in the model
orientation: Model orientation
parent: Parent ISheetAxisModel

Example

This example creates a custom axis model based on the DefaultSheetAxisModel.

Visual Basic

Public Class mySheetAxisModel
Inherits FarPoint.Web.Spread.Model.DefaultSheetAxisModel

Dim size As Integer=180

Public Overrides Function GetSize(By Val index As Integer)As Integer
Return size
End Function

Public Overrides Sub SetSize(By Val index As Integer, By Val value As Integer)
value=size
End Sub

End Class

Private SubPage_Load(By Val sender As System.Object,By Val e As System.EventArgs)Handles MyBase.Load

If(Me.IsPostBack)Then Return

Dim isheet As New mySheetAxisModel()
Dim model As New FarPoint.Web.Spread.Model.DefaultSheetAxisModel(FpSpread1.ActiveSheetView.ColumnCount,FarPoint.Web.Spread.Model.SheetAxisOrientation.Horizontal,isheet)
FpSpread1.ActiveSheetView.ColumnAxisModel=model

End Sub

public class mySheetAxisModel:FarPoint.Web.Spread.Model.DefaultSheetAxisModel
{
private int i=180;
private bool b=false;

public override int GetSize(intindex)
{
returni;
}

public override void SetSize(intindex,intvalue)
{
i=value;
}
}

private void Page_Load(objectsender,System.EventArgse)
{
if(this.IsPostBack)return;

mySheetAxisModel isheet= new mySheetAxisModel();
FarPoint.Web.Spread.Model.DefaultSheetAxisModel model = new FarPoint.Web.Spread.Model.DefaultSheetAxisModel(FpSpread1.ActiveSheetView.ColumnCount,FarPoint.Web.Spread.Model.SheetAxisOrientation.Horizontal,isheet);
FpSpread1.ActiveSheetView.ColumnAxisModel=model;
}

Reference

DefaultSheetAxisModel Class
DefaultSheetAxisModel Members
Overload List

Product Support Forum | Print this page