TdxSpreadSheetNumberFormatCategory Enum
Enumerates the cell value formatting variants.
#Declaration
TdxSpreadSheetNumberFormatCategory = (
nfcGeneral,
nfcNumber,
nfcCurrency,
nfcAccounting,
nfcDate,
nfcTime,
nfcPercentage,
nfcFraction,
nfcScientific,
nfcText,
nfcCustom
);
#Members
Name |
---|
nfc
|
nfc
|
nfc
|
nfc
|
nfc
|
nfc
|
nfc
|
nfc
|
nfc
|
nfc
|
nfc
|
#Remarks
Options include:
Value | Description | Example |
---|---|---|
nfc | The general number format category has no specific number format. | 891 |
nfc | The number format is used for general display of numbers. Both the | 891. |
nfc | The currency formats are used for general monetary values. Use the | $891 |
nfc | The accounting formats line up the | $ 891. |
nfc | Date formats display date and | 6/9/1902 |
nfc | Time formats display | 12:00 AM |
nfc | Percentage formats multiply the cell value by 100 and display the result with a percent symbol. | 89100. |
nfc | The fraction formats display the cell value as the common fraction. | 891 |
nfc | 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. |
nfc | Text format treats the cell value as text even when there is a numeric value. The cell content is displayed exactly as entered. | 891 |
nfc | With the nfc | 891. |