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
Hello,
The fix of this issue is available in the latest services release of Infragistics 11.2 and later and Infragistics 12.1.
Thank you for using Infragistics Components.
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.
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.