Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Appearance Class / IsDefined Method
AppearanceProperty object containing the appearance property
Example


In This Topic
    IsDefined Method (Appearance)
    In This Topic
    Returns whether an appearance property has been set.
    Syntax
    'Declaration
     
    
    Public Overridable Function IsDefined( _
       ByVal prop As AppearanceProperty _
    ) As Boolean
    'Usage
     
    
    Dim instance As Appearance
    Dim prop As AppearanceProperty
    Dim value As Boolean
     
    value = instance.IsDefined(prop)
    public virtual bool IsDefined( 
       AppearanceProperty prop
    )

    Parameters

    prop
    AppearanceProperty object containing the appearance property

    Return Value

    Boolean: true if property is set; false otherwise
    Remarks

    Use this method to check if one of the appearance properties has been set for the object. For a list of the properties, see the AppearanceProperty class list of members.

    Example
    This example creates two Appearance objects and a Cell object. Several properties are set for the first Appearance object, and they are subsequently copied to the second instance. The properties are then applied from the second Appearance object to the Cell objects corresponding properties. The BackColor property of the Appearance object is then queried to see if it has been defined, and the result is returned to a text box.
    FarPoint.Web.Spread.Appearance appr = new FarPoint.Web.Spread.Appearance();
    FarPoint.Web.Spread.Appearance appr1 = new FarPoint.Web.Spread.Appearance();
    FarPoint.Web.Spread.Cell acell;
    appr.BackColor=Color.Red;
    appr.ForeColor=Color.White;
    appr.Font.Bold=True;
    appr.HorizontalAlign=HorizontalAlign.Right;
    appr.VerticalAlign=VerticalAlign.Top;
    appr1.Copy(appr);
    acell=FpSpread1.Cells[0,0];
    acell.BackColor=appr1.BackColor;
    acell.ForeColor=appr1.ForeColor;
    acell.Font.Bold=appr1.Font.Bold;
    acell.HorizontalAlign=appr1.HorizontalAlign;
    acell.VerticalAlign=appr1.VerticalAlign;
    FpSpread1.ActiveSheetView.SetValue(0,0,"AppearanceTest");
    FpSpread1.Columns[0].Width=150;
    FpSpread1.Rows[0].Height=60;
    bool bl;
    bl=appr.IsDefined(FarPoint.Web.Spread.AppearanceProperty.BackColor);
    TextBox1.Text=Convert.ToString(bl);
    Dim appr As New FarPoint.Web.Spread.Appearance()
    Dim appr1 As New FarPoint.Web.Spread.Appearance()
    appr.BackColor=Color.Red
    appr.ForeColor=Color.White
    appr.Font.Bold=True
    appr.HorizontalAlign=HorizontalAlign.Right
    appr.VerticalAlign=VerticalAlign.Top
    appr1.Copy(appr)
    Dim acell As FarPoint.Web.Spread.Cell
    acell=FpSpread1.Cells(0,0)
    acell.BackColor=appr1.BackColor
    acell.ForeColor=appr1.ForeColor
    acell.Font.Bold=appr1.Font.Bold
    acell.HorizontalAlign=appr1.HorizontalAlign
    acell.VerticalAlign=appr1.VerticalAlign
    FpSpread1.ActiveSheetView.SetValue(0,0,"AppearanceTest")
    FpSpread1.Columns(0).Width=150
    FpSpread1.Rows(0).Height=60
    Dim prop As FarPoint.Web.Spread.AppearanceProperty
    Dim bl As Boolean
    bl=appr.IsDefined(prop.BackColor)
    TextBox1.Text=bl
    See Also