Formula SyntaxError using IF

[vladitekh]

With a formula using IF, the error "SyntaxError" occurs.
For example, the formula: IF(A1>0, A2/A1,0) will be in error.
And the formula IF (A1>0,A2/A1, 0) will be without error. The difference lies in the presence of a space in front of the zero at the end of the formula for the case of a false condition.

[jingwood]

I tested the case you mentioned, I can't find any problem. Is there any other stuff that affects the result? It will be helpful if you save your worksheet as .RGF file and upload to here.

[vladitekh]

Sorry for not answering for so long. I could not save the example in the RGF format, since the erroneous formula is simply not preserved. But I tried to save it in the xlsx format, which I then need to open using ReoGridEditor.
if_formula.xlsx


The difference in the images is the presence of a space in the second image by the leading zero at the end of the formula.

[yamidcelta]

Nice, that tip works for me, separate the comma with spaces, thank you.

[jingwood]

Fixed by #392