4.1.6 Cannot open .xls

Issues installing under the Mac OSX - X11 - Aqua

4.1.6 Cannot open .xls

Postby harolda3 » Tue Nov 20, 2018 2:33 am

MacBook Air (early 2013), OS 10.10.5; Just installed AOo 4.1.6.
a) Now cannot open any .ods file previously saved as a Microsoft Excel 97/2000/XP (.xls) file nor can I open any Microsoft Excel file saved as .xls or .xls: Read-Error. Internal import error. (I can open old .ods files.)
b) Nor can I now save any new AOo workbook as an Excel 97/2000/XP (.xls) file: Error saving the document Untitled: Read-Error. Internal import error. - -even though I gave it a different title.
OpenOffice 4.1.6 MacBook Air OS Yosemite 10.10.5
harolda3
 
Posts: 8
Joined: Tue Apr 12, 2016 5:47 pm

Re: 4.1.6 Cannot open .xls

Postby John_Ha » Tue Nov 20, 2018 1:00 pm

All work fine for me with 4.1.6 on W7.

Upload some example files showing the problems so they can be analysed. Use the Upload attachment tab below where you type (128 kB max); or use a file share site, Dropbox or Google Drive for larger files.

 Edit: Much more is now known about this problem so many posts in this thread are incorrect or misleading.

Jump straight to the last post in this thread by clicking here for a full explanation.

There appears to be a problem with AOO 4.1.6. 
Last edited by John_Ha on Tue Jan 22, 2019 2:06 pm, edited 1 time in total.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

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

Re: 4.1.6 Cannot open .xls

Postby John_Ha » Wed Nov 21, 2018 12:18 pm

harolda3 sent me these three test files. I could open all of them, and I could save as .xls files.

This therefore appears to be a problem with 4.1.6 on Mac.

See [Tutorial] Differences between Writer and MS Word files for why you should always work in and save Writer files as .odt. Similarly, spreadsheet files should always be saved as .ods and not as .xls.

Spreadsheet Test AOo.ods
A .ods file
(9.48 KiB) Downloaded 45 times

Spreadsheet Test XL.xls
A .xls file
(25 KiB) Downloaded 64 times

Spreadsheet Test XL.xlsx
A .xlsx file
(8.41 KiB) Downloaded 51 times
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

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

Re: 4.1.6 Cannot open .xls

Postby John_Ha » Wed Nov 21, 2018 1:42 pm

Try resetting the user profile - it often fixes random problems.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

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

Re: 4.1.6 Cannot open .xls

Postby harolda3 » Wed Nov 21, 2018 5:16 pm

John_Ha wrote:Try resetting the user profile - it often fixes random problems.


I created a new AOo user profile folder and entered my name, had no other prompt, but did not do any other entry into profile. Still cannot save a new file as .xls. [I frequently work with others that do not have OpenOffice and I do not have Excel on my working computer, so need to save spreadsheets as universal .xls files. The others have PCs and others have Macs with Excel. Have not had a problem until now.]

I can open or save old and new Writer files as .doc; but cannot open or save old or new .xls files with AOo 4.1.6, even with the new profile folder.
What do you suggest next?
Thanks for your concern, Harold A
OpenOffice 4.1.6 MacBook Air OS Yosemite 10.10.5
harolda3
 
Posts: 8
Joined: Tue Apr 12, 2016 5:47 pm

Re: 4.1.6 Cannot open .xls

Postby RoryOF » Wed Nov 21, 2018 5:18 pm

If you need to get work done, reinstall OO 4,1.5, or whatever version last worked for you.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29068
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: 4.1.6 Cannot open .xls

Postby harolda3 » Wed Nov 21, 2018 5:21 pm

Oh - I had updated the OpenOffice and OS version yesterday. I thought this was saved in the AOo user profile folder, but as you can see after I had just sent the previous message, the updated version is still there, even though I did not update the profile after deleting the old. Guess this info not stored in the profile folder?
OpenOffice 4.1.6 MacBook Air OS Yosemite 10.10.5
harolda3
 
Posts: 8
Joined: Tue Apr 12, 2016 5:47 pm

Re: 4.1.6 Cannot open .xls

Postby John_Ha » Wed Nov 21, 2018 5:34 pm

It looks like a bug in 4.1.6 as it works OK on Windows and Ubuntu. I suggest you report it.

 Edit: The files work on another Mac so it is a problem with your PC


You have two workarounds:

1 re-install 4.1.5 - you won't lose much as 4.1.6 is just a few bug fixes.

2 Save as .ods - which you should be doing in any case.
Last edited by John_Ha on Thu Nov 22, 2018 1:25 am, edited 1 time in total.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

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

Re: 4.1.6 Cannot open .xls

Postby lgusaas » Wed Nov 21, 2018 8:47 pm

Your test files all open on my Mac. Have no problems saving files as .xls.
Larry I. Gusaas
Moose Jaw, SK Canada
Website: http://larry-gusaas.com
"An artist is never ahead of his time but most people are far behind theirs." Edgard Varese
Apache OpenOffice 4.1.6 — MacBook Pro(Retina)—macOS Ver.10.14.5 Mojave
lgusaas
Volunteer
 
Posts: 1551
Joined: Sun Mar 30, 2008 8:32 pm
Location: Moose Jaw, SK Canada

Re: 4.1.6 Cannot open .xls

Postby harolda3 » Wed Nov 21, 2018 10:45 pm

Must be a problem with macOS Ver.10.10.5. I already have two OSs on my WORKHORSE small laptop (Yosemite & Snow Leopard) so that I can run apps daily that have not ever been updated for later OSs. Do not think I can segment drive into three parts since I hear later OSs are much more bloated, so have no disk room for three segments.
[I even had to buy another laptop with OS 10.12.6 just to run 2017 & 2018 TurboTax since it will not run on above OSs. Unfortunately its disk is not any larger.]
Harold
--
Whenever an OS or App is updated, the computer becomes less and less useful and more and more painful. hma
OpenOffice 4.1.6 MacBook Air OS Yosemite 10.10.5
harolda3
 
Posts: 8
Joined: Tue Apr 12, 2016 5:47 pm

Re: 4.1.6 Cannot open .xls

Postby RoryOF » Wed Nov 21, 2018 10:55 pm

Hasve you renamed the OO User Profile? This must be done explicitly - reinstalling OO does not do it.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29068
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: 4.1.6 Cannot open .xls

Postby harolda3 » Thu Nov 22, 2018 3:10 am

Yes, I closed AOo, gave user folder an 'old' name, reopened AOo (new user folder was created), but got same problems.
OpenOffice 4.1.6 MacBook Air OS Yosemite 10.10.5
harolda3
 
Posts: 8
Joined: Tue Apr 12, 2016 5:47 pm

Re: 4.1.6 Cannot open .xls

Postby John_Ha » Thu Nov 22, 2018 12:22 pm

1. Try a power OFF/ON reboot.

2. Try a boot into Safe Mode.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

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

Re: 4.1.6 Cannot open .xls

Postby harolda3 » Sat Nov 24, 2018 3:51 am

1. I shutdown my computer at least twice daily, so that is not causing the problem.
2. I tried Safe Mode. (It says Safe Boot in upper right corner).
[Never tried Safe Mode before - I would expect it to faster, but start up and shutdown take much longer!]
I still cannot SAVE AS .xls, or open an old .xls document with AOo 4.1.6 in Safe Mode. I can SAVE AS .ods and reopen old or new .ods files.
Will have to go back to AOo 4.1.5. [Read recently that Time Machine does not back up apps, but I seem to have found it on my Time Machine. Hope I do not have a problem reinstalling from TM.]
H
OpenOffice 4.1.6 MacBook Air OS Yosemite 10.10.5
harolda3
 
Posts: 8
Joined: Tue Apr 12, 2016 5:47 pm

Re: 4.1.6 Cannot open .xls

Postby harolda3 » Sat Nov 24, 2018 4:22 am

I copied AOo 4.1.5 from my Time Machine; renamed my AOo user folder [there was not AOo user folder on TM]; then opened AOo 4.1.5.
I can again SAVE AS new files as .xls and open old and and new .xls files again.
[The curious thing is the default AOo 4.1.6 SAVE AS is .xls format whereas the default AOo 4.1.5 SAVE AS is .ods format.]
OpenOffice 4.1.6 MacBook Air OS Yosemite 10.10.5
harolda3
 
Posts: 8
Joined: Tue Apr 12, 2016 5:47 pm

Re: 4.1.6 Cannot open .xls

Postby John_Ha » Sat Nov 24, 2018 1:49 pm

harolda3 wrote:[The curious thing is the default AOo 4.1.6 SAVE AS is .xls format whereas the default AOo 4.1.5 SAVE AS is .ods format.]

Set it in Tools > Options (Preferences?) > Load/Save.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

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

Re: 4.1.6 Cannot open .xls

Postby John_Ha » Mon Jan 21, 2019 11:22 pm

 Edit: There appears to be a problem with AOO 4.1.6 which cannot open some .docx or .xlsx (and presumably .pptx) files.

There are different effects of different operating systems and Windows seems to be able to open more files than Linux or MacOS. It seems to depend on the content of the file because, while I can open all the .docx files on my PC, I have now been sent a .docx file which I cannot open.

Development is aware of the problem.

The workaround is:

1. Uninstall AOO 4.1.6
2. Go to http://www.openoffice.org/download/index.html and load a previous version of AOO - AOO 4.1.5 does not have the problem.
3. Install AOO 4.1.5.

LO apparently does not have the problem.

Clipboard01.gif
 
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

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


Return to Mac OSX

Who is online

Users browsing this forum: Exabot [Bot] and 0 guests