You can use text cells to restrict users to entering text values and to display data as text. You can also specify the maximum text length and a password field.

The following image displays a text cell with a password.

For details on the properties and methods for this cell type, refer to the TextCellType class.

For information about checking a regular expression in a cell, refer to Setting a Regular Expression Cell.

Using Code

1. Define the text cell type by creating an instance of the TextCellType class.
2. Set properties for the text cell.
3. Apply the text cell type to a cell or range of cells.

Example

This example sets a password and a maximum length for the cell.

FarPoint.Web.Spread.TextCellType tcell = new FarPoint.Web.Spread.TextCellType();
tcell.Password = true;
tcell.MaxLength = 5;
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = tcell;

Dim tcell As New FarPoint.Web.Spread.TextCellType()
tcell.Password = True
tcell.MaxLength = 5
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = tcell

Using the Spread Designer

1. In the work area, select the cell or cells for which you want to set the cell type.
2. Select the Home menu.
3. Select the SetCellType icon under the CellType section.
4. Select the cell type and any other cell properties.
5. Select OK to close the dialog.
6. Click Apply and Exit to close the Spread Designer.