Spread Windows Forms 11.0 Product Documentation
Serialize Method (TextCellType)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > TextCellType Class : Serialize Method
XmlTextWriter to which to write (save) the object
Saves the object to XML.
Syntax
'Declaration
 
Public Overrides Function Serialize( _
   ByVal w As XmlTextWriter _
) As Boolean
'Usage
 
Dim instance As TextCellType
Dim w As XmlTextWriter
Dim value As Boolean
 
value = instance.Serialize(w)
public override bool Serialize( 
   XmlTextWriter w
)

Parameters

w
XmlTextWriter to which to write (save) the object

Return Value

Boolean: true if successful; false otherwise
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;
string fileName; 
fileName = "..\\files\\mycurr.xml"; 
System.IO.Stream stream;  
stream = System.IO.File.Open(fileName, System.IO.FileMode.Create); 
System.Xml.XmlTextWriter writer = new System.Xml.XmlTextWriter(stream, System.Text.Encoding.UTF8); 
writer.Formatting = System.Xml.Formatting.Indented; writer.Indentation = 2; 
writer.WriteStartDocument(); 
writer.WriteStartElement("Currency"); 
curr.Serialize(writer); 
writer.WriteEndElement(); 
writer.WriteEndDocument(); 
writer.Close();
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 fileName As String
fileName = "..\files\mycurr.xml"
Dim stream As System.IO.Stream
stream = System.IO.File.Open(fileName, System.IO.FileMode.Create)
Dim writer As New System.Xml.XmlTextWriter(stream, System.Text.Encoding.UTF8)
writer.Formatting = System.Xml.Formatting.Indented
writer.Indentation = 2
writer.WriteStartDocument()
writer.WriteStartElement("Currency")
curr.Serialize(writer)
writer.WriteEndElement()
writer.WriteEndDocument()
writer.Close()
See Also

Reference

TextCellType Class
TextCellType Members