I need to set all columns to #.### I enabled the auto format and tried to set each column.format but its not working. Also when I edit a cell to 9.0000000000 it puts 9... in my cell. I need a way to set my cells to a fixed format, is that possible?
This works for me:
{ headerText:"Est Price($)", key: "EstUnitPrice", dataType: "number", format: "########.##", width: "60" },
Don't know about autoFormat, I have never used that.
I think my issue is I have to set it after the data is loaded. So I use this approach
$( INSTANCE.gridIDMap.option( "columns" ) )[c].format = "#.000";
basically meaning. fin the grid instance and get all columns, then set the format filed. This is in a loop of course c being the column.
auto format works buts I need more control.