TypeTimeMax Property
Applies To
fpSpread control
Description
Sets or returns the maximum time value allowed in a time cell. This property is available at run time only.
Syntax
CString CSpreadSheet::GetTypeTimeMax( );
void CSpreadSheet::SetTypeTimeMax(LPCTSTR value);
[form.]fpSpread.TypeTimeMax[ = text$]
Remarks
Specify limit values within a 24-hour range, from 000000 to 235959, using the format "HHMMSS", where HH stands for hours, MM for minutes, and SS for seconds.
The default value for the TypeTimeMax property is "235959".
The value you set for the TypeTimeMax property is the maximum time value the control allows the user to type or paste into the specified time cell. Values larger than the specified maximum value can still be added to the cell in code at run time or from a database.
To use the TypeTimeMax 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 TypeTimeMax property for a cell or cells, any subsequent time cells you create will use the same TypeTimeMax setting unless you reset it for those cells.
The TypeTimeMax property does not have an effect unless the CellType property is set to 6 (Time) for the specified cell or cells.
Specify the minimum time value allowed in the cell by setting the TypeTimeMin property. You can have the time cell display a spin button that lets users increment the time value to the minimum or maximum value allowed in the cell. To have the cell display a spin button, set the TypeSpin property for the cell to True.
Spread Designer
Choose the Cell menu, the Cell Type menu, the Time menu, and then the Settings tab, and then type a value in the Max Time edit box in the Cell Type Settings dialog box.
Data Type
String
See Also
Creating and Customizing a Time Cell
CellType, Sheet, TypeSpin, TypeTime24Hour, TypeTimeMin, TypeTimeSeconds properties