GetAppearance(Appearance) Method

Visual Basic
C#

'Declaration
 
Public Overloads Function GetAppearance( _
   ByVal appearance As Appearance _
) As Appearance

'Usage
 
Dim instance As StyleInfo
Dim appearance As Appearance
Dim value As Appearance
 
value = instance.GetAppearance(appearance)

public Appearance GetAppearance( 
   Appearance appearance
)

Parameters

appearance: Appearance object to receive the appearance settings or null to create and return a new Appearance object

Return Value

Appearance object containing the appearance settings

This example creates an Appearance object and two StyleInfo objects. The cinfo object passes its settings into the Appearance object, which is then used to adjust the settings for the info objects properties. That, in turn, is used to set the style for the spreadsheet.

C#

FarPoint.Web.Spread.Appearance appr = new FarPoint.Web.Spread.Appearance();
FarPoint.Web.Spread.StyleInfo info = new FarPoint.Web.Spread.StyleInfo();
FarPoint.Web.Spread.StyleInfo cinfo = new FarPoint.Web.Spread.StyleInfo();
cinfo.BackColor = Color.Red;
cinfo.ForeColor = Color.White;
cinfo.HorizontalAlign = HorizontalAlign.Right;
cinfo.GetAppearance(appr);
info.BackColor = appr.BackColor;
info.ForeColor = appr.ForeColor;
info.HorizontalAlign = appr.HorizontalAlign;
FpSpread1.ActiveSheetView.SetStyleInfo(0, 0, info);
FpSpread1.ActiveSheetView.SetValue(0, 0, "StyleInfo");
FpSpread1.Columns[0].Width = 150;
FpSpread1.Rows[0].Height = 60;

Visual Basic

Dim appr As New FarPoint.Web.Spread.Appearance()
Dim info As New FarPoint.Web.Spread.StyleInfo()
Dim cinfo As New FarPoint.Web.Spread.StyleInfo()
cinfo.BackColor = Color.Red
cinfo.ForeColor = Color.White
cinfo.HorizontalAlign = HorizontalAlign.Right
cinfo.GetAppearance(appr)
info.BackColor = appr.BackColor
info.ForeColor = appr.ForeColor
info.HorizontalAlign = appr.HorizontalAlign
FpSpread1.ActiveSheetView.SetStyleInfo(0, 0, info)
FpSpread1.ActiveSheetView.SetValue(0, 0, "StyleInfo")
FpSpread1.Columns(0).Width = 150
FpSpread1.Rows(0).Height = 60

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

StyleInfo Class
StyleInfo Members
Overload List