Apache OpenOffice (AOO) Bugzilla – Issue 104759
OOo fails opening the attached broken XLSB document
Last modified: 2017-05-20 11:42:11 UTC
OpenOffice Calc doesn't support XLSB files at all. I opened the file, but nothing change in my Calc window. Last DevBuild doesn't support this format too. Full reference link: http://msdn.microsoft.com/en-us/library/cc313133.aspx I added support for this format in my application at one month standalone work.
Worksforme. For example I could open http://sc.openoffice.org/testdocs/drawing_import_biff12_12.xlsb in OOo 3.1.1 as well as in DEV300m56 without problems. Please, attach an example, that you can not open.
Created attachment 64539 [details] Test file
Sample file attached. It composed by application and successfully opened by Excel 2007 and Excel 2010.
Confirming problems opening the bugdoc attached by alexanderkozlenko. Testing with OOo 3.1.1 (OOO310m19) on Win2000: After selecting records.xlsb for opening, a dialog "Filter selection" shows up. After selecting "Microsoft Excel 2007 Binary", Calc shows a "general I/O error". Testing with OOo-dev 3.2.0 (DEV300m56) on Win2000: After selecting records.xlsb for opening, a dialog "Filter selection" shows up. After selecting "Microsoft Excel 2007 Binary", nothing happens. @alexanderkozlenko: Are you saying the bugdoc was created by your own application and not by MS Excel? This could be relevant for further investigation by an OOo developer!
Attached document was created by our application according to MS-XLSB specification, NOT in Microsoft Excel. I have not any error on it in Microsoft Excel 2007/2010. And I have not any exception message by OOo 3.1.1 on Vista Business x86 EN. Can you provide some information about which part of file confuse OOo. May be we have bad logic which can't occurs in Excel.
alexanderkozlenko, for your question you may want to subscribe and post a message to the dev@sc.openoffice.org mailing list (http://sc.openoffice.org/servlets/ProjectMailingListList) and try to come in contact with a Calc developer. If it turns out, that the problem is no bug in OOo, please return to this issue in Issue Tracker in order to close this issue. Thanks.
Ok. Now I don't see any problem in file structure, but if it will be found I post result here.
Hi. Can you provide some roadmap or plans about solving this problem? Thanks.
@alexanderkozlenko: As stated, for further investigation you could try to discuss your problem on the mailing list.
Hi Daniel, please have a look
Will have a look. Seems that already the file type detection fails on this file.
dr->mav: after fixing issue 105325 (open the OOXML packages with format type "ZipFormat") this file still does not open. Please have a look if there is a problem with this specific file. Fails at the same place as mentioned in the other issue, on creation of an instance of "com.sun.star.packages.comp.ZipPackage" (storage/source/xstor/xstorage.cxx#525)
If it helps, we used Microsoft.Deployment.Compression.Zip (Deployment Tools Foundation part) from Microsoft WiX prject (wix.sourceforge.net) to generate ZIP file.
Hi to all. Have you any good news about this issue?
Hi. Any roadmap for this problem?
mav->alexanderkozlenko: The "Target milestone" field contains the release, for which the fix is planned. In this case it is OOo3.3.
The file contains backslashes '\' as path-segments separator, that is actually forbidden by PKZIP specification. The PKZIP specification is used by OOXML format specification as far as I know, thus formally speaking this document looks to be no valid OOXML document. Adjusting the Summary accordingly. Please correct me if I have misunderstood something. Since it is an alien format, and the concurrent products look to accept such a broken file, it looks to make sense to accept it as well.
Fixed in cws fwk138.
mav->oc: Please verify the issue.
Verified in CWS fwk138.