Bug 91579 - Can't open xlsx file genrated by a delphi VCL component
Summary: Can't open xlsx file genrated by a delphi VCL component
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All Linux (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-05-24 14:04 UTC by Rico
Modified: 2017-10-01 00:47 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
file xlsx with problem (6.90 KB, application/zip)
2015-05-24 14:04 UTC, Rico
Details
backtrace log in Linux using LibreOffice 5.0.0.0.beta1 (2.41 KB, text/plain)
2015-05-24 17:01 UTC, Edmund Laugasson
Details
strace log in Linux with LibreOffice 5.0.0.0.beta1 (53.79 KB, text/plain)
2015-05-24 17:02 UTC, Edmund Laugasson
Details
the .xlsx file fixed in MS OneDrive (9.60 KB, application/vnd.openxmlformats-officedocument.spreadsheetml)
2015-05-24 17:05 UTC, Edmund Laugasson
Details
the original .xlsx file archive structure (58.54 KB, image/png)
2015-05-24 17:11 UTC, Edmund Laugasson
Details
the MS OneDrive fixed .xlsx file archive structure (33.12 KB, image/png)
2015-05-24 17:13 UTC, Edmund Laugasson
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rico 2015-05-24 14:04:48 UTC
Created attachment 115970 [details]
file xlsx with problem

Hello,

I use a delphi XE7 component to create xlsx files
My system is WIN7 64

The files can be openned with MS Office (no problem), but with LibreOffice I can't because I have this error : "The file is corrupted and can't be openend ..."

LibreOffice Calc doesn't show any detail info about why it can't open my files. I don't see how to start itemize the problem.

I attach one file and hope someboby could help me.

Thank in advance.

Best regards
Rico
Comment 1 Rico 2015-05-24 14:07:52 UTC
Libre Office version 4.4.3.2
Comment 2 tommy27 2015-05-24 16:26:15 UTC
I can't open that file too on Win8 using LibO 4.4.1
however I have no MS Excel to confirm the file can be opened
Comment 3 Edmund Laugasson 2015-05-24 17:01:41 UTC
Created attachment 115981 [details]
backtrace log in Linux using LibreOffice 5.0.0.0.beta1

Using 64-bit Linux Mint Cinnamon 17.1 with 4.0.4-040004-generic kernel
LibreOffice version: 5.0.0.0.beta1
Build ID: 0a16c3dda4150008d9be6f24cbd15ac198d116d3
Locale: et-EE (et_EE.UTF-8)

Could not open the file - seems to be broken.
Comment 4 Edmund Laugasson 2015-05-24 17:02:27 UTC
Created attachment 115982 [details]
strace log in Linux with LibreOffice 5.0.0.0.beta1

Using 64-bit Linux Mint Cinnamon 17.1 with 4.0.4-040004-generic kernel
LibreOffice version: 5.0.0.0.beta1
Build ID: 0a16c3dda4150008d9be6f24cbd15ac198d116d3
Locale: et-EE (et_EE.UTF-8)

Could not open the file - seems to be broken.
Comment 5 Edmund Laugasson 2015-05-24 17:05:37 UTC
Created attachment 115983 [details]
the .xlsx file fixed in MS OneDrive

Do not have MS Office either but everyone can use MS OneDrive at https://onedrive.live.com/ - I uploaded the file, made "Save with name" and replaced old file and then downloaded as .xlsx file.

Here is the fixed .xlsx file, which can be now opened without problems using LibreOffice 5.0.0.0.beta1 and I assume with older versions of LibreOffice also.
Comment 6 Edmund Laugasson 2015-05-24 17:11:45 UTC
Created attachment 115984 [details]
the original .xlsx file archive structure

This is the the original .xlsx file archive structure opened with Archive Manager 3.6.3 in 64-bit Linux Mint 17.1 Cinnamon - it seems that the original file structure is a bit damaged. This understanding comes when to look the MS OneDrive fixed file archive structure.
Comment 7 Edmund Laugasson 2015-05-24 17:13:14 UTC
Created attachment 115985 [details]
the MS OneDrive fixed .xlsx file archive structure

This is the MS OneDrive fixed .xlsx file archive structure opened with Archive Manager 3.4.3 in 64-bit Linux Mint 17.1 Cinnamon - it seems that the original file structure is a bit damaged but this file archive structure seems to be corrected.
Comment 8 Edmund Laugasson 2015-05-24 17:18:21 UTC
By the way - the MS OneDrive https://onedrive.live.com/ offers also download as ODS file.

This seems to be the result of UK's government battle - http://www.itproportal.com/2015/03/30/microsoft-will-adopt-open-document-standards-following-government-battle/ - which tells to have full ODF support. This certainly needs a deep investigation, how full the support is.
Comment 9 raal 2015-05-24 18:41:08 UTC
(In reply to tommy27 from comment #2)
> I can't open that file too on Win8 using LibO 4.4.1
> however I have no MS Excel to confirm the file can be opened

I can open file in excel 2010 without problems, setting to NEW
Comment 10 Cor Nouws 2015-05-26 15:10:19 UTC
3.6.6.1 asks for a filter, then throws an exception
3.3.4 and 3.3.0 crash immediately..
so an older problem.
Comment 11 Rico 2015-06-03 14:40:21 UTC
Hello,

Solution found here : http://stackoverflow.com/questions/30601475/delphi-system-zip-xlsx-libreoffice

Thanks to Arioch

Bad ZIP format specification

In fact, the developer of the Delphi component should use normal slashes "/", not back-slashes "\"
Comment 12 QA Administrators 2016-09-20 09:46:13 UTC Comment hidden (obsolete)
Comment 13 Aron Budea 2017-10-01 00:47:01 UTC
So it's not a LibreOffice issue. Let's close it as NOTABUG, then.
Comment 14 Aron Budea 2017-10-01 00:47:24 UTC
NOTOURBUG, I mean.