Unable to open monthly spreadsheets !

General discussion on OpenOffice Calc and its spreadsheets.

Unable to open monthly spreadsheets !

Postby Joseph S. Klein » Fri Aug 08, 2014 10:23 am

Hello,

I have inadvertently converted my monthly spreadsheets to xls files, which will no longer open in the three alternatives
I have, Sumatra pdf, Notepad , or Adobe reader. No idea how it happened.
Is there any way I can convert them to open in Open Office preferably, or failing that, any other program.

Thanks in Advance,
Joseph S. Klein
 
Posts: 38
Joined: Mon Mar 24, 2014 6:28 am

Re: Unable to open monthly spreadsheets !

Postby Ricky G. Marion » Fri Aug 08, 2014 10:33 am

Hello,

XLS is the file extension for a group of MS binary formats not fully compatible among themselves. I assume you did
already try to open your file with AOO (recent versions) and did not succeed. Sometimes LibreOffice may understand
an XLS that AOO didn't. Try the portable version if you dont want to tamper with your system.

Thanks,
Ricky G. Marion
 
Posts: 25
Joined: Mon Mar 24, 2014 6:33 am

Re: Unable to open monthly spreadsheets !

Postby Joseph S. Klein » Fri Aug 08, 2014 10:38 am

Thanks for your Fast reply. Tried your suggestion, d.loaded LirbreOffice, and am delighted to say it opened the spreadsheets. Can not thank you enough!.
Is it possible to convert the xls file ext. to one that will open in AOO?. there seem to be many programmes on the inernet to convert files.Not very tech. minded so hesitate to fiddle in case I make problems worse.
Joseph S. Klein
 
Posts: 38
Joined: Mon Mar 24, 2014 6:28 am

Re: Unable to open monthly spreadsheets !

Postby Ricky G. Marion » Fri Aug 08, 2014 10:42 am

The 'File' > 'Save As...' dialogue will offer a drop-down selection of the file format / extension to be used. Choose "ODF ... (*.ods)" there. Be sure to also mark 'Automatic filename extension' checked. That's next to the bottom of the dialogue windowlet.
No need of third party software!
Ricky G. Marion
 
Posts: 25
Joined: Mon Mar 24, 2014 6:33 am

Re: Unable to open monthly spreadsheets !

Postby Joseph S. Klein » Fri Aug 08, 2014 10:44 am

Worked perfectly. I Can now open 10 years of spreadsheets again!.
Thanks again for your help, very much appreciated.
Best wishes
Joseph S. Klein
 
Posts: 38
Joined: Mon Mar 24, 2014 6:28 am


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 1 guest

cron