Spread Windows Forms 9.0 Product Documentation
Serialize Method (NumberCellType)
Example 


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 NumberCellType
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()
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

NumberCellType Class
NumberCellType Members

 

 


Copyright © GrapeCity, inc. All rights reserved.