Deleted sheets, can be recovered?

Discuss the spreadsheet application
Post Reply
Larrie
Posts: 5
Joined: Thu Dec 08, 2016 4:19 am

Deleted sheets, can be recovered?

Post by Larrie »

I may have deleted sheet from a spreadsheet file. The file will still open but the items (sheets) I put in yesterday are not showing. Help?
Open Office 4 ... Windows 7
User avatar
Zizi64
Volunteer
Posts: 11505
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: deleted sheets

Post by Zizi64 »

Can you upload the problematic .ods file here?
Tibor Kovacs, Hungary; LO7.5.8/25.8.5.2 /Win7-10-11 x64Prof.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
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.
Larrie
Posts: 5
Joined: Thu Dec 08, 2016 4:19 am

Re: deleted sheets

Post by Larrie »

local.ods
Open Office 4 ... Windows 7
Larrie
Posts: 5
Joined: Thu Dec 08, 2016 4:19 am

Re: deleted sheets

Post by Larrie »

yes the file is local.ods and it opens with three empty sheets
Open Office 4 ... Windows 7
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: deleted sheets

Post by RusselB »

You posted the name of the file, but didn't upload it.
From the PostReply (not QuickReply) window, there is a tab under the area where you write your response, marked Upload attachment
On that tab, use the Choose File button to select your file, as it is on your computer, then click the Add the file button
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.
Larrie
Posts: 5
Joined: Thu Dec 08, 2016 4:19 am

Re: deleted sheets

Post by Larrie »

Local.ods
(8 KiB) Downloaded 118 times
Open Office 4 ... Windows 7
User avatar
robleyd
Moderator
Posts: 5500
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: deleted sheets

Post by robleyd »

That appears to be essentially a new spreadsheet with some random characters in cell A4 on Sheet 1

Except for the contents of A4 it is what I would expect to see if I do File | New | Spreadsheet. If you did add any additional sheets, it would appear that either they were not saved, or deleted before saving.
Slackware 15 (current) 64 bit
Apache OpenOffice 4.1.16
LibreOffice 26.2.2.2; SlackBuild for 26.2.2 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
User avatar
Zizi64
Volunteer
Posts: 11505
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: deleted sheets

Post by Zizi64 »

That appears to be essentially a new spreadsheet with some random characters in cell A4 on Sheet 1
+1 ...on my LibreOffice 4.4.7.
There are three (default) sheets, and one textual cell content on the Sheet1, and there is not any hidden sheets.
Tibor Kovacs, Hungary; LO7.5.8/25.8.5.2 /Win7-10-11 x64Prof.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
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.
Post Reply