TExportCellCustomNumber

TExportCellTExportCellCustomNumber

Description

TExportCellCustomNumber is the abstract cell class for all number (number/percent/currency/date/time cells). Don't use it directly, use child classes instead.

Properties

NameTypeDescription
ValueDoubleNumber value of the cell.
EmptyIfZeroBooleanTrue: a zero value won't be written to the sheet (instead an empty cell will be written).

TExportCellNumber

TExportCellTExportCellCustomNumberTExportCellNumber

Description

Use TExportCellNumber for number (float and integer) cells.

Properties

NameTypeDescription
ValueDoubleNumber value of the cell.
FormatTDecimalPlacesDecimal places in the number. This is a deprecated property. Use DecimalPlaces instead.
DecimalPlacesTDecimalPlacesDecimal places in the number.
IntegerDigitsTIntegerDigitsInteger digits of the number.
Example: IntegerDigits = 8 formats the number 123 as 00000123
NegativeRedBooleanDetermines if negative numbers appear red.
ThousandSepBooleanSwitches on the thousand separator.

TExportCellPercent

TExportCellTExportCellCustomNumberTExportCellNumberTExportCellPercent

Description

Use TExportCellPercent for percent (float and integer) cells.

Properties

NameTypeDescription
Please see TExportCellNumber above for inherited properties.

TExportCellCurrency

TExportCellTExportCellCustomNumberTExportCellNumberTExportCellCurrency

Description

Use TExportCellCurrency for currency (float and integer) cells.

Properties

NameTypeDescription
CurrencyStrOWideStringCurrency string. Use , EUR, $, USD etc.
CurrencyPosTExportCellCurrencyPositionCurrency position:
  • ecpBefore: Currency string appears before the number.
    E.g. € 1.500,00.
  • ecpBeforeFill: Currency string appears at the very left side of the cell, number at very right side.
    E.g. €     1.500,00.
  • ecpAfter: Currency string appears after the number.
    E.g. 1.500,00 €.
Please see TExportCellNumber above for inherited properties.

TExportCellScientific

TExportCellTExportCellCustomNumberTExportCellNumberTExportCellScientific

Description

Use TExportCellScientific for scientific (exponential) cells.

Properties

NameTypeDescription
ExponentDigitsTExponentDigits (1..3) Defines the number of digits in the exponent.
E.g. 2 = 1,51E+01; 1 = 1,51E+1.
Please see TExportCellNumber above for inherited properties.
Categories