Chart.ToImage() and DataLabels positioning

Aspose.Cells Product Family
21

Ok, this is almost perfect.

I found only one problem, regarding the amount of data in the chart. Please regard the attached xls example file. In its current state, the chart is correctly converted to an image but if you add another “slice” to the pie chart (selecting another row of data in the first worksheet) all leader lines and label positions are reset. I guess this happens because the new line of data caused a label to overflow the chart boundaries.

Is this an easy issue to fix? Can you give me timings on this?
Thanks again,
Cruz

22

Hi,

Thanks for your feedback.

OK, we will look into it and get back to you soon.

Thank you.

23

Hi there,

Do you already have any feedback for this issue?

Thanks,
Cruz

24

Hi Cruz,

We are still working on your issue and will update you soon.

Thanks for your patience.

25

Hi Cruz,

Please try the attachment. We update the leader lines issue and sheet2Image issue.

26

Thanks again for your reply,

I see the issue of the leader lines is fixed. It's perfect so far.

I noticed another issue, though. It's a matter of cells custom format.

Please try the attached file with the the following code:

Workbook book = new Workbook();

book.Open("c:\\teste.xls");

string aux = book.Worksheets[0].Cells[1, 1].StringValue;

Notice that the value in the workbook is correctly formated, but the String Value of the cell is just part of the string specified in the custom format, and it is not applying to the data it contains. I managed a workaround for me, but I thought you'd like to know about this.

Thanks again for your reply,

Cruz

27

Hi,

Thanks for pointing it out.

Yes, we found the issue, we will figure it out. If you want to get the value only, you may try to use "book.Worksheets[0].Cells[1, 1].Value".

Thank you.

28

Thanks for the tip, I used the Value property for the workaround, yes. Basically I retrieved the Style string, retrieved the Value and then manually applied the style to the value.

Thanks again,
Cruz

29

Hi Cruz,

Please try this fix.

Thank you.

30

Hi !

I am using Aspose.Cells 4.5.1 and I am confronted to the DataLabels positionning issue when using the ToImage() method.

Was it corrected in the later versions (for which we don't have a license) ? Which fix do I need ?

Thank you.

YB, Infocubed

31

Hi,

Thank you for considering Aspose.

Well, we have done many improvements in Chart2Image feature in our later releases. Please give a try to the attached latest version of Aspose.Cells with your template file and check if it works fine. If you face any problem, please share your template file and we will look into it soon.

Thank You & Best Regards,

32

Hi, and thank you for your reply.

This dll seem to produce better results.

Alas, it is dated from today, and our license does not include any release after the 26 nov. 2008.

What would you propose so that my company could work on a bug-free version of this product without extending the license ?

Thank you.

YB - Infocubed

33

Hi,

Well, I 'm afraid there is no option but to upgrade your subscription to use latest versions of the component.

Thank you.