These tasks relate to setting the appearance of columns or rows in the sheet:
- Setting the Row Height or Column Width
- Resizing the Row or Column to Fit the Data
- Finding Rows or Columns That Have Data
- Creating Alternating Rows
When you work with rows and columns, you can manipulate the objects using the shortcuts in code (Row, Rows, Column, Columns, AlternatingRow, etc.) or you can directly manipulate the model. Most developers who are not changing anything drastically find it easy to manipulate the shortcut objects. You can edit properties of the Rows and Columns classes in the Properties window (in Spread Designer or in Visual Studio .NET). For more information on the Cells, Columns, and Rows Editor that is available from the Properties window, refer to the explanation of this editor in the Spread Designer Guide.
As with most spreadsheet and grid products, Spread does not allow in-cell editing of the cells in the row and column headers.
For more information about the appearance of rows as a result of filtering, refer to Setting the Appearance of Filtered Rows.
For more information about the appearance of cells, refer to Creating and Applying a Style for Cells.
Settings applied to a particular row or column override the settings that are set at the sheet level and settings applied at a cell level override the row or column settings. Refer to Object Parentage.
For information on the underlying model responsible for rows and columns, refer to the Understanding the Axis Model.
For more information, refer to the Row, Rows, AlternatingRow, AlternatingRows, Column, and Columns objects in the Assembly Reference.