asked on October 22, 2018
Null values do not default to (blank) in exported CSV file.
In CSV it shows it as empty cell. I tried using localization as below, but it still doesn't work in CSV. It works in grid.
global: {
localization: {
grid: {
blankMember: "(blank)"
}
}
},
⋅ October 22, 2018
Hello Ankush,
Thank you for writing. The described above approach works fine when it is about string members.
In case you need to have a custom caption for the null numeric values, please follow our number formatting article: https://www.flexmonster.com/doc/number-formatting/.
Let us know if everything works fine for you.
Regards,
Dmytro
⋅ October 23, 2018
Hi Dmytro,
Please check this JS fiddle http://jsfiddle.net/trLb40ao/21/ .
Sector is a string, and in grid it is shown as "(blank)" in first row, but when you export to CSV, it shows "" value for sector.
Whereas in Excel and PDF it shows as "(blank)".
⋅ October 23, 2018
Hello Ankush,
Thank you for the clarification. Yes, you are right, there is some inconsistency there.
Our dev team will add the necessary fix on ETA Nov19.
We will keep you updated.
Regards,
Dmytro
⋅ November 22, 2018
Hello Ankush,
We are glad to inform you that version 2.6.8 is already released and it contains the fix for CSV export.
You are welcome to update.
Regards,
Ian
