Free Support Forum -

Issue for DATEVALUE function



Excel will return “12/31/2019” for both =DATEVALUE(“Dec 31”) and =DATEVALUE(“31 Dec”), while Aspose Cells Java will return “01/12/1931”.

Workbook wb = new Workbook();
Worksheet ws = wb.getWorksheets().get(0);
System.out.println(ws.calculateFormula("=DATEVALUE(“31 Dec”)"));
System.out.println(ws.calculateFormula("=DATEVALUE(“Dec 31”)"));

Could you please help?



We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-42909 - Issue with DATEVALUE function

P.S.I used Aspose.Cells for Java 19.4.5 which generates following output:
11658.0 (1/12/1931)
43830.0 (31/12/2019)
However Excel returns values as mentioned by you.



This is to inform you that we have fixed your issue (logged earlier as “CELLSJAVA-42909”) now. We will provide you the fixed version by next week after performing QA and incorporating other enhancements and fixes.


The issues you have found earlier (filed as CELLSJAVA-42909) have been fixed in Aspose.Cells for Java 19.5. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi