Calc document opens now in Writer

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

Calc document opens now in Writer

Postby Ladyredrobin38 » Mon Apr 04, 2016 4:23 pm

Not sure where to post this so I am starting here. Please forgive me ahead of time as I am new to Open Office.
I came up with a problem this morning when I went to open a document in Calc.
I have made a spreadsheet for statements that I am running for our local junior livestock show and premium sale.
I save the document correctly last night but this morning the document wants to open in writer and not calc. I sure hope someone can help me as this has been 2 weeks worth of work and I am on a time schedule to get this done. What do I do, or can I do anything?????? HELP!!!!!!

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).
OpenOffice4.1.2On Windows 10
Ladyredrobin38
 
Posts: 5
Joined: Sun Mar 20, 2016 7:58 pm

Re: Help with open office

Postby Bill » Mon Apr 04, 2016 7:35 pm

What file format did you specify when saving the document? Does it have the proper file name extension? Have you checked your default program settings for that file name extension? Can you post the document here? Do you have backups that you can restore?
AOO 4.1.8 on Manjaro Cinnamon
Bill
Volunteer
 
Posts: 8006
Joined: Sat Nov 24, 2007 6:48 am

Re: Calc document opens now in Writer

Postby Ladyredrobin38 » Mon Apr 04, 2016 11:32 pm

No clue but I will check on it thanks
OpenOffice4.1.2On Windows 10
Ladyredrobin38
 
Posts: 5
Joined: Sun Mar 20, 2016 7:58 pm

Re: Calc document opens now in Writer

Postby Ladyredrobin38 » Tue Apr 05, 2016 3:26 pm

I attached the file here. I am so new to all of this please bear with me. But learning is fun!
When This file was started 2 wks ago and up until now it was fine. I got into it and saved it multiple times. I saved it into a document file on my PC ( C) not on one drive. I have windows 10.
Attachments
SCJLS Exhibitors Statements.ods
File having problems with
(29 KiB) Downloaded 74 times
OpenOffice4.1.2On Windows 10
Ladyredrobin38
 
Posts: 5
Joined: Sun Mar 20, 2016 7:58 pm

Re: Calc document opens now in Writer

Postby RoryOF » Tue Apr 05, 2016 3:37 pm

Your file is corrupt, possibly because of over-hasty computer power down or hibernation, before internal housekeeping was complete.
Apache OpenOffice 4.1.8 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31735
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc document opens now in Writer

Postby Ladyredrobin38 » Tue Apr 05, 2016 3:40 pm

Great so starting over is my only option
OpenOffice4.1.2On Windows 10
Ladyredrobin38
 
Posts: 5
Joined: Sun Mar 20, 2016 7:58 pm

Re: Calc document opens now in Writer

Postby RoryOF » Tue Apr 05, 2016 3:43 pm

To try and recover your file, you should look in the backup and temporary directories pointed to by /Tools /Options /OpenOffice : Paths. Rename any files in those to type .odt (or whatever file type you were using) and see if they contain your data. Download Recuva or PhotoRec (only one needed) and let it do an indepth recovery of deleted files on your computer. You may get a file containing some or all of your data (or not).
Apache OpenOffice 4.1.8 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31735
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc document opens now in Writer

Postby Ladyredrobin38 » Tue Apr 05, 2016 8:33 pm

Thanks! Even if I redo all of this what do I watch for so this doesn't happen again?
OpenOffice4.1.2On Windows 10
Ladyredrobin38
 
Posts: 5
Joined: Sun Mar 20, 2016 7:58 pm

Re: Calc document opens now in Writer

Postby thomasjk » Tue Apr 05, 2016 8:41 pm

When you do File-->Save make sure that the box "Automatic File Name Extension" is checked.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
thomasjk
Volunteer
 
Posts: 4431
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Calc document opens now in Writer

Postby RoryOF » Tue Apr 05, 2016 8:48 pm

Don't be in a hurry to close the file then power down the computer. Close the file, close OpenOffice, then use the Shut down option on the Start button (or whatever way they do this on win 10) Wait for disk activity to cease. This only takes a few more seconds. Over time, these accumulated seconds will still add up to much less than the time to rewrite a damaged or lost file.
Apache OpenOffice 4.1.8 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31735
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: No registered users and 2 guests