Disable formula on FlexSheet Cell

Disable formula on FlexSheet Cell

Posted by: parmarav on 20 November 2017, 7:59 pm EST

• 

  parmarav

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 November 2017, 7:59 pm EST

  Hi Team,
  
  I want to disable formula evaluation on FlexSheet Cell. At the moment, when i enter “=” string in the cell with column Data Type = ‘Number’, a list of formula opens up. I do not want that. As the cell is with DataType = Number, “=” should not be allowed.

  Thanks
  
  Anshul Parmar

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 21 November 2017, 3:42 pm EST

  Hi Anshul,
  
  You may hide function opened formula list using hideFunctionList() method. You may prevent entering “=” by handling keydown event for FlexSheet.

  flex.hostElement.addEventListener("keydown",(e)=>{
  	// condition
  		e.preventDefault();
  		e.stopPropagation();
  },true);
  

  Hope it helps!

  ~Manish

• 

  parmarav

  • Post Options:
  • Link
    Copy

  Posted 21 November 2017, 4:47 pm EST

  Thanks Manish