Team,
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.
Thanks
Deepanshu