Number of major units on Horizontal and Vertical axis in Chart PDF don't match with source Excel : High Priority

Aspose Cells is causing change in number of units on both horizontal and vertical axis for Excel Charts when compared with source. We are using Aspose Cells v17.5.5. to create Chart PDFs. One our (Quark’s) big Enterprise client has reported several such Charts. Please find attached screenshot and Excel sheet containing various charts that exhibit this issue. The pattern observed here is - the range of values across Y-axis is reduced and range of values across X-axis is increased. Please look into these issues on high priority and provide the fix.AxisUnitsChangeIssue.zip (2.4 MB)

@ragarora

Thanks for using Aspose APIs.

When chart Axis values are automatic, we cannot do exactly same as Microsoft Excel. Besides, Microsoft Excel also do not behave same always. It also behaves differently in different situations or environments.

The following screenshot shows your Excel file in Microsoft Excel 2016 at our end.

sc.png (74.0 KB)

Hi Shakeel, there was an issue while copying the data from original source file. Please use this excel sheet instead Source Excel File.

@ragarora

Please spare us some time, we will look into your issue and update you asap.

@ragarora

We were able to observe this issue and logged it in our database for investigation and for a fix. 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-45579 - Number of Major Units on Horizontal and Vertical Axis in Chart PDF does not match with source Excel

Download Links:
part1.zip (2 MB)
part2.zip (2 MB)
part3.zip (232.6 KB)

Ok Shakeel, thanks for the update.

@ragarora

Please check the attached images. The 3 charts are same except the width of chart. But the labels of category axis are not same. We are afraid Aspose.Cells cannot do well as the MS-Excel.

Download Links:
Auto-Rotation.png (98.1 KB)
Auto-Rotation2.png (11.0 KB)

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