Export Excel chart as SVG

Aspose.Cells Product Family
1

Hi ,


I got pie chart . It seems that when I exporting to SVG format or PNG using Aspose Cell .NET 8.4.1 values are not summed to 100% . I think algorithm is little different than in excel.


Kind Regards ,
Piotr


2

Hi,


Thanks for the template file and some details.

Please try our latest version/ fix: Aspose.Cells for .NET v8.4.1.1

I have tested your scenario/ case a bit using your template file with v8.4.1.1. I converted your underlying chart in the first worksheet to SVG file format, it work fine except for one difference regarding United Kingdom datalabel which is 7% instead of 8% (we think Aspose.Cells is rounding Down the value a bit). Do you refer to this issue? Please elaborate and provide complete details to highlight the issue(s) (if possible in a screen shot) so, we could log it appropriately into our database.

I am using the following sample code with your template file:
e.g
Sample code:

string filePath = “e:\test2\pie+chart±+sum+of+values.xlsx”;

//Create a workbook object from the template file
Workbook book = new Workbook(filePath);


//Convert each worksheet into svg format in a single page.
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.SaveFormat = SaveFormat.SVG;

Chart chart = book.Worksheets[0].Charts[0];

chart.ToImage(“e:\test2\out1.svg”, imgOptions);

Thank you.


3

Yes this is the issue here :

work fine except for one difference regarding United Kingdom datalabel which is 7% instead of 8% (we think Aspose.Cells is rounding Down the value a bit).


I think it is bug because Excel show little different.
Cheers,
Piotr
4

Hi,


Thanks for the confirmation.

As we already observed the issue as you mentioned. I found an incorrect Pie Chart’s datalabel value when rendered the chart to image (SVG, PNG). I have logged a ticket with an id “CELLSNET-43591” for your issue. We will look into it to figure it out soon.

Thank you.
5

Any news for this issue ?




6

Hi,


I am afraid, your issue is not fixed yet. I have asked the product team to update on it or provide an eta (if possible).

Once we receive any update on it, we will let you know immediately here.

Thank you.
7

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.4.1.3 and let us know your feedback.

8

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

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