[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

Attila Szűcs  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |aszu...@gmail.com
   |desktop.org |
 Status|NEW |ASSIGNED

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

Justin L  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=94
   ||915

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #22 from Kevin Suo  ---
>From a person migrating from MSO to LibreOffice, I understand that this
(7-years old bug) is a key issue stoping them because the ERP software they
used, Kingdee, uses zip64 format when generating xlsx files, and they simply
can not open any xlsx files exported from their ERP using LibreOffice. A
workaround is to unzip their xlsx, and then zip again.

The following code comment:
// FIXME64: need to read the 64bit header instead

In
https://opengrok.libreoffice.org/xref/core/package/source/zipapi/ZipFile.cxx?r=d0a8d4a9#946
indicates that this is a core feature not yet implemented.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #21 from Ming Hua  ---
(In reply to Kevin Suo from comment #20)
> I pointed this out to help QA to determine whether a certain such bug is due
> to the using of backslash as file name separator (bug 76115), the use of
> ZIP64 (this bug), or other reasons, and mark as duplicate to the correct bug
> accordingly.
For QA purpose I think there are easier ways to identify files using zip64
format.

On Linux zipinfo has "-v" option which outputs a line like
A subfield with ID 0x0001 (PKWARE 64-bit sizes) and 16 data bytes:
d3 02 00 00 00 00 00 00 ef 00 00 00 00 00 00 00.
for each file that is compressed with zip64 format.

On Windows, 7-zip UI for archive content has a column indicating the file is
using zip64 format.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #20 from Kevin Suo  ---
(In reply to Ming Hua from comment #19)
I pointed this out to help QA to determine whether a certain such bug is due to
the using of backslash as file name separator (bug 76115), the use of ZIP64
(this bug), or other reasons, and mark as duplicate to the correct bug
accordingly.

Yes you are right, currently if the file is zipped using ZIP64, then it throws
an exemption in
https://opengrok.libreoffice.org/xref/core/package/source/zipapi/ZipFile.cxx?r=d0a8d4a9#950.
That is a FIXME and should be implemented.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

Ming Hua  changed:

   What|Removed |Added

 CC||ming.v@qq.com

--- Comment #19 from Ming Hua  ---
(In reply to Kevin Suo from comment #18)
> According to https://users.cs.jmu.edu/buchhofp/forensics/formats/pkzip.html:
> 
> 1. The first 4 bytes, "504b 0304" indicates that it is a zip file.
> 2. Bytes 19-22 denotes to "Compressed size". If archive is in ZIP64 format,
> then this is " ".
> 3. Bytes 23-26 denotes to "Uncompressed size". If archive is in ZIP 64
> format, then this is also " ".
I don't think reading zip file headers is necessary, as it seems to be already
read in
https://opengrok.libreoffice.org/xref/core/package/source/zipapi/ZipFile.cxx?r=d0a8d4a9#938
where nCompressedSize and nSize should correspond to the "Compressed size" and
"Uncompressed size" above.

(In reply to Kevin Suo from comment #16)
> File bugs which should be marked as a duplicate of this bug, in debugging
> the exception should be in:
> https://opengrok.libreoffice.org/xref/core/package/source/zipapi/ZipFile.
> cxx?r=d0a8d4a9#946
And here is tests if nCompressedSize or nSize is "0x" to see if Zip64
is needed, throwing exception if yes.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #18 from Kevin Suo  ---
The easiest way to identify whether an xlsx (zip) for is in ZIP64 format, under
linux, seems to be:

$ xxd ./test.xlsx
: 504b 0304 2d00  0800 4155 6e48 3c5c  PK..-.AUnH<\
0010: b548     1300 1400 5b43  .H[C
..

Each column is 2 bytes

According to https://users.cs.jmu.edu/buchhofp/forensics/formats/pkzip.html:

1. The first 4 bytes, "504b 0304" indicates that it is a zip file.
2. Bytes 19-22 denotes to "Compressed size". If archive is in ZIP64 format,
then this is " ".
3. Bytes 23-26 denotes to "Uncompressed size". If archive is in ZIP 64 format,
then this is also " ".

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

Kevin Suo  changed:

   What|Removed |Added

 Blocks||143352


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=143352
[Bug 143352] [META] XLSX (OOXML) Opening files from external generators
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #17 from Kevin Suo  ---
For ZIP64 specs, see
https://users.cs.jmu.edu/buchhofp/forensics/formats/pkzip.html
and
https://pkware.cachefly.net/webdocs/casestudies/APPNOTE.TXT

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

Kevin Suo  changed:

   What|Removed |Added

 CC||suokunl...@126.com

--- Comment #16 from Kevin Suo  ---
File bugs which should be marked as a duplicate of this bug, in debugging the
exception should be in:
https://opengrok.libreoffice.org/xref/core/package/source/zipapi/ZipFile.cxx?r=d0a8d4a9#946

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

Kevin Suo  changed:

   What|Removed |Added

 CC||plateauw...@qq.com

--- Comment #15 from Kevin Suo  ---
*** Bug 143958 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #14 from dongshili  ---
When will this BUG be solved?

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

NISZ LibreOffice Team  changed:

   What|Removed |Added

 CC||gabriel.san...@evozon.com

--- Comment #13 from NISZ LibreOffice Team  ---
*** Bug 98836 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 CC||79045_79...@mail.ru

--- Comment #12 from Roman Kuznetsov <79045_79...@mail.ru> ---
still repro in

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 7a0e0a84a02f505200331c19b28d45e898cd5a12
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded Jumbo

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

Version|4.3.0.4 release |Inherited From OOo
 OS|Linux (All) |All
   Severity|normal  |major

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||8244

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #11 from Krzysztof Rzymkowski  ---
Looks like LibreOffice (Version: 6.0.7.3, Build ID: 1:6.0.7-0ubuntu0.18.04.2)
has a hard requirement on just the zip version field. But only in Central
directory's "version needed to extract" (see:
https://en.wikipedia.org/wiki/Zip_(file_format)#Central_directory_file_header).
Looks like this version needs to less of equal to 30. Other version fields can
be 45: Local file header's version and "version made by" in central directory. 

For a Excel and LibreOffice compatible zip64  compressor implementation see:
https://github.com/rzymek/opczip/blob/master/src/main/java/com/github/rzymek/opczip/Zip64Impl.java

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 Blocks||108897, 109530
   Keywords||filter:xlsx


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
https://bugs.documentfoundation.org/show_bug.cgi?id=109530
[Bug 109530] [META] File opening issues
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #10 from Andreas Reichel  ---
This bug is still valid in LibreOffice Version: 6.1.3.2 (CPU threads: 16; OS:
Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc:
threaded).

I have created 2 files with the same content using Apache POI. One file is
ZIP64 and can be read by Gnumeric, but not LibreOffice. The other file has been
written without ZIP64 and can be read by LibreOffice 6.1.3.2

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #9 from Andreas Reichel  ---
Created attachment 147160
  --> https://bugs.documentfoundation.org/attachment.cgi?id=147160=edit
XLSX with ZIP64

This file can be read in Gnumeric, but fails in LibreOffice.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #8 from Andreas Reichel  ---
Created attachment 147159
  --> https://bugs.documentfoundation.org/attachment.cgi?id=147159=edit
XLSX without ZIP64

This file can be read in LibreOffice and Gnumeric.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #7 from Xisco Faulí  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice 
(5.4.1 or 5.3.6  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and 
your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave 
a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug-20170929

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #6 from William Mann  ---
As requested, I've confirmed that this bug still exists and it's behaviour is
the same as reported originally. I verified using LO 5.2.1.2 running on a
Kubuntu 16.04  64-bit system (linux kernel version is 4.4.0-38-generic).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #5 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice 
(5.1.5 or 5.2.1  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and 
your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave 
a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug-20160920

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #4 from William Mann wtm...@gmail.com ---
This bug is also confirmed on version:

Version: 5.0.0.5 
Build ID: 00m0(Build:5)

running on Linux Mint 17.2. Is zip going to be updated anytime soon? I'm
running into a lot of files that have been compressed with zip64 and unzipping
and rezipping is not really an end-user kind of thing. This is one of those
little things that keep some local governments (I work for a municipality)
from switching completely from a Microsoft-laden environment.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

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

--- Comment #3 from Aigars Mahinovs aigar...@gmail.com ---
Confirmed that this also affects files created with
https://xlsxwriter.readthedocs.org/ if use_zip64 option is used (which is
mandatory for large files).

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=82984

--- Comment #1 from William Mann wtm...@gmail.com ---
Created attachment 105138
  -- https://bugs.freedesktop.org/attachment.cgi?id=105138action=edit
Modified (rezipped) file that opens correctly.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=82984

Owen Genat owen.ge...@gmail.com changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #2 from Owen Genat owen.ge...@gmail.com ---
(In reply to comment #0)
 Current behavior:
 Error stating that file is damaged.

Confirmed under GNU/Linux using:

- v4.3.0.4 Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0
- v4.4.0.0.alpha0+ Build ID: e379401618268ed7f7f5885a36b90e1f4f6cd4af
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time:
2014-08-18_05:51:03

Status set to NEW.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs