jaisejames wrote:Say cupboard external size 2 x 1.2 x 2ht meter. Final assembled size.
What I understand is that you need final size of the furniture (cupboard in this case)? But this macro creates spreadsheet (list) with parts (chipboards made of FreeCAD cube objects) to cut (in market or cut service). This is not for showing final furniture dimensions, this you can already achieve with TechDraw easily or by normal dimensioning and measuring option in FreeCAD (just by measuring the furniture edges n the 3D model).
I would propose another macro for that, something like "measuring 3D objects" or something like that and then we should think about, how to measure or how to find the most outer edges of the furniture. If I understand what you mean correctly.
jaisejames wrote:I need to add some extrusions & clamps etc along with quantity.
Cutting service don't care about final furniture size or other things not related to cutting wood. You need to know all those things at the design model step, during cutting is too late. Also it would mess up the spreadsheet list. Sorry. Consider FreeCAD TechDraw module instead.
jaisejames wrote:Ok. Thank you for support.
You are welcome. Waiting for more comments and issues.
salp wrote: ↑Thu Dec 07, 2017 1:13 am
Python 3 tools have greatly simplified the process, I have tested some code to manipulate LibreOffice (any module not just calc) and it's pretty straight forward in a regular python session.
From what I've seen the current spreadsheet workbench is extremely useful but limited, if we can automate the process of launching LibreOffice in the background ad establish the communications link with FreeCAD automatically without any user intervention then we will gain all the functionality of LibreOffice and we can concentrate on the code to only transfer data in both directions.
I know this is very vague, I'm hoping to be able to post the initial macro code by the end of the month.
salp wrote: ↑Thu Dec 07, 2017 1:13 am
Python 3 tools have greatly simplified the process, I have tested some code to manipulate LibreOffice (any module not just calc) and it's pretty straight forward in a regular python session.
From what I've seen the current spreadsheet workbench is extremely useful but limited, if we can automate the process of launching LibreOffice in the background ad establish the communications link with FreeCAD automatically without any user intervention then we will gain all the functionality of LibreOffice and we can concentrate on the code to only transfer data in both directions.
I know this is very vague, I'm hoping to be able to post the initial macro code by the end of the month.
Sal
Interesting, I haven't tested this yet but if this preserve spreadsheet formating (bold text and table borders), this should be fine for me.
dprojects wrote: ↑Fri Mar 10, 2017 3:57 pm
Any comments and issues are welcome.
Great script. It was almost exactly what I was looking for.
Is there a nice way to set the display units to inches in the Macro? This would be much nicer than having to edit the cells in the spreadsheet using the UI.
acousticguy wrote: ↑Sun Feb 10, 2019 6:38 pm
Is there a nice way to set the display units to inches in the Macro? This would be much nicer than having to edit the cells in the spreadsheet using the UI.
this should be recalculated to square inches or just removed.
acousticguy wrote: ↑Sun Feb 10, 2019 6:38 pm
Great script. It was almost exactly what I was looking for.
Why almost? only because of the metric system or there is something more that could be changed?
Thanks for the issue. I will try to release also version for US metric system (but I have to learn it first because I am not from US) and will release it. Tell me exactly what You need there.
dprojects wrote: ↑Mon Feb 11, 2019 8:42 am
Thanks for the issue. I will try to release also version for US metric system (but I have to learn it first because I am not from US) and will release it. Tell me exactly what You need there.
Hey dprojects, can you also make sure that the script is py3/qt5 friendly (by testing it in the py3/qt5 Conda appimage (if you're on linux) ?