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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Allowing formulas to start with + or - as well as =

Thread ID:





64144 Jul 16,2007 12:52 AM UTC Jul 16,2007 05:32 PM UTC WinForms 1
Tags: GridControl
Ben Fraser
Asked On July 16, 2007 12:52 AM UTC

In Excel if the cell contents start with - or + the cell contents will be treated as a formula, in addition to cells starting with =.

I've tried setting the formulaChar to '\0' in the GridFormulaCellModel constructor to treat every cell as a formula as an attempt to get something like this to work, it doesn't. A & symbol in a normal string crashed the program outright.

Looking at the source the use of formulaChar looks widely dispersed meaning adding this sort of functionality would not be trivial.

Is there any way to hack together what I am trying to do here?


Administrator [Syncfusion]
Replied On July 16, 2007 05:32 PM UTC

We will have to modify our source to enable this functionality. We will setup a mechanism for you to derive GridFormulaEngine and allow you to override GridFormulaEngine.Parse. At that point, you could check the incoming potential formulastring, and if it is something that does not begin with = that you want to recognize as a formula, and if so, you can pre-pend an "=" to the string before calling the baseclass.

If you submit a Direct Trac support incident, we can notify you of when there is a daily build with this support in it.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon