We are using Aspose.Cells java library (licensed) to refresh excel templates.
While using the library we found a discrepancy between formula evaluation by Microsoft Excel and Aspose.Cells.
Formula evaluated was ISOWEEKNUM and below are the details for the same.
=ISOWEEKNUM(J7+1) where J7 holds the value 2019-01-06 (Date with custom format YYYY-MM-DD)
On refreshing the excel template with above formula programmatically via Aspose.cells java library output is 1 but the same if done manually in Microsoft excel output is 2.
Can you please help in this regard ASAP, as this is affecting our internal customers.
Please let me know if there are more details required.
After an initial test, I am able to observe the issue as you mentioned by using the following sample code with your template file. I found that result of the formula/function “ISOWEEKNUM” is not the same as per MS Excel:
e.g Sample code:
Workbook excelTemplateWithData = new Workbook("f:\\files\\sample.xlsx");
excelTemplateWithData.calculateFormula();
System.out.println(excelTemplateWithData.getWorksheets().get(0).getCells().get("A2").getStringValue());//1 , it should be 2
I have logged a ticket with an id “CELLSJAVA-42807” for your issue. We will look into it soon.
Once we have an update on it, we will let you know here.
This is to inform you that we have fixed your issue (logged earlier as “CELLSJAVA-42807”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.
The issues you have found earlier (filed as CELLSJAVA-42807) have been fixed in Aspose.Cells for Java 19.1. You can also get the latest Aspose.Cells for Java version from Maven repos. with simple configurations. Please see the document for your reference: Installation|Documentation
This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
Enables storage, such as cookies, related to analytics.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.