Hi,

I am sharing this workaround, which involves handling the cellExported client side event so that every community member can use it until this behavior is fixed in the next service release.

Basically, if a cell which display text uses the formatter function has just been exported we find the proper value and manually write it to the corresponding excel cell. Please see the attached sample for reference and let me know if you have any further questions on the matter.

     cellExported: function (sender, args) {
      if(args.columnKey == "ObjectCol" && args.xlRow.index() > 0) {
       var gridRowIndex = args.xlRow.index() - 1;
       
       var currentPage = $("#grid").igGridPaging("pageIndex") + 1;
       var pageSize = $("#grid").igGridPaging("pageSize");

       if ((currentPage == 1 && gridRowIndex >= pageSize) ||
        ((gridRowIndex < ((pageSize * currentPage) - pageSize)
        || gridRowIndex >= (pageSize * currentPage))))
       {
        var dataRow = $("#grid").igGrid().data("igGrid").dataSource._data[gridRowIndex]; // this is the current row corresponding record from the dataSource
        var cellValue = $("#grid").igGrid("option", "columns")[args.columnIndex].formatter(dataRow.ObjectCol); // this is the formatted cell text
        args.xlRow.setCellValue(args.columnIndex, cellValue); // write this value to the corresponding cell in the excel worksheet
       }
      }
     }

Hello,

I'm just following up to see if you need any further assistance with this issue. If so please let me know.