search

partkeepr / PartKeepr

Open Source Inventory Management
http://www.partkeepr.org
GNU General Public License v3.0
1.37k stars 397 forks source link

Exported xlsx cannot be opened in Excel #646

Open adis1987 opened 8 years ago

adis1987 commented 8 years ago

One example: In main meny click on Edit -> Projects Click on Export button on the project column side (left side) -> Export grid -> Excel 2007 or later When trying to open the file in excel (2013) it says that the file is not compatible and cannot be open.

Drachenkaetzchen commented 8 years ago

I can confirm the issue.

As a workaround you can use the CSV export until the bug is fixed

Drachenkaetzchen commented 8 years ago

The issue should now be solved. Please test against the demo system in one hour.

adis1987 commented 7 years ago

This fault still presists. In latest version 1.1.0 I still cannot export to excel. Even in demo

Drachenkaetzchen commented 7 years ago

I just double-checked and it works for me opening the .xlsx file in LibreOffice - I don't have MS Excel at hand. Do you receive a particular error message?

adis1987 commented 7 years ago

I tryed now to open it with google with same result, not working. The message in excel is just that is was possible to open it because it might be broken...

nealkfr commented 7 years ago

Just for documentation sake, I have experienced this same issue since first using partkeepr (1.1.0). I am using Office365 and upon opening the download I receive:

Excel cannot open the file 'export.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

Drachenkaetzchen commented 7 years ago

I was able to reproduce the issue. Unfortunately, there's no quick fix. OpenOffice and LibreOffice can open the sheets just fine - mainly because they interpret the actual contents and not the file extension.

The library we're using for exporting does only support exporting a single sheet and not a workbook, and that's what confuses MS Office.

Rescheduled for 1.3

FabPell980 commented 7 years ago

Same issue here. The exported file is an XML.