Date format of horizontal axis labels changes in Chart PDF : High Priority

Aspose.Cells Product Family
1

When creating Chart PDF using Aspose Cells v17.5.5 the date format is changed as compared to source excel. Please find few example charts in the attached excel. This is a critical issue for one of our Enterprise client, so an early feedback would be highly appreciated.DateFormatIssue.zip (297.3 KB)

2

@ragarora,

Thanks for using Aspose APIs.

It might not be a bug of Aspose.Cells but the limitation of Aspose.Cells. As we cannot do exactly like Microsoft Excel when it comes to Axis labels.

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-45562 - Date format of horizontal axis labels changes in Chart PDF
3

@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);