Data labels appear outside chart area

Aspose.Cells Product Family
1

Attached are xls/xlsx/ppt/pptx files with the same chart .

Aspose ppt renders it correctly, but
Aspose.Cells.Rendering.SheetRender.ToImage makes
unexpected results.

Data labes out of chart area (“1.5” and “7” in this example)
shouldn’t be visible .

Would you check this ?

Thank you.

# I’m cross-poiting this to Aspose.Slides forum.

2
Hi,

Thanks for the sample Excel files.

I can notice the issue as you have mentioned by placing the pictures/images (actual & expected) embedded in the same worksheet in the Excel file. Some data labels are rendered outside of the chart area (e.g "1.5" and "7" in this example) shouldn't be visible .

Sample code:

Workbook workbook = new Workbook("e:\\test2\\O20_GraphLabelTest.xlsx");
Worksheet sheet = workbook.Worksheets[0];
Chart chart = sheet.Charts[0];
chart.ToImage("e:\\test2\\outmychart1.emf", ImageFormat.Emf);

I have logged a ticket with an id "CELLSNET-41530" for your issue. We will look into your issue soon.

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

Thank you.
3
Hi,

We have fixed the issue.

Please download and try this fix: Aspose.Cells for .NET v7.4.2.4 and let us know your feedback.
4

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

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