Spread for ASP.NET 7.0 Product Documentation
FormatString Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > LabelCellType Class : FormatString Property


Glossary Item Box

Gets and sets the format for the label.

Syntax

Visual Basic (Declaration) 
Public Property FormatString As String
Visual Basic (Usage)Copy Code
Dim instance As LabelCellType
Dim value As String
 
instance.FormatString = value
 
value = instance.FormatString
C# 
public string FormatString {get; set;}

Property Value

String containing the format string

Remarks

The value of a general cell can be a string, a number, or a DateTime object.

The formats supported are the numeric formats and date-time formats in .NET framework.

Example

This example creates a LabelCellType object, allows its text to wrap if long enough and sets up the formatting for the text. It is assigned to the first cell in the sheet.
C#Copy Code
FarPoint.Web.Spread.LabelCellType lblcell=new FarPoint.Web.Spread.LabelCellType();
lblcell.AllowWrap=true;
int i=100;
string fstring=i.ToString("C");
lblcell.FormatString=fstring;
FpSpread1.ActiveSheetView.Cells[0,0].CellType=lblcell;
FpSpread1.ActiveSheetView.Cells[0,0].Text=fstring;
Visual BasicCopy Code
Dim lblcell As New FarPoint.Web.Spread.LabelCellType()
lblcell.AllowWrap=True
Dim i As Integer=100
Dim fstring As String=i.ToString("C")
lblcell.FormatString=fstring
FpSpread1.ActiveSheetView.Cells(0,0).CellType=lblcell
FpSpread1.ActiveSheetView.Cells(0,0).Text=fstring

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.