This table summarizes how the cell settings are handled when Spread.Sheets imports data from an Excel file. The properties are members of the GC.Spread.Sheets.CellRange class unless specifically noted otherwise.
| Excel Setting |
Spread.Sheets Setting |
Remarks |
| Cell color or pattern |
Cell.backColor or Cell.foreColor |
Spread.Sheets reads the color setting from Excel and assigns color based on the setting of each cell’s individual setting. Fill patterns are supported. |
| Cell borders |
Cell.borderLeft, borderTop, borderRight, borderBottom |
Spread.Sheets imports borders. Spread.Sheets sets the color to the color used in Excel. |
| Cell value |
Cell.value or Cell.text |
Spread.Sheets imports cell contents as the Value and displays it using the size specified by the Font property. |
| Cell ThemeFont, Fonts, font types |
Cell.font |
Spread.Sheets loads the cell fonts from Excel. |
| Cell Horizontal and vertical text alignment |
Cell.hAlign or Cell.vAlign |
Spread.Sheets imports this setting from Excel. |
| Cell Locked |
Cell.locked |
Spread.Sheets imports the Excel setting. Note the default value of the Lock property is True for all cells in Excel. |
| Cell Shrink to fit |
Cell.shrinkToFit |
Spread.Sheets imports this setting from Excel. |
| Cell WordWrap |
Cell.wordWrap |
Spread.Sheets imports this setting from Excel. |
| Cell TextIndent |
Cell.textIndent |
Spread.Sheets imports this setting from Excel. |
| Cell Format |
Cell.formatter |
Spread.Sheets imports all the Excel cell formats to the General cell type and assigns the formats as closely as possible by setting the NumberFormat, DateTimeFormat, and FormatString properties. |
| Cell Validator |
Cell.validator |
Spread.Sheets imports the Excel cell validator to DefaultDataValidator and assigns the validator as closely as possible by setting the different types of Validator properties. |