+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

Excel Export: Formatting Numerical Values

export
(combit Team) #1
Valid from List & Label 11
The formatting of numerical values in the Excel export is determined by the XLS.ConvertNumeric setting.

By default (XLS.ConvertNumeric=1) the formatting is set within the designer/project file. You can set the number of decimal places for all unformatted numerical values in the Project > Options dialog. If the number of decimal places is set to '2' here, all numerical values will have 2 decimals in the resulting Excel file as well.

If you'd like to prevent your numerical column from being formatted in this way, use the following switch:
LlXSetParameter(LL_LLX_EXTENSIONTYPE_EXPORT,"XLS","XLS.ConvertNumeric","2")


Now only those columns that have not been formatted explicitly by a function (ex. Str$(Price,0,0)) will be converted.

Alternatively you can choose to handle numbers like characters by setting XLS.ConvertNumeric to “0”.

Verwandte Artikel:

KBTE000655
IDKBTE000656 KBTE000656