TypeTimeMin Property
Applies To
fpSpread control
Description
Sets or returns the minimum time value allowed in a time cell. This property is available at run time only.
Syntax
CString CSpreadSheet::GetTypeTimeMin( );
void CSpreadSheet::SetTypeTimeMin(LPCTSTR value);
[form.]fpSpread.TypeTimeMin[ = 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 TypeTimeMin property is "000000".
The value you set for the TypeTimeMin property is the minimum time value the control allows the user to type or paste into the specified time cell. Values smaller than the specified minimum value can still be added to the cell in code at run time or from a database.
To use the TypeTimeMin 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 TypeTimeMin property for a cell or cells, any subsequent time cells you create will use the same TypeTimeMin setting unless you reset it for those cells.
The TypeTimeMin property does not have an effect unless the CellType property is set to 6 (Time) for the specified cell or cells.
Specify the maximum time value allowed in the cell by setting the TypeTimeMax 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 Min Time edit box in the Cell Type Settings dialog box.
Data Type
String
See Also
Creating and Customizing a Time Cell
CellType, Sheet, TypeTime24Hour, TypeSpin, TypeTimeMax, TypeTimeSeconds properties