We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to get the list of dependent cells for a particular cell?

Platform: UWP |
Control: SfSpreadsheet |
Published Date: July 27, 2016 |
Last Revised Date: July 27, 2016
Tags: formula

SfSpreadsheet provides support to get the list of dependent cells for a particular cell.

You can get the list of cells dependent on the cell by looping the PrecedentCells of FormulaEngine, like below code example.

C#

               

If you want to get the dependent cells of particular cell when its value changed, then subscribe the CellValueChanged event of Worksheet like below.

Spreadsheet.ActiveSheet.CellValueChanged += ActiveSheet_CellValueChanged;

private void ActiveSheet_CellValueChanged(object sender, CellValueChangedEventArgs e)

 {

        var list = GetDependentCells(e.Range.Row, e.Range.Column);

 }

 

 

Sample link:

 

WPF

 

WinForms

 

UWP

 

2X faster development

The ultimate UWP UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon