Bug 53859

Summary: FILEOPEN: Unable to open some Excel 97-2003 spreadsheets created in version 3.5.5.3
Product: LibreOffice Reporter: Ed Kapusniak <ed.kapusniak>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED FIXED    
Severity: major CC: bentleyjoakes, bfo.bugmail
Priority: medium    
Version: 3.5.6.2 release   
Hardware: All   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description Ed Kapusniak 2012-08-20 22:14:04 UTC
Libre Office doesn't recognize some files as valid Excel spreadsheets, prompts for ASCII conversion options.  Rolling back to 3.5.5.3 allows the files to be opened.  File size: 16.3 Meg.
Comment 1 Sören 2012-12-26 21:26:40 UTC
Please attach a file for which the problem occurs.

Marking as NEEDINFO. Once you get us some more information we'll see if we can help you. Mark as UNCONFIRMED once you update us a bit. Thanks for your understanding
Comment 2 Ed Kapusniak 2013-01-01 06:11:48 UTC
https://docs.google.com/open?id=0Bw9bOUcZM2ddT2I1U3hwNThaYlE

This is the problem file.
Comment 3 Bentley Oakes 2013-02-25 01:49:34 UTC
I could not open the Google Docs file, as LibreOffice requires a password. Could you please provide the password or upload a non-passworded file? Thank you.
Comment 4 Ed Kapusniak 2013-03-01 19:11:07 UTC
The problem occurs before the password prompt.  The latest version doesn't recognize the file as an Excel format spreadsheet but instead prompts for ASCII conversion options.  Version 3.5.5.3 recognizes the same file as an Excel format spreadsheet and prompts for a password.
Comment 5 bfoman (inactive) 2013-03-14 12:34:55 UTC
(In reply to comment #4)
> The problem occurs before the password prompt.  The latest version doesn't
> recognize the file as an Excel format spreadsheet but instead prompts for
> ASCII conversion options. 

Which is that?
Comment 6 Ed Kapusniak 2013-03-14 12:51:57 UTC
(In reply to comment #5)
> (In reply to comment #4)
> > The problem occurs before the password prompt.  The latest version doesn't
> > recognize the file as an Excel format spreadsheet but instead prompts for
> > ASCII conversion options. 
> 
> Which is that?

I don't understand your question.

The uploaded file (Comment 2) was created as an Excel format spreadsheet using LibreOffice ver 3.5.5.3.  Opening that file with the same LibreOffice version gives a password prompt (and if you enter the password the file opens just fine).

When I upgrade to LibreOffice version 3.5.6.2 and try to open the same file I don't even get the password prompt.  Instead I get prompted for ASCII conversion options.  In other words LibreOffice 3.5.6.2 doesn't recognize the file as a valid Excel format spreadsheet file.

I hope this answer your question.
Comment 7 bfoman (inactive) 2013-03-14 15:15:26 UTC
(In reply to comment #6)
> In other words LibreOffice 3.5.6.2 doesn't recognize
> the file as a valid Excel format spreadsheet file.

Please check if this bug is reproducible with the latest 4.0.x stable release as 3.5.x is EndOfLife and 3.6.x will be EOL soon (last .6 release to be released in April, code freeze in March).
Comment 8 Ed Kapusniak 2013-03-14 19:11:43 UTC
(In reply to comment #7)
> (In reply to comment #6)
> > In other words LibreOffice 3.5.6.2 doesn't recognize
> > the file as a valid Excel format spreadsheet file.
> 
> Please check if this bug is reproducible with the latest 4.0.x stable
> release as 3.5.x is EndOfLife and 3.6.x will be EOL soon (last .6 release to
> be released in April, code freeze in March).

Version 4.0.1.2 fixes the problem...whew!