The promise of the spreadsheet
The promise of the spreadsheet
Just doesn't live up to expectations. Entering an alias always feels like a double chore, even with the macro.
You're viewing a single thread.
There really needs to be a variable system like there is on Assembly4, you can't even see the aliased value in spreadsheets without clicking into the cell (which constitutes a change so the entire project recomputes) so I end up having to make another adjacent with the variable name in text. But no, that doesn't work to just put in the name because the spreadsheet will interpret it as the variable since it is within the spreadsheet, you have to put quotes around it.
Also, changing an alias'd value in the spreadsheet on anything larger than an extremely basic part can take upwards of 5 minutes, even when solving the entire model only takes on the order of 10 seconds.
Spreadsheets are horrible in freecad.
This absolutely. Using variables is a very powerful feature which enables robust, solid and parametric modelling. The way it is implemented currently, however, is very crude. I have also had issues where when a cell refers to another cell further down in the spreadsheet, all sorts of mysterious bugs occur.
Would be nice if someone would implement a proper solution for this. I'd be willing to chip in on financial support if that would be required.