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.
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.
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)”.
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.
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.