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 : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

List of acceptable functions in formulas...

Thread ID:

Created:

Updated:

Platform:

Replies:

63389 Jul 3,2007 03:51 PM UTC Jul 6,2007 02:07 PM UTC WinForms 9
loading
Tags: GridControl
Alex
Asked On July 3, 2007 03:51 PM UTC

Hello,
Would you please tell me:

1) Where can i get the full list of functions which i can use in CalcQuick (i.e. in formulas). I mean RAND() and so on.

2) Why RAND() is not working in expression like this "2 * RAND()". What should i do if i need using RAND() in expressions?

Alex
Replied On July 3, 2007 04:04 PM UTC

1) I'm already found this list.

haneefm [Syncfusion]
Replied On July 3, 2007 09:36 PM UTC

Hi Alex,

2)Why RAND() is not working in expression like this "2 * RAND()". What should i do if i need using RAND() in expressions?
>>>>>>>>>>>>>>>
RAND() formula is working fine with the attached sample.Could you please give me some more information regarding how to implement this issue in this sample?. I would really appreciate it if you could provide us a sample that exhibits this behavior. This will help us to analyse the issue further.

Sample : GridFormualRAND.zip

Best regards,
Haneef

Alex
Replied On July 3, 2007 10:06 PM UTC

Hello Haneef,
thanks for your previous help.

"RAND() formula is working fine with the attached sample".
NO, it's NOT! I'm using Syncfusion 5.1.0.51 and after i compiled and ran your example i had "invalid expression" in every cell.
That's what i'm talking about...
See the attached screen shot.

screen8.zip

haneefm [Syncfusion]
Replied On July 4, 2007 09:21 PM UTC

Hi Alex,

We have no reports of this problem, and have not seen it here. Attached ScreenShot clip formula cell value on my system which has 5.1.051 installed. Below is a screen shot.

Screenshot.zip

Please provide us more details to reproduce the issue. This will help us to analyse the issue further.

Best regards,
Haneef

Alex
Replied On July 5, 2007 09:19 AM UTC

At my work we're using ver 4.4.0.51. And we have the same result: invalid expression on different computers. At my home i'm using 5.1.0.51 and all the same. Is there any chance to resolve this problem.
I made the same style screen shot:

Doc120.zip

Alex
Replied On July 5, 2007 09:45 AM UTC

Previos Doc120.zip is not correct.


Doc121.zip

Administrator [Syncfusion]
Replied On July 5, 2007 07:12 PM UTC

I tried Haneef's sample using 4.4.0.51 and it did not show the problem for me either.

In your case, do you see any exceptions in the output window?

The only way I would know to proceed is to set up a GotoMeeting session so an engineer could access your system to see the error and try to debug it. To arrange this, you will have to submit a Direct Trac incident. It would also be helpful if you own the source code and have a debug build of our libraries available for use during the GoToMeeting session.

Administrator [Syncfusion]
Replied On July 5, 2007 07:20 PM UTC

Another sample you can check is the

Syncfusion\EssentialStudio\5.1.1.12\Windows\Grid.Windows\Samples\2.0\FormulaSupport\FormulaValueTest\CS

that we ship as part of the install.

It have a formula like

=Rand() * 100


Does this sample show the sample error?

Alex
Replied On July 6, 2007 02:07 PM UTC

"Does this sample show the sample error?"
I've checked this sample and yes, it does.

I'll say about settin up a GotoMeeting session to the boss. I don't know if he really needs it.

Anyway, thaks for support.

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

;