Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / DefaultSheetAxisModel Class / DefaultSheetAxisModel Constructor / DefaultSheetAxisModel Constructor(Int32,SheetAxisOrientation)
Number of rows or columns in the model
Orientation of the model
Example


In This Topic
    DefaultSheetAxisModel Constructor(Int32,SheetAxisOrientation)
    In This Topic
    Creates an axis model (DefaultSheetAxisModel object) with the specified number of rows or columns, and no parent model.
    Syntax
    '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");
    
    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")
    See Also