Export to Excel does not show values

[nenadvukovic]

Greetings,

Recently we have upgraded to QV April 2020 and have noticed that values exported into Excel are not visible or they are rounded. Has anybody experienced that and what was the solution? Thanks

Measurement format:

QV Table:

Export to Excel:

1. No value visible

2. Values rounded

[fosuzuki]

Hi,

it should follow the formatting from the table in the qvw. What is the formatting option in the table?

[nenadvukovic]

Hi,

I've provided the formatting part in QV in my initial post.

Also, note that this was working perfectly before the QV upgrade. We were for 6 years on 11.20 SR12 and, unfortunately,  had to upgrade because of the Windows Server version.

[fosuzuki]

The formatting option you posted was from the Document Properties panel, right?

What is the source object you are exporting from? A straight table?

[nenadvukovic]

Yes.

The source table is a Table Box type of table.

Could that be a reason? I usually do not use plan tables but this is one of the very old apps developed by someone else.

Thanks

[Or · Accepted solution]

Qlik entirely changed the way numeric exports work in April 2020 (it's listed under "bug fixes" in the release notes, oddly enough). It seems one of these changes may have broken the exporting of any values formatted as Number (X Precision), which will always be exported as an integer (format is e.g. #,### for precision 4). You can work around this to some extent, by using a fixed to / X decimals, which does export correctly.

I would have to call this a bug - it's clearly not exported as it should be. Qlik seems to be reading #### as "Up to four digits, before or after the decimal separator", while Excel reads it as "Up to four digits, before the decimal separator". 

[nenadvukovic]

Fully agree this is a bug, as it worked just normal in previous versions. I've asked our account manager to report it to Qlik. Thanks