SpreadJS Documentation
getRowHeaderAutoTextIndex Method
Gets which row header column displays the automatic text when there are multiple row header columns.
Syntax
var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: number
value = instance.getRowHeaderAutoTextIndex();
function getRowHeaderAutoTextIndex() : number;

Return Value

The column index of the row header that displays the automatic text.
Example
This example gets the row header settings.
activeSheet.setRowCount(2,GcSpread.Sheets.SheetArea.colHeader);
activeSheet.setColumnCount(2,GcSpread.Sheets.SheetArea.rowHeader);
activeSheet.setValue(0, 2,"Column",GcSpread.Sheets.SheetArea.colHeader);
activeSheet.setRowHeaderAutoTextIndex(1);
activeSheet.setRowHeaderAutoText( GcSpread.Sheets.HeaderAutoText.letters);
activeSheet.setColHeaderAutoTextIndex(1);
activeSheet.setColHeaderAutoText(GcSpread.Sheets.HeaderAutoText.numbers);
var htext = activeSheet.getRowHeaderAutoText();
var hindex = activeSheet.getRowHeaderAutoTextIndex();
var hvisible = activeSheet.getRowHeaderVisible();
alert(htext);
alert(hindex);
alert(hvisible);
Remarks
The default value is the right-most column, specified by -1.
See Also

Reference

Sheet type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.