Issue with display name of caliculated filed in pivot table

Aspose.Cells Product Family
1

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 BalanceAvailable 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.


.

2

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.

3

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);