I mean, in the SpreetSheet table, I can insert any value, but how can I link a value to any custom variable?
I mean, (=Wall002.height) = W002H, is this possible?
Not being an Arch expert I can only give general advice: You have to do this in the place where you would enter the height if you set it to a constant value. At the right of the input fiels you should see a blue f(x) symbol. Click it. Enter Spreadsheet.W002H.
The Expressions mechanism is a pull, not a push mechanism.
Do you mean you want to set an alias to a cell of a spreadsheet? Alias can be used to give a custom name. Then you can use this name when setting parameters in your model.
Another method to keep in mind is using the Dynamic Data workbench: https://github.com/mwganson/DynamicData
But spreadsheet is the obvious solution.
Linking ArchWall attributes (height and width) to cells in spreadsheet
Test_ Spreadsheet_ ArchWall.FCStd (12.8 KB)
thanks, guys, very nice suggestion, not exactly what I was searching for but anyway work, I was expecting something like excel/LibreOffice-calc method.
DynamicData looks awesome, I use it with time.
how can I mark this post as Solved?
I just want to add one more thing, DynamicData workbench is the perfect alternative to AutoCAD Dynamic Blocks, maybe should be pre-installed with FreeCAD.
You can start a thread discussion about this
sorry If I re-open this post, what is the way to link the spreadsheet Cell with a Sketch Contrains with Name WH1?
3D sketch.FCStd (20.3 KB)
The names are case sensitive. So if you want to reference ‘WH1’ in your spreadsheet you should use:
=Sketch004.Constraints.WH1
I love FreeCAD so much