Insert function arguments in the API

Insert function arguments in the API

Posted by: lior.sharabi on 14 August 2022, 5:26 am EST

• 

  lior.sharabi

  • Post Options:
  • Link
    Copy

  Posted 14 August 2022, 5:26 am EST - Updated 3 October 2022, 9:07 am EST

  Hi

  I’m trying to implement a wizard similar to the one in your demo, inserting a function in the formula editor.,
  
  

  

  1377×777 40.2 KB

  Is it possible to get a list of the functions, categories , arguments and the types of the arguments through the API?

  Thanks

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 16 August 2022, 1:59 am EST

  Hi Lior,

  You can get the list of all the functions using the findGlobalFunction method. You can get the functions’ description and the arguments using the description method.

  Formula Categorization is a part of Designer Component. You can refer to the following docs on Formula Functions and categorize the functions based on their name(https://www.grapecity.com/spreadjs/docs/latest/online/FormulaFunctions.html)

  For example, you can refer to the following sample that I have created for you: https://jscodemine.grapecity.com/share/Ez3iieTXb0i-t8I0Y6UE4w/

  API References:

  description method: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.CalcEngine.Functions.Function~description.html

  Formula Functions: https://www.grapecity.com/spreadjs/docs/latest/online/FormulaFunctions.html

  findGlobalFunction method: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.CalcEngine.Functions~findGlobalFunction.html

  Regards
  
  Ankit