Help opening Excel spreadsheet with OpenOffice

Discuss the spreadsheet application

Help opening Excel spreadsheet with OpenOffice

Postby dmcguiney » Sat Dec 22, 2012 10:48 pm

Hi,
I have Office 2010 which i can no longer use (or want to) as it on 4 computers which 2 recently died. I bought 2 new computers and MS has a 5 user restriction. So I have installed OOo and would like to save my files in OOo format. My problem is when I open the excel file in OOo nothing shows just a blank worksheet.
I have Version 3.4.1 Windows 7.
Thanks for any help.
Don McGuiney
Last edited by thomasjk on Sun Dec 23, 2012 6:28 am, edited 1 time in total.
Reason: Split post into new topic since the issue is different.
OPENOFFICE.ORG 3.4.1 ON WINDOWS 7
dmcguiney
 
Posts: 3
Joined: Sat Dec 22, 2012 10:27 pm

Re: Help opening Excel spreadsheet with OpenOffice

Postby RoryOF » Sun Dec 23, 2012 9:28 am

If it is an .xlsx file you may have more difficulty than an .xls file; the MS Office filters have been reverse engineered and can fail with complex formatting ( and the .???x formats). If you still have access to MS Office 2010, try saving the files as .xls to see if that improves opening. Alternately you could try LibreOffice, which I understand offers better support for .???x files.
Apache OpenOffice 4.0.1 on Xubuntu 13.10 and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 14328
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Help opening Excel spreadsheet with OpenOffice

Postby dmcguiney » Sun Dec 23, 2012 5:08 pm

Thanks Rory. They are xls files and haven't been able to convert using Zamzar etc. Any other thoughts? Thanks, Don
OPENOFFICE.ORG 3.4.1 ON WINDOWS 7
dmcguiney
 
Posts: 3
Joined: Sat Dec 22, 2012 10:27 pm

Re: Help opening Excel spreadsheet with OpenOffice

Postby FJCC » Sun Dec 23, 2012 5:12 pm

Can you post an example document? There is an Upload Attachment tab just below the box where you type a response.
AOO 3.4 or 4.0 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 3666
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Help opening Excel spreadsheet with OpenOffice

Postby RoryOF » Sun Dec 23, 2012 5:15 pm

If Zamzar can't handle them then there may be something wrong with the stored files. As FJCC says, a sample file would let us try to find the problem/solution.
Apache OpenOffice 4.0.1 on Xubuntu 13.10 and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 14328
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Help opening Excel spreadsheet with OpenOffice

Postby dmcguiney » Sun Dec 23, 2012 6:58 pm

Hi,
Yesterday after reading up on this and the recommendation of using Zamzar which I did almost all my .xls files semi converted. Instead of the regular OOo icon what I got was the base icon but with no color, just a black and white one. I tried several different files including the one attached which has just the black and white icon. Hope this doesn't confuse anyone.
Thanks,
Don
Attachments
BLOOD PRESSURE.xls
(1.5 KiB) Downloaded 31 times
OPENOFFICE.ORG 3.4.1 ON WINDOWS 7
dmcguiney
 
Posts: 3
Joined: Sat Dec 22, 2012 10:27 pm

Re: Help opening Excel spreadsheet with OpenOffice

Postby Hagar Delest » Sun Dec 23, 2012 7:11 pm

A 1.5 KiB file cannot be a correct .xls file. There has been a problem with the conversion, indeed.
AOO 4.0.1 on Windows 7 and Xubuntu 13.10 (Saucy Salamander)
User avatar
Hagar Delest
Moderator
 
Posts: 25074
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Help opening Excel spreadsheet with OpenOffice

Postby RoryOF » Sun Dec 23, 2012 7:31 pm

Definitely a corrupt (truncated?) file. Have you an earlier copy?

Sometimes in transfer from one machine to another, or from an older operating system to a new, files can be truncated for mysterious reasons. This may be one such.
Apache OpenOffice 4.0.1 on Xubuntu 13.10 and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 14328
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Help opening Excel spreadsheet with OpenOffice

Postby Radical_Magic63 » Mon Dec 24, 2012 1:02 am

A call to Microsoft tech support can get you 2 new keys so you can use excel on a new computer. They allow transfer as long as you tell them the computers are trashed.
Open Office 3.1 on windows 7 64 Bit
Radical_Magic63
 
Posts: 4
Joined: Sun Dec 23, 2012 8:20 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 14 guests