I am receiving an object reference error when attempting to load an Excel file using Infragistics.Documents.Excel.Workbook.Load. The workbook in question contains formulas that are part of an Automation Add-in (http://support.microsoft.com/kb/291392) that involve some remote data access. I would not expect that the Infragistics calculation engine would be able to evaluate these, but is there some way for me to have these items not crash the entire document loading process? If this is possible, is there any way for me to retrieve stale previously calculated formula values in these cases? Excel seems to have these available and keep them around in situations where Automatic Workbook Calculation is disabled.
Thanks,
Mike Rodriguez
Infragistics3.Documents.Core.v12.1.dll 12.1.20121.2054
Infragistics3.Documents.Excel.v12.1.dll 12.1.20121.2054
Call Stack:
at Infragistics.Documents.Excel.FormulaUtilities.EvaluationManager`1.EvaluateToken(FormulaToken currentToken) at Infragistics.Documents.Excel.FormulaUtilities.EvaluationManager`1.Evaluate() at Infragistics.Documents.Excel.FormulaUtilities.CalcEngine.CalcEngineTokenConverter.Evaluate() at Infragistics.Documents.Excel.FormulaUtilities.CalcEngine.CalcEngineTokenConverter.ConvertTokens(ExcelCalcFormula formula, Workbook workbook) at Infragistics.Documents.Excel.FormulaUtilities.CalcEngine.ExcelCalcFormula..ctor(Formula excelFormula, IExcelCalcReference baseReference, Workbook workbook) at Infragistics.Documents.Excel.Workbook.CompileFormula(IExcelCalcReference baseReference, Formula excelFormula) at Infragistics.Documents.Excel.FormulaUtilities.CalcEngine.ExcelRefBase.SetAndCompileFormula(Formula newExcelFormula, Boolean canClearPreviouslyCalculatedValue, Boolean forceSet, Boolean shouldRemoveCompiledFormulas) at Infragistics.Documents.Excel.FormulaUtilities.CalcEngine.ExcelRefBase.SetAndCompileFormula(Formula newExcelFormula, Boolean canClearPreviouslyCalculatedValue) at Infragistics.Documents.Excel.Workbook.ResumeCalculations(Boolean doFirstEvaluationIfInManualMode)
I believe this should load correctly without an error. Would you be able to post a sample file which has this error? As far as getting the last calculated value, I think that will be possible as well once we get the loading problem fixed.
Mike,
Sure, I have attached text.zip. This is a pretty simple example of the types of files we're attempting to load. The function values in question are in cells D8:D17 and in this case they're using an automation add-in to remotely fetch account descriptions defined in C8:C17. In an ideal world, I would be able to retrieve the cached values of these functions.
I have not included the automation add-in, but I do not think this should matter for the problem at hand.
Without the add-in, you will see function values that will look something like =CompeatXL.FinancialFunctions.GLDesc(C8), however, if you were to have the add-in installed, you would generally only see a =GLDesc(C8) without the full namespace. I'm not sure if this is helpful or even relevant.
Hello Mike,
I have created CAS-103105-H8P8X4 and logged this with our developers. You will be notified both through the case and this forum thread when the issue has been resolved.
This issue has been resolved in the latest Service Release as of the date of this post.