View original (French)

Unable to rename sheets in a calc file

ciney15 Posted messages 11 Status Membre -  
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   -
Hello,

Hello,

I can't rename the sheets of a calc file
neither by right-clicking on the sheet name (the menu doesn't offer "rename")
nor by going through "format", "sheet" (rename and other items are grayed out, inaccessible)
Note: I don't have this issue with all my calc files... and I don't understand where it comes from
If you have the right path... THANK YOU!!!

Configuration: Windows 7 / Firefox 47.0

6 réponses

Réponse 1 / 6
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   1 509
 
Hello,

Your document is protected tools/protect the document/sheet or document and on your submission document is checked and a password is required to unlock it.

Best regards
1
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   1 509
 
I would like to add that if you do not have the password, I refer you to the solution proposed by OOoForum.

Best regards
0
Réponse 2 / 6
yclik Posted messages 3865 Registration date   Status Membre Last intervention   1 603
 
Good evening
maybe all the sheets are selected
Right-click on a tab > Deselect all sheets
0
ciney15 Posted messages 11 Status Membre
 
Thank you for this suggestion.
I just tried, but no, the sheets were not selected.
Something else, maybe?.....
0
Réponse 3 / 6
shunesburg69 Posted messages 1061 Registration date   Status Membre Last intervention   220
 
What happens when you try, is there an error message, is it grayed out or not taken into account...?

--
Like LibreOffice, Apache OpenOffice is a fork of OpenOffice.org.
0
ciney15 Posted messages 11 Status Membre
 
The menu offers me, besides "copy...", only "select all sheets" and "sheet events".
0
Réponse 4 / 6
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 
Either you have protected your workbook, or you have macros...

--
Retirement is great! Especially in the West Indies... :-)
Raymond (INSA, AFPA, CF/R)
0
ciney15
 
Hello,
The workbook is not protected (I just checked for safety) and I have never used a macro...
The mystery at this stage remains unsolved...!
Does anyone have another hypothesis?
0
Réponse 5 / 6
shunesburg69 Posted messages 1061 Registration date   Status Membre Last intervention   220
 
Put your file on cjoint.com and share the link here so we can test on our side.

--
Like LibreOffice, Apache OpenOffice is a fork of OpenOffice.org.
0
ciney15
 
As requested, here is the link to the relevant file. Thank you for your upcoming proposals!
http://www.cjoint.com/c/FHouuqwNwsz
0
Réponse 6 / 6
OOoForum Posted messages 3871 Registration date   Status Membre Last intervention   964
 
This problem occurs if the workbook is (or has been) in XLS format.
The solution is to copy each sheet into a new file in ODS format.

.
--
Why hack MS-Office when there is a free solution?
Use OpenOffice
0
shunesburg69 Posted messages 1061 Registration date   Status Membre Last intervention   220
 
I've never had this issue, it's a strange behavior, and even if the file was saved in ods?
0
ciney15 > shunesburg69 Posted messages 1061 Registration date   Status Membre Last intervention  
 
This file is several years old and was created directly in OpenOffice. Therefore, the problem does not come from a transfer from Microsoft Office....
0