Hi,
I have an ultragrid that takes a datatable as datasource.
this datatable contains columns of type decimal (6 decimal places)
Is there a way of displaying custom decimal places and taking into consideration that the value will stay with 6 decimal places in order to have correct results when sorting and filtering
for example:
the table 1 is the original value.. i want to show it as table 2, but if sorting or filtering or conditional formatting keep the average of ID 178 greater than the average of ID182
thx
You can set the Format property on the Column to 00.00. You can do that in both design time and runtime.
I got a similar problem. the datasource only has 2 decimals (for all money columns), while the grid shows 4
The problem is, the columns always change names (dynamic) , we recycle the grid for everything.
is there a way to set default decimal to 2 for entire grid
No, but you could handle the InitializeLayout event and loop through the columns and set the Format on any column that needs it. Maybe you could base it on the column.DataType, if you don't know the name.