Calculating xl with pivot table - Gets stuck on workbook.CalculateFormula(opts);

Aspose.Cells Product Family
,
1

Hi There,

I am using latest version of Aspose.Cells (2024.8.0).
We have a file holding a pivot table which with some table references. (attached under ‘input.zip’)
input.zip (2.9 MB)

We wont to perform:
workbook.CalculateFormula(opts)
on the file though, this method get stuck and does not reach our simplest implementation of: AbstractCalculationEngine.Calculate(CalculationData data)

Implementing AbstractCalculationEngine:

public class CalcEngine : AbstractCalculationEngine
 {
     public override void Calculate(CalculationData data)
     {
         //Do some work
     }

     public Workbook GetCalculatedWorkbook(string xlPath)
     {
         var opts = new CalculationOptions
         {
             CustomEngine = this
         };

         var workbook = new Workbook(xlPath);

         workbook.CalculateFormula(opts);

         return workbook;
     }
 }

Calling CalcEngine:

var calcEngine = new CalcEngine();
calcEngine.GetCalculatedWorkbook(<input-file-path>);

Please advise,

Thanks,
Shlomi

2

@shlomi.z
By testing with sample file and code on the latest version v24.8, we can reproduce the issue. Discovered that the program is getting stuck on Workbook.CalculateFormula(opts) when calculating xlsx file with pivot table.

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-56587

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.

3

Hey There,

Any updates?

4

@shlomi.z,

We apologize, but your issue has not been resolved yet. We will check if we can provide an update or estimated time of resolution. We will get back to you soon.

5

@shlomi.z,

We are pleased to inform you that your issue (Ticket Id: “CELLSNET-56587”) has been resolved. The fix/enhancement will be included in our upcoming release (Aspose.Cells v24.9) that we plan to release in this week. You will be notified when the next version is released.

6

The issues you have found earlier (filed as CELLSNET-56587) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi