Tracing formula dependencies

Tracing formula dependencies

Posted by: ian.scriven on 14 March 2018, 12:02 am EST

• 

  ian.scriven

  • Post Options:
  • Link
    Copy

  Posted 14 March 2018, 12:02 am EST

  Is it possible to trace dependencies between cells using Spread.Services?

  I imagine that the internal formula evaluation logic does this so it knows which cells need recalculation after a value is changed, but is this functionality exposed in the API?

• 

  ian.scriven

  • Post Options:
  • Link
    Copy

  Posted 14 March 2018, 12:11 am EST

  For example, if I had a spreadsheet where:
  
  A1: 1
  
  A2: 3
  
  A3: =A2
  
  A4: =A3+A1

  I want to be able to quickly (without manually parsing the formulas) determine that cell A4 depends on Cells A1, A2 and A3. Is that possible?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 15 March 2018, 11:17 am EST

  Hello Ian,

  There is no direct method to find about all the dependents cells of a Formula. we currently only have HasFormula property for cell/cell range which can tell you whether a cell has formula or not.

  Thanks,
  
  Deepak Sharma