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
Posts: 6223
Joined: Thu Jan 05, 2017 9:03 pm

Dedicated Spreadsheet Workbench Maintainer/Devs needed

Postby Kunda1 » Sat Nov 09, 2019 1:04 pm

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
Want to contribute back to FC? Checkout:
#lowhangingfruit | Use the Source, Luke. | How to Help FreeCAD | How to report FC bugs and features
User avatar
Kunda1
Posts: 6223
Joined: Thu Jan 05, 2017 9:03 pm

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Postby Kunda1 » Fri Nov 15, 2019 12:57 pm

anyone ?
Want to contribute back to FC? Checkout:
#lowhangingfruit | Use the Source, Luke. | How to Help FreeCAD | How to report FC bugs and features
User avatar
Joel_graff
Posts: 1617
Joined: Fri Apr 28, 2017 4:23 pm
Contact:

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Postby Joel_graff » Fri Nov 15, 2019 4:35 pm

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
Posts: 2464
Joined: Thu Oct 18, 2018 9:18 pm

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Postby vocx » Fri Nov 15, 2019 4:58 pm

Joel_graff wrote:
Fri Nov 15, 2019 4:35 pm
... LO integration would be great GSOC projects - especially LO Calc.
...
What is LO?
To support the documentation effort, and code development, your donation is appreciated: paypal.
User avatar
kkremitzki
Posts: 1834
Joined: Thu Mar 03, 2016 9:52 pm
Location: Texas

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Postby kkremitzki » Fri Nov 15, 2019 5:38 pm

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
Posts: 2464
Joined: Thu Oct 18, 2018 9:18 pm

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Postby vocx » Fri Nov 15, 2019 7:36 pm

kkremitzki wrote:
Fri Nov 15, 2019 5:38 pm
https://www.libreoffice.org/
Oh. I just hate the use of too many acronyms.
To support the documentation effort, and code development, your donation is appreciated: paypal.
triplus
Posts: 8898
Joined: Mon Dec 12, 2011 4:45 pm

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Postby triplus » 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".
ulrich1a
Posts: 1920
Joined: Sun Jul 07, 2013 12:08 pm

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Postby ulrich1a » Fri Nov 15, 2019 9:21 pm

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
Posts: 6223
Joined: Thu Jan 05, 2017 9:03 pm

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Postby Kunda1 » Fri Nov 29, 2019 1:10 pm

Anyone willing to step-up and fix these bugs before 0.19 release?
Want to contribute back to FC? Checkout:
#lowhangingfruit | Use the Source, Luke. | How to Help FreeCAD | How to report FC bugs and features
ezzieyguywuf
Posts: 637
Joined: Tue May 19, 2015 1:11 am

Re: Dedicated Spreadsheet Workbench Maintainer/Devs needed

Postby ezzieyguywuf » Fri Nov 29, 2019 1:35 pm

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.