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.
We just ran into the IFERROR bug today too.Can I get associated with the case too or should I open a second one of my own?
Thank you,Chris
Infragistics4.WebUI.Documents.Excel.v11.1Version 11.1.20111.1006
Hello Noamk,
Thank you very much for provided information. I was able to reproduce your issue. I already create a case with reference number CAS-70866-75M26C and I`ll update you through the case. Please if you have any questions, do not hesitate to ask me
Regards
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
);
I was not able to reproduce this issue. Also, I don't know of any SetFormula method. Can you provide some sample code?