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 | 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 | Spread imports borders. Refer to Border Styles Substituted for details. Spread sets the color to the color used in Excel. | |
Cell formats | 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 | Spread imports cell contents as the Value and displays it at size specified by the Font property. | |
Columns | See the Column object in Spread. | |
Conditional Formatting | The imported conditional formatting is similar to the Spread conditional formatting that uses rules. | |
Fonts, font types | Spread loads the cell fonts from Excel. | |
Formulas | Refer to the Formula Settings Imported. | |
Horizontal and vertical text alignment | Spread imports the Excel setting. | |
Locked cells | 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 | 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 | Spread creates a span range corresponding to the merged cells in Excel. | |
Outlining | Spread imports the Excel setting. | |
Rows | See the Row object in Spread. | |
Sparklines | Sparkline | Sparklines are imported. |
TextIndent | Spread imports the Excel setting. | |
Rich text | Spread imports the rich text formats. Refer to Setting Rich Text in a Cell. |