Spreadsheet module

Info about new community or project announcements, implemented features, classes, modules or APIs. Might get technical!
PLEASE DO NOT POST HELP REQUESTS OR OTHER DISCUSSIONS HERE!
Forum rules
Be nice to others! Respect the FreeCAD code of conduct!
User avatar
jriegel
Founder
Posts: 3369
Joined: Sun Feb 15, 2009 5:29 pm
Location: Ulm, Germany
Contact:

Re: Spreadsheet module

Post by jriegel »

The savest way is to have code working with the spread sheet is part of the modules, then its under certain control..

Werner and me had the same discussion about the python feature save/restore. Code in our documents is way to dangerous, especially when it comes to big standard parts libraries, or downloads from thingyverse...
If we fumble there, the fcstd files will show up on blacklists of anti virus programs and corporate fire walls. Then the user gets bombarded with security warning if he/she download, copy or transport fcstd files. Then we are basically dead in the water...

Its a bit drastic scenario ;) but we have to be alerted!

Anyway, the spreadsheet is a great tool without programign with it!
Stop whining - start coding!
pinniped
Posts: 17
Joined: Mon Jun 04, 2012 11:51 pm

Re: Spreadsheet module

Post by pinniped »

That's excellent. This will be extremely useful for people who have moderately complex parametric designs. I use SW and I always curse not being able to use a free spreadsheet to do some of my parametric tables.
User avatar
yorik
Founder
Posts: 13640
Joined: Tue Feb 17, 2009 9:16 pm
Location: Brussels
Contact:

Re: Spreadsheet module

Post by yorik »

jriegel wrote:Its a bit drastic scenario ;) but we have to be alerted!
Anyway, the spreadsheet is a great tool without programign with it!
Yes, you are right... After all this spreadsheet tool is basically meant to store spreadsheet data somewhere, not to perform extended operations. It is better to keep it simple anyway. Also because I feel that soon people would start to ask for features found in complete spreadsheet programs, which would be out of the scope here... Better to concentrate on making it compatible with other spreadsheet programs, which I intend to do soon (exporting/importing to a couple of common - and open - formats)
triplus
Veteran
Posts: 9471
Joined: Mon Dec 12, 2011 4:45 pm

Re: Spreadsheet module

Post by triplus »

Better to concentrate on making it compatible with other spreadsheet programs, which I intend to do soon (exporting/importing to a couple of common - and open - formats)
Probably ODF is the way to go for simple operations like this:

http://office.microsoft.com/en-gb/word- ... 78944.aspx

Microsoft Office has basic support for ODF 1.1 and Open/Libre Office uses ODF as default format/standard.
User avatar
yorik
Founder
Posts: 13640
Joined: Tue Feb 17, 2009 9:16 pm
Location: Brussels
Contact:

Re: Spreadsheet module

Post by yorik »

actually i was thinking of starting with even simpler stuff, like .csv or .dif... But who knows, if I can find a python lib to export to odf...
wmayer
Founder
Posts: 20243
Joined: Thu Feb 19, 2009 10:32 am
Contact:

Re: Spreadsheet module

Post by wmayer »

Qt already supports ODF from version 4.5 on: http://doc.qt.digia.com/qq/qq27-odfwriter.html
User avatar
yorik
Founder
Posts: 13640
Joined: Tue Feb 17, 2009 9:16 pm
Location: Brussels
Contact:

Re: Spreadsheet module

Post by yorik »

wmayer wrote:Qt already supports ODF from version 4.5 on: http://doc.qt.digia.com/qq/qq27-odfwriter.html
Oh! Excellent!!! Definitely, Qt rocks!
User avatar
NormandC
Veteran
Posts: 18587
Joined: Sat Feb 06, 2010 9:52 pm
Location: Québec, Canada

Re: Spreadsheet module

Post by NormandC »

triplus wrote:Microsoft Office has basic support for ODF 1.1
The Mac version of MS Office does not support ODF! A Mac user told me so.

ODF support would be nice, after all FreeCAD is an open source software and should prioritize open formats. But I think .csv should be provided as well.
kwahooo
Posts: 204
Joined: Wed May 19, 2010 11:11 pm
Contact:

Re: Spreadsheet module

Post by kwahooo »

There is even CSV module in Python.
User avatar
yorik
Founder
Posts: 13640
Joined: Tue Feb 17, 2009 9:16 pm
Location: Brussels
Contact:

Re: Spreadsheet module

Post by yorik »

Wow! I'm glad you guys get digging out those things... It's even a builtin module!
Post Reply