FormulaTextBox doesn't update on showCell

FormulaTextBox doesn't update on showCell

Posted by: davide.vago on 13 August 2021, 5:40 am EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 13 August 2021, 5:40 am EST

  Dear support,

  Looking for the search feature within a Workbook I found and used a snippet from a colleague of yours (https://www.grapecity.com/forums/spreadjs/multiple-search-results-fr#helloyou-can-find-all-inst).

  It seems like the showCell method doesn’t update the formulaTextBox so when the user travel between different search results nothing changes in the formula bar.

  Would you please double check if there is some bug around that area?

  Thanks in advance

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 13 August 2021, 5:55 am EST

  The same applies to setActiveCell

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 16 August 2021, 2:57 am EST

  Hi Davide,

  This is expected behavior from SJS. After changing the selection we need to call formulaTextBox.refresh method. Please refer to the following code snippet and let us know if you face any issues.

  
  sheet.setActiveCell(row, col);
  fbxInstance.refresh(true)
  
  

  API References:
  
  referesh: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.FormulaTextBox.FormulaTextBox~refresh.html

  Regards
  
  Avinash