REGD---Formula Cell

[manohar]

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.

[Administrator]

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.

[manohar]

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

[Administrator]

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("<-","
            

[Administrator]

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();