Horizontal axis is missing in rendered images from Excel chart

Aspose.Cells Product Family
1

Hi,

I have a chart with ‘automatic category axis rotation angle’ created by Ms Excel (mentioned in another post in https://forum.aspose.com/t/how-to-make-the-rotation-angle-of-category-axis-automatic/181272/4 ). I also tried to convert the chart to an image, and found that the whole horizontal axis in the output image was missing.
Code:
var workbook = new Workbook(@“MsChart.xlsx”);
var options = new ImageOrPrintOptions
{
ImageType = ImageType.Emf,
ChartImageType = ImageFormat.Emf,
OnlyArea = false,
TextRenderingHint = TextRenderingHint.ClearTypeGridFit,
OnePagePerSheet = true
};
workbook.Worksheets[0].Charts[0].ToImage(@“testout.emf”, options);

image.png (31.9 KB)

I’ve attached the test file and the output image for your reference. Could you please kindly take a look?

test.zip (14.6 KB)

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-46287 - Horizontal axis is missing in rendered images from Excel chart
3

@ServerSide527,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

Thanks for the prompt fix. I’m looking forward to the release.

5

@ServerSide527,

Thanks for following up.

Hopefully, we will publish the next fix in the next couple of days or so.

Once the fix is available for public use, we will share the Download link (to the fix) here.

6

@ServerSide527,

Please give a try to our latest hotfix Aspose.Cells for .NET 18.8.1 which should resolve your issue. We have provided CategoryAxis.IsAutoTickLabelSpacing for setting tick label spacing to automatic.

7

Hi,

Thanks very much for the pre-release!

I have tested the fix using my test files for both tickets and they are looking fine now. This is going to be very helpful.

Regards,

8

@ServerSide527,

Good to know that your issue is sorted out by the new fix. Feel free to contact us any time if you need further help or have some other issue or queries, we will happy to assist you soon.

9

The issues you have found earlier (filed as CELLSNET-46287) have been fixed in Aspose.Cells for .NET v18.9. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi