TdxSpreadSheetNumberFormatCategory Enum

Enumerates the cell value formatting variants.

Declaration

delphi

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