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.
Syncfusion Feedback

formula problem

Thread ID:

Created:

Updated:

Platform:

Replies:

16479 Jul 16,2004 02:07 AM UTC Jul 18,2004 08:04 PM UTC Windows Forms 5
loading
Tags: GridControl
seth
Asked On July 16, 2004 02:07 AM UTC

Hello, I''m testing the grid (v2.x i believe), using the included sample Essential Grid Formula Support. Suppose the following values entered into this demo: B126: 500 C126: 0.03 D126: 0.90 I attempt to enter a formula: =B126*POW((C126+1),2) I get: bad index or invalid expression etc Why do I get this? If I do individual pieces of the expression, it works, just not all together. Second question. Also, I''m looking for a Class Reference for the grid, is this available with the purchased version or somewhere in the documentation I''m missing? I see mention of it in the documentation in User''s Guide > Introducing Essential Grid > Resources > Class Reference, but can''t find this. Probably something obvious. Thanks...

Administrator [Syncfusion]
Replied On July 16, 2004 05:47 AM UTC

I think it is the extra set of parens around the C26+1 that is causing the problem. We will get this corrected in our code base in some manner. Normally, an extra set of parens does not really affect anything. But when used in the manner you have done around an arg in the Pow argument list, the argument is not being marked as a formula that needs computing, but instead is being treated as a value already computed because of the outside parens. Anyway, until we get this corrected, you can avoid the problem by not including the extra parens around the argument. This formula worked for me =B126*POW(C126+1,2)

Administrator [Syncfusion]
Replied On July 16, 2004 05:49 AM UTC

To see the class reference, inside VisStu, open up the Help Contents, and make sure the Filtered By is set to none. This should display the Syncfusion Class Reference and User Guide. In the other help displays like Index, also make sure Filtered By is set to none as well to include the Syncfusion Class Reference.

Seth
Replied On July 17, 2004 03:46 PM UTC

Thanks for the quick response. I can get the forumla working now without the parens; hopefully this can be fixed soon as some parameters of functions will need order of operations to be accurate. Next problem is, when I copy the formula to the next cell, and press F2 to edit (I have to press this twice for the edit cursor to come up... odd, but clicking on a cell brings the edit cursor right up), I change the Pow( C126+1,2) to Pow(C126+1,3) and press enter and I get ".. is not a valid value for Double." If I click Ok, then move cells with the arrow key, it calculates the value with the most recently entered forumla (Pow(..,3)), but still shows the old formula (Pow(..,2)) in the cell. Also, I turned all filters off in VisualStudio and I''m still not seeing the Class Reference. Even in the StartMenu, Class Reference, I get a blank help index and contents (w/ no filter). I installed the GridEvaluation 2.051.

Administrator [Syncfusion]
Replied On July 17, 2004 04:36 PM UTC

Have you set the CellValueType of that cell to a typeof(double)? If so, that would explain this problem. Cells of CellType "FormulaCell" cannot be set to double CellValueType. The reason is teh cell contains a text formula. So, try removing this setting if you have it. If this is not the problem, can you attach a smaple showing it? I could not see it in teh sample I tried. Regarding the classreference, so you only downloaded the Grid eval and not the full suite eveail. That may be why you cannot see the class reference. I will have to check with our install team on Monday to see if that is the case. You can look in the Program Files\Syncfusion\Essential Suite\2.0.5.1\Help folder, in the full install, there should be about 3 dozen help type files. Among them is RegNameSpace.bat which you can run to try to re-register the help and expose it in Visual Studio.

Administrator [Syncfusion]
Replied On July 18, 2004 08:04 PM UTC

The grid eval does not include the class reference. To get that, you would have to download and install the full suite evaluation.

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.

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

;