Deleting unwanted worksheets

Discuss the spreadsheet application
Post Reply
Katesfriend256
Posts: 4
Joined: Thu Oct 18, 2018 8:37 am

Deleting unwanted worksheets

Post by Katesfriend256 »

I have a worksheet in constant use, but attempting to delete a sheet that was no longer required causes a total crash of Calc. I have emptied the sheet of all data, selected all, deleted all, but nothing seems to help this annoying problem. If anybody can help, I'd be grateful because it is irritating to have a blank worksheet!
OpenOffice 4.1 on MacOS 10.11
User avatar
Zizi64
Volunteer
Posts: 11361
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Deleting unwanted worksheets

Post by Zizi64 »

but attempting to delete a sheet that was no longer required causes a total crash of Calc. I have emptied the sheet of all data, selected all, deleted all, but nothing seems to help this annoying problem.
It is the right methodf to delete the CONTENT of a sheet.

But you want delete the sheet itself.

Right click on the TAB of the sheet, and click on the Delete item in the appeared floating menu.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.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.
Katesfriend256
Posts: 4
Joined: Thu Oct 18, 2018 8:37 am

Re: Deleting unwanted worksheets

Post by Katesfriend256 »

Thank you but I have done that multiple times - all that happens is that the app crashes completely! I have no idea why.
OpenOffice 4.1 on MacOS 10.11
Katesfriend256
Posts: 4
Joined: Thu Oct 18, 2018 8:37 am

Re: Deleting unwanted worksheets

Post by Katesfriend256 »

For sake of completeness, if I attempt to open up the app again, it goes into recovery mode - always successful, but still that is not the way it should be!
OpenOffice 4.1 on MacOS 10.11
User avatar
Zizi64
Volunteer
Posts: 11361
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Deleting unwanted worksheets

Post by Zizi64 »

Please upload your sample .ods file here.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.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.
Katesfriend256
Posts: 4
Joined: Thu Oct 18, 2018 8:37 am

Re: Deleting unwanted worksheets

Post by Katesfriend256 »

Unfortunately there is no way to do that as it is full of company information which is regarded as confidential, and obviously I cannot delete those sheets :-(
OpenOffice 4.1 on MacOS 10.11
User avatar
Zizi64
Volunteer
Posts: 11361
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Deleting unwanted worksheets

Post by Zizi64 »

Is there problem with this file only?

Try to copy all of the needed content into a new, empty .ods file.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.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