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
);
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
Hello Garth,
We will inform you through the e-mail message when we are ready with the fix of your issue. Meanwhile you could write us through the case or in this forum thread. Let me know if you have any questions.
Do I need to follow up the CASE #: CAS-82409-MN7KMF or you will update me when this issue will fix?
If Yes, what is the procedure to follow up the Case?
Thanks a lot!
I was able to reproduce your issue when I`m using Excel (.xls) file, but the issue is not reproducible with Excel 2010 (.xlsx) file. I already create a case for you with reference number CAS-82409-MN7KMF. I`ll provide you additional information through the case. Let me know if you have any questions.
Hi Georgi,
I tried to load the excel file(MyTestData File.xls) attached above by using following code:-
Workbook wk = Workbook.Load(@"..\\MyTestData File.xls");
and it fails. Would you please give a try a look into it?
In my test sample eveything works properly. Please take a look at the attached sample. Please let me know if you think that I didn`t reproduce your scenario in my sample. Feel free to modify this sample to reproduce your issue and revert it back to me. I`ll be glad to research it. If you have any questions, do not hesitate to write me