FormatString Property (LabelCellType)

Gets and sets the format for the label.

Syntax

Visual Basic
C#

'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;

Visual Basic

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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

LabelCellType Class
LabelCellType Members