Why GridCalculatedColumn does not display decimal numbers?

[tomekm]

Why GridCalculatedColumn does not display decimal numbers?

<telerik:GridCalculatedColumn DataFields="CustomersActivated,Customers" Expression="({0}/{1})*100" DataType="System.Double" DataFormatString="{0:f}" telerik:GridCalculatedColumn/>

For values like 1 and 300 grid displays "0.00" instead of "0.33"

[Martin]

Hello Rychu,

I tried the following code and it ran as expected on my side:

Markup:

<telerik:RadScriptManager ID="RadScriptManager1" runat="server" />
<telerik:RadGrid ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource" AutoGenerateColumns="false">
    <MasterTableView>
        <Columns>
         <telerik:GridBoundColumn DataField="Numerator" HeaderText="Numerator" UniqueName="Numerator">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="Denominator" HeaderText="Denominator" UniqueName="Denominator">
            </telerik:GridBoundColumn>
            <telerik:GridCalculatedColumn DataFields="Numerator,Denominator" Expression="({0}/{1})*100"
                DataType="System.Double" DataFormatString="{0:f}" HeaderText="Result">
            </telerik:GridCalculatedColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

Code behind:

protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
    DataTable table = new DataTable();
    table.Columns.Add("Numerator", typeof(double));
    table.Columns.Add("Denominator", typeof(int));
    for (int i = 0; i < 10; i++)
    {
        table.Rows.Add(i, (i*i)+1);
    }
    RadGrid1.DataSource = table;
}

I hope this helps,
Martin
the Telerik team

[tomekm]

Please close the ticket - my fault I did not cast int to double.