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.
Unfortunately, activation email could not send to your email. Please try again.

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

Thread ID:

Created:

Updated:

Platform:

Replies:

64144 Jul 15,2007 08:52 PM Jul 16,2007 01:32 PM Windows Forms 1
loading
Tags: GridControl
Ben Fraser
Asked On July 15, 2007 08:52 PM

Hello,
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?

Thanks,
Ben

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

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.

CONFIRMATION

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.

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.

;