freecad spreadsheet export loses units

Post here for help on using FreeCAD's graphical user interface (GUI).
Forum rules
and Helpful information
IMPORTANT: Please click here and read this first, before asking for help

Also, be nice to others! Read the FreeCAD code of conduct!
Post Reply
ubiquity
Posts: 63
Joined: Fri Nov 03, 2017 7:40 pm

freecad spreadsheet export loses units

Post by ubiquity »

When I export a spreadsheet to CSV the units included in the value cell are not exported, and consequently when reimported there are no units either.
Is there some way to overcome this?
I realise I can copy and paste but this rather defeats the purpose of the import/export functionality, especially as I need to send it to my students.

OS: Linux Mint 19.3 (X-Cinnamon/cinnamon)
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.19.24291 (Git) AppImage
Build type: Release
Branch: (HEAD detached at 0.19.2)
Hash: 7b5e18a0759de778b74d3a5c17eba9cb815035ac
Python version: 3.8.8
Qt version: 5.12.9
Coin version: 4.0.0
OCC version: 7.4.0
Locale: English/Australia (en_AU)
OS - Linux Mint 19 & Win10 (both 64bit)
IT Training & Support (retired)
Cheers Paul
User avatar
thomas-neemann
Veteran
Posts: 11801
Joined: Wed Jan 22, 2020 6:03 pm
Location: Osnabrück DE 🇩🇪
Contact:

Re: freecad spreadsheet export loses units

Post by thomas-neemann »

ubiquity wrote: Sat Nov 27, 2021 9:38 am
In my opinion, exporting from open source software is not necessary. everyone can use freecad and the original fcstd file.
Gruß Dipl.-Ing. (FH) Thomas Neemann

https://www.youtube.com/@thomasneemann5 ... ry=freecad
mario52
Veteran
Posts: 4673
Joined: Wed May 16, 2012 2:13 pm

Re: freecad spreadsheet export loses units

Post by mario52 »

Hi

tray this macro Macro_FCSpreadSheet_Extract Image

This macro save the spreadsheet data in a csv file with the formula or in a xml file.

mario
Maybe you need a special feature, go into Macros_recipes and Code_snippets, Topological_data_scripting.
My macros on Gist.github here complete macros Wiki and forum.
User avatar
adrianinsaval
Veteran
Posts: 5541
Joined: Thu Apr 05, 2018 5:15 pm

Re: freecad spreadsheet export loses units

Post by adrianinsaval »

ubiquity wrote: Sat Nov 27, 2021 9:38 amespecially as I need to send it to my students.
if it is for use in FreeCAD, just them a file that has only the spreadsheet
Post Reply