FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : RowHeaderAutoText Property |
'Declaration Public Property RowHeaderAutoText As HeaderAutoText
'Usage Dim instance As SheetView Dim value As HeaderAutoText instance.RowHeaderAutoText = value value = instance.RowHeaderAutoText
public HeaderAutoText RowHeaderAutoText {get; set;}
Exception | Description |
---|---|
System.ComponentModel.InvalidEnumArgumentException | Specified header setting is not valid; must be one of the HeaderAutoText enumeration settings |
The automatic text is the text automatically assigned to header cells by the component. Use this property to change the automatic text to blank or to letters.
This property is equivalent to the RowHeader.AutoText property.
If your header has multiple row header columns, you can specify which header column displays the automatic text by setting the RowHeaderAutoTextIndex property (or the RowHeader.AutoTextIndex property).
This example sets up a number of column and row headers for the spreadsheet and changes the location of the header text and its type.
fpSpread1.ActiveSheet.ColumnHeader.RowCount = 3; fpSpread1.ActiveSheet.RowHeader.ColumnCount = 2; fpSpread1.ActiveSheet.ColumnHeaderAutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers; fpSpread1.ActiveSheet.ColumnHeaderAutoTextIndex = 0; fpSpread1.ActiveSheet.RowHeaderAutoText = FarPoint.Win.Spread.HeaderAutoText.Letters; fpSpread1.ActiveSheet.RowHeaderAutoTextIndex = 0;
FpSpread1.ActiveSheet.ColumnHeader.RowCount = 3 FpSpread1.ActiveSheet.RowHeader.ColumnCount = 2 FpSpread1.ActiveSheet.ColumnHeaderAutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers FpSpread1.ActiveSheet.ColumnHeaderAutoTextIndex = 0 FpSpread1.ActiveSheet.RowHeaderAutoText = FarPoint.Win.Spread.HeaderAutoText.Letters FpSpread1.ActiveSheet.RowHeaderAutoTextIndex = 0
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8