CalculatedField Issue in linux operating system

Aspose.Cells Product Family
1

Hi Team,


we are using aspose cells 7.0.3.

we are adding CalculatedField to the pivot table. it is working fine if it has more than 2 calculated fileds.

for example

pivotTable.addCalculatedField(“fffgfga”,"=‘Annual Salary’-‘Assignment Id’",true);
pivotTable.addCalculatedField(“fffgfgb”,"=‘Assignment Id’-‘Annual Salary’",true);
pivotTable.addCalculatedField(“fffgfgc”,"=‘Assignment Id’-10",true);

this will gives the correct output.

if we add like this to the pivot table

pivotTable.addCalculatedField(“fffgfga”,"=‘Annual Salary’-‘Assignment Id’",true);
pivotTable.addCalculatedField(“fffgfgb”,"=‘Assignment Id’-‘Annual Salary’",true);

generated pivot table CalculatedFields have only one formula “Annual Salary’-'Assignment Id”.

This our Production issue.
please find the attached code,input file and output file.

Thanks,
EiS Technologies.


2
Hi,

Thanks for providing us the sample code and template files.

I can notice the issue as you have mentioned by using your sample code with your template file. I can find the CalculatedField issue when we add 2 fields to the table, it works fine if we add three fields to it.

I have logged a ticket with an id "CELLSJAVA-40503" for your issue. We will look into your issue to figure it out soon.

Thank you.
3

Hi Team ,


Any Update on this,

Thanks,
EiS Technologies.
4

Hi,

Thanks for your posting and using Aspose.Cells.

We are afraid, there is no update for you at this moment, your issue is still under process. However, we have logged your comment in our database. Once, there is some update for you, we will let you know asap.

5

Hi,


Please try the attached latest fix/version: Aspose.Cells for Java:
Aspose.Cells for Java (Latest Version)

I have tested your case with it and it works fine.

Thank you.

6

Hi Team,



Thanks for the update,


i tested with latest jars. it works fine.
but it gives the following error.

"com.aspose.cells.CellsException: The subscription included in this license allows free upgrades until 2012-08-29, but this version of the product was released on 2013-04-22. Please renew the subscription or use a previous version of the product."

Thanks,
EiS Technologies.
7

Hi,


Well, it is unfortunate but as per the exception your subscription was expired on April 22, 2013. So, you may not use latest versions/fixes that are released after your subscription expiry date. You have to upgrade your subscription to use latest versions/fixes or updates.

For your information, when you purchase a license, you are authorized to use this license file with any new (and upcoming) versions / hot fixes of the component(s) for the next whole year before your subscription expiry date. Either you should persist with older versions of Aspose products (that should be released before your expiry date (you may simply open your license file into notepad and check the license’s expiry date without modifying it) or upgrade your subscription to use our latest versions. For upgradation or subscription or licensing matters, please contact our Sales representative, you may post a query into Aspose.Purchase forum.


By the way, you may also try to use this if it works fine too:
(Note: your existing subscription allows to use the above version)

Thanks for your understanding!

8

Hi Team,


Thanks for your quick Response.

The jar file you have provided is not working with our license for Aspose jars. Can you please provide another jar file which works with our license file?

Thanks,
EiS Technologies.


9

Hi,


Sorry for the confusion.

After closely looking the error message, well, your subscription was actually expired on August 29, 2012, so you may use any version that was released before the date, e.g you may try to use v7.3.1 or older versions. Could you try to use the v7.3.1 (that was released on August 23, 2012) with your existing subscription:
Aspose.Cells for Java (Latest Version)

Thank you.

10

Hi Team,


Thanks for quick response,

This version is working fine. Is there any API changes from 7.0.3 to 7.3.1.

thanks,
EiS Technologies.
11

Hi,


Good to know that your issue is resolved.

And, there is not any significant difference regarding API in the new versions e.g 7.3.1, you may use it without any problem.

Let us know if you still find any issue.

Thank you.
12

Hi Team,


Thanks for your response,

We found some errors while compiling the jsp’s.

like

SaveOptions opt = new OoxmlSaveOptions();
opt.setSaveFormat(FileFormatType.XLSX);

setSaveFormat method not found.

the above method is there in 7.0.3 version.



Thanks,
EiS Technologies.
13

Hi,

Thanks for your posting and using Aspose.Cells for Java.

Please change the above lines of code into following code.

SaveOptions opt = new OoxmlSaveOptions(SaveFormat.XLSX);