Wrong type in export grid to excel and csv

Raul Castro asked on November 20, 2018

When export the grid to excel or csv this take the numeric values as string, not as numbers, when we try to summarize in excel manually has to remove the characters, comma, dot and convert to numeric.
In the demos page can observate this, export and the money values has for example $1,000,000.00

2 answers

Public
Tanya Gryshko Flexmonster November 21, 2018

Hello, Raul,
Thank you for writing to us.
When exporting to Excel, the numeric values should be exported as numbers. Our development team will fix this and release an update on December the 17th.
When you export the content from the grid as CSV, each member is surrounded with double quotes to ensure the correctness of the data. For example, the value “Bikes, Cars” will be misinterpreted if left simply as Bikes, Cars. The data from CSV export is intended to be used in Excel or Google Spreadsheets and the main concern is to display it the same way it was displayed in Flexmonster.
Please let me know in case of any other questions.
Regards,
Tanya

Public
Tanya Gryshko Flexmonster December 19, 2018

Hello, Raul,
We are glad to inform you that the new version of the component is already available on our website.
The issue with exporting numeric data to Excel was fixed.
You are welcome to update the component.
Regards,
Tanya

Please login or Register to Submit Answer