Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetAxisModel Class / Parent Property
Example


In This Topic
    Parent Property (DefaultSheetAxisModel)
    In This Topic
    Gets or sets the parent sheet axis model.
    Syntax
    'Declaration
     
    
    Public Property Parent As ISheetAxisModel
    'Usage
     
    
    Dim instance As DefaultSheetAxisModel
    Dim value As ISheetAxisModel
     
    instance.Parent = value
     
    value = instance.Parent
    public ISheetAxisModel Parent {get; set;}

    Property Value

    ISheetAxisModel object with the parent sheet axis model
    Example
    This example creates a new DefaultSheetAxisModel based on an overridden one and assigns it to the spreadsheets ColumnAxisModel.
    Public Class mySheetAxisModel
    Inherits FarPoint.Web.Spread.Model.DefaultSheetAxisModel
    
    Dim size As Integer=180
    
    Public Overrides Function GetSize(ByVal index As Integer)As Integer
    Return size
    End Function
    
    Public Overrides Sub SetSize(ByVal index As Integer,ByVal value As Integer)
    value=size
    End Sub
    
    End Class
    
    Private Sub Page_Load(ByVal sender As System.Object,ByVal 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(int index)
    {
    return i;
    }
    
    public override void SetSize(int index,int value)
    {
    i=value;
    }
    }
    
    private void Page_Load(object sender,System.EventArgs e)
    {
    if(this.IsPostBack)return;
    
    mySheetAxisModel isheet=new mySheetAxisModel();
    FarPoint.Web.Spread.Model.DefaultSheetAxisMode lmodel=new FarPoint.Web.Spread.Model.DefaultSheetAxisModel(FpSpread1.ActiveSheetView.ColumnCount,FarPoint.Web.Spread.Model.SheetAxisOrientation.Horizontal);
    model.Parent=isheet;
    FpSpread1.ActiveSheetView.ColumnAxisModel=model;
    }
    See Also