View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0002474||Spreadsheet||Feature||public||2016-03-14 22:38||2021-11-24 15:22|
|Summary||0002474: Integrate LibreOffice Calc via GUI|
|Description||A convenient way to integrate a spreadsheet from LibreOffice Calc via GUI would be nice to have|
|Additional Information||The FreeCAD spreadsheets offer some awesome functionalities for FreeCAD while still being slim and fast. However, for some applications it is necessary to do more difficult calculations.|
Most of them would be more or less doable in FreeCAD spreadsheets but sometimes it can be more convenient to use a "full grown" spreadsheet program like LibreOffice Calc. For those cases an integration of LibreOffice Calc would be good.
If this is going to be implemented one difficulty might be to handle cell aliases. LibreOffice however has that feature, see https://help.libreoffice.org/Calc/Naming_Cells
Without a doubt, power of a full featured spreadsheet program should certainly be useful in a number of projects !
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/2011/10/oosheet-as-freecad-and-libreoffice.html which may present the beginning of a solution with 2 way (!) communication between a OO sheet and a FreeCAD model.
||@silopolis please open a forum thread to generate more community discussion on this topic. Thanks for the link. Very interesting.|
||Discussion opened here|
||Integration attempt happening in https://github.com/myoldz/FC_LibreOffice.git|
||Moved to https://github.com/myoldz/FC_Libre|
||This ticket has been migrated to GitHub as issue 5646.|
|2016-03-14 22:38||Spindoctor||New Issue|
|2017-01-19 14:23||Kunda1||Tag Attached: spreadsheet|
|2017-03-09 13:04||Kunda1||Relationship added||related to 0002957|
|2017-03-09 20:42||kkremitzki||Product Version||0.15 =>|
|2017-08-08 09:02||silopolis||Note Added: 0009881|
|2017-08-08 17:12||Kunda1||Note Added: 0009883|
|2017-08-12 19:14||silopolis||Note Added: 0009895|
|2017-12-13 15:27||Kunda1||Project||FreeCAD => Expressions|
|2020-03-14 21:59||Kunda1||Note Added: 0014230|
|2020-11-03 15:08||Kunda1||Note Added: 0014959|
|2020-11-03 15:12||Kunda1||Note Added: 0014960|
|2020-11-03 15:53||Kunda1||Note Edited: 0014960|
|2021-02-06 06:30||abdullah||Target Version||=> 0.20|
|2021-02-07 13:16||dprojects||Relationship added||related to 0004556|
|2021-11-24 15:22||chennes||Project||Expressions => Spreadsheet|