Converted image looks different from the original Excel chart

Aspose.Cells Product Family
1

Hi,

When converting a chart to an image, I noticed several elements in the chart looked differently in the images.

Code:
var workbook2 = new Workbook(@“test.xlsx”);
var options = new ImageOrPrintOptions
{
ImageType = ImageType.Emf,
ChartImageType = ImageFormat.Emf,
OnlyArea = false,
TextRenderingHint = TextRenderingHint.ClearTypeGridFit,
OnePagePerSheet = true
};

        workbook2.Worksheets[0].Charts[0].ToImage(@"out.emf", options);

I can see some line thickness and position accuracy issue (marked in my screenshot).

image.png (237.5 KB)

out.zip (32.2 KB)

I’ve attached the test files for your reference. Could you please help me check?

Thanks

2

@ServerSide527,

We were able to observe the issue but we need to look into it more. We have logged the issue 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 issue has been logged as

CELLSNET-46389 - Converted EMF image looks different from the original Excel chart
3

@ServerSide527,

We are afraid, the position issues cannot be fixed for now. We can read the position of lines that are sub-shapes of chart is recorded in Excel file. But the chart elements position is not documented in the Excel file. So, we need to calculate them. Now, calculating the position is too complex to sort out. We cannot do it same as Excel for now.

4

@ServerSide527,

Please try our latest version/fix: Aspose.Cells for .NET v18.10.3 (attached):

We fixed the issue only for thin lines in it.

Let us know your feedback.
Aspose.Cells18.10.3 For .Net2_AuthenticodeSigned.Zip (4.7 MB)
Aspose.Cells18.10.3 For .Net4.0.Zip (4.7 MB)

5

@ServerSide527

Please try our latest version Aspose.Cells 21.6.0.