How to hide flexsheet arithmatic functions popup?

How to hide flexsheet arithmatic functions popup?

Posted by: chayankar209 on 3 September 2018, 2:45 am EST

• 

  chayankar209

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 September 2018, 2:45 am EST

  I want to disable the flexsheet arithmatic functions popup which appears once user types “=”.

  I’ve tried using the following code:
  
  flex.hostElement.addEventListener(“keydown”,(e)=>{
  
  // condition: If key is “=” then
  
  e.preventDefault();
  
  e.stopPropagation();
  
  },true);

  But this prevents “=” from rendering on the selected cell.

  However, I want the user to enter formulas using basic arithmatic operators, without using the arithmatic fucntions.

  I also tried using the Flexsheet.hideFunctionList, but I am not getting desired result.

  For the record we have purchased wijmo license, so I seek quality assistance from the support.

  Thank you,
  
  Chayan

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 4 September 2018, 4:43 am EST

  Hi Chayan,

  We are currently working on this and it is taking a bit longer.
  
  We will update you soon on this.

  Thanks
  
  Sharad

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 29 October 2018, 6:18 am EST

  Hi Chayan,

  From build 5.20182.536+, a new property named ‘enableFormulas’ is added to the flexSheet to handle enable/disable formulas as required.
  
  You may confirm the same from the following sample which uses the nightly build 5.20182.536:
  
  https://stackblitz.com/edit/angular-rumpy2?file=app%2Fapp.component.html

  Note: Nightly builds are suitable for production and hence should not be used in production builds.

  ~Sharad