Removing cell-level auto-completion without losing other functionality

Removing cell-level auto-completion without losing other functionality

Posted by: benjamin.michaels on 14 February 2019, 10:43 am EST

• 

  benjamin.michaels

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 February 2019, 10:43 am EST

  Hello,
  
  In version 9, FormulaTextBox.autoComplete could be used to toggle the auto-completion of formulas in all use cases.
  
  In newer versions this only effects the FormulaBar itself. To stop formula auto-completion when typing directly into cells we were advised to set

  WorkBook.options.enableFormulaTextbox = false;
  

  This option stops auto-completion, but it also removes the ability to create a formula by clicking cells.
  
  We’re looking for a way to stop the auto-completion of formula without losing this other functionality. Is there a way we can do this?

  Thanks,
  
  Ben

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 17 February 2019, 9:28 pm EST

  Hello,

  We couldn’t find a way to enable range selection if enableFormulaTextbox is set to false. Hence, we have escalated your issue to the concerned team for further investigation. We will get back to you as soon as we hear anything from them.

  Tracking id for your issue is #267506

  Thanks,
  
  Reeva

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 5 March 2019, 8:39 pm EST

  Hello,

  Developer suggested to try below:

      GC.Spread.Sheets.FormulaTextBox.FormulaTextBox.prototype.add = function () {
          //do nothing
      }
  

  It will allow the select range and formula input, but not show help.

  Thanks,
  
  Deepak Sharma