AddCellSpan

Ignores the spans in the spreadsheet. The data in each cell that was hidden by the spanned cell is exported to the XML data.

AllowCellOverflow

Ignores the setting of this property. The data in the cell is exported to XML in its entirety.

AllowEditOverflow

Ignores the setting of this property.

BackColor

Colors and other appearance settings are ignored.

CellNote

Cell notes are not exported to XML data.

CellTag

Cell tags are not exported to XML data.

CellType

For many cell types, the data and formatting in Spread are exported to XML data, as explained in the following rows.

Button

Contents of button cells are not exported.

Check box

If the check box cell is a two-state check box, the value 0 or 1 is exported to XML. If the check box cell is a three-state check box, the value 0, 1, or 2 is exported to XML.

Combo box

If formatted data is exported, the current value in the edit field of the combo box is exported. If unformatted data is exported, the index number of the current value in the edit field of the combo box is exported.

Currency

Currency cells are exported in the format in which they are displayed if you choose to export formatted data. Exporting unformatted data exports the values in the cells similar to returning the values using the Value property, as explained in the following rows.

TypeCurrencyDecimal

If exporting formatted data, the setting of the TypeCurrencyDecimal property determines the decimal character or characters in Spread, which is the character exported to the XML data. For unformatted data, the exported data uses the default decimal character, specified by the regional settings.

TypeCurrencyDecPlaces

The setting of the TypeCurrencyDecPlaces property determines the number of decimal digits displayed in Spread, which is the number of decimal digits exported to the XML data.

TypeCurrencyLeadingZero

The setting of the TypeCurrencyLeadingZero property determines whether the leading zero is displayed for values between -1 and 1 in Spread. If the leading zero is displayed in Spread, it is exported to the XML data.

TypeCurrencyNegStyle

If exporting formatted data, the setting of the TypeCurrencyNegStyle property determines the format displayed for negative values in currency cells, which is the format exported to the XML data. For unformatted data, the exported data uses the default negative style, specified by the regional settings.

TypeCurrencyPosStyle

If exporting formatted data, the setting of the TypeCurrencyPosStyle property determines the format displayed for positive values in currency cells, which is the format exported to the XML data. For unformatted data, the exported data uses the default negative style, specified by the regional settings.

TypeCurrencySeparator

If exporting formatted data, the setting of the TypeCurrencySeparator property determines the separator character in Spread, which is the character exported to the XML data. For unformatted data, the separator character is not exported.

TypeCurrencyShowSep

If exporting formatted data, the setting of the TypeCurrencyShowSep property determines whether the cell displays a separator character in Spread; if the cell displays the character, it is exported to the XML data. For unformatted data, the separator character is not exported.

TypeCurrencyShowSymbol

If exporting formatted data, the setting of the TypeCurrencyShowSymbol property determines whether the cell displays a currency character in Spread; if the cell displays the character, it is exported to the XML data. For unformatted data, the currency character is not exported.

TypeCurrencySymbol

If exporting formatted data, the setting of the TypeCurrencySymbol property determines the currency character in Spread, which is the character exported to the XML data. For unformatted data, the currency character is not exported.

Date

Date cells are exported in the format in which they are displayed, as explained in the following rows.

TypeDateCentury

If formatted data is exported, and the TypeDateCentury property is set to True, the displayed date displays the century digits, which are exported to XML. If unformatted data is exported, the date is exported in the format MMDDYYYY regardless of the setting of the TypeDateCentury property.

Note To avoid misunderstanding, always display century values in Spread so that they are exported to XML.

TypeDateFormat

If formatted data is exported, the setting of the TypeDateFormat property determines the date format in Spread, which is the format exported to XML. If unformatted data is exported, the date is exported in the format MMDDYYYY regardless of the setting of the TypeDateFormat property.

TypeDateSeparator

If formatted data is exported, the setting of the TypeDateSeparator property determines the date separator in Spread, which is the separator exported to XML. If unformatted data is exported, the date is exported in the format MMDDYYYY and no separator character is used, regardless of the setting of the TypeDateSeparator property.

Edit

Edit cells are exported in the format in which they are displayed, as explained in the following rows.

TypeEditCharCase

The setting of the TypeEditCharCase property determines the text case in Spread, which is the text case exported to XML.

TypeEditPassword

The data displayed in the cell is exported. If the cell displays a placeholder character, such as "*", that character is exported.

Number

Number cells are exported in the format in which they are displayed if you choose to export formatted data. Exporting unformatted data exports the values in the cells similar to returning the values using the Value property, as explained in the following rows.

TypeNumberDecimal

If exporting formatted data, the setting of the TypeNumberDecimal property determines the decimal character or characters in Spread, which is the character exported to the XML data. For unformatted data, the exported data uses the default decimal character, specified by the regional settings.

TypeNumberDecPlaces

The setting of the TypeNumberDecPlaces property determines the number of decimal digits displayed in Spread, which is the number of decimal digits exported to the XML data.

TypeNumberLeadingZero

The setting of the TypeNumberLeadingZero property determines whether the leading zero is displayed for values between -1 and 1 in Spread. If the leading zero is displayed in Spread, it is exported to the XML data.

TypeNumberNegStyle

If exporting formatted data, the setting of the TypeNumberNegStyle property determines the format displayed for negative values in number cells, which is the format exported to the XML data. For unformatted data, the exported data uses the default negative style, specified by the regional settings.

TypeNumberSeparator

If exporting formatted data, the setting of the TypeNumberSeparator property determines the separator character in Spread, which is the character exported to the XML data. For unformatted data, the separator character is not exported.

TypeNumberShowSep

If exporting formatted data, the setting of the TypeNumberShowSep property determines whether the cell displays a separator character in Spread; if the cell displays the character, it is exported to the XML data. For unformatted data, the separator character is not exported.

Owner-Drawn

Contents of owner-drawn cells are not exported.

Percent

Percent cells are exported in the format in which they are displayed if you choose to export formatted data. Exporting unformatted data exports the values in the cells similar to returning the values using the Value property, as explained in the following rows.

TypePercentDecimal

If exporting formatted data, the setting of the TypePercentDecimal property determines the decimal character or characters in Spread, which is the character exported to the XML data. For unformatted data, the exported data uses the default decimal character, specified by the regional settings.

TypePercentDecPlaces

The setting of the TypePercentDecPlaces property determines the number of decimal digits displayed in Spread, which is the number of decimal digits exported to the XML data.

TypePercentLeadingZero

The setting of the TypePercentLeadingZero property determines whether the leading zero is displayed for values between -1 and 1 in Spread. If the leading zero is displayed in Spread, it is exported to the XML data.

TypePercentNegStyle

If exporting formatted data, the setting of the TypePercentNegStyle property determines the format displayed for negative values in percent cells, which is the format exported to the XML data. For unformatted data, the exported data uses the default negative style, specified by the regional settings.

PIC

The data in PIC cells is exported, as explained in the following rows.

TypePicDefaultText

Default text is not exported unless the user has typed some data in the cell, in which case the PIC cell displays the data and the default text, and it is all exported.

TypePicMask

The setting of the TypePicMask property determines which data users can enter in the cell. The data provided by the users is exported, as are the literal characters defined in the PIC cell.

Picture

Contents of picture cells are not exported.

Static text

Static text cells are exported in the format in which they are displayed.

Scientific

Scientific cells are exported in the format in which they are displayed.

TypeScientificDecimal

If exporting formatted data, the setting of the TypeScientificDecimal property determines the decimal character or characters in Spread, which is the character exported to the XML data. For unformatted data, the exported data uses no decimal symbol or places.

TypeScientificDecPlaces

If exporting formatted data, the setting of the TypeScientificDecPlaces property determines the number of decimal places in Spread, which is the number of decimal digits exported to the XML data. For unformatted data, the exported data uses no decimal places.

Time

Time cells are exported in the format in which they are displayed or as data, as explained in the following rows.

TypeTime24Hour

If formatted data is exported, the setting of the TypeTime24Hour property determines whether the cell displays time in 12- or 24-hour format in Spread; whichever format the cell displays is the format exported to XML. If unformatted data is exported, the time value is exported as a 24-hour time value in the format HHMMSS, regardless of the setting of the TypeTime24Hour property.

TypeTimeSeconds

If formatted data is exported, the setting of the TypeTimeSeconds property determines whether the cell displays the seconds value in Spread; if the cell displays seconds, the seconds value is exported to XML. If unformatted data is exported, the time value is exported as a 24-hour time value in the format HHMMSS, regardless of the setting of the TypeTimeSeconds property.

TypeTimeSeparator

If formatted data is exported, the setting of the TypeTimeSeparator property determines which time separator character the cell displays in Spread; whichever separator the cell displays is exported to XML. If unformatted data is exported, the time value is exported as a 24-hour time value in the format HHMMSS, regardless of the setting of the TypeTimeSeparator property.

ColHeaderRows

The additional column header rows are ignored. The text in the column header row specified by the ColHeadersAutoTextIndex property is used as the element tags.

ColHeadersAutoText

Sets text in column headers as element tags.

ColHeadersAutoTextIndex

The text in the column header row specified by the ColHeadersAutoTextIndex property is used as the element tags.

ColHeadersShow

Setting this property does not have an effect on the export. The XML file uses the heading numbering or text that would be displayed if ColHeadersAutoText is set to True to name the element tags.

ColHeadersUserSortIndex

The setting of the ColHeadersUserSortIndex property is ignored.

ColHidden

Spread does not export hidden columns to XML.

ColID

Column ID settings are ignored.

ColMerge

Merged cells are treated as individual cells, each containing the same data. The merge setting is ignored.

ColWidth

The column width setting is ignored.

Font

Font settings are ignored.

Formula

Current value in the cell at time of export is exported to XML.

Tip Before you perform the export, recalculate the formulas in the spreadsheet to be sure you are exporting the most current value.

GridShowHoriz

Appearance settings are ignored.

GridShowVert

Appearance settings are ignored.

LockBackColor

Colors and other appearance settings are ignored.

LockForeColor

Colors and other appearance settings are ignored.

MaxCols

Using the ExportToXML method or the SSExportToXML function, the fpSpread control exports all the columns and rows that contain data in the spreadsheet to XML. If you specify a range of cells using the ExportRangeToXML method or the SSExportRangeToXML function, all the cells you specify that contain data are exported to XML.

MaxRows

Using the ExportToXML method or the SSExportToXML function, the fpSpread control exports all the columns and rows that contain data in the spreadsheet to XML. If you specify a range of cells using the ExportRangeToXML method or the SSExportRangeToXML function, all the cells you specify that contain data are exported to XML.

RowHeaderCols

The row headers are ignored.

RowHeadersAutoText

The row headers are ignored.

RowHeadersAutoTextIndex

The row headers are ignored.

RowHeadersShow

The row headers are ignored.

RowHeight

The row height setting is ignored.

RowHidden

Spread does not export hidden rows to XML.

RowMerge

Merged cells are treated as individual cells, each containing the same data. The merge setting is ignored.

ShadowColor

Colors and other appearance settings are ignored.

ShadowText

Colors and other appearance settings are ignored.

StartingColNumber

Numbering used in Spread exports to the XML data, and is used as the element tags.

StartingRowNumber

The row header is ignored.

TwoDigitYearMax

The XML data receives dates in the same format as they were displayed in the spreadsheet. Therefore, if the TypeDateCentury property is set to True so that dates display century digits, this value affects how the century values were determined in Spread, if the year values were provided as two-digit values.

TypeEllipses

Ignores the setting of this property. The data in the cell is exported to XML in its entirety.

TypeHAlign

Appearance settings are ignored.

TypeNegRed

Appearance settings are ignored.

TypeSpinInc

Spin button settings are ignored.

TypeSpinWrap

Spin button settings are ignored.

TypeTextOrient

Appearance settings are ignored.

TypeVAlign

Appearance settings are ignored.

VirtualMode

Set the VirtualMode property to False before exporting the spreadsheet from Spread. If you do not turn virtual mode off before exporting from Spread, the XML data will contain only the data that is currently in the virtual buffer.

Other settings

Control border

Appearance settings are ignored.

Empty cells

Empty cells are not exported to XML data.

Leading or trailing spaces in cells

Leading or trailing spaces are exported as data.