The number of rows and columns in the sheet corner depend on number of the column header rows and row header columns of the sheet. In fact, these two are synchronized by Spread, so if you change sheet corner size, the sheet header rows and columns are adjusted accordingly and if you change the number of sheet header rows or columns of the sheet, the sheet corner adjusts accordingly.

You can use the Rows and Columns properties of the sheet corner to modify the sheet’s row header column count and column header row count. The row count of column headers of the sheet always equals the row count of the sheet corner; the column count of row headers of the sheet always equals the column count of the sheet corner.

Example

The following example illustrates how the number of rows in the sheet corner change when you change the number of column header rows.

fpSpread1.ActiveSheet.AllowTableCorner = true;
fpSpread1.ActiveSheet.SheetCorner.ColumnCount = 6;
fpSpread1.ActiveSheet.SheetCorner.RowCount = 7;
//Change rows in sheet corner by change Row count of columns header
fpSpread1.ActiveSheet.ColumnHeader.RowCount = 5;

FpSpread1.ActiveSheet.AllowTableCorner = True
FpSpread1.ActiveSheet.SheetCorner.ColumnCount = 6
FpSpread1.ActiveSheet.SheetCorner.RowCount = 7
'Change rows in sheet corner by change Row count of columns header
FpSpread1.ActiveSheet.ColumnHeader.RowCount = 5

Example

The following example illustrates how the number of column header rows change when you change the number of sheet corner columns.

fpSpread1.ActiveSheet.ColumnHeader.RowCount = 5;
fpSpread1.ActiveSheet.SheetCorner.ColumnCount = 3;

FpSpread1.ActiveSheet.ColumnHeader.RowCount = 5
FpSpread1.ActiveSheet.SheetCorner.ColumnCount = 3

Copyright © GrapeCity, inc. All rights reserved.