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

Glossary Item Box

UnitType Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the units used for the column width and row height.

Syntax

C++

long CSpreadSheet::GetUnitType( );
void CSpreadSheet::SetUnitType(long value);

Visual Basic

[form.]fpSpread.UnitType[ = setting%]

Remarks

The following settings are available:

Setting Description Constant
0 - Normal Column width and row height are based on system fixed font UnitTypeNormal
1 - VGA Base Column width and row height are based on predetermined value UnitTypeVGABase
2 - Twips Units are in twips
(1/1440 inch)
UnitTypeTwips

This setting is applied to the entire workbook, including all sheets in the control.

Settings 0 (Normal) and 1 (VGA Base) are very similar. You probably will not notice any difference between the settings unless your display is set to a high resolution.

Note: If you change the UnitType property, set it before any other property is referenced within the Form_Load event. The application cannot change this value once you set it.

Spread Designer

Choose the Book menu, then the Unit Type menu, select the Unit Type tab, and then choose an option in the Settings group box in the Sheet Default Settings dialog box.

Data Type

Integer (Enumerated)

See Also

Setting Measurement Units

ColWidth, RowHeight properties

DLL Correspondence

SSGetUnitType, SSSetUnitType functions

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