FreeCADView Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002737 | FreeCAD | Bug | public | 2016-10-14 12:24 | 2016-10-16 16:09 |
| Reporter | mikeh | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | x86-64 | OS | Windows | OS Version | 10 |
| Product Version | 0.16 | ||||
| Fixed in Version | 0.17 | ||||
| Summary | 0002737: Importing LibreOffice generated .xlsx spreadsheeds are always empty | ||||
| Description | When importing a spreadsheet that was generated with LibreOffice Calc (both version 4 or 5, actual tested version that generated the attached test file: 5.1.5.2) and saved as "Microsoft Excel 2007-2013 XML (.xlsx)" document, FreeCad generates only an empty spreadsheet. No errors are reported, neither in the Python console, the Report view or the FreeCAD.log file. Tested both in FreeCAD 0.16.6706 and 0.17.8676 dev. | ||||
| Steps To Reproduce | - Create a new FreeCAD project - Go to the "Spreadsheet" workbench - Import a spreadsheet in Excel format written by LibreOffice Calc (see the attached file test.xlsx) - Open the newly generated spreadsheed Expected result: The spreadsheet contains the information from the Excel file (two cells filled in, one with the string "test", the other with the number "100") Actual result: The spreadsheet is empty. | ||||
| Additional Information | OS: Windows 10 Word size of OS: 64-bit Word size of FreeCAD: 64-bit Version: 0.16.6706 (Git) Build type: Release Branch: releases/FreeCAD-0-16 Hash: f86a4e411ff7848dea98d7242f43b7774bee8fa0 Python version: 2.7.8 Qt version: 4.8.7 Coin version: 4.0.0a OCC version: 6.8.0.oce-0.17 | ||||
| Tags | No tags attached. | ||||
| FreeCAD Information | |||||
|
|
|
|
|
When looking at the tooltip of the import function then it says: Import CSV file into spreadsheet Why do you assume that xlsx or any other format is allowed/supported? |
|
|
The documentation at http://www.freecadweb.org/wiki/index.php?title=Spreadsheet_Workbench says: "Spreadsheets in Excel-format "xlsx" can be imported into a FreeCAD document. Excel-spreadsheets can also be opened by FreeCAD." Edit: I just tried to *open* an Excel spreadsheet in 0.17 - that does indeed work. But *importing* does not work and generates an empty spreadsheet. As a workaround I can open the spreadsheet and copy/paste it to the project I want to import it into. |
|
|
In the 0.17 version there is a Python script importXLSX.py which does the loading of the Excel file. The script provides the methods "open" which is used for File > Open and "insert" which is used for File > Import. For me both ways work without problems. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-10-14 12:24 | mikeh | New Issue | |
| 2016-10-14 12:24 | mikeh | File Added: test.xlsx | |
| 2016-10-15 18:15 | wmayer | Note Added: 0007363 | |
| 2016-10-15 18:28 | mikeh | Note Added: 0007364 | |
| 2016-10-15 18:42 | mikeh | Note Edited: 0007364 | |
| 2016-10-16 16:09 | wmayer | Note Added: 0007388 | |
| 2016-10-16 16:09 | wmayer | Status | new => closed |
| 2016-10-16 16:09 | wmayer | Resolution | open => fixed |
| 2016-10-16 16:09 | wmayer | Fixed in Version | => 0.17 |
