ToImage of chart resulting in different axes ticks compared to excel

Aspose.Cells Product Family
1

Hi,

When rendering a chart to images with Aspose.Cells, I noticed the chart axes ticks was rendered incorrectly.

var options = new ImageOrPrintOptions
{
ChartImageType = ImageFormat.Emf,
OnlyArea = false,
TextRenderingHint = TextRenderingHint.ClearTypeGridFit,
OnePagePerSheet = true,
Transparent = true,
ImageType = ImageType.OfficeCompatibleEmf;
HorizontalResolution = 600;
VerticalResolution = 600;
};

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

I’ve attached the test files and a screenshot for you reference. Could you please help to take a look?ToImage.zip (33.3 KB)

2

@ServerSide527,

Thanks for the sample Excel file.

We reproduced the issue as you mentioned by using your sample file. We found Chart.ToImage results in different axes ticks compared to Excel chart. This may be due to the chart being compressed in size. Nonetheless, we will need to investigate further to gather more information about the issue.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-53814

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

Hi @ServerSide527
For this issue, the result of our optimization is as follows, it will take effect in the next version (23.8).
230801.zip (2.9 KB)

4

The issues you have found earlier (filed as CELLSNET-53814) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi