How to get all dependents of a sheet?

How to get all dependents of a sheet?

Posted by: eduardo.cobuci on 16 November 2022, 1:55 am EST

• 

  eduardo.cobuci

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 November 2022, 1:55 am EST

  Is there a way to retrieve all sheets that depend on any cell of a specific sheet (not a specific cell like “getDependents”).
  
  I’m asking this because I need to perform an operation after a sheet is renamed and I need to known all the other sheets that depend on the renamed one.

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 17 November 2022, 9:24 am EST

  Hi,

  You can iterate through the dataTable of the sheet’s json and see if a cell contains the formula, then use the formulaToExpression method to find the dependent sheet name.

  Sample: https://jscodemine.grapecity.com/share/0w7dbbz2p0aJHWwTI5dhCA/

  References:

  toJSON method: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#tojson

  formulaToExpression method: https://www.grapecity.com/spreadjs/api/modules/GC.Spread.Sheets.CalcEngine#formulatoexpression

  Regards,

  Ankit