Problem
Office Excel (view-xls) macro does not load and its corresponding thread gets stuck if the file contains formulas. Example:
=COUNTIF(Section,"Person4")+H1
Steps to Reproduce
- Attach the file Test.xls
to a page
- Add the Office Excel macro and select that file
- Save the page
Expected Results
The page and the macro render as expected.
Actual Results
The page does not load anymore and the thread gets stuck infinitely. Only restarting the application will clear up that thread.
Workaround
The file Test-noformulas.xls is the same but the "COUNTIF" formulas were removed. The bug cannot be reproduced with that file. So, the options are:
- Edit the file and remove those formulas
- Or, use the File Preview macro instead of the Office Excel one
Notes
Example of hanging thread:
at com.aspose.cells.zaaj.c
at com.aspose.cells.Workbook.calculateFormula
This can result in full unresponsiveness of the instance if the page is visited the same number of times that is defined in maxThreads (48 by default) since they all will get stuck in this operation. Only restarting will clear them up.
It also affects Data Center because the Office Excel macro is not covered by the file conversion sandboxing due to this bug:
Bug
Low
