You can customize the appearance of header cells by changing the row height or column width, or both, for any of the rows or columns of headers. You can change the size by setting properties in the RowHeader class for the row header or the ColumnHeader class for the column header or both, or use the respective SheetView class properties. Use these properties:

• ColumnHeader.Height
• RowHeader.Width
• SheetView.ColumnHeaderHeight
• SheetView.RowHeaderWidth

You can also use the Spread Designer to set the width and height of header cells.

For information on setting the size of cells in the data area, refer to Setting the Row Height or Column Width.

Using Code

Set the height or width for the headers.

Example

This example code sets the height and width of the headers.

// Set the height and width for the headers.
FpSpread1.Sheets[0].ColumnHeader.Height = 60;
FpSpread1.Sheets[0].RowHeader.Width = 60;

' Set the height and width for the headers.
FpSpread1.Sheets(0).ColumnHeader.Height = 60
FpSpread1.Sheets(0).RowHeader.Width = 60

Using the Spread Designer

1. Select the Settings menu.
2. Select the Header Editor icon in the Other Settings section.
3. Select the header you wish to edit.
4. Set the height or width properties.
5. Choose Apply and OK to apply your changes to the component.
6. Click Apply and Exit to close the Spread Designer.

Copyright © GrapeCity, inc. All rights reserved.