Failed to get all dependent cells

[Mark Li]

Hi,

When a cell change, I want to get all dependent cells from it.

 I use the "this.Model.FormulaEngine.DependentCells" ,But  Sometimes miss some cells.

What ways I can totally get all dependent cells, whether it is hidden or not?

 

Thanks,

Mark

[Kanimozhi Bharathi]

Hi Mark Li,

Thank you for contacting Syncfusion Support.

We have analyzed your query. You cannot get the dependent cells when the cells are hidden, since hidden cells will not be considered while validating, hence if you could update us with the details of your requirement or the sample which explains your requirement, we will provide you a better solution. Please find the below sample which provides you a dependent cells list when you modify a cell value.

Sample link: http://www.syncfusion.com/downloads/support/forum/119643/ze/WpfApplication4-589034176

Please let us know if you have any queries.

Thanks

Kanimozhi B

[Mark Li]

Hi Kanimozhi B,

Please see the sample I attached. In the sample I use a GridControl and entered some value in the cells. This GridControl's rowCount is 35 and columnCount is 15, there is a Formula in the cell C34("=A1+B1"). Run this project , edit the cell A1 or B2,click the "Enter" button .

I set a breakpoint on a method ComputeDependentcells, then you will see the field dependentcells.Count is 0.It is incorrect , because the affected cell is C34.

[Kanimozhi Bharathi]

Hi Mark Li,

 

We have analyzed your query. The Dependent cells  will be updated only when they get into the view, otherwise it will be simply stored as a value. So to overcome this issue, we need to get the FormattedText of the particular cell. We have modified the sample based on your requirement. Please find the link below.

 

Sample link: http://www.syncfusion.com/downloads/support/forum/119643/ze/Dependent_CellDemo-1410010353

 

Please let us know if you have any queries.

 

Thanks

Kanimozhi B