Sets the format string for formatting values.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As GeneralCellType
Dim value As String
Dim isDateFormat As Boolean
instance.SetFormatString(value, 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.
C# | Copy Code |
---|
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()); |
Visual Basic | Copy Code |
---|
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 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also