I want to replace zero with hypher in data grid

[RJ]

Hi!

I want to replace zeros' in grid with hyphen.

[Pavithra Subramaniyam]

Hi RJ,

Thanks for contacting Syncfusion support.

You can achieve your requirement by using the “valueAccessor” function, which provides the option for modifying the cell display value. Please refer to the below code example and documentation link for more information.

 

@{ 

    var valueAccessor = "valueAccessorFn";

}

 

<ejs-grid id="Grid" dataSource="@ViewBag.DataSource" height="280">

    <e-grid-columns>

        <e-grid-column field="Freight" valueAccessor="valueAccessor" width="150"></e-grid-column> 

        .   .   .

    </e-grid-columns>

</ejs-grid>

 

<script>

    function valueAccessorFn(field, data, column){

        var value = data[field]

        if (data['Freight'] == 0) {

            value =  '_';

        }

        return value;

    }

</script>

 

 

https://ej2.syncfusion.com/aspnetcore/documentation/grid/columns/columns#valueaccessor

Please get back to us if you need further information.

Regards,

Pavithra S

[RJ]

Thank you for solution, i applied it in my solution but zero value replaced with blank not hyphen 

Following code i used 

function valueAccessorFn(field, data, column) {

        var value = data[field]

        if (data['pendingPRQty'] == 0) {

        value = '_';

        }

        return value;

    }

[Pavithra Subramaniyam]

Hi RJ,

To validate further please share the below details which will be helpful for us to provide a better solution as early as possible.

1. Sample data for the “pendingPRQty” field
2. Column definition of the “pendingPRQty” field
3. Share an issue reproducible sample if possible