DefaultSheetAxisModel Constructor(Int32,SheetAxisOrientation)

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

Syntax

Visual Basic
C#

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

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

public DefaultSheetAxisModel( 
   int count,
   SheetAxisOrientation orientation
)

Parameters

count: Number of rows or columns in the model
orientation: Orientation of the model

Example

This example creates a DefaultSheetAxisModel and assigns it to the ColumnAxis of the active sheet.

FarPoint.Win.Spread.Model.DefaultSheetAxisModel dsam = new FarPoint.Win.Spread.Model.DefaultSheetAxisModel(3, FarPoint.Win.Spread.Model.SheetAxisOrientation.Horizontal);
dsam = (FarPoint.Win.Spread.Model.DefaultSheetAxisModel)fpSpread1.ActiveSheet.Models.ColumnAxis;
dsam.SetMergePolicy(0, FarPoint.Win.Spread.Model.MergePolicy.Always);
FarPoint.Win.Spread.Model.MergePolicy p;
p = dsam.GetMergePolicy(0);
MessageBox.Show("The merge policy is " + p.ToString());

fpSpread1.ActiveSheet.SetText(0, 0, "Test");
fpSpread1.ActiveSheet.SetText(1, 0, "Test");
fpSpread1.ActiveSheet.SetText(2, 0, "Test");

Visual Basic

Dim dsam As New FarPoint.Win.Spread.Model.DefaultSheetAxisModel(3, FarPoint.Win.Spread.Model.SheetAxisOrientation.Horizontal)
dsam = fpSpread1.ActiveSheet.Models.ColumnAxis
dsam.SetMergePolicy(0, FarPoint.Win.Spread.Model.MergePolicy.Always)
Dim p As FarPoint.Win.Spread.Model.MergePolicy
p = dsam.GetMergePolicy(0)
MessageBox.Show("The merge policy is " & p.ToString())

fpSpread1.ActiveSheet.SetText(0, 0, "Test")
fpSpread1.ActiveSheet.SetText(1, 0, "Test")
fpSpread1.ActiveSheet.SetText(2, 0, "Test")

Reference

DefaultSheetAxisModel Class
DefaultSheetAxisModel Members
Overload List