Hi Team,
we have been using Aspose 22.11 untill August and recently upgraded to 24.7. The wokrbook which has been working is now throwing an exception with the latest version 24.8 and 24.9. Tried with 24.9 as well and the issue persists. locally downgraded to 22.11 , there is no exception and its working as expected.
The workbook is .xlsm type and contains macro and below formulas
INDEX
SUM
IF
UNIQUE
TRANSPOSE
FILTER
MATCH
IFERROR
VALUETOTEXT
TEXTBEFORE
SUMIFS
INDIRECT
SUBTOTAL
CELL
FIND
MID
ROW
CONCAT
MAX
COUNTIF
verified that all the formulas are supported.
Error
EXCEPTION: IndexOutOfRangeException: Index was outside the bounds of the array.(Based on cell DTA Summary_FY Details!B31)
STACK TRACE: at Aspose.Cells.Workbook.CalculateFormula(CalculationOptions options)
at Aspose.Cells.Workbook.CalculateFormula()
at Deloitte.Tax.TaxPortal.Core.ExcelHelper.InsertTableToWorkbook(MemoryStream stream, DataTable data, String sheetName, Int32 startRowIndex, Int32 startColumnIndex, Boolean displayTableHeaders, String tableName, Nullable`1 tabColor, String password)
at
attached copy of the file being used
DTASummarySanitizedVersion.zip (1.3 MB)
Thanks
@Mveerabaghu,
Thanks for the template XLSM file.
After initial testing, I am able to reproduce the issue as you mentioned by using your template XLSM file. I found the exception: “IndexOutOfRangeException: Index was outside the bounds of the array” when calling Workbook.CalculateFormula() method in code.
Workbook workbook = new Workbook("e:\\test2\\DTASummarySanitizedVersion.xlsm");
workbook.CalculateFormula();
We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-56848
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
hi,
do we have any suggested workaround code fix for this, as our clients use a lot of formulas in excel ?
or is this a specific usage of an excel function causing it?
thanks
@Mveerabaghu,
Please allow us some time to thoroughly evaluate your issue. Then we could provide details or root cause of the issue. Moreover, if we discover a viable workaround, we will share it with you in the meantime.
@Mveerabaghu,
We are pleased to inform you that your issue has been resolved. The fix will be included in our upcoming release Aspose.Cells v24.10 that is scheduled to be published in the second week of October (next month). You will be notified when the new release is published.