PasswordChar Property (TextCellType)

Visual Basic
C#

'Declaration
 
Public Property PasswordChar As Char

'Usage
 
Dim instance As TextCellType
Dim value As Char
 
instance.PasswordChar = value
 
value = instance.PasswordChar

public char PasswordChar {get; set;}

Property Value

Character containing the character for masking the password

This property lets you set which character to substitute in the display of the cell contents when a user types in a password. When this property is set, the display of the formatted data (Text property) appears to be replaced with the password character but the unformatted data (Value property) contains the actual text string.

The PasswordChar property has no effect when the Multiline property is set to true. Refer to the TextBox.PasswordChar property in the .NET Framework Reference documentation for more information.

This example specifies a password character (asterisk) that replaces all the text characters when displayed. The value of the cell is the text string, though it is not visible.

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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

TextCellType Class
TextCellType Members