Is it possible to create custom functions that can be used as formulas? For instance "=MyFunction(A1:A10)"?
Thank you for posting in our community.
In order to provide you with more accurate support I will need some additional information regarding your scenario. Can you please answer the following questions:
Looking forward to hearing from you.
Thank you for using the igSpreadsheet!
About your scenario - I would suggest for you to take a look at the ExcelCalcFunction and see if this would do the work for you- https://www.igniteui.com/help/api/2018.2/ig.excel.ExcelCalcFunction.html#methods
Meanwhile, I have contacted the team that is working on the Spreadsheet control and I will update you with any additional information on your scenario as soon as possible.
Thank you once more for choosing Ignite UI!
I am playing with this now. After I create a class based off of ExcelCalcFunction how do I register it with the workbook so I can start using it like I would use formulas? Is there an example somewhere? I've searched but came up with nothing.
Thank you for your response!
The information that our development team has provided according to this scenario is that using ‘ExcelCalcFunction’ is not recommended as it could result in unexpected behaviors if you create a type that conflicts with some of the internal types.
I have created a work item about exposing a ‘customFunction’ class that would be available in the future releases. I will attach the work item to this case so that you would be notified once it is resolved and the class is available.
Thank you for bringing this to our attention!
If you have other questions about the igSpreadsheet, do not hesitate to contact us again!
Best regards, Alexander