Spread Windows Forms 7.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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

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