Office Excel thread hangs if xls file contains formulas

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

1. Attach the file Test.xls to a page
2. Add the Office Excel macro and select that file
3. 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:

1. Edit the file and remove those formulas
2. 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:

• https://jira.atlassian.com/browse/CONFSERVER-59425