Hi, I'm trying to set formula for cell this way:
mySheet.Cell(10, 5).FormulaA1 = "=IF(B15<0;(B15*G15)/(360*100);(B15*F15)/(360*100))";
File is succesfully generated, but when I try to open it, I get the following error:
Excel found unreadable content in 'report.xlsl'. Bla, bla ...
If I accept repairing of file I get this info:
Removed Records: Formula from /xl/worksheet/sheet.xml part
Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)
If I try the same formula directly in Excel, it works fine.
I have the same problem with formula like:
Thank you, Robert.