View Issue Details

IDProjectCategoryView StatusLast Update
0002474ExpressionsFeaturepublic2020-03-14 21:59
ReporterSpindoctor Assigned To 
PrioritynormalSeverityfeatureReproducibilityN/A
Status newResolutionopen 
Summary0002474: Integrate LibreOffice Calc via GUI
DescriptionA convenient way to integrate a spreadsheet from LibreOffice Calc via GUI would be nice to have
Additional InformationThe 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
Tagsspreadsheet
FreeCAD Information

Relationships

related to 0002957 new please add spreadsheet direct printing 

Activities

silopolis

2017-08-08 09:02

reporter   ~0009881

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.
This way:
   * 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.

Kunda1

2017-08-08 17:12

administrator   ~0009883

@silopolis please open a forum thread to generate more community discussion on this topic. Thanks for the link. Very interesting.

silopolis

2017-08-12 19:14

reporter   ~0009895

Discussion opened here

Kunda1

2020-03-14 21:59

administrator   ~0014230

Integration attempt happening in https://github.com/myoldz/FC_LibreOffice.git

Issue History

Date Modified Username Field Change
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