We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Incorrect value from Aspose while using 31st as date in Excel function

While setting 31st as a date in a formula (price function) in Excel, the value expected is not the same as what Aspose generates.

In PRICE function when the settlement date is 31st of a month, then the formula fails in Aspose. Other dates work fine.

This error is seen only for date 31st. All other dates prior to 31st is working fine, ie, the formula when used in Excel directly and in Aspose have the exact same value.

Hope the query is clear.

We are kind of stuck and a quick response would help.


Please provide us a sample console application replicating the problem. We will look into it and fix it and update you asap.

Please also try the latest version:
Aspose.Cells for Java v7.0.3.1
and see if it resolves your problem.

We have now downloaded we are using attached java class and XLS file. when we passing settlement date as month end ex 31-OCT-2011 ,30-NOV-2011 that time price value is not calculating correctly but non month end it calculation looks good.


Thanks for your comment and feedback.

We have logged this issue in our database. We will update you asap.

This issue has been logged as CELLSJAVA-40039.


Please try the new fix: v7.0.3.2. We have fixed the issue of calculating given formulas.

Thank you.

The issues you have found earlier (filed as CELLSJAVA-40039) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.