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

GridFormulaTag without a formula result

Thread ID:





69194 Oct 17,2007 11:46 PM UTC Oct 22,2007 12:18 AM UTC WinForms 2
Tags: GridControl
Ben Fraser
Asked On October 17, 2007 11:46 PM UTC


I am using 5.2 as a Virtual Grid. Every cell in my grid is a formula cell.

When I enter a cell reference as a formula i.e. =C11 my program falls into an infinite loop. The grid formula tag I am getting in SaveCellInfo has a parsed formula but no formula result: {GridFormulaTag(11,2) [ C11-> ]}. The grid continues sending me the same formula tag forever.

In my grid I see tags getting passed back to me with a parsed formula but an empty result for a number of different formulas but it always fills in the result on a subsequent call to SaveCellInfo. It is only bare cell references that have this effect. In particular =C11 + 1 and =1 + C11 both work fine.

I have been unable to reproduce this bug in a small sample so I cannot send you one. I know this makes things difficult. Have you perhaps come across something like this before?

Ben Fraser

Administrator [Syncfusion]
Replied On October 19, 2007 11:29 AM UTC

We have not seen this problem before.

If you have our source code, you could do a debug build of our libraries (using the BuildManager from the DashBoard) and step through the GetFormattedText method in the Syncfusion\Essential Studio\\Windows\Grid.Windows\Src\Extensions\Formulas\GridFormulaCell.cs as you leave this cell where you enter =C11. Normally, the formulaTag is created and populated in this method as you complete editing a cell.

Some other things you might check.

Are you providing the FormulaTag with just the parsed formula in QueryStyleInfo? If you are not doing this (and thus always providing an empty FormulaTag), this might explain why the engine never gets beyond parsing.

You could try explicitly and setting the value in your SaveCellInfo when you get a FormulaTag that only has a parsed result to see if this will avoid the recursion. You can do this by calling engine.ComputedValue(parsedFormula).

I assume these are not circular calls. Ie, you are not entering =C11 in the C11 cell. Or, C11 does not reference the cell where you type the =C11. Correct?

Ben Fraser
Replied On October 22, 2007 12:18 AM UTC

Hi Clay,

Thanks for your help. I've tracked down the reason for the bug using your advise. I'll lodge an incident with a sample in direct track shortly.



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

or the page will be automatically redirected to 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