TypePicDefaultText Property
Applies To
fpSpread control
Description
Sets or returns the default text displayed in a PIC cell. This property is available at run time only.
Syntax
CString CSpreadSheet::GetTypePicDefaultText( );
void CSpreadSheet::SetTypePicDefaultText(LPCTSTR value);
[form.]fpSpread.TypePicDefaultText[ = text$]
Remarks
The default text is initially displayed in the cell when it is in edit mode. When the user types characters, the characters replace the default text. When the user deletes data within the cell, the deleted characters are replaced by the default text.
The characters you specify to use as the default text must be characters allowed by the mask defined for the cell using the TypePicMask property. For example, if you have defined a mask for the PIC cell that only allows numbers, the default text you provide must be numbers. Provide default text that has the same number of characters as the mask, and use the same literal characters in the default text as used in the defined mask.
To use the TypePicDefaultText property, specify the sheet with which you want to work by setting the Sheet property. Then specify the cell or cells to which to apply the property, as described in Using Column and Row Properties. Once you set the TypePicDefaultText property for a cell or cells, any subsequent PIC cells you create will use the same TypePicDefaultText setting unless you reset it for those cells.
The TypePicDefaultText property does not have an effect unless the CellType property is set to 4 (PIC) for the specified cell or cells.
Spread Designer
Not available.
Data Type
String
See Also
CellType, Sheet, TypePicMask properties