I am trying to get the cellsformat to work with no success. My number from the database might be something like this “11.01243”. Here is my code snippet… The grid displays the number in the orginial format even with the cellformat code. I am finding this with all the formatters and the $ or % sign does not display. Am I using this correctly? Do I have to format the sql results first? Please help me understand cellsformat.
{ text: ‘Cost’, dataField: ‘Cost’, width: 80, editable: false, filterable: false, cellsalign: ‘right’, cellsformat: ‘C2’ },