GETPIVOTDATA is not working when using field grouping

Aspose.Cells Product Family
, ,
1

I have a pivot table with list grouping:
(4.5 KB)

And a cell pulling data using GETPIVOTDATA
image.png (5.9 KB)

After running the following code:

    Workbook wb = new Workbook("SimplePivot2.xlsx");
    PivotTable pivot = wb.getWorksheets().get("Pivot").getPivotTables().get(0);
    pivot.refreshData();
    pivot.calculateData();
    wb.calculateFormula(new CalculationOptions());
    wb.save("simple_pivot_out.xlsx");

The output excel pivot seems to collapse:
image.png (2.9 KB)

And the cell with GETPIVOTDATA return error #REF

When manually refreshing the pivot in excel, everything gets back to normal.

files.zip (1.5 KB)

2

@odedha,
We have observed the issue and logged it in our database for further investigation. You will be notified here once any update is ready for sharing.

This issue is logged as:
CELLSJAVA-43383 - GETPIVOTDATA is not working when using field grouping

3

@odedha,

This is to inform you that your issue has been resolved. This fix will be included in the upcoming release of Aspose.Cells v23.12, scheduled for release in the second week of December. You will be notified when a new version is published.

4

The issues you have found earlier (filed as CELLSJAVA-43383) have been fixed in Aspose.Cells for Java 23.12.