[Solved] Problem Opening .xlsx File

Discuss the spreadsheet application

[Solved] Problem Opening .xlsx File

Postby Frankwm123 » Fri Jul 22, 2011 2:24 am

I don't have MSOffice, but I do have the 'readers'. I have a .xlsx file which I can open with Excel Reader, but when I try to open it with OpenOffice, the application just hangs after a couple of minutes & I have to close it with Task Manager which informs me that the application is not responding. I need to be able to input information into this file, which is why I am trying to open it with OpenOffice.
Any solution/s will be welcome, thanks.

PS: This is a link to the downloadable file I am trying to open "DOWNLOAD (10MB)": https://docs.google.com/leaf?id=0B91OyOS9I8JsMmZmZWI5N2UtZTNiNC00NGE1LWE4YzYtNjMwNjIzMjZmODhi&sort=name&layout=list&num=50
Last edited by Hagar Delest on Fri Jul 22, 2011 12:36 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 3.3
Windows XP Pro
User avatar
Frankwm123
 
Posts: 2
Joined: Fri Jul 22, 2011 1:50 am

Re: Problem Opening .xlsx File

Postby aqualung » Fri Jul 22, 2011 5:18 am

Hello and welcome to the forum!

An .xlsx file may be viewable in MS Excel Viewer (not "Reader") but fail to open in OpenOffice.org.

This is not uncommon. The file import filters from Office 2007/2010 into OOo are incomplete. A future version of OOo will improve this situation, but by that time Microsoft will have introduced yet another incompatible proprietary file format in Office 2014 :(

You could experiment using a range of options (for example, a free on-line file conversion service such as Zamzar.) Or you could ask the author of the .xslx file to "Save As" .xls (the file format in Excel 97 / XP / 2003) and send it to you again. The .xls import filter in OOo gives much better results.
OOo 3.3.0, Windows 7 64-bit SP1, planning to add LibreOffice after a bug-fix version of 3.4 is released.
Has your question been answered? Please go back to the message at the top of the thread and mark it as [SOLVED].
User avatar
aqualung
Volunteer
 
Posts: 308
Joined: Mon Dec 20, 2010 10:35 pm

Re: Problem Opening .xlsx File

Postby Hagar Delest » Fri Jul 22, 2011 8:33 am

Better avoid the OOXML format anyway, have a look at: MS Office 2007 OOXML file format (docx, xslx, pptx, ppsx). Can you ask for a .xls? Not perfect but should give better results.
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28918
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Problem Opening .xlsx File

Postby Frankwm123 » Fri Jul 22, 2011 8:54 am

Yes, you're correct, Excel Viewer (must have been thinking Adobe Reader).

Thanks for explaining that. Fortunately the website has a .xls version of the file which OpenOffice could open.

Again, thanks for the help.
OpenOffice 3.3
Windows XP Pro
User avatar
Frankwm123
 
Posts: 2
Joined: Fri Jul 22, 2011 1:50 am

Re: [Solved] Problem Opening .xlsx File

Postby ozlady » Sat Jul 23, 2011 5:36 am

In future, another option can be to upload to Google Docs (free), then download as an xls or odt file.
Stephanie
OpenOffice 3.3, NeoOffice 3.2 Patch 0, LibreOffice 3.3.2 with MacOS 10.7
User avatar
ozlady
 
Posts: 10
Joined: Tue Oct 26, 2010 3:55 am
Location: Singapore / Australia

Re: [Solved] Problem Opening .xlsx File

Postby cemden » Sun Sep 15, 2019 9:37 am

Surprisingly, after waiting for longer than a minute watching the import bar freezed at 10%, it opened in calc, without any distortions. My PC has 256GB memory, and taskmanager showed no lack of it. So I presume this was because of a 64b computer running a 32 bit OpenOffice. In fact, it runs inside a windows 32b virtual machine. MS virtualization problem? ...
OpenOffice 4.1.6 on Windows10 64b
cemden
 
Posts: 1
Joined: Sun Sep 15, 2019 9:09 am

Re: [Solved] Problem Opening .xlsx File

Postby Villeroy » Sun Sep 15, 2019 1:26 pm

cemden wrote:Surprisingly, after waiting for longer than a minute watching the import bar freezed at 10%, it opened in calc, without any distortions. My PC has 256GB memory, and taskmanager showed no lack of it. So I presume this was because of a 64b computer running a 32 bit OpenOffice. In fact, it runs inside a windows 32b virtual machine. MS virtualization problem? ...

xlsx is an insanely complex file format. Don't use it.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28441
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Problem Opening .xlsx File

Postby John_Ha » Thu Mar 26, 2020 7:43 pm

LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 7785
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests