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.
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.
Regards
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