Spread Windows Forms 11.0 Product Documentation
Cell Settings Imported
Spread Windows Forms 11.0 Product Documentation > Import and Export Reference > Excel-Formatted Files Import > Cell Settings Imported

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.