Tracing formula dependencies

Posted by: ian.scriven on 13 March 2018, 3:02 pm EST

  • Posted 13 March 2018, 3:02 pm 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?
  • Replied 13 March 2018, 3:11 pm 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?
  • Replied 15 March 2018, 2: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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels