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

You can use Rows, Columns properties of sheet corner to modify the sheet’s rows header column count and columns 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

Here is an example of rows in the sheet corner changing when you change the number of column headers.

C#	Copy Code
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;

VB	Copy Code
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

Here is an example of column header rows changing when you change the number of sheet corner columns.

C#	Copy Code
fpSpread1.ActiveSheet.ColumnHeader.RowCount = 5; fpSpread1.ActiveSheet.SheetCorner.ColumnCount = 3;

VB	Copy Code
FpSpread1.ActiveSheet.ColumnHeader.RowCount = 5 FpSpread1.ActiveSheet.SheetCorner.ColumnCount = 3

See Also