Spread Windows Forms 13.0 Product Documentation
Spread Windows Forms 13.0 Product Documentation / Developer's Guide / Customizing the Sheet Appearance / Customizing the Sheet Corner Appearance / Header Count Synchronization in the Sheet Corner
In This Topic
    Header Count Synchronization in the Sheet Corner
    In This Topic

    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.

    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

    The following example illustrates how the number of column header rows change 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