Calculated Columns (Column Expressions)

[Chakkrit]

Dim col = New GridViewDecimalColumn()
col.Name = "Calculated Column"
col.HeaderText = "Order value"
RadGridView1.Columns.Add(col)
RadGridView1.Columns("Calculated Column").Expression = "UnitsOnOrder * UnitPrice"
'=========================================================
I want to use Function math.round("UnitsOnOrder * UnitPrice",3) in Column("Calculated Column").Expression
How can i  calculate ?

Thank you. 

[Richard Slade]

Hello,

As far as I'm aware, you cannot use a Round function in this way. The RadGridView takes it's implementation of the expression from the standard Microsoft version (see this link) which does not contain a Round function.

The CellFormatting event and ViewCellFormatting event fires for these cells, but assigning a new value to these cells does not affect the outcome. Similarly, the CellValueChanged event contains arguments that have the cell value, but these are read only.

Regards,
Richard

[Daniel]

This is rather ugly way how to do the rounding.

RadGridView1.Columns["CalculatedColumn"].Expression =  "CONVERT(Column1 - Column2, 'System.Int32') + ',' + (CONVERT(100 * (Column1 - Column2), 'System.Int32') - (100 * CONVERT(Column1 - Column2, 'System.Int32')))";

Colon is used as decimal separator and it's rounded to 2 digits. It's actually not rounding, rather trimming, but better then nothing. And it works.

Daniel