Hello,
We’ve encountered an issue with GETPIVOTDATA function - on the attached excel test file the Aspose result on the GETPIVOTDATA formula is #VALUE!, Excel’s result is: 1194.
Please verify the attached file and provide some feedback.
We’ve noticed that starting with version 7.0.4 Aspose added support for GETPIVOTDATA function, as per this link: https://blog.aspose.com/2011/12/19/aspose.cells-for-.net-7.0.4-released-with-tremendous-enhancements.
However, the list of unsupported excel formulas in the Aspose documentation seems to not be updated - Supported Excel Functions|Documentation , is this correct ? Are they any other formulas listed in this link which are supported by Aspose ?
Thanks in advance,
Mihai Andrei,
Sr. Software Engineer,
IBM Romania
Hi Mihai,
Thank you for using Aspose.Cells.
As per the blog post and release notes of version 7.0.4, GETPIVOTDATA function is supported by Aspose.Cells, and there seems to be a need of updating the online documentation.
I can reproduce/observe the issue as you have mentioned. We will investigate this issue and get back to you as soon as possible after having an update from our development team about this.
The issue has been logged in our Issue Tracking System as: CELLSNET-40862.
The issues you have found earlier (filed as CELLSNET-40862) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.