HotkeyPrefix Property (TextCellType)

Visual Basic
C#

'Declaration
 
Public Property HotkeyPrefix As HotkeyPrefix

'Usage
 
Dim instance As TextCellType
Dim value As HotkeyPrefix
 
instance.HotkeyPrefix = value
 
value = instance.HotkeyPrefix

public HotkeyPrefix HotkeyPrefix {get; set;}

Property Value

HotkeyPrefix setting that determines the type of hot-key prefixes

When this property is set to HotkeyPrefix.Hide, an ampersand in the text does not appear as an ampersand, nor does it underline the following letter. You might want to use the Hide setting if you want to temporarily hide the underlined letters, but sometimes display them for users who want hot key access.

When this property is set to HotkeyPrefix.None, ampersand characters are displayed as characters and the following character is not underlined.

When this property is set to HotkeyPrefix.Show, ampersand characters are not displayed but instead the character following the ampersand character is underlined. This only affects the appearance.

This example specifies how text can be displayed including the letter case, the length, and whether it can wrap to multiple lines.

C#

FarPoint.Win.Spread.CellType.TextCellType txt = new FarPoint.Win.Spread.CellType.TextCellType();
txt.CharacterCasing = CharacterCasing.Upper;
txt.CharacterSet = FarPoint.Win.Spread.CellType.CharacterSet.Ascii;
txt.HotkeyPrefix = System.Drawing.Text.HotkeyPrefix.Show;
txt.MaxLength = 40;
txt.Multiline = true;
txt.PasswordChar = Convert.ToChar("*");
txt.ScrollBars = ScrollBars.Vertical;
txt.Static = true;
fpSpread1.Sheets[0].Cells[0, 0].CellType = txt;
fpSpread1.Sheets[0].Cells[0, 0].Text = "This is a text cell.  It can provide a wide range of" + " functionality for handling
a large amount of data that a user might want to include" + " in a single cell.";

Visual Basic

Dim txt As New FarPoint.Win.Spread.CellType.TextCellType()
txt.CharacterCasing = CharacterCasing.Upper
txt.CharacterSet = FarPoint.Win.Spread.CellType.CharacterSet.Ascii
txt.HotkeyPrefix = System.Drawing.Text.HotkeyPrefix.Show
txt.MaxLength = 40
txt.Multiline = True
txt.PasswordChar = "*"
txt.ScrollBars = ScrollBars.Vertical
txt.Static = True
FpSpread1.Sheets(0).Cells(0, 0).CellType = txt
FpSpread1.Sheets(0).Cells(0, 0).Text = "This is a text cell.  It can provide a wide range of" & _
" functionality for handling a large amount of data that a user might want to include" & _
" in a single cell."

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

TextCellType Class
TextCellType Members