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

Free Support Forum - aspose.com

Issue with display name of caliculated filed in pivot table

Hi Team,

we are using aspose cells 7.0.3.jar

we have issue with display name of caliculated filed in pivot table for the following fields.

1. display name.—Available formula----Available Balance10
2. display name----budget formula----Budget Balance
Available Balance
3. display name.—actual formula----Actual Balance*Available Balance.

in this one the display names are first names of column names.

if i use other than the first name it will generates pivot.


please find the attached sample code, csv and output files.
Thanks
eistechnologies.


.

Hi,

Thanks for using Aspose.Cells for Java and providing a test code.

We have logged your issue in our database. We will investigate the problem and update you asap.

This issue has been logged as CELLSJAVA-40069.

Hi,

This issue has been fixed in the latest version: Aspose.Cells for Java v7.0.4.

Please quote the field name with ':

Please change the sample code:


Java

pivotTable.addCalculatedField(“Available”,"='Available Balance’10",true);

pivotTable.addCalculatedField(“Budget”,"=‘Budget Balance’
‘Available Balance’",true);

pivotTable.addCalculatedField(“Actual”,"=‘Actual Balance’*‘Available Balance’",true);