Bug 79428 - FILEOPEN: Calc cannot open an Excel sheet created by Quick Office.
Summary: FILEOPEN: Calc cannot open an Excel sheet created by Quick Office.
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.5.3 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL: https://drive.google.com/file/d/0BxP3...
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-29 20:35 UTC by Christopher Yeleighton
Modified: 2014-05-29 21:01 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Christopher Yeleighton 2014-05-29 20:35:26 UTC 
Problem description: 

Steps to reproduce:
1. Tell Calc to open the spreadsheet lofail.xslx.

Current behavior:
1. File damaged, bad format, cannot fix.

Expected behavior:
1. Import the spreadsheet.





              
Operating System: openSUSE
Version: 4.1.5.3 release
Comment 1 Maxim Monastirsky 2014-05-29 21:01:52 UTC 
Hi,

This file seems corrupted. Here is the output from unzip:

$ unzip -t lofail.xlsx
Archive:  lofail.xlsx
  End-of-central-directory signature not found.  Either this file is not
  a zipfile, or it constitutes one disk of a multi-part archive.  In the
  latter case the central directory and zipfile comment will be found on
  the last disk(s) of this archive.
unzip:  cannot find zipfile directory in one of lofail.xlsx or
        lofail.xlsx.zip, and cannot find lofail.xlsx.ZIP, period.

However I was able to repair that file using:
$ zip -FF --out fixed.xlsx lofail.xlsx