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

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

 

4 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

Public
Ian Sadovy Flexmonster 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

Please login or Register to Submit Answer