Free Support Forum - aspose.com

Point missing and shape squeezed in image renderd by Aspose.Cells

Hi,

When rendering a 100% stacked chart to an image. I noticed one series point is missing and all the bars squeezed.

Code:

var workbook = new Workbook(@".\test.xlsx");
var chart = workbook.Worksheets[0].Charts[0];
chart.ToImage(@".\out.emf");

I’ve attached the test files and a screenshot for your reference. Could you please help take a look?

test.zip (12.5 KB)
image.png (33.0 KB)

Thanks,

An update that I found the squeeze problem even by copying and resaving this worksheet.

Code:
var workbook = new Workbook(@".\original.xlsx");
var copyWorkbook = new Workbook();
copyWorkbook.Copy(workbook);
copyWorkbook.Save(@".\out.xlsx");

Attached the test files and screenshot as well:

test2.zip (21.5 KB)
image.png (27.2 KB)

@ServerSide527,
We were able to observe the issues but we need to look into them more. We have logged the issues in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issues have been logged as

CELLSNET-47369 – Chart point missing and shape squeezed in EMF image renderd by Aspose.Cells
CELLSNET-47370 – Chart point missing and shape squeezed while loading and saving Excel file