I just upgraded to NetAdvantage 11.2. In my application, I am trying to import a workbook with user defined functions. When I call the function WorkBook.Load(fileName), It crashes with an ArgumentNullException. The formula string cannot be null. Parameter name: value. The stack trace says it occurs at:
at Infragistics.Documents.Excel.Formula.TryParse(String value, CellReferenceMode cellReferenceMode, FormulaType type, WorkbookFormat fileFormat, CultureInfo culture, Formula& formula, FormulaParseException& exception) at Infragistics.Documents.Excel.Formula.Parse(String value, CellReferenceMode cellReferenceMode, FormulaType type, WorkbookFormat fileFormat, CultureInfo culture)
Is there something I am doing wrong that could cause this to happen? Is there a way to prevent it from happening?
I do not need to save the formulas. I just would like to be able to grab the values from cells without the functions.
It occurs on the first line of my import method: var wb = WorkBook.Load(fileName);
The file, in my case, is fairly database dependent, so if an example is needed I will try to come up with something.
Thanks In Advance
I left an important part out. The user defined functions are in an external macro enabled file. I attached an example a sheet that references an external file. and the file it references. The file that would crash when you import it is the UserDefinedFormulaConsumerExample.xlsx.. The other file contains the VBA functions that the UserDefinedFormulaConsumerExample references.
Hello,
I have created a support ticket with id CAS-84506-YK2KKD. I will update you for the progress of this issue via the case as soon as I have information for you.
Thank you for using Infragistics Components.
The fix of this issue is available in the latest services release of Infragistics 11.2 and later and Infragistics 12.1.
The crashing issue should be fixed, if you have the latest service release. I haven't tested to see how it handles the functions yet.
What's the status? This is a critical issue for us.