Cannot open my spreadsheet files

Discuss setup / installation issues - Add a spell checker, Language pack?

Cannot open my spreadsheet files

Postby ADJER » Fri May 18, 2018 5:21 pm

Hello, Recently updated Open Office to version 4.1.5. Has worked OK for a time. Today I suddenly cannot open any of my .ods spreadsheet files. Instead of the usual start routine I get a dialog box who's title is: Text import with Import, character set, Language, & sepatator Options. I cannot find a way to open my files from this point. I have tried switching the computer off & restarting, I have tried to do Open Office repair routine, I have reinstalled Open Office from the original zip file, all to no avail.A couple of times I somehow managed to open a new blank spreadsheet. but could not open my .ods files from there.
Any ideas what to try next?? Thanks, Adjer.
OpenOffice 4.1.5
Windows 10
ADJER
 
Posts: 2
Joined: Fri May 18, 2018 4:57 pm

Re: Cannot open my spreadsheet files

Postby FJCC » Fri May 18, 2018 6:53 pm

Most of the symptoms sound like you have corrupted files but it would be very strange to have multiple corrupted files. Also, you should in any case be able to open a blank document.
What happens if you click the Windows button, scroll through the list of available programs and start OpenOffice from there?
Can you post one of your files here? It has to be under 128kB. To post a file, click Post Reply and then look for the Upload Attachment tab just under the box where you type a response.
AOO 3.4 or 4.1 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: 6463
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Cannot open my spreadsheet files

Postby John_Ha » Fri May 18, 2018 7:28 pm

Download and try opening this file:

1. by double clicking it

2. by starting AOO and going File > Open ...
Attachments
test.ods
(8.95 KiB) Downloaded 4 times
AOO 4.1.5, 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.
John_Ha
Volunteer
 
Posts: 5365
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Cannot open my spreadsheet files

Postby ADJER » Fri May 18, 2018 10:36 pm

To; FJCC Correction to previous post. Only two spreadsheet files fail to open, they are my current working files. All my old files open as normal. Starting via the O/Office Program file gives a blank spreadsheet but using the file menu & Open command does not work. Sorry I cannot post files because I cannot open them. As you say I think I have corrupted files. I will try to restore them tomorrow from my file history backup.
To John_Ha Downloaded you test spreadsheet. I opened correctly no problem. Thanks to both for your help. Adjer.
OpenOffice 4.1.5
Windows 10
ADJER
 
Posts: 2
Joined: Fri May 18, 2018 4:57 pm

Re: Cannot open my spreadsheet files

Postby jrkrideau » Sat May 19, 2018 1:34 am

ADJER wrote:Sorry I cannot post files because I cannot open them.


Unless I am misunderstanding your point, you do not need to open a file to post it.
OpenOffice 4.1.4 Ubuntu 16.04 Xenial Xerus
jrkrideau
Volunteer
 
Posts: 3485
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: No registered users and 6 guests