Formula Suggestions in custom input field

Formula Suggestions in custom input field

Posted by: sathwik.kotla on 31 October 2022, 2:03 am EST

• 

  sathwik.kotla

  • Post Options:
  • Link
    Copy

  Posted 31 October 2022, 2:03 am EST - Updated 31 October 2022, 2:08 am EST

  I am building a custom component, I want to invoke the formula helper from my custom component.
  
  

  The second thing is I want to make changes so that I can see the text typed in the input HTML element in the active cell the same as the formula bar behaves. You can refer to the same in the attached video.
  
  

  Thanks and regards
  
  Sathwik

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 1 November 2022, 1:07 am EST

  Hi,

  I am building a custom component, and I want to invoke the formula helper from my custom component.

  We are sorry but currently, there is no API available for opening the formula suggestion drop-down. We are sorry for the inconvenience.

  The second thing is I want to make changes so that I can see the text typed in the input HTML element in the active cell the same as the formula bar behaves. You can refer to the same in the attached video.

  The formula is implemented using the FormulaTextBox control. if you want its feature you could implement it by calling its constructor. Please refer to the following demo that explains the same.

  Demo: https://www.grapecity.com/spreadjs/demos/features/calculation/formula-textbox/range-select#demo_source_name

  regards,
  
  Avinash