[]
        
(Showing Draft Content)

Worksheet Settings Imported

This table summarizes how the sheet settings are handled when SpreadJS imports data from an Excel-formatted file. These settings are members of the GC.Spread.Sheets.Worksheet class unless otherwise noted.

Excel Setting

SpreadJS Setting

Remarks

Worksheets Worksheet names

SpreadJS Spread.name

SpreadJS imports this setting from Excel.

Default Width

Sheet.defaults.colWidth

SpreadJS imports this setting from Excel.

Frozen panes

Sheet.frozenRowCount or Sheet.frozenColumnCount

SpreadJS imports this setting from Excel.

Data


SpreadJS loads the data from Excel.

Sparkline

Sheet.setSparkline

SpreadJS imports this setting from Excel.

Spans

Sheet.addSpan

SpreadJS loads all span information from Excel.

ActiveCell

Sheet.setActiveCell

SpreadJS sets the active cell when importing from Excel.

Selections

Sheet.setSelection

SpreadJS sets the selection when importing from Excel.

GridLine

Sheet.options.gridline

SpreadJS imports this setting from Excel.

Zoom

Sheet.zoom

SpreadJS keeps the zoom factor when importing from Excel.

Theme

Sheet.currentTheme

SpreadJS imports this setting from Excel.

Conditional Formats

Sheet.ConditionalFormats

SpreadJS loads all conditional formats when importing from Excel.

TabColor

Sheet.options.sheetTabColor

SpreadJS imports this setting from Excel.

Sheet Protected

Sheet.options.isProtected

SpreadJS imports this setting from Excel.

Tables

Sheet.tables.add

SpreadJS loads all tables when importing from Excel.

Range Group

Sheet.rowOutlines or Sheet.columnOutlines

SpreadJS loads all group information when importing from Excel.

Cell Overflow

Sheet.options.allowCellOverflow

SpreadJS sets allowCellOverflow to true (cells can always overflow in Excel).

Filter

Sheet.rowFilter

SpreadJS loads all filter information when importing from Excel.

Sheet Custom Names

Sheet.addCustomName

SpreadJS loads all custom names when importing from Excel.

Sheet Row or Column Header

Sheet.options.rowHeaderVisible or Sheet.options.colHeaderVisible

SpreadJS imports this setting from Excel.

Display Zeros as Blank

Sheet.options.showZeros

SpreadJS imports this setting from Excel.