Spread 8.0 Documentation
TypeTimeMax Property
Support Options
ActiveX Reference > ActiveX Properties > TypeTimeMax Property

Glossary Item Box

TypeTimeMax Property


See Also    DLL    Example

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

C++

CString CSpreadSheet::GetTypeTimeMax( );
void CSpreadSheet::SetTypeTimeMax(LPCTSTR value);

Visual Basic

[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

DLL Correspondence

SSSetTypeTime function

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.