This topic summarizes some general differences in behavior and operation between Spread COM and Spread.NET versions based on product design.

Row and Column Indexes

In Spread COM, row and column indexes are one-based, so indexes start at 1. In Spread.NET, row and column indexes are zero-based, so indexes start at 0.In Spread COM, column 0 was the header column and row 0 was the header row. In Spread.NET, column 0 is the first data column and row 0 is the first data row. The data area is a separate object from the headers and from the sheet corner.

For more information on finding indexes of rows and column in Spread.NET, refer to Getting Information of a Clicked Cell in the Developers Guide.

Cell Properties

In Spread COM, cell properties are targeted using Row, Col, Row2, Col2, and BlockMode properties. In Spread.NET, cell properties are targeted using Cells property.

For more information on the spreadsheet objects in Spread.NET, refer to Understanding the Spreadsheet Objects in the Developers Guide.

Cell Type Properties

In Spread COM, there are separate CellTypeEdit and CellTypeText members. In Spread.NET, there is a single TextCellType. In Spread COM, cell type properties are assigned using the CellType and TypeXxx properties. In Spread.NET, cell type properties are assigned by setting up a CellType object and the assigning the object to the CellType property.

For more information on converting cell types, refer to Cell Types Imported from Spread COM Files.

For more information about using cell types, refer to Customizing Interaction with Cell Types in the Developers Guide.

Reference Styles

Spread COM supported the Default reference style; no such style exists for Spread.NET. Spread COM supported three reference styles (Default, A1, and R1C1). Spread.NET supports two reference styles (A1 and R1C1). The Default style was an older style that used the # character to indicate same row or same column. The A1 style is a Microsoft Excel style that uses the $ character to indicate an absolute reference. The R1C1 style is a Microsoft Excel style that uses the [ ] characters to indicate a relative reference.

For more information on cell references in Spread.NET, refer to Specifying a Cell Reference in a Formula in the Developers Guide.