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

Free Support Forum - aspose.com

Regarding price function in excel

after price function calculation ,generated value is not reflecting in the cell

Hi,

Please try the latest version:
Aspose.Cells for .NET 7.0.3
and if the problem persists then provide us a sample console application replicating the problem along with the source xls/xlsx files.

We will look into it and update you asap.

Shakeel,

Just to make the issue a little more clear....

We are using Aspose to get and set values in Java for an Excel function called PRICE. This function works in Excel correctly. However, when the settlement date passed into this function is the last date of any month, the value that is fetched is wrong.

Do you still recommend that we go ahead and download .NET components because the core application is in Java.

Hi,


We have already logged your issue (regarding PRICE function) in our database with an id: CELLSJAVA-40039 for your other thread:
<a href="

We will figure it out soon.

Guys,

The problem is with your COUPONPCD and COUPONCD function implementation.
On month ends it returns incorrect values. So if you can fix that it would solve the issue.

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.