Excel Export: Formatting Numerical Values

[combit_Webmaster (combit Team)]

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”.

Related articles:

Excel Export: Working With the Export Result

Valid from List & Label 10 The Excel export module offers two modes: a full layout export and a pure data export from the table object. List & Label offers two ways to influence the export type: 1. Using the Excel export's option dialog You'll get into this dialog by choosing 'Microsoft Excel Format' in the print options dialog and then clicking on the button on the right hand side of the format combo box. On the 'Output' tab you can choose to export only table data. You can also choose to igno…