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
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 Chris,
I already create a case for you with reference number CAS-71124-CK52WQ. Please if you have any questions, do not hesitate to ask me through the case or in the forum thread.
I am also facing the same issue. In one of the cell , i put formaul as "=M2323823238".
And currently I am using the Infragistics4.Documents.Excel.v11.2 (Version : 11.2.20112.1010)
When we expect this issue to be resolved?
Hello,
The mentioned issue in this forum thread was fixed at the begining of October 2011 in versions 10.2, 10.3, 11.1, 11.2. Also I see that you are using older service release of version 11.2.20112.1010. Could you please try to install the latest available service release - 11.2.20112.2019 from Infragistic.com -> MyIG -> My Keys and Downloads and let me know what is the result. Also please take a look at the attached sample and feel free to modify my sample to reproduce your scenario and revert it back to me. I`ll be glad to research it.
Let me know if you have any questions
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