Built in functions

Posted by: candrez on 10 September 2017, 10:57 am EST

  • Posted 10 September 2017, 10:57 am EST

    Hi guys,

    I'm implementing a very similar window that you have on "Spreadsheet Designer" related with built in functions ( Insert Function Window ), basically I need to list the whole functions list ( in ListBox ) and for each one I need to describe the sintax, arguments, summary and more. Could you show me a way to implement it easily ? There is a method that allows me to list them and for each function get the complete description ( Sintax, Arguments, Summary .. etc ) ?


    Thanks in advance !..


    Carlos Diaz. 

  • Replied 10 September 2017, 10:57 am EST


    It seems you are talking about the built in functions (Mathematical, logical, volatile, text etc.) for Spread. There is no method to fetch information for all the built in functions for you. You will have to write code to add each of them to your list.



  • Replied 10 September 2017, 10:57 am EST

    You can for each all types in CalcEngine assembly, and find all types which is inherited from <span style="font-family:arial, sans-serif;">CalcBuiltinFunc</span><span style="font-family:arial, sans-serif;">tion </span>class, that's all built in functions control provides. As for Syntax, Summary, you have to write by yourself.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels