Cell Settings Imported

In This Topic

This table summarizes how the cell settings are handled when Spread imports data from an Excel file. The properties are members of the Cell class unless specifically noted otherwise. They are also members of the Column class and Row class if you needed to set the cells of an entire column or entire row. For formula settings, refer to Formula Settings Imported.

Excel Setting	Related Spread Property or Method	Remarks
Cell color or pattern	BackColor ForeColor	Spread reads the color setting from Excel and assigns color based on the setting of each cell’s individual setting. Fill patterns are not supported.
Cell blocks	selections in Spread	Sets selected cell blocks in Spread as they were when file was saved in Excel.
Cell borders	Border	Spread imports borders. Refer to Border Styles Substituted for details. Spread sets the color to the color used in Excel.
Cell formats	CellType	Spread 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 value	Value	Spread imports cell contents as the Value and displays it at size specified by the Font property.
Columns	Column	See the Column object in Spread.
Conditional Formatting	SetConditionalFormatting	The imported conditional formatting is similar to the Spread conditional formatting that uses rules.
Fonts, font types	Font	Spread loads the cell fonts from Excel.
Formulas		Refer to the Formula Settings Imported.
Horizontal and vertical text alignment	HorizontalAlignment VerticalAlignment	Spread imports the Excel setting.
Locked cells	Locked	Spread imports the Excel setting. Note the default value of the Lock property is True for all cells in Excel. See Protected in the table of Workbook Settings Imported.
Comments	Note	Spread provides cell notes for corresponding comments in Excel cells. Excel always displays comment indicators, so Spread’s CellNoteIndicator property is set to true.
Hyperlink object		Spread does not import hyperlinks.
Merged cells	ColumnSpan RowSpan	Spread creates a span range corresponding to the merged cells in Excel.
Outlining	AddRangeGroup	Spread imports the Excel setting.
Rows	Row	See the Row object in Spread.
Sparklines	Sparkline	Sparklines are imported.
TextIndent	TextIndent	Spread imports the Excel setting.
Rich text	RichText	Spread imports the rich text formats. Refer to Setting Rich Text in a Cell.