TdxSpreadSheetNumberFormatCategory Enum

Enumerates the cell value formatting variants.

Declaration

TdxSpreadSheetNumberFormatCategory = (
    nfcGeneral,
    nfcNumber,
    nfcCurrency,
    nfcAccounting,
    nfcDate,
    nfcTime,
    nfcPercentage,
    nfcFraction,
    nfcScientific,
    nfcText,
    nfcCustom
);

Members

Name
nfcGeneral
nfcNumber
nfcCurrency
nfcAccounting
nfcDate
nfcTime
nfcPercentage
nfcFraction
nfcScientific
nfcText
nfcCustom

Remarks

Options include:

Value	Description	Example
nfcGeneral	The general number format category has no specific number format.	891
nfcNumber	The number format is used for general display of numbers. Both the nfcCurrency and nfcAccounting categories offer specialized formatting for monetary values.	891.00
nfcCurrency	The currency formats are used for general monetary values. Use the nfcAccounting formats to align decimal points in a column.	$891
nfcAccounting	The accounting formats line up the currency symbols and decimal points in a column.	$ 891.00
nfcDate	Date formats display date and time serial numbers as date values. Date formats that begin with an asterisk (*) respond to changes in regional date and time settings that are specified for the operation system.	6/9/1902
nfcTime	Time formats display date and time serial numbers as date values.	12:00 AM
nfcPercentage	Percentage formats multiply the cell value by 100 and display the result with a percent symbol.	89100.00%
nfcFraction	The fraction formats display the cell value as the common fraction.	891
nfcScientific	The scientific format displays the cell value in a standard (exponential) form. The Spreadsheet control displays a number to the right of the “E” that corresponds to the number of positions by which the decimal point is moved.	8.91E+02
nfcText	Text format treats the cell value as text even when there is a numeric value. The cell content is displayed exactly as entered.	891
nfcCustom	With the nfcCustom format, you can type the number format code, using one of the existing codes as a starting point. Date formats that begin with an asterisk (*) respond to changes in regional date and time settings that are specified for the operation system.	891.0E+0