Sheet >Rename sheet, show sheet, hide sheet options are greyed out and can not be selected. The calc file or sheets are not protected and not read only.
Can you edit the existing sheets in the document?
1.1. If no, the whole document is read-only. Just save it to your home directory.
1.2. The sheets may be protected against editing which can be changed via menu:Tools>âProtect Sheetâ
2. In case of yes, menu:Tools>âProtect spreadsheet structureâ which protects the collection of sheets.
https://help.libreoffice.org/7.5/en-US/text/scalc/guide/cell_protect.html?DbPAR=CALC#bm_id3146119
I can edit the existing sheets. The file is not protected. Under the menu tab âsheetâ hide sheet, insert sheet, rename sheet options are greyed out. But I can add rows and columns to existing sheets.
Then unprotect the sheet structure.
1 Like
Thank you so much. I was struggling for an hour. You solved in in seconds. Thanks once again.
1 Like