View underlying arithmatic function for a cell

View underlying arithmatic function for a cell

Posted by: chayankar209 on 23 May 2018, 1:16 am EST

• 

  chayankar209

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 May 2018, 1:16 am EST

  Hi,

  I am calculating the value for a flexsheet cell on the fly and setting the data. I am using the FlexSheet.evaluate function. Below is the code snippet:

  let value = this.flxSheet.evaluate(‘=sum(B2,C2)’,‘D2’,sheet, true);
  
  this.flxSheet.setCellData(1,3,value ,false,true);

  The value is setting in the field properly. But I want the user to view the underlying arithmatic expression which is “=sum(B2,C2)”, when the user clicks on the cell.

  Is this achievable ? If yes, then how ?

  Thank you !!

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 24 May 2018, 9:58 am EST

  Hi,
  
  You may set direct formula in the cell using setCellData method. Please refer to the following code snippet for the same.

  this.flexSheet.setCellData(1,3,'=Sum(B2,C2)');
  

  ~Manish