Can we add our own fields in the formula dropdown

Can we add our own fields in the formula dropdown

Posted by: sathwik.kotla on 29 August 2022, 7:39 am EST

• 

  sathwik.kotla

  • Post Options:
  • Link
    Copy

  Posted 29 August 2022, 7:39 am EST - Updated 3 October 2022, 9:05 am EST

  I would like to add some of the values to the existing formula drop down can that be done?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 30 August 2022, 3:02 am EST

  Hi Sathwik,

  You can define and add the global custom function and it will be available in the formula dropdown.

  You can refer to the following case that discusses the similar issue: https://www.grapecity.com/forums/spreadjs/i-would-like-to-override-t_1

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

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

  addCustomFunction method: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Workbook~addCustomFunction.html

  Regards
  
  Ankit