Spread Windows Forms 8.0 Product Documentation > Developer's Guide > Customizing the Sheet Appearance > Customizing the Sheet Corner Appearance > Header Count Synchronization in the Sheet Corner |
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.
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 |
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 |