FontSize Property

Applies To

fpSpread control

Description

Sets or returns the font size of displayed text.

Syntax

C++

float CSpreadSheet::GetFontSize( );
void CSpreadSheet::SetFontSize(float value);

Visual Basic

[form.]fpSpread.FontSize[ = value%]

Remarks

The default value for the FontSize property is determined by your system settings. To change the default, specify the size of the font in points.

The maximum value for the FontSize property is 2048 points.

This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property. Before specifying the font size, specify the cell or cells to which to apply the size, as described in Using Column and Row Properties. Then set the font size.

Note: When you set fonts, you are setting properties of the Font object. For more information about the Font object, see Font Object Settings.

Available fonts vary according to your system configuration, display devices, and printing devices. Font-related properties can be set only to values for which actual fonts exist.

If you use the FontSize property to retrieve the font size for a block of cells that do not all use the same font size, the font size used in the active cell is returned.

Notes:

In general, you should change the FontName property before you set size and style attributes with the FontSize, FontBold, FontItalic, FontStrikethru, and FontUnderline properties. However, when you set TrueType fonts to smaller than 8 points, you should set the point size with the FontSize property, then set the FontName property, and then set the size again with the FontSize property. The Windows environment uses a different font for TrueType fonts that are smaller than 8 points.
The method for accessing the Font properties varies depending on your development environment. In some environments, such as Visual Basic 4.0, you must double-click the Font property listed in the Properties window to access the Font dialog for setting font characteristics.

Visual Basic users can refer to the Visual Basic documentation for additional information about this property.

Spread Designer

Choose the Cell menu, then the Font menu, and then the Font tab, and then select an item from the Size drop-down list box in the Cell Settings dialog box.

Specify the portion of the sheet to which to apply the font size using the instructions in Selecting an Item in Spread Designer. Then use the combo box to specify the font size.

Data Type

Single

DLL Correspondence

SSGetFont, SSSetFont, SSSetFontRange functions

Spread 8.0 Documentation
FontSize Property
Support Options