Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / GeneralCellType Class / SetFormatString Method
Format string for formatting values
Whether to consider the number as a date and time value
Example


In This Topic
    SetFormatString Method (GeneralCellType)
    In This Topic
    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)
    See Also