Saved Calc file won't load

Discuss the spreadsheet application

Saved Calc file won't load

Postby Trenoweth » Mon Jul 20, 2020 2:57 am

A file that I use each month and which has loaded happily for years will not load today! It is saved as a Microsoft 97/2000/XP .xls file.

When I try to load it I have a Filter/selection window open. I select Microsoft Excel 97/2000/XP which is followed by an "Unknown graphics format" error message!

No graphics are involved, just a bog standard spreadsheet with calculations but no macros etc.

Clicking "OK" on that error message produces a General Error message: "General input/output error".

Is there something I can do to restore this file? It is the same whether I'm trying to access the saved file or the backed-up file.
Open Office 4.1.7, Windows 10
Trenoweth
 
Posts: 8
Joined: Mon Jul 20, 2020 2:41 am

Re: Saved Calc file won't load

Postby RusselB » Mon Jul 20, 2020 3:43 am

Welcome to the Forums.
The Microsoft 97/2000/XP .xls file is, probably, just your .ods file (presuming you were saving it in the default OpenDocument Format).
Usually that happens when Windows changes the file associations. To change it back follow this tutorial
As to the "General input/output error" message, this is more concerning.
You might be able to get your file or a previous version of your file. See How to find and un-delete AOO temporary files
Please do these steps as soon as you can as the more you use your system the lower the chances of a successful recovery.
Last edited by robleyd on Mon Jul 20, 2020 4:07 am, edited 1 time in total.
Reason: Fix typo in link
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6308
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Saved Calc file won't load

Postby Trenoweth » Mon Jul 20, 2020 4:58 am

Thank you for your suggestions. Unfortunately nothing worked! I feel if only I could resolve the "Filter selection" problem all might be well - but I can't (so far) and it isn't! :(
Open Office 4.1.7, Windows 10
Trenoweth
 
Posts: 8
Joined: Mon Jul 20, 2020 2:41 am

Re: Saved Calc file won't load

Postby Zizi64 » Mon Jul 20, 2020 5:45 am

A file that I use each month and which has loaded happily for years will not load today! It is saved as a Microsoft 97/2000/XP .xls file.

When I try to load it I have a Filter/selection window open. I select Microsoft Excel 97/2000/XP which is followed by an "Unknown graphics format" error message!


How you tried to load (open) it?
- by a double click on the file name in a file explorer?
- by the File - Open menu item from the Apache OpenOffice?
- has the filename any extension? (.xls or other?)
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9724
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Saved Calc file won't load

Postby Trenoweth » Mon Jul 20, 2020 5:48 am

Both by double clicking and using File/Open. The extension is .xls
Open Office 4.1.7, Windows 10
Trenoweth
 
Posts: 8
Joined: Mon Jul 20, 2020 2:41 am

Re: Saved Calc file won't load

Postby Zizi64 » Mon Jul 20, 2020 5:51 am

Have you tried to open it with LibreOffice or with MS Office?

Can you upload or share the problematic file here?
Note: the file size limit is 128 KiB in this forum. You can share the larger files on a free file sharing service like the Google drive.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9724
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Saved Calc file won't load

Postby Trenoweth » Mon Jul 20, 2020 5:57 am

I don't have MS Office and did try, but failed, with Free Office. Not sure I want to upload the file as it contains personal details.

I suppose it's a case of having to start all over again.... Maybe I should save in two different formats just in case this should happen again.

I recently had the same problem with another file, but I was able to open that from my back-up drive. This time I fear I am not so lucky.

As far as I have checked all my other files seem to open correctly so maybe it is down to an unfortunate event on a day when just these two files were open.
Open Office 4.1.7, Windows 10
Trenoweth
 
Posts: 8
Joined: Mon Jul 20, 2020 2:41 am

Re: Saved Calc file won't load

Postby Zizi64 » Mon Jul 20, 2020 6:13 am

I don't have MS Office

Then why you saved your important documents into an obsolete, never standardized file format like the binary MS .xls format?

Always use the international (ISO) standard ODF file formats.
Have you any saved backups of the file? Try to open one of them.


And you can try the LibreOffice: I never lost any file with it since the date of forking from the OpenOffice.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9724
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Saved Calc file won't load

Postby Trenoweth » Mon Jul 20, 2020 6:21 am

Historic reasons really, plus I do share a number of files and it was simpler to just use the one format.

Only the one saved back-up and that doesn't load, no doubt overwritten by the corrupted one. It's /xlx rather than .xlsx as OO doesn't save in that format. At least, mine doesn't, and I think it is the latest version - 4.1.7.

I had Libre Office on a Linux machine a good number of years ago and found it a bit 'çlunky', but that may just have been the Ubuntu OS! I'll give it another go and do as you suggest, save in native format and only use MS ones when sharing files.
Open Office 4.1.7, Windows 10
Trenoweth
 
Posts: 8
Joined: Mon Jul 20, 2020 2:41 am

Re: Saved Calc file won't load

Postby Zizi64 » Mon Jul 20, 2020 6:29 am

It's /xlx rather than .xlsx as OO doesn't save in that format.

The LibreOffice can save into the Strict version of the OOXML file format. Unfortunately the OOXML file formats of the MS have two subversion: the Strict one and the Transitional one. Not an easy thing to follow the undocumented changes of the Transitional version.

Therefore always better to store your documents in the native ODF file formats. Create (export) a copy into the foreign file formats at end of the editing - if it is necessary.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9724
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Saved Calc file won't load

Postby Trenoweth » Mon Jul 20, 2020 6:32 am

Thanks for your suggestions. I'll bear them in mind for the future - and convert all the existing .xls files.
Open Office 4.1.7, Windows 10
Trenoweth
 
Posts: 8
Joined: Mon Jul 20, 2020 2:41 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests