We are using excel 2010 along with analysis toolpack add in. There are lot of formulas available in analysis toolpack which we are using. we plan to use aspose cells for our .NET based application.
Does aspose.cell support analysis toolpack formula?
If yes, do i need some extra add in to use it or analysis toolpack is part of aspose.cell library?
a code sample will be useful.
If no, is there any plan to release aspose.cell version to support analysis toolpack.
Regards
Bhavesh
Thanks for your query.
Well, the add-ins would be retained if you open and resave the template Excel file via Aspose.Cells. Regarding calculating formulas (non native MS Excel formulas/functions in add-ins) and rendering Excel file (containing add-ins) to PDF or image, this may not be supported.
We always recommend our clients to extend Aspose.Cells default calculation engine using the AbstractCalculationEngine class. Now you will have access to all native and non-natives custom function or write them as custom functions for calculations, see the document for your reference:
http://www.aspose.com/docs/display/cellsnet/Implement+Custom+Calculation+Engine+to+extend+the+Default+Calculation+Engine+of+Aspose.Cells)
We can log a ticket for it but I think we might not support it or support it soon. Could you provide more details, what type of support you need Aspose.Cells should incorporate for Analysis Toolpack? You may provide a template Excel file containing sample add-ins with complete details, screenshots and steps involved (in MS Excel), we will check it soon.