Gets the appearance settings for the StyleInfo object.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As StyleInfo
Dim appearance As Appearance
Dim value As Appearance
value = instance.GetAppearance(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
Example
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# | Copy Code |
|---|
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 | Copy Code |
|---|
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 |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
