View Issue Details

IDProjectCategoryView StatusLast Update
0002474SpreadsheetFeaturepublic2021-11-24 15:22
ReporterSpindoctor Assigned To 
PrioritynormalSeverityfeatureReproducibilityN/A
Status newResolutionopen 
Target Version0.20 
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

Relationships

related to 0002957 closedwmayer Spreadsheet please add spreadsheet direct printing 
related to 0004556 assignedchennes File formats allow export and import of ODS files 

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

Kunda1

2020-11-03 15:08

administrator   ~0014959

Moved to https://github.com/myoldz/FC_Libre

Kunda1

2020-11-03 15:12

administrator   ~0014960

Last edited: 2020-11-03 15:53

Another project thread by @salp (AKA myoldz on github) at https://forum.freecadweb.org/viewtopic.php?f=8&t=44005

yorik

2022-03-03 13:55

administrator   ~0016481

This ticket has been migrated to GitHub as issue 5646.

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
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