Tracing dependents of a spreadsheet cell

Post here for help on using FreeCAD's graphical user interface (GUI).
Forum rules
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!
Post Reply
berka
Posts: 88
Joined: Sat Aug 22, 2015 9:08 pm

Tracing dependents of a spreadsheet cell

Post by berka »

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?
openBrain
Veteran
Posts: 9041
Joined: Fri Nov 09, 2018 5:38 pm
Contact:

Re: Tracing dependents of a spreadsheet cell

Post by openBrain »

Would Std DependencyGraph fit your need?
berka
Posts: 88
Joined: Sat Aug 22, 2015 9:08 pm

Re: Tracing dependents of a spreadsheet cell

Post by berka »

openBrain wrote: Mon Dec 28, 2020 3:27 pm Would Std DependencyGraph fit your need?
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:
Screen Shot 2020-12-28 at 23.25.01.png
Screen Shot 2020-12-28 at 23.25.01.png (171.31 KiB) Viewed 192 times
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.
Post Reply