Bug 131575 - FILEOPEN: LO can't open generated XLSX (without docsProps) that MSO opens - opens if [content_types].xml caps changed
Summary: FILEOPEN: LO can't open generated XLSX (without docsProps) that MSO opens - o...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks:
 
Reported: 2020-03-25 15:09 UTC by patrice.marchand
Modified: 2020-03-26 08:34 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
File xlsx (65.08 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-03-25 15:10 UTC, patrice.marchand
Details
Same file after Excel 2010 RT (72.28 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-03-25 15:49 UTC, Xisco Faulí
Details

Note You need to log in before you can comment on or make changes to this bug.
Description patrice.marchand 2020-03-25 15:09:42 UTC
Description:
When opening this simple xlsx file with calc, it says that the file is corrupted. With excel, no problem to open it. When you save it in excel and you reopen the file in calc it'OK. Problem with different version of LO : 6.4.2 , 6.3.5, ...
Thans for help

Steps to Reproduce:
1.Open xlsx file
2.
3.

Actual Results:
Dialog box saus corrupt file

Expected Results:
Dialog box saus corrupt file


Reproducible: Always


User Profile Reset: No



Additional Info:
Bug on several versions of CALC
Comment 1 patrice.marchand 2020-03-25 15:10:21 UTC
Created attachment 158990 [details]
File xlsx
Comment 2 Xisco Faulí 2020-03-25 15:45:57 UTC
Reproduced in

Version: 7.0.0.0.alpha0+
Build ID: 9163755e9f64a0b1dd5f2090e0702c19e31c12c9
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

Version: 5.2.0.0.alpha1+
Build ID: 5b168b3fa568e48e795234dc5fa454bf24c9805e
CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; 
Locale: ca-ES (ca_ES.UTF-8)

Version: 4.3.0.0.alpha1+
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e
Comment 3 Xisco Faulí 2020-03-25 15:48:45 UTC
Hello Patrice,
The issue goes away if I open it in MSO Excel 2010 and save it
Comment 4 Xisco Faulí 2020-03-25 15:49:16 UTC
Created attachment 158997 [details]
Same file after Excel 2010 RT
Comment 5 patrice.marchand 2020-03-25 15:56:56 UTC
Thanks for your answer
The problem is that the xlsx file is an automatic export from another software and users don't have Excel on their computers.
Thanks.
Comment 6 himajin100000 2020-03-25 16:34:57 UTC
when I change

[content_types].xml to [Content_Types].xml, the xlsx file can be opened.
Comment 7 himajin100000 2020-03-25 16:36:42 UTC
by the way, should we mark this bug as NOTOURBUG?
Comment 8 Xisco Faulí 2020-03-25 16:46:48 UTC
(In reply to patrice.marchand from comment #5)
> Thanks for your answer
> The problem is that the xlsx file is an automatic export from another
> software and users don't have Excel on their computers.
> Thanks.

Which software is it ?
To me, it seems the problem is in that software but otoh, Excel can import it without any problem as well... maybe we could do the same
Comment 9 himajin100000 2020-03-25 16:48:50 UTC Comment hidden (obsolete)
Comment 10 patrice.marchand 2020-03-26 07:14:55 UTC
Hi, 
The software is https://www.salviadeveloppement.fr/en/property-management/

We are a french administration, we have tried to deal with the company but they just answer us that it's only compatible with excel !

If possible, it could be nice to fix it.
Thanks a lot.

(In reply to Xisco Faulí from comment #8)
> (In reply to patrice.marchand from comment #5)
> > Thanks for your answer
> > The problem is that the xlsx file is an automatic export from another
> > software and users don't have Excel on their computers.
> > Thanks.
> 
> Which software is it ?
> To me, it seems the problem is in that software but otoh, Excel can import
> it without any problem as well... maybe we could do the same

Hi, 
The software is https://www.salviadeveloppement.fr/en/property-management/

We are a french administration, we have tried to deal with the company but they just answer us that it's only compatible with excel !

If possible, it could be nice to fix it.
Thanks a lot.
Comment 11 Timur 2020-03-26 08:31:38 UTC
Cause is that XLSX is not properly generated. docsProps folder is missing.
(In reply to himajin100000 from comment #6)
> when I change
> [content_types].xml to [Content_Types].xml, the xlsx file can be opened.
Good and strange.
And that makes it somewhat different to bug 122336 and bug 76115 where simple rezip helps.