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
);
I am facing the same issue while loading the the above file (MyTestData File.xls )with your test application.
Would you kindly look into this issue?
Thanks!
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
Regards
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?
Hello Garth,
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.
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!
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.