We have a client that is heavily using the STOCKHISTORY function. When we try to re-calculate his Excel -> we are receiving #Name result.
Is this function support/planned to be supported?
Thanks
The STOCKHISTORY function may not be supported by Aspose.Cells’ formula calculation engine. Could you please share a sample Excel file containing the underlying formula in tact, we will evaluate and may log appropriate ticket(s) for it into our database.
Thanks for the sample file.
I have logged a ticket with an id “CELLSNET-51911” for your issue/requirements. We will evaluate the STOCKHISTORY function in details. Once we figure it out, we will let you know.
We found the calculation of this function requires different protocols and permissions to connect to different external data sources, which is beyond the constraints of our components about security. And such kind of process also causes user concerns about security. So we are afraid we cannot support it directly.
However, we plan to support users to set/refresh/calculate those formulas which use this function with their own custom engine (implementation of AbstractCalculationEngine). We will provide the ultimate values of those parameters of this function so users can fetch data accordingly.
Please let us know whether this solution can fit your requirements? If yes we may provide some new APIs and share some example code of this solution for you later.
We supported to parse/save STOCKHISTORY formula. We supported to calculate it with user’s custom engine. The enhancement will be included in our upcoming release (Aspose.Cells v23.1) which is scheduled in the next week of January 2023.