Dateformat dd-mmm issue in excel formula bar

Jayaraj · August 26, 2021, 1:11am

Hi Team,

I am generating a .xlsx file in aspose java . The column date format is DD-MMM or DD/MMM or DD.MMM output is getting correct but in the formula bar it is showing 1904 date system. attached image for reference. could you please suggest us how to fix the issue to show the correct format in the formula bar.

image.png (27.3 KB)

Thanks

Amjad_Sahi · August 25, 2021, 7:12pm

@Jayaraj,

This might be due to your inserted (underlying) DateTime value into those cells. Please note, setting custom formatting (e.g. DD-MMM or DD/MMM or DD.MMM) would be only for display, so your original DateTime value behind the scene would be always shown in the formula bar.

If you still think it is an issue with Aspose.Cells APIs, kindly do share your template Excel file and output Excel file, we will check it soon.

PS. please zip the files prior attaching.

Jayaraj · September 13, 2021, 8:33am

Hi Team,
Thank you for the reply, we will check from our side and let you know if we have any issues.

Thank you

Amjad_Sahi · September 13, 2021, 8:47am

@Jayaraj,

Sure, please evaluate the issue on your end and in case you still find any issue with Aspose.Cells APIs, let us know with your template Excel files and sample code that you are using to reproduce the issue on our end, we will check it soon.