Is it possible to create your own custom functions in Aspose.Cells?
if it also possible to remove functions aspose has defined?
Lets say i want to change the way the SUM function works. Aspose created that function. How would i remove the Aspose implemented version of SUM and replace it with my own?
Sure, i’ll create my own definition of the SUM function via the interface. How does the calc engine know to call the one i made versus the aspose has in the box.
//Adding custom formula to Cell A1
workbook.Worksheets.Cells[“A1”].Formula = “=MyFunc(B1,C1:C5)”;
<span class="code-comment" style="color: rgb(128, 128, 128); background-color: inherit;">//Calcualting Formulas
workbook.CalculateFormula(false, new CustomFunction());