schupin wrote: ↑
Fri Apr 24, 2020 2:44 pm
Honestly, I don't really see what can have changed between those versions and I never had the courage to test the macro on "all" possible configurations.
Finally, it works!
Problem was the FreeCad version, with its libraries and Python too...
If I can, I would like to report you a trouble about the report on spreadsheets I've found: it's about measurement units. I've verified results of the macro are good because I'd same calculations on my own on a mine FreeCad job with internal spreadsheet... cell by cell
I launch the macron on a simple model and it works very well. Then I've exported the cvs file and imported, again, it on FreeCad: I need this datas on another FreeCad work, essentially an assembly of small parts like the one's I've tested.
I've found your macro exports values of volume in m^3 and density in kg/m^3. However, the internal spreadsheet of FreeCad work in mm^3, so I think the macro should do the same because of it's very simple to change measurement units just selecting a group of cells from GUI and change them, but only if underground datas are in mm, kg and other internal FreeCad measurement units. Otherwise, it need to transform values from report, cell by cell before... I do this because, since I work on small parts of model airplanes, I work in mm like FreeCad!
Look at follow image: it's a report from your great macro, when I've highlighted the only line I've modified.
I've change volume value this way:
and I've changed the density value this other:
Then, how you can see, using internal GUI, changing measurement units in coherent. I think, reanding some post from this same discussion, probably the right way is to create an option in macro GUI giving the ability of select "metric units" (like with density) so all people will be happy
Another question: if I would to help you or the FreeCad (I don't know) giving data about density of some materials most used by air modellers, how can I do it?