POWER CHART Problems EXPORTING data to csv file

[MG3]

I have a feeling that this issue is flipped and the values are automatically formatted in the Ignition DB Query Browser. For example, I just replicated your issue (using simulated tags) and looking at raw the CSV, I get values like:

1738063481806,-49.25258255004883

But when I look in the DB Query Browser, they are nicely rounded.

I did just have a look and tried some different properties on the chart to try and find a quick easy solution (Ignition based solution) but unfortunately I couldn't find one.

Until someone from IA replies the only things I can think of would be to format / transform the tag values before they are stored in history OR set the column format in Excel (as they are just really long floats) - formatting in Excel has been mentioned as a solution before:

Exporting Large Numbers

I have a client who uses Ignition to historize the discharge data and generate their reports for the city/county. As part of their report they require a exported CSV file of the data used to generate the report. Well they have just turned over 10M gallons on their totalizer and now when opening the CSV file Excel had decided to round the number to 1.00E+07 dropping any fractional numbers and whole numbers that became fractional in the rounding to E+7. The data displaying in the Vision Table loo…