Bug 98836 - FILEOPEN Calc unable to open xlsx files created with SharpZipLib .NET
Summary: FILEOPEN Calc unable to open xlsx files created with SharpZipLib .NET
Status: RESOLVED DUPLICATE of bug 82984
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX File-Opening
  Show dependency treegraph
Reported: 2016-03-23 10:40 UTC by gabriel.sandor
Modified: 2021-07-14 08:29 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Calc unable to open the attached file when it should. (4.86 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-03-23 10:40 UTC, gabriel.sandor

Note You need to log in before you can comment on or make changes to this bug.
Description gabriel.sandor 2016-03-23 10:40:33 UTC
Created attachment 123789 [details]
Calc unable to open the attached file when it should.

LibreOffice Calc sees as invalid an xlsx file that is missing the "count" and "uniqueCount" attributes in the "sst" root element of the sharedStrings.xml file.

The SpreadsheetML specification states in section 18.4.9 that they are optional and can both be missing without any problems.

Other applications such as MS Excel can open the file without a glitch.
Comment 1 Cor Nouws 2016-03-23 11:05:32 UTC
Thanks for filing Gabriel. I confirm the issue.
Ciao - Cor
Comment 2 gabriel.sandor 2016-03-25 09:25:06 UTC
I just found the real cause of the failure to open the file in Calc.

It's not related to any of the XML files in the archive.

It's because of the archive itself, it was created programatically using the SharpZipLib .NET library and it seems Calc is unable to process the archive. I don't really know why, because the file can still be opened in MS Excel or unzipped with 7-Zip.
Comment 3 QA Administrators 2017-05-22 13:19:01 UTC Comment hidden (obsolete)
Comment 4 gabriel.sandor 2017-05-22 15:20:02 UTC
The bug is still present and acts the same in the latest version of LibreOffice (x64) on Windows 10 x64 version 1703.
Comment 5 QA Administrators 2018-05-23 02:37:16 UTC Comment hidden (obsolete)
Comment 6 Roman Kuznetsov 2019-03-24 10:56:50 UTC
still repro in

Version: (x64)
Build ID: 5a907fe76bc628629fddb5501727642468d38dae
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-03-22_00:18:04
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 7 NISZ LibreOffice Team 2021-07-14 08:29:01 UTC
7-Zip reports this is a Zip64 file, marking as duplicate.

*** This bug has been marked as a duplicate of bug 82984 ***