As asked by kunda1 following my comment on issue #2474
about LibreOffice Calc integration via GUI, I'm opening this thread to drag others attention and comments on the subject.
Without a doubt, power of a full featured spreadsheet program should certainly be useful in a number of projects ! (see bug report above, as well as this post
). Plus, after more reading here, it appears (without surprise) that I'm not the first to think about using LO Calc in parallel of FC: @jmaustpc thought
about it already three years ago.
AFAIC, linking models to external spreadsheets presents another VERY important and powerful advantage that is being able to centralize and share parameters between models. This would allow me to put all common parameters in a LO Calc "project sheet", and link/dynamicaly import it in all parts and assembly files.
* modifying a parameter in the central sheet would "spread" into the whole project
* misses and errors in duplicating values and cells aliases in all spreadsheets in all project files would be avoided.
Looking for a solution for this, I found this page https://freecad-tutorial.blogspot.fr/20 ... ffice.html
which may present the beginning of a solution with 2 way (!) communication between a LO sheet and a FreeCAD model.
Reading more of the great documentation while writing this message, I discovered in the "Expressions" page that variables defined in spreadsheets can be referenced across FC documents, which provides a solution for the data sharing need
Just wish I had discovered this before diving in my current furniture project... For this, I think the "Cross-document linking" section of the "Expressions" documentation page would be better placed in the "Spreadsheet workbench" page.