Spread ASP.NET 6.0 Product Documentation
CellType Property
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > NamedStyle Class : CellType Property


Glossary Item Box

Gets or sets the cell type object for the style.

Syntax

Visual Basic (Declaration) 
Public Overrides Property CellType As ICellType
Visual Basic (Usage)Copy Code
Dim instance As NamedStyle
Dim value As ICellType
 
instance.CellType = value
 
value = instance.CellType
C# 
public override ICellType CellType {get; set;}

Property Value

ICellType object that contains the cell type for cells of this style

Example

This example creates a new custom style and sets several of the style properties.
C#Copy Code
FarPoint.Web.Spread.NamedStyle nstyleheaders = new FarPoint.Web.Spread.NamedStyle("StyleData", "DataAreaDefault");
ns.BackColor = Color.LightBlue;
ns.Border = new FarPoint.Web.Spread.Border(Color.Red);
ns.CellType = new FarPoint.Web.Spread.TextCellType();
ns.Editor = new FarPoint.Web.Spread.TextCellType();
ns.Font.Bold = true;
ns.ForeColor = Color.Red;
ns.Formatter = new FarPoint.Web.Spread.TextCellType();
ns.HorizontalAlign = HorizontalAlign.Left;
ns.Locked = true;
ns.Name = "StyleData";
ns.Parent = "DataAreaDefault";
ns.Renderer = new FarPoint.Web.Spread.TextCellType();
ns.VerticalAlign = VerticalAlign.Bottom;
FpSpread1.NamedStyles.Add(ns);
FpSpread1.ActiveSheetView.Cells[0, 0].StyleName = "StyleData";
FpSpread1.ActiveSheetView.SetText(0, 0, "NamedStyle");
FpSpread1.ActiveSheetView.Columns[0].Width = 120;
FpSpread1.ActiveSheetView.Rows[0].Height = 80;
Visual BasicCopy Code
Dim ns As New FarPoint.Web.Spread.NamedStyle("StyleData", "DataAreaDefault")
ns.BackColor = Color.LightBlue
ns.Border = New FarPoint.Web.Spread.Border(Color.Red)
ns.CellType = New FarPoint.Web.Spread.TextCellType
ns.Editor = New FarPoint.Web.Spread.TextCellType
ns.Font.Bold = True
ns.ForeColor = Color.Red
ns.Formatter = New FarPoint.Web.Spread.TextCellType
ns.HorizontalAlign = HorizontalAlign.Left
ns.Locked = True
ns.Name = "StyleData"
ns.Parent = "DataAreaDefault"
ns.Renderer = New FarPoint.Web.Spread.TextCellType
ns.VerticalAlign = VerticalAlign.Bottom
FpSpread1.NamedStyles.Add(ns)
FpSpread1.ActiveSheetView.Cells(0, 0).StyleName = "StyleData"
FpSpread1.ActiveSheetView.SetText(0, 0, "NamedStyle")
FpSpread1.ActiveSheetView.Columns(0).Width = 120
FpSpread1.ActiveSheetView.Rows(0).Height = 80

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.