Hi,
I open an empty excel file using Infragistics.Excel library than add the formula: =AVERAGEIFS(G45:G107,C45:C107,"O",D45:D107,"SMALL") to cell A2 using SetFormula.
When calling Workbook.Save function an exception occur: Value cannot be null.Parameter name: input
Thanks.
I was not able to reproduce this issue. Also, I don't know of any SetFormula method. Can you provide some sample code?
Thank you for your quick reply. After upgrading to 2011 Vol1 with the latest service a different issue came up. Now Excel is showing #name? error on the cell. If I go to the formula edit for this cell and press enter the #name$ disappear and the result are showing.
Below is a sample code for this issue:
wb1.Worksheets.Add(
"sheet1");
wb1.SetCurrentFormat(
WorkbookFormat.Excel2007);
wb1.Worksheets[0].Rows[0].Cells[0].Value = 2;
wb1.Worksheets[0].Rows[0].Cells[1].Value = 4;
wb1.Worksheets[0].Rows[0].Cells[2].ApplyFormula(
"=IFERROR(A1/B1,\"\")");
wb1.Save(fileName
);