Here is sample code:
Excel ex =new Excel();
Worksheet ws = ex.Worksheets[0];
ws.Cells[0, 0].Formula = “=IF(FALSE, 0, 1)”;
string fName = @“c:\test.xls”;
ex.Save(fName);
Before release 3.4 everything worked just fine.
After I installed it, the same formula renders in Excel as:
=IF(‘FALSE’(),0,1)
and cells displays error: #NAME?
Could you fix the problem or provide workaround for this issue.
Thank you
Steve