Xll/xla Support vs 'Cell.SetAddInFormula and CellsHelper.AddAddInFunction' in .NET

Aspose.Cells Product Family
1

I’m confused on Cell.SetAddInFormula and CellsHelper.AddAddInFunction. From my understanding of Aspose.Cells from forum posts and discussion with a support tech this morning, Aspose.Cells does not support calculating *.xls files/formulas that depend on .xll/.xla. That is understandable. If that is a correct statement, what is the purpose of Cell.SetAddInFormula and CellsHelper.AddAddInFunction functions?

(Note: I understand that if my assumption about xll/xla execution is correct, I am to use ICustomFunction interface to implement my own replacement code)

2

Hi,


Thanks for your query.

1) Cell.SetAddInFormula --> This method is used to set external add-ins formula.

2) CellsHelper.AddAddInFunction —> This method is used to add an add-in formula which is embedded in vba codes of the workbook/file.

And, your understanding is correct, Aspose.Cells does not support to calculate Add-ins formulas at runtime.


Thank you.