Need to disable formula for specific cell in sheet

Need to disable formula for specific cell in sheet

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

• 

  nam2.nguyen

  • Post Options:
  • Link
    Copy

  Posted 3 March 2025, 9:51 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 5 March 2025, 9:29 am EST

  Hello,

  We have already provided updates on your support ticket along with the additional forum ticket you created. Please refer to the following forum link for reference: https://developer.mescius.com/forums/spreadjs/disable-formula-for-specific-cell-in-sheet

  Regards