Why is there not a delete option in sheets for officelibre calc??
No delete option or copy move or copy sheet!
First time here? Check out the FAQ!
No delete option or copy move or copy sheet!
Hello, may be I didn't get you right but all is there - just right click on the sheet name and you get a context menu.
Second option:
Go to Sheet
in menu and you also will find Delete Sheet
and/or Move or Copy Sheet...
and Rename Sheet
Third option:
If you can't delete or move sheets, then Tools -> Protect Spreadsheet Structure...
might be enabled.
Not sure if still an issue ... Check if you have Recording mode active. This will disable delete/copy worksheet commands
Tomaz actually already said this, but I know I missed it the first time I read through.
"tracking changes" can make the delete sheet disappear from the sheet right click, and grey out in the Sheet menu, as in saochen's screenshots.
I'm sure I had never turned it on, but, somehow it was on and that was what was creating this problem.
I'm having the same issue. The last time I use Libre Office Calc about a week ago I was able to delete, move and copy sheets and now I either don't have that option in the contextual menu or it is greyed out under the sheets tab.
Thank you;
Steve
When I go there it asks me to create a password to turn it on.
From my perspective the Spreadsheet Structure is protected and you need a password to unprotect it. But I don't have your sheet so I cannot verify. Hence I cannot further help unless I could investigate the file.
Asked: 2019-05-03 17:40:09 +0200
Seen: 1,515 times
Last updated: Dec 15 '20
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]
I know this sounds crazy but there is NOT that option any longer. These options, images that you displayed were there as of 2 days ago. I came in yesterday and it was missing. I restarted the computer thinking it could be like our phones. And STILL nothing. The delete and move/copy sheet option are gone.
This sounds really weird - which OS are you using and which LibreOffice Verision? May be you need give
a try.
Have you customized your menu's? If yes - Go to
Tools -> Customize -> Tab: Context Menus
SelectSheet Tabs Bar
in categoryTaget
and click toDefaults
I have looked to customize, yes. And it was already set in there as if it always has been. 6.1.5 is what I am using. I think I canceled my other comment. Sorry! I replied back with... I have one spreadsheet that has BOTH the options in the sheet tab, I have one spreadsheet that has ONE option in the sheet tab, being (move/copy). And ONE spreadsheet, my everyday use one, the one a I am referring to that does NOT have the options.
I've never had an issue like this in my years of Office Admin work. But have never used LibreOffice either. When I was hire on here everything had been done by paper ledger since 1955 hahahahahahaha... I started here 3 months ago. Also when given the computer, windows 8 I was not able to download excel. Because microsoft office had not been installed. Which they thought had been when buying and setting up the computer to begin with?? Soooooo I was left with LibreOffice (being free and all)
If there is only 1 Sheet in a LibreOffice file, then there is no "Delete" option, since you cannot delete the one and only sheet.
One spreadsheet has approx 25 sheets (no options) One spreadsheet has approx 10 sheets with (both options) One spreadsheet has 3 sheets (one option)
Did you follow my advice above? And which file format are you using (hopefully .ods ?)
Yes I did.. except the reinstalling part. If I do that will all my work be deleted?
I've meant the
part. It may be that the customized settings are stored within the respective file and thus resetting the user profile will have no effect,