Export data to excel from table does not maintain custom format defined at script level/expression/measure when number formatting sets to AUTO

Andre_Sostizzo — Tue, 10 May 2022 19:23:50 GMT

When exporting data to Excel, the data format is Excel does not match the one defined in the script/expression/measure. Number formatting is set to AUTO.

This is working as designed.

To vote on reviewing the behaviour, see Keep formatting on Excel Export for an idea logged to maintain formatting.

Example:

1. Load below INLINE data in Qlik Sense application and reload

LOAD * Inline
[
Country,Sales
India, 200000
USA,300000
AUS, 400000
NEWZ, 250000
];

2. Create a table with expression by defining custom format and setting number formatting to AUTO.

NUM(Sum(Sales),'###,#0.0 $')

Please note: The same issue will occur if the number formatting has been set to custom or measure expression.

3. Export data to excel:

Environment:

Re: Export data to excel from table does not maintain custom format defined at script level/expression/measure when number formatting sets to AUTO

shlomoh — Mon, 04 Oct 2021 18:18:07 GMT

Excel export formatting can be achieved using the following extension for QS

https://logiexport.logsys.co.il/documentation/

https://logiexport.logsys.co.il/articles/how-to-easily-control-the-values-formatting/

article Export data to excel from table does not maintain custom format defined at script level/expression/measure when number formatting sets to AUTO in Official Support Articles

Export data to excel from table does not maintain custom format defined at script level/expression/measure when number formatting sets to AUTO

Example:

Re: Export data to excel from table does not maintain custom format defined at script level/expression/measure when number formatting sets to AUTO