Expresion in a cell

[Administrator]

I need help with the expression in a cell. I am using GDBG.

I have a grid that is displaying three columns.

First column is description.

Second Column is expression column.

Third column is result of expression in second column, readonly.

My question is,

Can I enter something like in second column ((10 * 400)/100 )?

How do I evaluate expression on tab out from the cell and store the result in third colum.

Please help.

Thanks,
VS

[Administrator]

If you are using version 3.3 or later, you can use a method in the GridFormulaEngine class to handle this in the CurrentCellAceptedChanged event. Here is a little sample.
http://www.syncfusion.com/Support/user/uploads/GDBG_Calculate_cf9add01.zip

If you are using an earlier version, this method was not exposed. One solution in that case is to do something similar, but use the Essential Calculate''s CalcQuick object to perform the parsing and computing.

[Administrator]

Thanks,

We are using 3.0.1.1.

is ther a small sample for where i can look?

Thanks,

[Administrator]

You do the same thing except you use a CalcQuick object.

http://www.syncfusion.com/Support/user/uploads/GDBG_Calculate_fb722948.zip

[Administrator]

I Don''t see the Syncfusion.Calculate.CalcQuick.

Is it a separate installation?

Thanks,

[Administrator]

Yes. It is part of Essential Suite.