[Libreoffice-bugs] [Bug 144732] [FILEOPEN] Missing content from bare BIFF8 XLS Files

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144732

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTOURBUG
             Status|UNCONFIRMED                 |RESOLVED
           See Also|                            |https://bz.apache.org/ooo/s
                   |                            |how_bug.cgi?id=23425,
                   |                            |https://bz.apache.org/ooo/s
                   |                            |how_bug.cgi?id=44031,
                   |                            |https://bz.apache.org/ooo/s
                   |                            |how_bug.cgi?id=62752

--- Comment #7 from Mike Kaganski <mikekaganski at hotmail.com> ---
Code pointer:

ScFormatFilterPluginImpl::ScImportExcel starts importing the file.
In it, a call to XclImpStream::DetectBiffVersion returns EXC_BIFF5 (because the
file does not define a specific BIFF version). Later, in ImportExcel::Bof5, it
also reads subtype (bytes 06 and 07), that is 0x1000 in the bugdoc, while the
expected value is in the range 0x05 - 0x40. The result state in
ImportExcel::Read is Z_BiffNull, and nothing is read.

I tend to agree with comment 3, comment 5, and comment in
XclImpStream::DetectBiffVersion:

> there are some *really* broken documents out there...

So I close it as NOTOURBUG. The generator is just extra lazy, creating
something that only Excel seems to be able to comprehend (so they rely on "if
Excel didn't choke, it's good enough" approach, instead of implementing a
standardized output using published standards). If OP has any documentation
about ways to read such data that exercises Excel's extra-permissive rules of
the non-standardized files, please provide them and reopen the bug. Thanks.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210927/fcc6ffde/attachment-0001.htm>