ParseFormatString Property

Gets or sets the parsed formatting string for the cell.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ParseFormatString As String

'Usage
 
Dim instance As Cell
Dim value As String
 
instance.ParseFormatString = value
 
value = instance.ParseFormatString

public string ParseFormatString {get; set;}

Property Value

String containing the parsed formatting string

Remarks

This property is only for use with cells of type GeneralCellType.

Example

This example shows how to parse cell data.

FarPoint.Win.Spread.CellType.GeneralCellType gct = new FarPoint.Win.Spread.CellType.GeneralCellType();
fpSpread1.ActiveSheet.Cells[0, 0].CellType = gct;
System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("en-us", true);
fpSpread1.ActiveSheet.Cells[0, 0].Value = System.DateTime.Now;
fpSpread1.ActiveSheet.Cells[0, 0].ParseFormatString = ci.DateTimeFormat.ToString();

Visual Basic

Dim gct As New FarPoint.Win.Spread.CellType.GeneralCellType
Dim ci As New System.Globalization.CultureInfo("en-us", True)
fpSpread1.ActiveSheet.Cells(0, 0).CellType = gct
fpSpread1.ActiveSheet.Cells(0, 0).Value = Now
fpSpread1.ActiveSheet.Cells(0, 0).ParseFormatString = ci.DateTimeFormat.ToString()

Reference

Cell Class
Cell Members
ParseFormatInfo Property
GetParseFormat Method
SetFormatString Method
IParseFormatSupport Interface