Formula bar: autocomplete when pressing Tab

Formula bar: autocomplete when pressing Tab

Posted by: lior.sharabi on 22 February 2023, 5:23 am EST

• 

  lior.sharabi

  • Post Options:
  • Link
    Copy

  Posted 22 February 2023, 5:23 am EST

  Hi SpreadJS

  in Excel when you click on the formula bar and start typing, an Autocomplete dropdown is appearing with suggestion for functions you can use.
  
  If you click on the “Tab” key the formula bar is autocompleting with one of the suggestion.

  i want the same behavior in SpreadJS but when i click Tab it just move to the next cell instead of autocompleting the formula.

  is it possible to do that?
  
  thanks a head.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 23 February 2023, 8:46 am EST

  Hello,

  You can enable the autocomplete in formula text box by removing the default command(navigationRight) from Tab key binding in command manager. You can use commandManager.setShortcutKey() method to unbind the default command from Tab key.

  Please refer to the code snippet and attached sample for further understanding.

  [code]// gets the host element of formula bar(formula text box)
  
  let formulaTextBoxHost = document.querySelector(‘[gcuielement=“gcAttachedFormulaTextBox”]’);
  
  formulaTextBoxHost.addEventListener(‘focus’, (e) => {
  
  commandManager.setShortcutKey(null, GC.Spread.Commands.Key.tab, false, false, false, false);
  
  });

  formulaTextBoxHost.addEventListener(‘focusout’, (e) => {
  
  commandManager.setShortcutKey(GC.Spread.Sheets.Commands.navigationRight, GC.Spread.Commands.Key.tab, false, false, false, false);
  
  });[/code]
  
  Sample: https://jscodemine.grapecity.com/share/0pnvyJbLhE6sh6dszRswIg/?defaultOpen={“OpenedFileName”%3A[“%2Findex.html”%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}
  
  Please let us know if the issue still persis.
  
  Doc reference:

  CommandManager class: https://www.grapecity.com/spreadjs/api/v16/classes/GC.Spread.Commands.CommandManager#class-commandmanager

  commandManager.setShortcutKey(): https://www.grapecity.com/spreadjs/api/v16/classes/GC.Spread.Commands.CommandManager#setshortcutkey

  regards,
  
  Avinash