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

REGD---Formula Cell

Hi Clay, "=9/-3" entered in the formula cell gives an exception is there any way of allowing execution of this formula with out having to put the negative numbers with in parenthesis like "=9/(-3)". Regards, Manohar B.

4 Replies

AD Administrator Syncfusion Team March 11, 2005 08:01 AM

This is bug. It has been entered in our open issues data base as defect#99. It has been corrected in our code base, and the fix will be in the next release. I do not know when this release will hit, but it is being worked on.


MA manohar March 11, 2005 08:08 AM

Hi Clay, Can you just let us know the piece of code that we need to change so that it works as per our requirement if possible. Regards Manohar


AD Administrator Syncfusion Team March 11, 2005 08:39 AM

In \Syncfusion\Essential Suite\3.0.1.0\Windows\Grid.Windows\Src\Extensions\Formulas\GridFormulaCell.cs, search for this comment. //Mark unary minus with u-token. It is in one of the ParseSimple overloads. The 2nd line under this comment should be replaced with this line. text = sb.Replace(",-",",u").Replace("[-","[u").Replace("=-","=u").Replace(">-",">u").Replace("<-","


AD Administrator Syncfusion Team March 11, 2005 08:51 AM

Looks like the web page is not displaying the pasted code properly, probably due to HTML tags. Anyway, the line that is present in the 3.0.1.0 code base should end like this:
.Replace("/-","/u").Replace("*-","*u").Replace("+-","+u").Replace("--","-u").ToString();

Loader.
Live Chat Icon For mobile
Up arrow icon