Is there a way to find all the dependents of a specific cell in a spreadsheet?
Here is an example use case:
- Spreadsheet cell B1 (Alias InnerDiameter): 10mm
- Spreadsheet cell B2 (Alias Thickness): 2mm
- Spreadsheet cell B3 (Alias OuterDiameter): =InnerDiameter + Thickness
- OneSketch -> Uses The InnerDiameter
- AnotherSketch -> Uses the OuterDiameter
I want to be able to Start from my "Thickness" cell in the spreadsheet and find all the dependents:
- Spreadsheet.OuterDiameter
- AnotherSketch
This is a simplified example; you can imagine how this is necessary for a complicated model where I have forgotten all the dependencies.
I've found this thread with Pythonic ways of tracing dependencies using OutList and InList properties:
https://forum.freecadweb.org/viewtopic. ... 53#p140415
As far as I can tell, I can't apply this to specific cells in spreadsheets. I can tell my spreadsheet affects just about everything in the design, but I already knew that.
Is there a way to trace dependents of a specific cell in spreadsheets?
Tracing dependents of a spreadsheet cell
Forum rules
and Helpful information
and Helpful information
IMPORTANT: Please click here and read this first, before asking for help
Also, be nice to others! Read the FreeCAD code of conduct!
Also, be nice to others! Read the FreeCAD code of conduct!
Re: Tracing dependents of a spreadsheet cell
Would Std DependencyGraph fit your need?
Re: Tracing dependents of a spreadsheet cell
I was about to say "that doesn't show me the cells inside the spreadsheet," but that's not correct. I remembered; it /does/ show the cells (at least the aliases in my case.)
However, without the ability to select a dependency arrow, I can't trace anything back. That's why I didn't even consider it.
Here is the middle third for my dependency graph: The spreadsheet is the sliver at the bottom with an umbilical cord of dependencies entering it. I hope you can see the challenge.
I also don't see any dependencies within the spreadsheet shown.
Is there a way to highlight an arrow? Or filter this graph just to show dependents of one or two specific items?
As a side note, I was never able to figure out a legend for the dependency graph describing the dashed arrows and significance of dashed boxes etc.