Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / ISheetAxisModel Interface / IsPropertySet Method
Row or column index
Property to evaluate
Example


In This Topic
    IsPropertySet Method (ISheetAxisModel)
    In This Topic
    Determines whether the specified SheetAxisModel property is set.
    Syntax
    'Declaration
     
    Function IsPropertySet( _
       ByVal index As Integer, _
       ByVal prop As SheetAxisProperty _
    ) As Boolean
    'Usage
     
    Dim instance As ISheetAxisModel
    Dim index As Integer
    Dim prop As SheetAxisProperty
    Dim value As Boolean
     
    value = instance.IsPropertySet(index, prop)
    bool IsPropertySet( 
       int index,
       SheetAxisProperty prop
    )

    Parameters

    index
    Row or column index
    prop
    Property to evaluate

    Return Value

    Boolean: true if a property is set for a row or column; false otherwise
    Example
    This example returns whether the size property is set and resets it.
    FarPoint.Win.Spread.Model.ISheetAxisModel isa;
    DialogResult dlg;
    bool b;
    isa = (FarPoint.Win.Spread.Model.ISheetAxisModel)fpSpread1.ActiveSheet.Models.ColumnAxis;
    isa.SetSize(1, 120);
    b = isa.IsPropertySet(1, FarPoint.Win.Spread.Model.SheetAxisProperty.Size);
    label1.Text = "Is the size property set = " + b.ToString();
    dlg = MessageBox.Show("Do you want to reset the size??", "ResetProperty", MessageBoxButtons.YesNo);
    if (dlg == DialogResult.Yes)
    {
    bool b1;
    isa.ResetProperty(1, FarPoint.Win.Spread.Model.SheetAxisProperty.Size);
    b1 = isa.IsPropertySet(1, FarPoint.Win.Spread.Model.SheetAxisProperty.Size);
    label1.Text = "Is the size property set = " + b1.ToString();
    }
    Dim isa As FarPoint.Win.Spread.Model.ISheetAxisModel
    Dim dlg As DialogResult
    Dim b As Boolean
    isa = FpSpread1.ActiveSheet.Models.ColumnAxis
    isa.SetSize(1, 120)
    b = isa.IsPropertySet(1, FarPoint.Win.Spread.Model.SheetAxisProperty.Size)
    Label1.Text = "Is the size property set = " & b.ToString()
    dlg = MessageBox.Show("Do you want to reset the size??", "ResetProperty", MessageBoxButtons.YesNo)
    If dlg = DialogResult.Yes Then
    Dim b1 As Boolean
    isa.ResetProperty(1, FarPoint.Win.Spread.Model.SheetAxisProperty.Size)
    b1 = isa.IsPropertySet(1, FarPoint.Win.Spread.Model.SheetAxisProperty.Size)
    Label1.Text = "Is the size property set = " & b1.ToString()
    End If
    See Also