Spread Windows Forms 6.0 Product Documentation
DefaultSheetAxisModel Constructor(Int32,SheetAxisOrientation)
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetAxisModel Class > DefaultSheetAxisModel Constructor : DefaultSheetAxisModel Constructor(Int32,SheetAxisOrientation)


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

Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Function New( _
   ByVal count As Integer, _
   ByVal orientation As SheetAxisOrientation _
)
Visual Basic (Usage)Copy Code
Dim count As Integer
Dim orientation As SheetAxisOrientation
 
Dim instance As New DefaultSheetAxisModel(count, orientation)
C# 
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.
C#Copy Code
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 BasicCopy Code
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")

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.