Exception when save Excel File | Infragistics Forums

480

Exception when save Excel File

Noam Kalter posted over 13 years ago

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.

605

Garth posted over 12 years ago in reply to Garth

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!
Cancel
Reply

Cancel
605

Garth posted over 12 years ago in reply to Georgi
Cancel
Reply

Cancel
53790

Georgi posted over 12 years ago in reply to Garth

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

ExcelWorkbookApplyFormula.zip
Cancel
Reply

Cancel
605

Garth posted over 12 years ago in reply to Georgi

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?
Cancel
Reply

Cancel
53790

Georgi posted over 13 years ago in reply to chris

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.

Regards
Cancel
Reply

Cancel