We are using the Aspose Cells.Net v7.0.3.0 library
. With reference to the below articles, we would like to retrieve the Precedents and Dependents of a cell. We are currently unable to retrieve the Dependent Cell values:
Hi,
Hi Amjad,
Hi,
I am afraid, this feature is not available and we will support it later.
As Amjad has already logged the New Feature Request in our database. Once, we will implement this feature or we have any other update for you, we will let you know asap.
Hi,
Please download and try this fix: Aspose.Cells for .NET v7.1.0.1
We have added Cells.GetDependents(bool isAll, int row,int column) method.
Hi Shakeel,
- Is there any difference between the “public Aspose.Cells.Cell[] GetDependents(bool isAll)” and “public Aspose.Cells.Cell[] GetDependents(bool isAll, int row, int column)” methods?
- Currently the above methods return the first-level (direct) dependency. Is there any API that would retrieve the in-direct (multi-level) dependencies also? I am not comfortable with looping and getting each cell dependency recursively and I dont think that would be a good idea… Please advice.
- Also please advice, what would be the best way to implement the above, keeping in consideration performance and memory management.
Hi,
1) Cells.GetDependents(bool isAll) is same as Cell.GetDependents(bool isAll, int row, int column)
The parameter “isAll” means whether to check all worksheets in the workbook.
2) and 3) We don’t support get multi-level dependents of the cell now. We will look into it later.
Thanks,
The issues you have found earlier (filed as CELLSNET-40294) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.