cyclic dependancy detected?

[garya]

I'm probably blind. Checking out some things and ended up with this simple construction.
file attached.

Load File
Click on Spreadsheet to select it.
^C to copy
=> Result: DocumentObject::getOutListRecursive(): cyclic dependency detected!

I don't see any cycles there.
The cube gets its dimensions from the spreadsheet.
The cube's dimensions are used in expressions in other cells in the spreadsheet.
But there are no cycles.

The error can be delayed by double-clicking on the spreadsheet to display it,
then selecting the cube
clicking on the Box.Length data and trying to edit it by clicking the blue squiggle icon,
but it's the same error.

Clues? Bug? IUE? (Illiterate User Error)

OS: UNIX (freebsd)
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.18.dace2f39cf
Build type: Release
Python version: 2.7.15
Qt version: 4.8.7
Coin version: 3.1.3
OCC version: 7.3.0
Locale: C/Default (C)

[kisolre]

I don't think it can unroll this kind of dependency. Every object is calculated once on recalculate. And the dependent object is the spreadsheet and not each of its cells.
You can have two spreadsheets - one with dimensions and one with properties read from the model. This should work.

[garya]

I don't think it can unroll this kind of dependency. Every object is calculated once on recalculate. And the dependent object is the spreadsheet and not each of its cells.
You can have two spreadsheets - one with dimensions and one with properties read from the model. This should work.

Thanks, that's what I needed to know

[kisolre]

It was in the docs Expressions - known issues. Also take note that by default Spreadsheet numbers are unitless. I will make some experiments and post problems that could arise from that later.

[garya]

It was in the docs Expressions - known issues. Also take note that by default Spreadsheet numbers are unitless. I will make some experiments and post problems that could arise from that later.

Thanks, found that and something similar at end of spreadsheet. I'm working on spreadsheet and will be moving some things from there to expressions as soon as I have time -- stuff that is not unique to spreadsheet.

[kisolre]

Take a look at my post for unitless values for constraint/spreadsheet https://forum.freecadweb.org/viewtopic.php?f=3&t=34713

[garya]

Take a look at my post for unitless values for constraint/spreadsheet https://forum.freecadweb.org/viewtopic.php?f=3&t=34713

Thanks, will do.