# Cell Settings Imported

Understand the nuances of importing Excel data into Spread, including handling of locked cells, comments, and rich text formats.

## Content

This table summarizes how the cell settings are handled when Spread imports data from an Excel file. The properties are members of the [Cell](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.html) class unless specifically noted otherwise. They are also members of the [Column](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.html) class and [Row](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Row.html) class if you needed to set the cells of an entire column or entire row. For formula settings, refer to [Formula Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-formulas).

| **Excel Setting** | **Related Spread Property or Method** | **Remarks** |
| ------------- | --------------------------------- | ------- |
| Cell color or pattern | [BackColor](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.BackColor.html) [ForeColor](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.ForeColor.html) | 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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.Border.html) | Spread imports borders. Refer to [Border Styles Substituted](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-border) for details. Spread sets the color to the color used in Excel. |
| Cell formats | [CellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.CellType.html) | 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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.Value.html) | Spread imports cell contents as the Value and displays it at size specified by the Font property. |
| Columns | [Column](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.Column.html) | See the Column object in Spread. |
| Conditional Formatting | [SetConditionalFormatting](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.SetConditionalFormatting.html) | The imported conditional formatting is similar to the Spread conditional formatting that uses rules. |
| Fonts, font types | [Font](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.Font.html) | Spread loads the cell fonts from Excel. |
| Formulas |  | Refer to the [Formula Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-formulas). |
| Horizontal and vertical text alignment | [HorizontalAlignment](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.HorizontalAlignment.html) [VerticalAlignment](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.VerticalAlignment.html) | Spread imports the Excel setting. |
| Locked cells | [Locked](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.Locked.html) | 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](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-workbk). |
| Comments | [Note](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.Note.html) | 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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.ColumnSpan.html) [RowSpan](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.RowSpan.html) | Spread creates a span range corresponding to the merged cells in Excel. |
| Outlining | [AddRangeGroup](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.AddRangeGroup.html) | Spread imports the Excel setting. |
| Rows | [Row](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.Row.html) | See the Row object in Spread. |
| Sparklines | Sparkline | Sparklines are imported. |
| TextIndent | [TextIndent](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.TextIndent.html) | Spread imports the Excel setting. |
| Rich text | [RichText](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.IFeatures.RichText.html) | Spread imports the rich text formats. Refer to [Setting Rich Text in a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cells-richtext). |

## See Also

[Workbook Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-workbk)
[Chart Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-chart)
[Sheet Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-sheet)
[Row and Column Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-rowcol)
[Border Styles Substituted](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-border)
[Formula Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-formulas)
[Print Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-print)