AddCellSpan

TD and TH tags, COLSPAN and ROWSPAN attributes

Spans in the spreadsheet are exported to become spanned cells in the HTML table (using the COLSPAN and ROWSPAN attributes).

Caution Data that had been hidden under spanned cells is discarded.

AllowCellOverflow

TD and TH tags, COLSPAN and NOWRAP attributes

If the AllowCellOverflow property is set to True, cells in the spreadsheet that overflowed into adjacent empty cells become cells that span columns in the HTML table (COLSPAN attribute) and the NOWRAP attribute is set.

If the AllowCellOverflow property is set to False, cells containing long data allow data to wrap in the cells.

BackColor

TH and TD tags, BGCOLOR attribute

Displays the background color assigned to the individual cell, the row, the column, or the spreadsheet, in that order. The colors in the fpSpread control are translated to the closest color of the 216 defined web-compliant colors.

CellNote

Spread does not export cell notes to the HTML file.

CellTag

Spread does not export cell tags to the HTML file.

CellType

HTML tables do not provide cells that can act similarly to controls, as Spread does. However, for many cell types, the data and formatting in Spread are exported to the HTML table, 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 the HTML table. If the check box cell is a three-state check box, the value 0, 1, or 2 is exported to the HTML table.

Combo box

The current value in the edit field of the combo box is exported to the cell in the HTML table.

Currency

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

TypeCurrencyDecimal

The setting of the TypeCurrencyDecimal property determines the decimal character or characters in Spread, which is the character exported to the HTML table.

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 HTML table.

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 HTML table.

TypeCurrencyNegStyle

The setting of the TypeCurrencyNegStyle property determines the format displayed for negative values in currency cells. The format used in Spread is the format used for data exported to the HTML table.

TypeCurrencyPosStyle

The setting of the TypeCurrencyPosStyle property determines the format displayed for positive values in currency cells. The format used in Spread is the format used for data exported to the HTML table.

TypeCurrencySeparator

The setting of the TypeCurrencySeparator property determines the separator character in Spread, which is the character exported to the HTML table.

TypeCurrencyShowSep

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 HTML table.

TypeCurrencyShowSymbol

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 HTML table.

TypeCurrencySymbol

The setting of the TypeCurrencySymbol property determines the currency character in Spread, which is the character exported to the HTML table.

Date

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

TypeDateCentury

If the TypeDateCentury property is set to True, the displayed date displays the century digits, which are exported to the HTML table.

Note To avoid misunderstanding and possible miscalculations, always display century values in Spread so that they are exported to the HTML table.

TypeDateFormat

The setting of the TypeDateFormat property determines the date format in Spread, which is the format exported to the HTML table.

TypeDateSeparator

The setting of the TypeDateSeparator property determines the date separator in Spread, which is the separator exported to the HTML table.

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 the HTML table.

TypeEditPassword

If the TypeEditPassword property is set to True, the asterisks used to mask the data in the fpSpread control are exported to the HTML table.

Number

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

TypeNumberDecimal

The setting of the TypeNumberDecimal property determines the decimal character or characters in Spread, which is the character exported to the HTML table.

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 HTML table.

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 HTML table.

TypeNumberNegStyle

The setting of the TypeNumberNegStyle property determines the format displayed for negative values in number cells. The format used in Spread is the format used for data exported to the HTML table.

TypeNumberSeparator

The setting of the TypeNumberSeparator property determines the separator character in Spread, which is the character exported to the HTML table.

TypeNumberShowSep

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 HTML table.

Owner-Drawn

Contents of owner-drawn cells are not exported.

Percent

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

TypePercentDecimal

The setting of the TypePercentDecimal property determines the decimal character or characters in Spread, which is the character exported to the HTML table.

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 HTML table.

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 HTML table.

TypePercentNegStyle

The setting of the TypePercentNegStyle property determines the format displayed for negative values in percent cells. The format used in Spread is the format used for data exported to the HTML table.

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

The icon or bitmap in the picture cell is converted to a JPEG file.

TypePictCenter

TD and TH tags, VALIGN attribute

If the TypePictCenter property is set to True, the VALIGN attribute is set to CENTER.

TypePictMaintainScale

The picture in the cell is converted to a JPEG that is exactly the same in dimensions and appearance as the picture as it is displayed in the Spread control.

TypePictPicture

The file specified by the TypePictPicture property is converted to a JPEG, named SPRnnnnn.JPG (where nnnnn is a random number), and placed in the same directory as the HTML file.

TypePictStretch

The picture in the cell is converted to a JPEG that is exactly the same in dimensions and appearance as the picture as it is displayed in the Spread control.

Scientific

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

TypeScientificDecimal

The setting of the TypeScientificDecimal property determines the decimal character or characters in Spread, which is the character exported to the HTML table.

TypeScientificDecPlaces

The setting of the TypeScientificDecPlaces property determines the number of decimal digits displayed in Spread, which is the number of decimal digits exported to the HTML table.

Static text

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

Time

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

TypeTime24Hour

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 the HTML table.

TypeTimeSeconds

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 the HTML table.

TypeTimeSeparator

The setting of the TypeTimeSeparator property determines which time separator character the cell displays in Spread; whichever separator the cell displays is exported to the HTML table.

ColHeaderRows

TH tag

Creates additional table head rows. Sets any text in column headers in table heading rows.

ColHeadersAutoText

TH tag

Sets text in column headers in table heading.

ColHeadersAutoTextIndex

TH tag

Sets text in column headers in table heading, in same row as in spreadsheet header rows.

ColHeadersShow

TH tag

Displays column headers if set to True; does not display them if set to False.

ColHeadersUserSortIndex

The export ignores the setting of this property. The HTML table does not support the user sort feature.

ColHidden

Spread does not export hidden columns to the HTML file.

ColID

The export ignores the setting of this property. The HTML table does not support the column ID feature.

ColMerge

TD and TH tags, COLSPAN attribute

If the ColMerge property is set to True for a column, and the cells in the spreadsheet have merged because they contain identical data, the HTML table displays cells that span columns (COLSPAN attribute).

ColWidth

TD and TH tags, WIDTH attribute

The widths of the exported columns are set (in pixels) to create columns that are the same widths as the Spread columns.

Font

See separate font setting properties

FontBold

B tag

Sets bold face text using bold tag.

FontItalic

I tag

Sets italicized text using italic tag.

FontName

FONT FACE attribute

Sets font displayed using FONT FACE attribute.

FontSize

FONT SIZE attribute

Translates the font size from points to a value between 1 and 7 as follows:

Font size in points Font size attribute
<10 1
<12, but =10 2
<14, but =12 3
<18, but =14 4
<24, but =18 5
<36, but =24 6
=36 7

FontStrikethru

S tag

Sets strike through using strikethrough tag.

FontUnderline

U tag

Sets underline using underline tag.

ForeColor

TH and TD tags, FONT COLOR attribute

Displays the text color assigned to the individual cell, the row, the column, or the spreadsheet, in that order. The colors in the fpSpread control are translated to the closest color of the 216 defined web-compliant colors.

Formula

HREF tag if URL function is in formula

Current value in the cell at time of export goes into HTML file.

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

If the URL function is used in the formula, the information in the function is used to create an HREF tag (hypertext link) in the exported HTML table.

GridShowHoriz

TABLE tag, RULES attribute

If the GridShowHoriz property is set to True, the RULES attribute for the table is set to ROWS. If both the GridShowHoriz and the GridShowVert are set to False, the RULES attribute is set to NONE. Note that if you set the BORDER attribute to 0, no grid lines are displayed.

GridShowVert

TABLE tag, RULES attribute

If the GridShowVert property is set to True, the RULES attribute for the table is set to COLS. If both the GridShowHoriz and the GridShowVert are set to False, the RULES attribute is set to NONE. Note that if you set the BORDER attribute to 0, no grid lines are displayed.

LockBackColor

TH and TD tags, BGCOLOR attribute

Displays the locked cell background color. The colors in the fpSpread control are translated to the closest color of the 216 defined web-compliant colors.

LockForeColor

TH and TD tags, FONT COLOR attribute

Displays the locked cell text color. The colors in the fpSpread control are translated to the closest color of the 216 defined web-compliant colors.

MaxCols

Using the ExportToHTML method or the SSExportToHTML function, the fpSpread control exports all the columns and rows that contain data in the spreadsheet to the HTML table. If you specify a range of cells using the ExportRangeToHTML method or the SSExportRangeToHTML function, all the cells you specify are exported to the HTML table, whether those cells have data or not.

Remember to consider your users' system resources and design your exported table's size accordingly.

MaxRows

Using the ExportToHTML method or the SSExportToHTML function, the fpSpread control exports all the columns and rows that contain data in the spreadsheet to the HTML table. If you specify a range of cells using the ExportRangeToHTML method or the SSExportRangeToHTML function, all the cells you specify are exported to the HTML table, whether those cells have data or not.

Remember to consider your users' system resources and design your exported table's size accordingly.

RowHeaderCols

TH tag

Creates additional table head columns. Sets any text in row headers in table heading columns.

RowHeadersAutoText

Sets text in row headers in table heading.

RowHeadersAutoTextIndex

TH tag

Sets text in row headers in table heading, in same column as in spreadsheet header columns.

RowHeadersShow

TH tag

Displays row headers if set to True; does not display them if set to False.

RowHeight

TD and TH tags, HEIGHT attribute

The heights of the exported rows are set (in pixels) to create rows that are the same heights as the Spread rows.

RowHidden

Spread does not export hidden rows to the HTML file.

RowMerge

TD and TH tags, ROWSPAN attribute

If the RowMerge property is set to True for a row, and the cells in the spreadsheet have merged because they contain identical data, the HTML table displays cells that span rows (ROWSPAN attribute).

ShadowColor

TH and TD tags, BGCOLOR attribute

Displays the background color assigned to the headers and static text cells. The colors in the fpSpread control are translated to the closest color of the 216 defined web-compliant colors.

ShadowText

TH and TD tags, FONT COLOR attribute

Displays the text color assigned to the headers and static text cells. The colors in the fpSpread control are translated to the closest color of the 216 defined web-compliant colors.

StartingColNumber

Numbering used in Spread exports to the HTML table.

StartingRowNumber

Numbering used in Spread exports to the HTML table.

TwoDigitYearMax

The HTML table displays 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

The export ignores the setting of this property. The data in the cell is exported to HTML in its entirety.

TypeHAlign

TD and TH tags, ALIGN attribute

Sets the horizontal alignment for the individual cell, the row, the column, or the spreadsheet, in that order.

TypeNegRed

FONT tag, COLOR attribute

If set to True, sets the font color to red for the text in the HTML table for any exported negative values.

TypeSpinInc

The export ignores the setting of this property. The HTML table does not support the spin button feature.

TypeSpinWrap

The export ignores the setting of this property. The HTML table does not support the spin button feature.

TypeTextOrient

The export ignores the setting of this property. The HTML table displays the text horizontally.

TypeVAlign

TD and TH tags, VALIGN attribute

Sets the vertical alignment for the individual cell, the row, the column, or the spreadsheet, in that order.

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 HTML table will contain only the data that is currently in the virtual buffer.

Other settings

Control border

TABLE tag, BORDER attribute

The export reads the NoBorder property setting. If the NoBorder property is set to True, the BORDER attribute is set to 0, and the HTML table will not display grid lines. If the NoBorder property is set to False, the HTML uses the default BORDER attribute setting of 1.

Cell spacing

TABLE tag, CELLSPACING attribute

The cell spacing is set to 0 to create a single-line grid effect similar to Spread.

TABLE tag, CELLPADDING attribute

The cell padding is set to 0 to appear similar to Spread (which does not provide padding capability).

Empty cells

&nbsp;

The export inserts a nonbreaking space in each empty cell.

Leading or trailing spaces in cells

&nbsp;

The export inserts a nonbreaking space in place of each leading or trailing space in cells. Without these nonbreaking spaces, leading or trailing spaces within the HTML tags are ignored.