We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Build a pivot based on another pivot

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

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.

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

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,

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.