SpreadJS 15
Features / Rows and Columns / Create Multiple Headers
In This Topic
    Create 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 pointer over the line at the edge of a header. The pointer changes to a double arrow and you can then drag the column or row to the new width or height.

    Multiple row and column headers in sheet

    You can use the options.colHeaderAutoTextIndex, options.colHeaderAutoText, options.rowHeaderAutoTextIndex, and options.rowHeaderAutoText properties in code to change the default header text.

    Using Code

    This example specifies the type and location of the header text and creates custom header text.

    Copy Code
    activeSheet.setValue(0, 2,"Column",GC.Spread.Sheets.SheetArea.colHeader);
    activeSheet.options.rowHeaderAutoTextIndex = 1;
    activeSheet.options.rowHeaderAutoText = GC.Spread.Sheets.HeaderAutoText.numbers;
    activeSheet.options.colHeaderAutoTextIndex = 1;
    activeSheet.options.colHeaderAutoText = GC.Spread.Sheets.HeaderAutoText.letters;
    See Also