Dedicated Spreadsheet Workbench Maintainer/Devs needed

Have some feature requests, feedback, cool stuff to share, or want to know where FreeCAD is going? This is the place.
Forum rules
Be nice to others! Read the FreeCAD code of conduct!
User avatar
Kunda1
Veteran
Posts: 13434
Joined: Thu Jan 05, 2017 9:03 pm

Dedicated Spreadsheet Workbench Maintainer/Devs needed

Post by Kunda1 »

Anyone interested in helping to maintain/develop/fix/triage the Spreadsheet Workbench. It is getting to be a pretty popular part of users FC workflow and there is a backlog of bugs and feature requests:

issue #4197 - Crash on Recompute With Expression as PropertyString Value
issue #4196 - Expression parser does not allow "/" after first member
issue #4192 - Set an expression with many objects at the same time
issue #4191 - Freecad 0.19pre crashes in spreadsheet
issue #4003 - Renaming spreadsheet no longer has any affect on field tags.
issue #4037 - rewrite unit handling so that unit prefixes will be recognized
issue #4031 - Crash upon solving expression referencing named Constraint
issue #4015 - Expression "jumps" to new object when created
issue #3981 - Add Expression support to certain fields
issue #3925 - Negative numbers with multiple units interpeted as expressions
issue #3839 - Support to update sketch when changing values in a spreadsheet
issue #3696 - Constraints lose values upon reloading file.
issue #3518 - Expressions (fx) not updated
issue #3487 - Add ability to copy objects with expressions linked to spreadsheet
issue #3466 - Control objects visibility via expressions and spreadsheets cells
issue #3460 - Add the following functions to expressions and spreadsheet: concatenate text and indirect
issue #3448 - Failed to parse expression
issue #3391 - Array and dictionary lookup does not work in expressions
issue #3379 - Certain identifiers (like h, rad) cannot be used as names for constraints for usage in expressions
issue #3272 - Failed to parse expression occurs when referencing an alias in an external spreadsheet document
issue #3271 - Relative file references give 'Document not found' unless that file is opened first
issue #3255 - Use consistent angle measure for expressions
issue #2957 - please add spreadsheet direct printing
issue #2766 - Expression link is cuting by creating new object
issue #2477 - Copy of sub objects with expression pointing to a spreadsheet shall not create a new spreadsheet
issue #2474 - Integrate LibreOffice Calc via GUI
issue #2472 - Spreadsheet - Move Cells
issue #2467 - Expression auto-completer slows down FreeCAD
issue #2100 - Spreadsheet: Additional Inverse Display Units

Also, there is a need for better scripting documentation of the Spreadsheet Workbench#Scripting Basics
Alone you go faster. Together we go farther
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
'good first issues' | Open TODOs and FIXMEs | How to Help FreeCAD | How to report Bugs
User avatar
Kunda1
Veteran
Posts: 13434
Joined: Thu Jan 05, 2017 9:03 pm

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Post by Kunda1 »

anyone ?
Alone you go faster. Together we go farther
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
'good first issues' | Open TODOs and FIXMEs | How to Help FreeCAD | How to report Bugs
User avatar
Joel_graff
Veteran
Posts: 1949
Joined: Fri Apr 28, 2017 4:23 pm
Contact:

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Post by Joel_graff »

I'm definitely interested in seeing improvement here.

Setting up FC for dev on my machine has always been problematic, so I don't know that I can contribute directly. However, I think both improving the Spreadsheet module and LO integration would be great GSOC projects - especially LO Calc.

Maybe we could at least identify a path for getting LO integration to work? I have a few of the details worked out, but really no idea. Would happily mentor a GSocC student next year, though. :)
FreeCAD Trails workbench for transportation engineering: https://www.github.com/joelgraff/freecad.trails

pivy_trackers 2D coin3D library: https://www.github.com/joelgraff/pivy_trackers
vocx
Veteran
Posts: 5197
Joined: Thu Oct 18, 2018 9:18 pm

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Post by vocx »

Joel_graff wrote: Fri Nov 15, 2019 4:35 pm ... LO integration would be great GSOC projects - especially LO Calc.
...
What is LO?
Always add the important information to your posts if you need help. Also see Tutorials and Video tutorials.
To support the documentation effort, and code development, your donation is appreciated: liberapay.com/FreeCAD.
User avatar
kkremitzki
Veteran
Posts: 2511
Joined: Thu Mar 03, 2016 9:52 pm
Location: Illinois

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Post by kkremitzki »

Like my FreeCAD work? I'd appreciate any level of support via Patreon, Liberapay, or PayPal! Read more about what I do at my blog.
vocx
Veteran
Posts: 5197
Joined: Thu Oct 18, 2018 9:18 pm

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Post by vocx »

kkremitzki wrote: Fri Nov 15, 2019 5:38 pm https://www.libreoffice.org/
Oh. I just hate the use of too many acronyms.
Always add the important information to your posts if you need help. Also see Tutorials and Video tutorials.
To support the documentation effort, and code development, your donation is appreciated: liberapay.com/FreeCAD.
triplus
Veteran
Posts: 9471
Joined: Mon Dec 12, 2011 4:45 pm

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Post by triplus »

In my opinion we won't "Integrate LibreOffice Calc via GUI" into Spreadsheet workbench anytime soon, as that is just (technically) unrealistic. Best to close the issue as "won't fix".
ulrich1a
Veteran
Posts: 1957
Joined: Sun Jul 07, 2013 12:08 pm

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Post by ulrich1a »

triplus wrote: Fri Nov 15, 2019 8:58 pm In my opinion we won't "Integrate LibreOffice Calc via GUI" into Spreadsheet workbench anytime soon, as that is just (technically) unrealistic. Best to close the issue as "won't fix".
I agree to this statement. The spreadsheet in FreeCAD handles objects like properties of shapes where no counterparts exist in LibreOffice.

Ulrich
User avatar
Kunda1
Veteran
Posts: 13434
Joined: Thu Jan 05, 2017 9:03 pm

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Post by Kunda1 »

Anyone willing to step-up and fix these bugs before 0.19 release?
Alone you go faster. Together we go farther
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
'good first issues' | Open TODOs and FIXMEs | How to Help FreeCAD | How to report Bugs
ezzieyguywuf
Posts: 656
Joined: Tue May 19, 2015 1:11 am

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Post by ezzieyguywuf »

Kunda1 wrote: Fri Nov 29, 2019 1:10 pm Anyone willing to step-up and fix these bugs before 0.19 release?
I can take a look. I’ll put a pause on my other freecad projects for a few days and try to wrap my head around these spreadsheet improvements.
Post Reply