Build a pivot based on another pivot

Aspose.Cells Product Family
1

hi - excel has the ability to build a pivot whose data source is another pivot table. can this be done with java aspose.cells ?


thanks, simon
2

Hi,

Well, I am afraid the feature is not supported. Your feature request has been registered into our internal issue tracking system with an issue id: CELLSJAVA-11615. We will support your desired feature soon.

Thank you.

3

Hi,

Thank you for considering Aspose.

Please try this new fix and check if it fits your requirement. We have added two new APIs:

int com.aspose.cells.PivotTables.add(PivotTable pivotTable, String destCellName, String tableName)

Adds a new PivotTable Object to the collection from another PivotTable.

Parameters :

pivotTable The source pivotTable.

destCellName The cell in the upper-left corner of the PivotTable report’s destination range.

tableName The name of the new PivotTable report.

Returns :

The new added PivotTable index.

And

int com.aspose.cells.PivotTables.add(PivotTable pivotTable, int row, int column, String tableName)

Adds a new PivotTable Object to the collection from another PivotTable.

Parameters :

pivotTable The source pivotTable.

row Row index of the cell in the upper-left corner of the PivotTable report’s destination range.

column Column index of the cell in the upper-left corner of the PivotTable report’s destination range.

tableName The name of the new PivotTable report.

Returns :

The new added PivotTable index.

Thank You & Best Regards,

4

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.