Last axis label missing

Aspose.Cells Product Family
1

Hello,

My use case for Aspose Cells involves opening an existing spreadsheet, taking a specified range and exporting the contents to an image. Generally this works pretty well, but we have run into a case where chart images are missing a label on the X axis that shows up in Excel.

In the below image, you will see that the Jun 17 label shows up in Excel, but the Aspose output only doesn’t show that last label (though the data lines are fine). I can’t seem to find anything that I can do in the code to make that label show.

Do you have any thoughts or suggestions?

ChartDiff.png (92.6 KB)

2

@ITP.SUPPORT

Thanks for using Aspose APIs.

Please save your chart into pdf using Chart.toPdf() method and see if it renders the chart fine. Please provide us your Excel file and sample code so that we could look into this issue at our end.

Please also download and try the following most recent version and see if it makes any difference and resolves your issue.

3

Hello,

Thank you for your response. I’ve attached a quick demo project that shows the problem. Included is a dummy spreadsheet (ChartOutputTest.xlsx) with lots of data and a sheet with one chart. In the sample application, you just have to select the spreasheet and set sheetname to “OutputChart” and the cell range to “A1:M29”. When you generate the Aspose image, you’ll see it is missing the last X axis label compared to the Excel spreadsheet it was generated from.

Your help is greatly appreciated!

2018-02-13 15_12_00-Aspose Excel Range Test.png (9.8 KB)
ExcelRangeTest.zip (314.3 KB)

4

@ITP.SUPPORT

Thanks for using Aspose.Cells.

We were able to observe this issue as per your description. We have logged this issue in our database for product team investigation. Once, the issue is resolved or we have some other news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45923 - Last axis label i.e. Jun 17 is missing from the chart image

Download Link:
output.pdf (594.5 KB)

C#

Workbook wb = new Workbook("F:/Download/ExcelRangeTest/ChartOutputTest.xlsx");

wb.CalculateFormula();

PdfSaveOptions opts = new PdfSaveOptions();
opts.OnePagePerSheet = true;

wb.Save("output.pdf", opts);

Screenshot:

5

Thank you for your help and having the team look at the issue. I will keep an eye out for updates on the resolution.

6

@ITP.SUPPORT

Sure. We will keep you updated with any progress on this issue and let you know when the fix is available.

7

@ITP.SUPPORT

Thanks for using Aspose APIs.

This is to inform you that we have fixed your issue CELLSNET-45923 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

8

Fantastic news! Thanks for the update!

9

@ITP.SUPPORT ,

Thanks for using Aspose APIs.

Please download and try the following fix for your issue CELLSNET-45923 and let us know your feedback.

10

The issues you have found earlier (filed as CELLSNET-45923) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi

11

The issues you have found earlier (filed as CELLSNET-45923) have been fixed in this update. Please also check the following article:* <a href="Install Aspose Cells through NuGet|Documentation