I am facing two issues on ASPOSE.Cell both are related to AddIn.
1) The latest version of component I have (i.e 220.127.116.11) is corrupting the excel file when I used the SetAddInFormula method. But it worked with the ASPOSE.Cell version 18.104.22.168 (this version I got from one of the support question in the ASPOSE website).
2) I have an excel file, which is already setup with formulas, macro’s addon etc. i.e in Excel there are few input cells and the output cells (Output field uses Macros and Addin to calculate the output). So, I should input the values into the input fields and read output from the output fields and finally save the output values into the database.
So following are the challenges that I am facing.
1) I understands that the SetAddInFormula can be used to add the addin formula to the excel. (In my case the excel is already setup with addin formulas), But I am looking for a method which I can be used to read the calculated value. (Now the cell.Value is returning as null.)
2) Why the SetAddInFormula method not working on my latest dll version.