Null values do not default to (blank) in exported CSV file

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)”
                            }
                        }
                    },

 

3 answers

Public
Dmytro Zvazhii Flexmonster 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

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

Public
Dmytro Zvazhii Flexmonster 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

Please login or Register to Submit Answer