Hello Infragistics ,
I have a formula ((([Usable_Volume]/[Current_Volume])*100)) in a cell and the formula is calculating fine. I don't want a long decimal value instead I want it short say 25.6. How can I do that using Web Cal Manager. Is there any function available in Infragistics grid for such process
Hi,
I solved this issue by setting the following for the WebGrid Column that contains the data I want to format. In the InitializeLayout section for your WebGrid, set the Format of the column to ###,###,##0.0 (if you want thousands sepaerators) or ########0.0 (if you don't want thousands separator). I also set the DataType of the Column to "System.Double". The resulting code would look something like this:
{
c.Format = "###,###,##0.0";
c.CellStyle.HorizontalAlign =
}
On top of this, I formatted my actual values during DataBinding using Math.Round(Convert.ToDouble(value),1).
I hope this helps you are anyone else who has these same issues.
Mark