Spread Windows Forms 9.0 Product Documentation
SetFormatString Method (GeneralCellType)
Example 


Format string for formatting values
Whether to consider the number as a date and time value
Sets the format string for formatting values.
Syntax
'Declaration
 
Public Sub SetFormatString( _
   ByVal value As String, _
   ByVal isDateFormat As Boolean _
) 
'Usage
 
Dim instance As GeneralCellType
Dim value As String
Dim isDateFormat As Boolean
 
instance.SetFormatString(value, isDateFormat)
public void SetFormatString( 
   string value,
   bool isDateFormat
)

Parameters

value
Format string for formatting values
isDateFormat
Whether to consider the number as a date and time value
Example

This example shows the use of this method for a currency cell but the use is similar for any cell type.

FarPoint.Win.Spread.CellType.CurrencyCellType curr = new FarPoint.Win.Spread.CellType.CurrencyCellType();
curr.DecimalSeparator = ",";
curr.DecimalPlaces = 3;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = curr;
fpSpread1.ActiveSheet.Cells[0, 0].Value = 443.0908;
bool b; 
System.Xml.XmlDocument doc = new System.Xml.XmlDocument(); 
doc.Load("..\\files\\mycurr.xml"); 
System.Xml.XmlNode node;  
node = doc.FirstChild; 
while (!node.Name.Equals("Currency")) 
    node = node.NextSibling; 
System.Xml.XmlNodeReader r = new System.Xml.XmlNodeReader(node); 
r.Read(); 
b = curr.Deserialize(r); 
listBox1.Items.Add(b.ToString());
Dim curr As New FarPoint.Win.Spread.CellType.CurrencyCellType()
curr.DecimalSeparator = ","
curr.DecimalPlaces = 3
FpSpread1.ActiveSheet.Cells(0, 0).CellType = curr
FpSpread1.ActiveSheet.Cells(0, 0).Value = 443.9098
Dim b As Boolean
Dim doc As New System.Xml.XmlDocument()
doc.Load("..\files\mycurr.xml")
Dim node As System.Xml.XmlNode
node = doc.FirstChild
While Not (node.Name.Equals("Currency"))
node = node.NextSibling
End While
Dim r As New System.Xml.XmlNodeReader(node)
r.Read()
b = curr.Deserialize(r)
ListBox1.Items.Add(b)
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

GeneralCellType Class
GeneralCellType Members
IParseFormatSupport Interface
ParseFormatString Property
SetParseFormat Method

 

 


Copyright © GrapeCity, inc. All rights reserved.