Spread Windows Forms 12.0 Product Documentation
Cell Types Imported from Spread COM Files
Spread Windows Forms 12.0 Product Documentation > Version Comparison Reference > Object Import from Spread COM > Cell Types Imported from Spread COM Files

Spread.NET provides more cell types than Spread COM provided. The cell types in Spread COM are represented in Spread.NET, as described in the following table.

Spread COM Cell Type Spread.NET Cell Type
CellTypeButton ButtonCellType
CellTypeCheckBox CheckBoxCellType
CellTypeComboBox ComboBoxCellType
CellTypeCurrency CurrencyCellType
CellTypeDate DateTimeCellType
CellTypeEdit TextCellType
CellTypeNumber NumberCellType
CellTypeOwnerDrawn No equivalent cell type, but you can create a custom cell type object
CellTypePercent PercentCellType
CellTypePic MaskCellType
CellTypePicture ImageCellType and you can set the BackgroundImage property in any of the editable cell types
CellTypeScientific No equivalent cell type
CellTypeStaticText TextCellType
CellTypeTime DateTimeCellType

As shown in the table, some cell types do not have equivalent cell types, but instead can be re-created using properties or classes in Spread.NET.

When Spread.NET imports a Spread COM file, cell types are converted to their equivalent cell types. For Owner-Drawn and Picture cells, the import converts the cells as follows:

Spread COM Cell Type How it is imported
CellTypeOwnerDrawn The cell type in Spread COM is ignored. The cell in Spread.NET remains a general cell (default) or whatever cell type was assigned to that cell.
CellTypePicture As an empty cell that displays the picture set as the BackgroundImage property.

Spread.NET also offers the following additional cell types:

Spread.NET Cell Type Description
BarCodeCellType A cell that displays a bar code
ColorPickerCellType A cell that displays a color picker
GeneralCellType A general cell, that can accept a wide range of data, and formats it according to the type of data
HyperLinkCellType A cell with text that can function as a hyperlink
ImageCellType A cell that can handle images when bound to a data set
MultiOptionCellType A cell with a set of options, displayed as radio buttons
ProgressCellType A cell that displays a progress indicator
RegularExpressionCellType A cell that handles regular expressions
RichTextCellType A cell that allows multiple colors and fonts
SliderCellType A cell that displays a slider control

For a complete list of cell types, refer to Customizing Interaction with Cell Types.