Y-axis labels do not match with source excel

Aspose.Cells Product Family
1

We are using Aspose Cells 17.9.2 (for Java) and one of customer is facing this critical issue of Y-axis units not being same in the PDF output. Could you please provide quick feedback on this issue? The source excel along with screenshots of excel and aspose output are attached. Aspose_Y-axis_issue.zip (143.5 KB)

2

@ragarora

Thanks for using Aspose APIs.

Your Axis Major and Minor units are Automatic and not Manual. When these are automatic, then Aspose.Cells could not work fine like Microsoft Excel. But if they are manual, then Aspose.Cells will draw the chart axis just like Microsoft Excel.

In order to fix this issue, please set Major and Minor Units as Manual instead of Automatic as shown in this screenshot.

Screenshot

3

Thanks Shakeel for your quick feedback. Is this (handling automatic axis units like Excel) on the roadmap to address?

4

@ragarora

This issue is complex for us to fix. However, we have logged it in our database for product team investigation and for a fix. Once, we will have some update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45771 - Handling Automatic Axis Units like Microsoft Excel
5

@ragarora,

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-45771”) now. We will soon provide you the fix after performing QA and incorporating other enhancements and fixes.

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

6

The issues you have found earlier (filed as CELLSNET-45771) have been fixed in this Aspose.Cells for .NET 18.1 update.

Please also check the following article: