Huge data export to CSV loses decimal precision issue

[#1]

Hi Dears,

I have a straight table which may have over 70000 rows data.

And when I trigger function to export to excel, it will store as CSV format.

However, the question is, I set the number format to show 2 decimals in QV table which may have 8 decimals from datasource, when it goes to CSV file, loses decimal precision.

But, when I limit rows, maybe down to 20000, table will export as xls format and in full decimals.

I have attached the QV sample, please help me.

Thanks.

[swuehl]

Try to use an export to xlsx (edit: using a macro), which should be capable of handling more records.

[#3]

Can we export in full decimals in CSV in system function in QV?

We are not allowed to use macro in dashboard in normal.

[swuehl]

Or maybe try to export the table in this sample.

[#5]

thank you.

But we have over 30 expressions in a table like that, if each one I add a new column, it will double when user export it which is not so ideally.

And less than 65000, it works fine.

Can you have another solution.

[swuehl]

What about creating another table only for export?

Basically a copy of your original, with all number formats set to max precision.

Not the best idea from a usability point of view, but I have no idea how to change the CSV value format on export (without macros).