Set category and parameter name and info in Custom Functions

Set category and parameter name and info in Custom Functions

Posted by: niels on 17 May 2023, 12:34 am EST

• 

  niels

  • Post Options:
  • Link
    Copy

  Posted 17 May 2023, 12:34 am EST - Updated 17 May 2023, 12:39 am EST

  How to set category of a custom function
  
  and set parameter name and add parameter info
  
  for Custom Functions
  
  And how to see the value of a defined name (MH.SampleID=3 in screenshot)
  
  

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 17 May 2023, 3:04 pm EST

  Hello,

  We are discussing this issue with the development team and will get back to you with the updates soon.
  
  [Internal Tracking ID: SPNET-30033]

  Regards,
  
  Prabhat Sharma.

• 

  niels

  • Post Options:
  • Link
    Copy

  Posted 18 May 2023, 10:33 am EST

  Found it
  
  .AsWorkbook().WorkbookSet.LanguagePackage =
  
  Create a new LanguagePackage class
  
  override string GetArgumentName
  
  override string GetArgumentDescription

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 18 May 2023, 6:35 pm EST

  Hello Niels,

  It is good to hear that you have found how to set the Parameter name and info in the customer function.
  
  As per the developers, there is no support for custom functions to change its category yet. They all belong to “User Defined”.

  You can implement the IIntelliSenseFunction interface and implement the following functions:

  *GetArgumentName
  
  GetDescription2
  
  GetArgumentDescription

  Regards,
  
  Prabhat Sharma.