Incorrect Pie Chart Data when rendered through Aspose

Aspose.Cells Product Family
1

Hi,


When we are creating a PDF of the attached Excel Spreadsheet via Aspose.Cells, the UK percentage value is being incorrectly switched from 8% to 7%. As you can see in the excel spreadsheet, the %value for UK is shown as 8%, but when rendered through Aspose, the PDF shows up as 7%. No such issue when rendering the same excel via Acrobat.

Can you please look into this issue on a priority and share your feedback? It looks like Excel/Acorbat seems to round this UP to 8% whereas
Aspose when reading this data seems to be rounding DOWN the same to 7%.

Thanks,
Arminder
2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after executing the following sample using the latest version: Aspose.Cells
for Java v8.4.1.1 which converts your source excel file into pdf and found that the pie chart data relating to UK is not correct.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSJAVA-41300 - Incorrect Pie Chart Data when rendered through Aspose

I have attached the output pdf and screenshot highlighting this issue for a reference.

Java

String filePath = “F:\Shak-Data-RW\Downloads\pie+chart±+sum+of+values_ORG.xlsx”;


Workbook workbook = new Workbook(filePath);


workbook.calculateFormula();


PdfSaveOptions opts = new PdfSaveOptions();

opts.setOnePagePerSheet(true);


workbook.save(filePath + “.out.pdf”, opts);

3

Hi Shakeel,


Thank you for the confirmation. Look forward to an expedited fix for this issue as this is blocking our customer from publishing some important documents as they are not sure if the data is correctly displayed or not for 100’s of other similar spreadsheets which are part of their workflow.

Thanks,
Arminder
4

Hi,

Thanks for your posting and using Aspose.Cells.

Sure, we will try to fix as soon as possible. Please spare us sometime a week or two. Hopefully, your issue will be fixed in this time span. Once, there is some update for you, we will let you.

5

Ok. Thanks for the update Shakeel.


Regards,
Arminder
6

Hi Shakeel,


Just checking in to see if there is any progress on this issue pl.?

Thanks,
Arminder
7

Hi Arminder,


The ticket attached to this thread is currently in analysis phase. Please allow us some more time to properly analyze the reported scenario. Once we have completed the investigation, we will post the results here along with estimated schedule for the fix, if applicable.

Thank you for your understanding.
8

Hi,

Thanks for using Aspose.Cells for Java.

Please download and try this fix: Aspose.Cells for Java v8.4.1.4 and let us know your feedback.

9

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

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