setColumnHeaderAutoTextIndex Method

Sets which column header row displays the automatic text when there are multiple column header rows.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: any
value = instance.setColumnHeaderAutoTextIndex(autoTextIndex);

function setColumnHeaderAutoTextIndex( 
   autoTextIndex : number
) : any;

Parameters

autoTextIndex: The row index of the column header that displays the automatic text.

Example

This example specifies that a specific column header displays numbers.

Javascript

sheet.setRowCount(2,GcSpread.Sheets.SheetArea.colHeader);
sheet.setColumnCount(2,GcSpread.Sheets.SheetArea.rowHeader);
sheet.setValue(0, 2,"Column",GcSpread.Sheets.SheetArea.colHeader);
sheet.setColumnHeaderAutoTextIndex(1);
sheet.setColumnHeaderAutoText(GcSpread.Sheets.HeaderAutoText.numbers);

Reference

Sheet type