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.

Enter a formula in a FormulaCell, it will prompts need some parameters.

Thread ID:

Created:

Updated:

Platform:

Replies:

118802 Apr 10,2015 04:49 AM Apr 14,2015 08:54 AM WPF 3
loading
Tags: GridControl
Mark Li
Asked On April 10, 2015 04:49 AM

First I Change Region and Language settings to French(Canada),  Run my program and Enter a formula ("IF((A1>A2),A1,A2)") in a FormulaCell, Click the Enter Button it show a messageBox "requires 3 arguments". Can you tell me how to get the correct results?

Regards,
Mark Li

Kanimozhi Bharathi [Syncfusion]
Replied On April 13, 2015 08:12 AM

HiMark Li,

Thank you for contacting Syncfusion support.

We have analyzed your query and this issue occurs because the argument separator will be varied based on your Language and Region settings. So, you can overcome this issue by setting ParseArgumentSeparator of GridFormulaEngine as “,” like the following code snippet

Code snippet:



GridFormulaEngine.ParseArgumentSeparator = ',';

Please let us know if you have any queries

Thanks

Kanimozhi B


Mark Li
Replied On April 13, 2015 11:38 PM

Hi kanima,
Your reply to solve my problem, thanks! 
There was another issue, if I enter a Formula like "=IF ((A1-A2) <0,0,A1)", 
It will recognize the comma int the formula as a decimal point, then it show a message that  "number contains 2decimal points". I tried to set"GridFormulaEngine.ParseDecimalSeparator = '.'", 
but it does not work.Can you give me some suggestions to solve the problem?

Kanimozhi Bharathi [Syncfusion]
Replied On April 14, 2015 08:54 AM

HiMark Li,

We have analyzed your query and in French region language settings “,” is treated as decimal separator and “;” is treated as argument separator. So, you can overcome this issue by setting ParseDecimalSeparator of GridFormulaEngine as “.” and ParseArgumentSeparator of GridFormulaEngine as “,” like the following code snippet

Code snippet:

GridFormulaEngine.ParseArgumentSeparator = ',';

GridFormulaEngine.ParseDecimalSeparator = '.';

We have also prepared a sample for your clarification. Please find the sample link below.

Sample link: http://www.syncfusion.com/downloads/support/forum/118802/WpfApplication9_(3)476371596.zip

If the issue still persists at your side, please revert us by modifying the sample based on your application along with the replication procedure? This would be helpful for us to serve you.

Please let us know if you have any queries

Thanks

Kanimozhi B


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.

;