Free Support Forum - aspose.com

Issue for DATEVALUE function


#1

Hi,

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?

Thanks,
Hui


#2

@huichen,
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.


#3

@huichen,

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.


#4

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