Finding Cell's Dependencies

Posted by: eladavn on 8 September 2017, 12:58 pm EST

  • Posted 8 September 2017, 12:58 pm EST

    <FONT face=Arial size=2><SPAN>Hi,<o:p></o:p></SPAN></FONT>


    <FONT face=Arial size=2><SPAN>Is there an API for finding all cells which a given cell is depended upon? E.g. suppose we have a cell with "=A1+B1" as its formula, I need an API which returns A1 and B1 for that cell.<o:p></o:p></SPAN></FONT>


    <FONT face=Arial size=2><SPAN><o:p> </o:p></SPAN></FONT>


    <FONT face=Arial size=2><SPAN>Thanks,<o:p></o:p></SPAN></FONT>


    <FONT face=Arial size=2><SPAN>Elad<o:p></o:p></SPAN></FONT>

  • Replied 8 September 2017, 12:58 pm EST

    Hello,


    There is not a way in the Spread control to determine the dependent cells of a cell with a formula. I will add this as a possible enhancement for a future version.

Need extra support?

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

Learn More

Forum Channels