Broken formatting in both exported CSV and Excel files since v4.6.1

[dmitry-borzov]

Plunkr:
http://plnkr.co/edit/7yFTvr1z35AzmlZjzDUF?p=preview

Expected result (as it worked until v4.4.6):
8.99
-13.09
51.45
-1,128.65

Actual result in CSV:
null9
#NAME?
null51
-null1,129

Actual result in Excel:
null9
-null13
null51
-null1,129

It looks like the bug was introduced in the following commit:
3207b29

The code in the commit changes filter parameters from
return $filter('currency')(value, "");
to
return $filter('currency')(value, null, null);
It gives wrong output.

[johnoscott]

anyone know if this is getting fixed ?

[johnoscott]

workaround is to override the broken default implementation by setting this in your grid options

grid.options = {
    // return raw call value without cellFilters being applied			
    exporterFieldCallback: function ( grid, row, col, value ) {
        return value;
   },...
}

[Neonchen]

Extending the workaround from @johnoscott you can just apply all cellFilters by yourself:

exporterFieldCallback: function ( grid, row, col, value ) {
        // example for a more advanced filter
        if(col.cellFilter === "date:\'dd.MM.yyyy\'") { 
            value = $filter('date')(value, 'dd.MM.yyyy')

        //every common filter like 'currency'
        } else if ( col.cellFilter !== "") {
           value = $filter(col.cellFilter)(value)
        }
        //all cols without filter just return the value
        return value;
}

[Cornchips007]

How are people not getting their build broken by the parameters not being found? I can replace grid with this.myGrid but row, col and value I'm just not sure about.

I'm using typescript but can type them as any.

Answer: Just add types to the parameters. e.g. (grid: uiGrid.IGridApi, row: uiGrid.IGridRow, col: uiGrid.IGridColumn, input: any)

[mportuga]

should be fixed by https://github.com/angular-ui/ui-grid/pull/7154/files