Spread for ASP.NET 8.0 Product Documentation
FormatString Property (LabelCellType)
Example 


Gets and sets the format for the label.
Syntax
'Declaration
 
Public Property FormatString As String
'Usage
 
Dim instance As LabelCellType
Dim value As String
 
instance.FormatString = value
 
value = instance.FormatString
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.
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;
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

Reference

LabelCellType Class
LabelCellType Members

 

 


Copyright © GrapeCity, inc. All rights reserved.