Spread ASP.NET 6.0 Product Documentation
FormatString Property
See Also  Example Send Feedback
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.LabelCellTypelblcell=newFarPoint.Web.Spread.LabelCellType();
lblcell.AllowWrap=true;
inti=100;
stringfstring=i.ToString("C");
lblcell.FormatString=fstring;
FpSpread1.ActiveSheetView.Cells[0,0].CellType=lblcell;
FpSpread1.ActiveSheetView.Cells[0,0].Text=fstring;
Visual BasicCopy Code
DimlblcellAsNewFarPoint.Web.Spread.LabelCellType()
lblcell.AllowWrap=True
DimiAsInteger=100
DimfstringAsString=i.ToString("C")
lblcell.FormatString=fstring
FpSpread1.ActiveSheetView.Cells(0,0).CellType=lblcell
FpSpread1.ActiveSheetView.Cells(0,0).Text=fstring

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.