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
Help opening Excel spreadsheet with OpenOffice
Help opening Excel spreadsheet with OpenOffice
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.
Reason: Split post into new topic since the issue is different.
OPENOFFICE.ORG 3.4.1 ON WINDOWS 7
Re: Help opening Excel spreadsheet with OpenOffice
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.1.15 on Xubuntu 22.04.4 LTS
Re: Help opening Excel spreadsheet with OpenOffice
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
Re: Help opening Excel spreadsheet with OpenOffice
Can you post an example document? There is an Upload Attachment tab just below the box where you type a response.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Help opening Excel spreadsheet with OpenOffice
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.1.15 on Xubuntu 22.04.4 LTS
Re: Help opening Excel spreadsheet with OpenOffice
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
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 131 times
OPENOFFICE.ORG 3.4.1 ON WINDOWS 7
- Hagar Delest
- Moderator
- Posts: 32658
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Help opening Excel spreadsheet with OpenOffice
A 1.5 KiB file cannot be a correct .xls file. There has been a problem with the conversion, indeed.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Help opening Excel spreadsheet with OpenOffice
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.
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.1.15 on Xubuntu 22.04.4 LTS
-
- Posts: 10
- Joined: Sun Dec 23, 2012 8:20 pm
Re: Help opening Excel spreadsheet with OpenOffice
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