Pivot table refresh problem when excel has special charecters (other language)

Aspose.Cells Product Family
1

hi

i am refreshing the pivot tables in an excel and it has other language characters.

like chinese, spanish etc.

i am refreshing the excel pivot tables and saving the file with same name. its working for all other excels which dont have special charecters but with special charecters its not working.

sample code:
Workbook workbook = new Workbook(excelFileName);

int sheetCount = workbook.getWorksheets().getCount();
System.out.println(“sheet count…” + sheetCount);
for (int i = 0; i < sheetCount; i++) {
Worksheet ws = workbook.getWorksheets().get(i);
System.out.println(“worksheet name :”+ws.getName());
for (int k = 0; k < ws.getPivotTables().getCount(); k++) {
System.out.println(“in start…” + k);
ws.getPivotTables().get(k).setRefreshDataOnOpeningFile(true);
ws.getPivotTables().get(k).setRefreshDataFlag(true);
if (excelFileName.contains(“Extract”)) {

} else {
ws.getPivotTables().get(k).refreshData();
}
try {
ws.getPivotTables().get(k).calculateData(); //throwing outofbounds //error here
} catch (Exception el) {
el.printStackTrace();

}
ws.getPivotTables().get(k).setRefreshDataFlag(false);
}

}
workbook.save(excelFileName);
}catch(Exception e){
e.printStackTrace();
}


please provide the solution for this issue. i am using the latest aspose.jar(aspose-cells-7.4.3.1.jar)


thanks

2

Hi,


Thanks for the sample code and sharing template file.

After an initial test, I can notice the issue as you mentioned by using your sample code with your template file.

Here is the output console on my end:

sheet count..8
worksheet name :Sheet1
worksheet name :Plan of Record
in start..0
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at java.util.ArrayList.rangeCheck(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at com.aspose.cells.PivotFieldCollection.get(Unknown Source)
at com.aspose.cells.ais.a(Unknown Source)
at com.aspose.cells.ais.I(Unknown Source)
at com.aspose.cells.ais.a(Unknown Source)
at com.aspose.cells.PivotTable.calculateData(Unknown Source)
at PivotTableRefresh1.main(PivotTableRefresh1.java:30)
worksheet name :ReportCriteria
worksheet name :ReportPeriodMap
worksheet name :SWMETA2
worksheet name :SWMETA3
worksheet name :Queries
worksheet name :Ambassador_Data

The output file is also corrupted.

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

Thank you.





3

thanks amjad for quick reply.

This is an high priority issue for our client. Please look into this issue and provide me a solution as soon as possible.


thanks


4

Hi,


Please spare us some time, we will surely look into it and figure it out soon (if possible).

Thanks for being patient!
5

hi amjad any update on the issue?

6

Hi,


Hopefully, we could update on your issue in the next week or so.
Keep in touch
Thanks for being patient!
7

Hi Amjad

Do you have any update on this bug?



Thanks

8

Hi,

Thanks for your posting and using Aspose.Cells.

We are afraid, there is no update for you at this moment. However, we have logged your comment. Once, there is some update for you, we will let you know asap.

9

Hi thanks for the reply

ETA for this issue was before this week end. Any change in that ?


Thanks

10

Hi,

Please try the new fix/version: Aspose.Cells for Java v7.4.3.5.

The “outofbounds” issue is fixed in the latest fix/version: Aspose.Cells for Java v7.4.3.5.

Still the output file may not be correct, we will look into it further.

Thank you.

11

Hi

Thanks for the reply.

after updating the aspose jar file i found following observations:

1) column headers color ( if it is mixed color) aspose is not detecting that.
if it is straight color its working fine.

you can observe the excel (blue color) and generated pdf does not show up any thing(its blank).
if i change the color to straight color (red) its working fine.

2)some of the data in excel not appearing in pdf and some data is appearing incorrectly.

if you observe the current plan report sheet and at end of excel there are some rows but in generated pdf its showing "grand total " and blank values.

please analyze these issues and provide me fix.


Thanks

12

Hi,


Thanks for the sample files with details.

Well, as we mentioned, we only fixed the “java.lang.IndexOutOfBoundsException” issue (logged as “CELLSJAVA-40512”) as the there are still some issues for which we are already working on them. I have logged your comments/details with your files against your issue id “CELLSJAVA-40512”. Once we have any update on it, we will let you know here.

Thank you.


13

hi

Thanks for the reply.

Can you provide me the ETA for the same.


Thanks

14

Hi,

Thanks for your posting and using Aspose.Cells.

Please spare us some time. Your issue is still under process. Once, there is some update for you, we will let you know asap.

15

Hi,

We have evaluated your issue a bit. I am afraid we could not support refreshing table formatting at the moment, we hope we could support it before the end of this month.


Thank you.

16

Hi,


Please try the latest fix/version: Aspose.Cells for Java v7.5.0.2, we have fixed the issue(s).

Let us know your feedback.

Thank you.

17

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.