Horizontal Axis labels (date range) in Chart PDF don't match with the source excel : High Priority

When creating Chart PDFs using Aspose Cells v17.5.5 the horizontal axis labels appear totally different from source excel. Our Enterprise client has reported several such charts (see attached) where date labels/range across X-axis are different in PDF outputs. This is a critical issue and requires an immediate fix.IncorrectHorizontalAxisIssue.zip (688.7 KB)

@ragarora

Thanks for using Aspose APIs.

It is a similar issue that you have described in your previous threads. Aspose.Cells cannot exactly do the same as Microsoft Excel when Axis are set to be automatic. However, we have logged your issue in our database for further investigation. We will look into it and update you asap.

This issue has been logged as

  • CELLSNET-45564 - Horizontal Axis labels (date range) in Chart PDF don’t match with the source Excel file

@ragarora

Thanks for using Aspose APIs.

The format of date-time data relates to the region of the machine. You may set region by following code.

C#

Aspose.Cells.LoadOptions loadOptions = new Aspose.Cells.LoadOptions();
loadOptions.LanguageCode = CountryCode.USA;
loadOptions.Region = CountryCode.USA;
Workbook book = new Workbook(sourceFile, loadOptions);