Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by John on May 06, 2009 04:59
open dhtmlx forum
Math formula calculations in Grid.

DHTMLX Grid : calculating cell values on the fly.

sample XML:
ColTypes:
<column width="20" type="currency[=c2+c3]" sort="na"></column>
<column width="20" type="currency[=c2/c3]" sort="na"></column>
<column width="20" type="currency" sort="na"></column>
<column width="20" type="currency" sort="na"></column>

currency is my custom defined cell type.

Cell Values:
<cell></cell>
<cell></cell>
<cell>100</cell>
<cell>10</cell>

1st and 2nd cell values are not calculating on the fly. It's showing blank. It was supported in grid 1.5 version. If i changed the order of derived cells(kept as last columns in grid), it's working fine.
Answer posted by dhxSupport on May 06, 2009 06:00
This issue is not reproduced at the latest dhtmlxGrid verstion (2.1). Please contact support@dhtmlx.com and provide you ref. ID and we will send you example.
Answer posted on May 06, 2009 20:58
I wrote a mail to support@dhtmlx.com and provided our ref Id. But they didn't reply me yet. Can you please tell me, how can i get the patch for this issue? 
It's urgent. Need to fix the issue as soon as possible.
Answer posted by dhxSupport on May 07, 2009 05:24
We have tested this functionality at the dthmlxGrid ver 2.0 and issue didn't appear. You will receive sample by email.