1. Home
  2. Forum
  3. WPF
  4. Problems with =IF Function

Problems with =IF Function

Hi @all!

I need to evaluate some logical functions in my App where i need a "true" or "false" als a result.
Now i did for testing purposes this here:

CalcQuickBase calcQuick = new CalcQuickBase();
var result = calcQuick.ParseAndCompute("=IF(\"False\" = \"True\" AND \"True\" = \"True\", \"True\", \"False\")");

But i don´t get the expected result = "False". Else i get the error "requires 3 Arguments" -> but i provide 3 arguments, don´t i?
I don´t see any error and checked the documentation and samples now for hours, but i didn´t find the error.

Could someone please help me with this?
Thanks very much

Greetings
Thomas

11 Replies
EM Elakkiya Muthukumarasamy Syncfusion Team March 29, 2018 10:17 AM UTC

Hi Thomas,  
 
Thanks for contacting Syncfusion support.  
 
We suspect that you have used the formula wrongly, since we have checked the same given formula with MS Excel, it also shows the error. Hence we have modified the formula as=IF(FALSE=TRUE&TRUE=TRUE,"True","False") to achieve your requirement. Please find the code example for your reference,  
 
Code example:  
 
  
CalcQuickBase calcQuick = new CalcQuickBase();  
var result =calcQuick.ParseAndCompute("=IF(FALSE=TRUE&TRUE=TRUE,\"True\",\"False\")");  
  
 
Regards,  
Elakkiya M. 


TK Thomas Klocker March 29, 2018 12:20 PM UTC

Hi Elakkiya,

thanks for your answer, but it still doesn´t work. This is my simple sample code:

columnRule = "=IF(\"True\"=\"False\" & \"False\"=\"False\",\"TRUE\",\"FALSE\")";

CalcQuickBase calcQuick = new CalcQuickBase(); 
var res = calcQuick.ParseAndCompute(columnRule);

after executing this code, the variable res contains the string "requires 3 arguments".
The variable 'columnRule' is created in the app dynamically, but in my sample i just hardcoded the string for testing purposes.

Could you please modify the 3 lines from my sample so that they will work?

Thanks for your help
Greetings

Thomas

KB Kanimozhi Bharathi Syncfusion Team April 1, 2018 03:25 PM UTC

Hi Thomas, 
 
We have analyzed your reported issue with your code in the sample, but we were unable to reproduce the issue. Please find the sample link for your reference, 
 
 
if the issue still occurs at your end, could you please modify the above sample to reproduce the issue and update us with replication procedure or video link. So that we will be able to analyze the issue better and update you with appropriate solution. 
 
Regards 
Kanimozhi B 


TK Thomas Klocker April 3, 2018 01:39 PM UTC

Hi Kanimozhi,

attached you find a sample where it doesn´t work. Just look at the App.xaml.cs file in the Constrcutor.

There i get the result "requires 3 Arguments".

Thank you for your help!
Greetings

Thomas


Attachment: eDocXAppX_c8beca74.rar

BR Backia Raj Kanagaraj Syncfusion Team April 4, 2018 01:40 PM UTC

  
Hi Thomas, 
 
We have analyzed your reported issue and checked with your sample. We are unable to reproduce your issue. Please find the screenshot for your reference. 
 
 
Regards, 
Backia Raj Kanagaraj 


TK Thomas Klocker April 4, 2018 01:49 PM UTC

Hi Backia Raj Kanagaraj,

now that´s fascinating! Attached you will find my Screenshot.
I will try to get a other computer and try it there. I have no clue what the problem is here :/

Anyway thanks for your help
Greetings

Thomas

Attachment: CalcQuickBaseFailure_5df8cb8c.rar

SR Sivakumar R Syncfusion Team April 4, 2018 02:38 PM UTC

Hi Thomas,  
 
Can you please let us know the Syncfusion Version you are using. 
 
Thanks, 
Sivakumar 


TK Thomas Klocker April 4, 2018 02:42 PM UTC

Hi Sivakumar,

in my sample i used the Version 16.1.0.24. But the problem also occurs with Version 16.1.0.32
The interesting thing is: if i create a new xamarin forms project in Visual Studio, then the code sample works.

But in my sample project which i have send you it doesn´t.
I need some days to get a other machine on which i can test my sample to evaluate if the problem remains their also.

Thanks for your help
Greetings

Thomas

KB Kanimozhi Bharathi Syncfusion Team April 5, 2018 11:02 AM UTC

Hi Thomas, 
 
We will wait to hear your test results. Also,we have checked the issue with 16.1.0.24 and 16.1.0.32 versions, but we were unable to reproduce the issue. 
 
Regards 
Kanimozhi B 


TK Thomas Klocker June 14, 2018 11:58 AM UTC

Hi Kanimozhi,

we still have this Problem in our Xamarin.Forms App.
Maybe you would have time to looka via web meeting at my monitor, so that i can show you the problem?

Tomorrow, Friday 14.06 would be great. If this doesn´t work for you then i would have time from the 25.06 until 30.06.

Thank you very much for your help
Greetings

Thomas

EM Elakkiya Muthukumarasamy Syncfusion Team June 18, 2018 12:51 PM UTC

Hi Thomas, 
 
We would like to have web meeting to discuss about this “Issue in IF function” hence we have created a new incident under your account. Please log on to our support website to check for further updates. 
 
https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents 
 
Regards, 
Elakkiya M. 


Loader.
Up arrow icon