Bug 148833 - [FILEOPEN] QPW dropping sheets
Summary: [FILEOPEN] QPW dropping sheets
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
7.3.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-04-28 09:34 UTC by SheetJS
Modified: 2022-06-16 20:07 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
sample file (25.93 KB, application/x-ole-storage)
2022-04-28 13:09 UTC, Xisco Faulí
Details

Note You need to log in before you can comment on or make changes to this bug.
Description SheetJS 2022-04-28 09:34:36 UTC
Description:
LO is extracting only the first 256 worksheets from a QPW file, silently dropping other sheets.

Steps to Reproduce:
https://github.com/SheetJS/test_files/raw/master/q10test.qpw (download and open)

Actual Results:
Sheet "ZZZ" / "Sheet18278" is missing

Expected Results:
Sheet "ZZZ" has content in cell A1


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Comment 1 Xisco Faulí 2022-04-28 13:09:51 UTC
Created attachment 179824 [details]
sample file
Comment 2 Roman Kuznetsov 2022-05-01 19:20:01 UTC
I confirm the problem.

Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: c81f4a4ecbfa7dc97d8c28b5ec5f00d1d561b6bb
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL

Interesting that LibreOffice could open it but I didn't see the QPW extension in our file format list...

btw, LO Calc support only 10000 sheets in the one spreadsheet.
Comment 3 Julien Nabet 2022-06-16 20:07:41 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.

Just for info, it uses libwps lib.
Beginning of logs:
./soffice /tmp/q10test.qpw 
WPSDocument::isFileFormatSupported()
WPSHeader::constructHeader: find a Quatto Pro qpw spreadsheet
Throwing InvalidHeaderException
Throwing InvalidHeaderException
WPSDocument::isFileFormatSupported()
WPSHeader::constructHeader: find a Quatto Pro qpw spreadsheet
warn:oox.storage:1308993:1308993:oox/source/helper/zipstorage.cxx:68: ZipStorage::ZipStorage exception opening input storage com.sun.star.io.IOException message: "at /home/julien/lo/libreoffice/package/source/xstor/xfactory.cxx:260"
warn:oox:1308993:1308993:oox/source/crypto/DocumentDecryption.cxx:166: Encrypted package does not contain DataSpaceMap
Throwing InvalidHeaderException
WPSDocument::isFileFormatSupported()
WPSHeader::constructHeader: find a Quatto Pro qpw spreadsheet
Throwing InvalidHeaderException
AbiDocument::isFileFormatSupported
Found xml parser severity error Document is empty

WPSDocument::isFileFormatSupported()
WPSHeader::constructHeader: find a Quatto Pro qpw spreadsheet
PageSpan::get: can not find a master page name
...

But I don't know where's the 256 sheets limit.