Messy code when exporting to csv file

[derbySoft]

We are having some problem when exporting table content to csv. In the content, there are some special characters such as '∞'. There is no problem for the excel format but it turns to messy code in csv file.

Is there a way to fix it or a workaround to override the content? Thanks.

[paramvir]

The cell content can be overridden while export in column.render callback and use of properties column.exportRender and passing render: true to exportData() method.

Code: [Select]

column.render = function(ui){
  if(ui.Export){ //true while export.
     return "custom value";
  }
}

https://paramquery.com/pro/api#option-column-render

https://paramquery.com/pro/api#option-column-exportRender

https://paramquery.com/pro/api#method-exportData