Problems with =IF Function

[Thomas Klocker]

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

[Elakkiya Muthukumarasamy]

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. 

[Thomas Klocker]

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

[Kanimozhi Bharathi]

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, 

 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/WpfApplication2-727051861 

 

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 

[Thomas Klocker]

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

[Backia Raj Kanagaraj]

  

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. 

 

Screenshot: http://www.syncfusion.com/downloads/support/forum/136736/screenshot631742880 

 

Regards, 

Backia Raj Kanagaraj 

[Thomas Klocker]

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

[Sivakumar R]

Hi Thomas,  

 

Can you please let us know the Syncfusion Version you are using. 

 

Thanks, 

Sivakumar 

[Thomas Klocker]

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

[Kanimozhi Bharathi]

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 

[Thomas Klocker]

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

[Elakkiya Muthukumarasamy]

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.