Download it now!
Bug 124525 - FILEOPEN Calc doesn't open XLSX archive - opens if extracted and rezipped
Summary: FILEOPEN Calc doesn't open XLSX archive - opens if extracted and rezipped
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: XLSX File-Opening
  Show dependency treegraph
 
Reported: 2019-04-03 12:21 UTC by Roman Kuznetsov
Modified: 2020-03-28 07:28 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
XLSX file (7.81 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-04-03 12:22 UTC, Roman Kuznetsov
Details
XLSX file after resaving with MS Excel 2016 (10.18 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-04-03 19:47 UTC, Bartosz
Details
XLSX file after manual resave (8.31 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-04-03 20:32 UTC, Bartosz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2019-04-03 12:21:56 UTC
Description:
Calc doesn't open XLSX file

Steps to Reproduce:
1. Try open attached XLSX file


Actual Results:
Calc doesn't open the file

Expected Results:
Calc opens file fine


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.3.0.0.alpha0+
Build ID: d31d77b7199ecc9a7edc899d9703e9da52d5cbd1
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-04-01_00:04:09
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 1 Roman Kuznetsov 2019-04-03 12:22:33 UTC
Created attachment 150508 [details]
XLSX file
Comment 2 Xisco Faulí 2019-04-03 13:58:11 UTC
Reproduced in

Version: 6.3.0.0.alpha0+
Build ID: 93f1c3665fcdc31c36078f179ac37fd69d3ebb00
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

and

Versió: 6.1.4.2
ID de la construcció: 1:6.1.4-0ubuntu0.16.04.1~lo2
Fils de CPU: 4; SO: Linux 4.15; Renderitzador de la IU: per defecte; VCL: gtk3; 
Configuració local: ca-ES (ca_ES.UTF-8); Calc: group threaded

in previous versions of LibreOffice it crashes at import time...
Comment 3 Xisco Faulí 2019-04-03 13:59:01 UTC
@Mike, I thought you might be interested in this issue...
Comment 4 Bartosz 2019-04-03 19:47:46 UTC
Created attachment 150517 [details]
XLSX file after resaving with MS Excel 2016

After resaving with MS Excel 2016, LibreOffice is opening document successully
Comment 5 Eike Rathke 2019-04-03 19:59:48 UTC
Fwiw, it happens in package/source/zippackage/ZipPackage.cxx look out for three places with

 throw css::packages::zip::ZipIOException("Bad Zip File, stream as folder");

It might be the zip is erroneous, but it might also be the code is confused at some point when looking for a _rels name and there are directories _rels and xl/_rels (though both should have the folder flag it seems at least one doesn't), didn't dig deeper.
Comment 6 Bartosz 2019-04-03 20:32:23 UTC
Created attachment 150518 [details]
XLSX file after manual resave

After recreating archive with the same files, the .xlsx could be opened via LibraOffice Calc.

I suspect that the problem is with the archive which couldn't be read propelry via LibreOffice
Comment 7 Xisco Faulí 2019-07-18 11:45:15 UTC Comment hidden (obsolete)
Comment 8 Roman Kuznetsov 2020-01-10 14:05:06 UTC
still repro in

Version: 6.5.0.0.alpha0+ (x64)
Build ID: b6295e4a1b7735c148174f44f6d28221f4f52302
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 9 Timur 2020-03-28 07:28:31 UTC
Similar to bug 76115  opens if extracted and rezipped.
But there #The problem is that the zip has "\" instead of "/" as the separators.# which may not be here.