Spread WPF 15
Spread WPF Documentation / Developer's Guide / Managing the User Interface / Creating Multiple Headers
In This Topic
    Creating Multiple Headers
    In This Topic

    You can display multiple column and row headers and specify whether to show letters, numbers, or nothing in the default header. You can also put custom text in the headers.

    Clicking on a header will select that row or column by default. You can also resize a column or row by moving the mouse pointer over the line at the edge of a header. The mouse pointer changes to a double arrow and you can then drag the column or row to the new width or height.

    Multiple column and row headers in a spreadsheet

    You can use the AutoTextIndex and AutoText properties in code to change the default header text.

    Using Code

    The following example specifies the type of text in the headers and puts custom text in a column header.

    CS
    Copy Code
    gcSpreadSheet1.Sheets[0].ColumnHeader.RowCount = 2;
    gcSpreadSheet1.Sheets[0].RowHeader.ColumnCount = 2;
    gcSpreadSheet1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Column";
    gcSpreadSheet1.Sheets[0].RowHeader.AutoTextIndex = 1;
    gcSpreadSheet1.Sheets[0].RowHeader.AutoText = GrapeCity.Windows.SpreadSheet.Data.HeaderAutoText.Letters;
    gcSpreadSheet1.Sheets[0].ColumnHeader.AutoTextIndex = 1;
    gcSpreadSheet1.Sheets[0].ColumnHeader.AutoText = GrapeCity.Windows.SpreadSheet.Data.HeaderAutoText.Numbers;
    gcSpreadSheet1.Invalidate();
    
    VB.NET
    Copy Code
    GcSpreadSheet1.Sheets(0).ColumnHeader.RowCount = 2
    GcSpreadSheet1.Sheets(0).RowHeader.ColumnCount = 2
    GcSpreadSheet1.Sheets(0).ColumnHeader.Cells(0, 2).Text = "Column"
    GcSpreadSheet1.Sheets(0).RowHeader.AutoTextIndex = 1
    GcSpreadSheet1.Sheets(0).RowHeader.AutoText = GrapeCity.Windows.SpreadSheet.Data.HeaderAutoText.Letters
    GcSpreadSheet1.Sheets(0).ColumnHeader.AutoTextIndex = 1
    GcSpreadSheet1.Sheets(0).ColumnHeader.AutoText = GrapeCity.Windows.SpreadSheet.Data.HeaderAutoText.Numbers
    GcSpreadSheet1.Invalidate()
    
    See Also