Disable formula for specific cell in sheet

Disable formula for specific cell in sheet

Posted by: nam2.nguyen on 3 March 2025, 9:49 am EST

• 

  nam2.nguyen

  • Post Options:
  • Link
    Copy

  Posted 3 March 2025, 9:49 am EST

  Problem: Disable formula for specific cell in FlexSheet
  
  Description: “Disable formula” means that

  • Function list is not opened when user start cell with “=”
  • Formula is not resolved (i.e: “=1+1” remains as “=1+1”, “=sum(1,2)” remains as “=sum(1,2)”, =“A3” remains as “=A3”
    
    However, other cells are allowed to use formula as default, specifically means that
  • Function list is opened when user start cell with “=”
  • Formula is resolved (i.e: “=1+1” resolved as “2”, “=sum(1,2)” resolved as “3”, =“A3” resolved as value of cell at A3 position
• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 4 March 2025, 1:57 am EST

  Hello,

  There isn’t any built-in API to disable formula evaluation on specific cells. However, you can workaround this with some of the FlexGrid event handlers. Here is a sample demonstrating how you can achieve the same:
  
  https://stackblitz.com/edit/vue-example-1-sm9b3hym?file=src%2FApp.vue

  Hope it helps.

  Regards