Hello
We have been using Aspose 7.7 since it was available and are considering to update it to the latest version (17.11 or later). We have noticed that the ROUND, INDEX(;;0), INDEX(0;0;), PRODCT(;;:;#DIV/0!), VLOOKUP(;;1) and general precise rounding behave different. This means that our calculation outputs differ when updating to Aspose Cells 17+ instead of Aspose 7.7
I found there are a lot of release notes on (link) since Aspose 7.7. As there have been many updates, it is a lot to read through and often the changes in behaviour are not specified.
My question is:is there a list of all Excel functions that had an update in Aspose behaviour?
/ Is there a list of all changes/Aspose updates that could effect calculation results?
And does that list contain descriptions of the previous bad behaviour that has been fixed in that update?
@jbijsusteen
Thanks for considering Aspose APIs.
Please provide us some code and template Excel file(s) which we could use to test your issue with older and newer version. We will then look into it and log the issue in our database for product team consideration and investigation and provide you a fix or any other update relating to it. Thanks for your cooperation in this regard and have a good day.
Could you please just read my question and comment on it?
@jbijsusteen
We are not sure, what problem you are facing. However, for release notes, we are afraid, you will have to go through them one by one to find the changes in the next versions.
Here is the list of supported functions by Aspose.Cells. This list is valid for both .NET and Java versions.
Hello Shakeel,
Thank you for taking the time to read my question.
We are now using Aspose 7.7 already for a couple of years. We use Aspose to let our consultants fill in a webform and then ‘excel’ (Aspose) calculates it all. All the entries in our database have been calculated with Aspose 7.7.
Now we are considering updating the Aspose version we are using to 17.11. However, it is unknown to us how big the effect will be of updating Aspose. We already know that calculated values will be different, but it is not sure to what extend.
For example, could you tell me what updates the function VLOOKUP had over the last couple years?
@jbijsusteen
Thanks for considering Aspose APIs.
We have logged your concerns and questions in our database as CELLSJAVA-42477 for product team consideration and evaluation. We will look into them and help you asap.
@jbijsusteen,
We are afraid we cannot give the complete change details of the formula calculation. Comparing with the versions, the formula calculating engine has been rebuilt completely. If you find some formulas have been calculated incorrectly by current formula engine, we need the code and template to reproduce the issue and we will try to provide fix for it as soon as possible. For some issues, especially about double values precision, it is hard for us to make all situations work same with MS Excel. We have made many investigations and tests for them already, but cannot find the ultimate solution which can make all cases work. What we can do (and have done so far) is to use some solution which may work for most cases, the new engine did fix many calculation issues which were produced by old engine. However, the change also caused some special cases give different results from the result of old versions and MS Excel. Anyways, we need you to provide the test case to reproduce the issue, so we can check whether we can fix it.
Thanks for your understanding!