Spread Windows Forms 6.0 Product Documentation
IsPropertySet Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > ISheetAxisModel Interface : IsPropertySet Method


index
Row or column index
prop
Property to evaluate

Glossary Item Box

Determines whether the specified SheetAxisModel property is set.

Syntax

Visual Basic (Declaration) 
Function IsPropertySet( _
   ByVal index As Integer, _
   ByVal prop As SheetAxisProperty _
) As Boolean
Visual Basic (Usage)Copy Code
Dim instance As ISheetAxisModel
Dim index As Integer
Dim prop As SheetAxisProperty
Dim value As Boolean
 
value = instance.IsPropertySet(index, prop)
C# 
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.
C#Copy Code
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();
}
Visual BasicCopy Code
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

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.