List of acceptable functions in formulas...

[Alex]

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]

1) I'm already found this list.

[haneefm]

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]

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]

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]

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]

Previos Doc120.zip is not correct.


Doc121.zip

[Administrator]

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]

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]

"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.