Spread 8.0 Documentation
SSSetTypePercentEx Function
Support Options
DLL Reference > DLL Functions > SSSetTypePercentEx Function

Glossary Item Box

SSSetTypePercentEx Function


See Also    ActiveX

Applies To

fpSpread DLL control

Description

Sets the style, number of decimal places, minimum, maximum, format, and spin button characteristics for percent cells.

Syntax

C

LPSS_CELLTYPE SSSetTypePercentEx(HWND hWnd, LPSS_CELLTYPE lpCellType, long lStyle, BYTE Right, double Min, double Max, LPTSTR lpszDecimal, BYTE bLeadingZero, BYTE bNegStyle, BYTE fSpin, BYTE fSpinWrap, double SpinInc);

C++

LPSS_CELLTYPE TSpread::SetTypePercentEx(LPSS_CELLTYPE lpCellType, long Style, BYTE Right, double Min, double Max, LPTSTR lpszDecimal, BYTE bLeadingZero, BYTE bNegStyle, BYTE fSpin, BYTE fSpinWrap, double SpinInc);

Parameters

The following parameters are available:

Parameter Description
hWnd Window handle of the fpSpread control
lpCellType Pointer to structure to contain cell type information
Style Percent style
Use the (|) OR operator and combine the following values as indicated:
Constant Description
SSS_ELLIPSES Displays an ellipsis (...) when text is too long to fit in the cell
SSS_NEGRED Displays negative numbers as red
Use one of the following values:
SSS_ALIGN_TOP (Default) Aligns text at the top of cells
SSS_ALIGN_BOTTOM Aligns text at the bottom of cells
SSS_ALIGN_VCENTER Centers text vertically within the cell
Use one of the following values:
SSS_ALIGN_LEFT (Default) Aligns text to the left in the cell
SSS_ALIGN_RIGHT Aligns text to the right in the cell
SSS_ALIGN_CENTER Centers text horizontally within the cell
Use one of the following values:
SSS_TEXTORIENT_VERT_LTR Displays text vertically in the cell and wraps from left to right
SSS_TEXTORIENT_DOWN Rotates text 90 degrees (to "3 o'clock")
SSS_TEXTORIENT_UP Rotates text 270 degrees (to "9 o'clock")
SSS_TEXTORIENT_INVERT Rotates text 180 degrees (to "6 o'clock")
SSS_TEXTORIENT_VERT_RTL Displays text vertically in the cell and wraps from right to left
Right Number of digits to right of decimal place
Min Minimum valid percent value
The smallest value allowed is –99,999,999,999,999.
Max Maximum valid percent value
The largest value allowed is 99,999,999,999,999
lpszDecimal Decimal character
bLeadingZero Specifies whether a leading zero displays
Can be one of the following values:
Constant Description
SS_LEADINGZERO_INTL Uses the regional setting for Number Format in the Windows Control Panel
SS_LEADINGZERO_NO Removes the leading zero
SS_LEADINGZERO_YES Displays the leading zero
bNegStyle Format for negative percent values
Can be one of the following values:
Constant Description
SS_PERCENT_NEGSTYLE_INTL Uses the regional Number Format setting in the Windows Control Panel
SS_PERCENT_NEGSTYLE_1 (1.1%)
SS_PERCENT_NEGSTYLE_2 –1.1%
SS_PERCENT_NEGSTYLE_3 1.1–%
SS_PERCENT_NEGSTYLE_4 1.1%–
SS_PERCENT_NEGSTYLE_5 –1.1 %
SS_PERCENT_NEGSTYLE_6 1.1 %–
SS_PERCENT_NEGSTYLE_7 1.1– %
SS_PERCENT_NEGSTYLE_8 (1.1 %)
fSpin Displays spin button in cell
(The spin button is displayed only if edit mode is on.)
fSpinWrap Set to TRUE to wrap the value of the spin button when the maximum or minimum values are reached
SpinInc Amount spin button increments value

Remarks

This function is applied to the current sheet setting unless you first call the SSSetSheet function to specify the sheet for which you are calling this function.

This function sets a percent cell type that lets you customize the percent format and allows a spin button to be placed within the percent cell. Use this function if you want to customize the percent format and display a spin button in a percent cell; otherwise, use the SSSetTypePercent function.

This function initializes a structure of the specified type (SS_CELLTYPE). You can use this structure to set an individual cell or block of cells using the SSSetCellType or SSSetCellTypeRange functions.

The control uses the regional Number Decimal Symbol setting in the Windows Control Panel. If you want to specify a different decimal character, use the lpszDecimal parameter.

Notes:
  • Do not use a plus sign ("+"), a minus sign ("–"), or a space as a decimal character.
  • The control does not recognize changes made to the regional Windows settings until you restart your development environment or your application (or perform any operation that unloads and reloads the current control files). For more information about regional settings and Windows operating environments, see Variations in Windows Regional Settings or Options.

The value specified for the Max parameter is the maximum value the control allows the user to type or paste into the cell. If the user tries to type or paste a value greater than the value specified, the control beeps (unless you have called the SSSetBool function and set the SSB_NOBEEP boolean to TRUE) and the user is not allowed to type the value.

Values larger than the specified maximum value can still be added to the cell in code at run time; when they are added in code, the value is allowed in the cell. However, the control adjusts those values to be zero the next time the cell is in edit mode. If the cell leaves edit mode with no change to the value, though, the control changes the value back to the invalid value.

The value specified for the Min parameter is the minimum valid value for the cell. When the user types or pastes a value smaller than the minimum value into the cell, the control sends the SSN_INVALIDDATA message when the cell leaves edit mode, but the user's value is allowed in the cell. Values smaller than the specified minimum value can also be added to the cell in code at run time; when they are added in code, the value is allowed in the cell and the control does not send the SSN_INVALIDDATA message.

Return Value

Pointer to the SS_CELLTYPE structure, or NULL if any of the parameters are invalid.

See Also

Variations in Windows Regional Settings or Options
Formatting a Percent Cell
Displaying a Spin Button in a Percent Cell

SSSetBool, SSSetCellType, SSSetCellTypeRange, SSSetSheet, SSSetTypePercent functions

SSN_INVALIDDATA message

SS_CELLTYPE structure

ActiveX Correspondence

TypePercentDecimal, TypePercentDecPlaces, TypePercentMax, TypePercentMin, TypePercentNegStyle properties

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