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: 27879
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?
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28715
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.
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28715
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 5 guests