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.