[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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&action=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
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&action=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
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
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
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
https://bugs.documentfoundation.org/show_bug.cgi?id=82984 --- Comment #4 from William Mann --- 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
https://bugs.documentfoundation.org/show_bug.cgi?id=82984 --- Comment #3 from Aigars Mahinovs --- 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
https://bugs.freedesktop.org/show_bug.cgi?id=82984 Owen Genat changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #2 from Owen Genat --- (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
[Libreoffice-bugs] [Bug 82984] FILEOPEN: Error opening XLSX file in zip64 format
https://bugs.freedesktop.org/show_bug.cgi?id=82984 --- Comment #1 from William Mann --- Created attachment 105138 --> https://bugs.freedesktop.org/attachment.cgi?id=105138&action=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