Spread for ASP.NET 11 Product Documentation
FormatString Property (GeneralCellType)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > GeneralCellType Class : FormatString Property
Gets or sets the format string used to format the value.
Syntax
'Declaration
 
Public Overridable Property FormatString As String
'Usage
 
Dim instance As GeneralCellType
Dim value As String
 
instance.FormatString = value
 
value = instance.FormatString
public virtual 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
System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo();
dtf.LongDatePattern = "D";
dtf.ShortDatePattern = "M/d/yyyy";
FarPoint.Web.Spread.GeneralCellType g = new FarPoint.Web.Spread.GeneralCellType();
g.DateTimeFormat = dtf;
g.FormatString = dtf.ShortDatePattern
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = g;
FpSpread1.ActiveSheetView.Cells[0, 0].Value = DateTime.Now;
Dim dtf As New System.Globalization.DateTimeFormatInfo
Dim b As Boolean
dtf.LongDatePattern = "D"
dtf.ShortDatePattern = "M/d/yyyy"
Dim g As New FarPoint.Web.Spread.GeneralCellType
g.DateTimeFormat = dtf
g.FormatString = dtf.ShortDatePattern
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = g
FpSpread1.ActiveSheetView.Cells(0, 0).Value = DateTime.Now
See Also

Reference

GeneralCellType Class
GeneralCellType Members