Calculation time increasing issue

Aspose.Cells Product Family
21

Hi,


We have evaluated your issue further.
Well, even though new versions can work with normal mode (without debug options), the calculation still needs to calculate formulas recursively and repeatedly. This causes deep stack when calculating formulas. To avoid StackOverflowError, we have to throw some kind of exception to handle the calculation stack. And it is just the try…catch blocks for handling exceptions which caused performance issue in debug mode.

For your situation, we think it has to be solved by using the option to avoid calculating cells recursively.

Thank you.
22
Hi. Thank you for reply. But can you clarify some details:

1) Why you throw some exception (which absorbed within library and slowdown debug process), instead of performing a simple checking a circular references (like HashSet of Cells within calculation stack), which will break calculation?

2) What should we expect for new version (will you return back possibility to old behavior of calculation)

Best regards
23

Hi,


This is to inform you that from v8.9.0.10 (we will share the Download link here soon), we provide new option for calculating formulas:
i.e.,
CalculationOptions.Recursive
With this option, you need to use the old logic which worked with older versions of Aspose.Cells and change the code of calculating formulas:
i.e.,
cell.calculate(true, null);
to:
CalculationOptions copts = new CalculationOptions();
copts.setRecursive(false);
cell.calculate(copts);

Thank you.
24

The issues you have found earlier (filed as CELLSJAVA-41925) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.