We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Expresion in a cell

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

5 Replies

AD Administrator Syncfusion Team December 14, 2005 07:37 PM UTC

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.


AD Administrator Syncfusion Team December 14, 2005 08:41 PM UTC

Thanks, We are using 3.0.1.1. is ther a small sample for where i can look? Thanks,


AD Administrator Syncfusion Team December 14, 2005 09:13 PM UTC

You do the same thing except you use a CalcQuick object. http://www.syncfusion.com/Support/user/uploads/GDBG_Calculate_fb722948.zip


AD Administrator Syncfusion Team December 15, 2005 05:24 PM UTC

I Don''t see the Syncfusion.Calculate.CalcQuick. Is it a separate installation? Thanks,


AD Administrator Syncfusion Team December 15, 2005 05:45 PM UTC

Yes. It is part of Essential Suite.

Loader.
Live Chat Icon For mobile
Up arrow icon