Loss of data in OOo Calc

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

Loss of data in OOo Calc

Postby mcpalbir » Tue Mar 29, 2011 4:25 pm

I have lost all data in a calc file, the file opens with only a blank spreadsheet. my other files in the same folder are fine. I have just updated to oo3.3.
I have successfully used oo for 6 years with no problem. I am not expert but have tried everything I know. Any solution would be appreciated as I am desperate. As simple as poss please
Open Office 3.3 on Windows XP
mcpalbir
 
Posts: 9
Joined: Tue Mar 29, 2011 4:12 pm

Re: Loss of data in OO Calc

Postby Villeroy » Tue Mar 29, 2011 4:31 pm

Restore the last version from your backups. No backups? Well, then you lost your data.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28839
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Loss of data in OO Calc

Postby hol.sten » Tue Mar 29, 2011 4:58 pm

mcpalbir wrote:the file opens with only a blank spreadsheet

I gave your file a try: I took a look at it with a hex editor. All it contains are 12032 Bytes of value zero. So there is nothing to rescue from that file.
OOo 3.2.0 on Ubuntu 10.04 • OOo 3.2.1 on Windows 7 64-bit and MS Windows XP
hol.sten
Volunteer
 
Posts: 495
Joined: Mon Oct 08, 2007 1:31 am
Location: Hamburg, Germany

Re: Loss of data in OO Calc

Postby mcpalbir » Tue Mar 29, 2011 5:51 pm

Many Thanks
Open Office 3.3 on Windows XP
mcpalbir
 
Posts: 9
Joined: Tue Mar 29, 2011 4:12 pm

Re: Loss of data in OO Calc

Postby mcpalbir » Tue Mar 29, 2011 5:53 pm

Villeroy wrote:Restore the last version from your backups. No backups? Well, then you lost your data.

Thank you I have used the back up restore and unfortunately and suprisingly it makes no difference
Open Office 3.3 on Windows XP
mcpalbir
 
Posts: 9
Joined: Tue Mar 29, 2011 4:12 pm

Re: Loss of data in OOo Calc

Postby Hagar Delest » Tue Mar 29, 2011 10:05 pm

Check your backup folder in the profile perhaps: [Tutorial] The OOo user profile.

Was it caused by a crash? Any specific event?
LO 6.4.6 on Xubuntu 20.04 and Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29072
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Loss of data in OOo Calc

Postby mcpalbir » Wed Mar 30, 2011 12:07 am

Thanks, I think it may have happened when I MAY have had the file opened and there was a power cut but I cant be sure.
What doeshappen is that when I try to open the file a page headed "TEXT IMPORT" comes on screen with the file heading on it and if I press OK it opens in WRITER with a page full of ###### which would indicate to me that there must be something there if I could only get it to open in CALC. But I dont understand why when doing a full backup restore it did not come back up
Anyway tomorrow I will try your sugestion, again many thanks
Open Office 3.3 on Windows XP
mcpalbir
 
Posts: 9
Joined: Tue Mar 29, 2011 4:12 pm

Re: Loss of data in OOo Calc

Postby Hagar Delest » Wed Mar 30, 2011 12:19 am

Sadly, nothing to do: 22 page term paper replaced with pound signs.

Check the temporary folder of the system (see in OOo Tools>Options>OOo>Paths). If there are folders like sgmlf.tmp with a file having the same name inside, make a copy of that file, rename it in .ods and cross your fingers.
LO 6.4.6 on Xubuntu 20.04 and Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29072
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: No registered users and 4 guests