View original (French)

Unable to rename sheets in a calc file

ciney15 Posted messages 11 Status Member -  
PapyLuc51 Posted messages 4569 Registration date   Status Member 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 answers

  1.
    PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 512
     
    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
    1. PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 512
       
      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
  2. yclik Posted messages 3875 Registration date   Status Member Last intervention   1 611
     
    Good evening
    maybe all the sheets are selected
    Right-click on a tab > Deselect all sheets
    0
    1. ciney15 Posted messages 11 Status Member
       
      Thank you for this suggestion.
      I just tried, but no, the sheets were not selected.
      Something else, maybe?.....
      0
  3. shunesburg69 Posted messages 1061 Registration date   Status Member Last intervention   221
     
    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
    1. ciney15 Posted messages 11 Status Member
       
      The menu offers me, besides "copy...", only "select all sheets" and "sheet events".
      0
  4. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
     
    Either you have protected your workbook, or you have macros...

    --
    Retirement is great! Especially in the West Indies... :-)
    Raymond (INSA, AFPA, CF/R)
    0
    1. 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
  6. shunesburg69 Posted messages 1061 Registration date   Status Member Last intervention   221
     
    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
    1. ciney15
       
      As requested, here is the link to the relevant file. Thank you for your upcoming proposals!
      http://www.cjoint.com/c/FHouuqwNwsz
      0
  7. OOoForum Posted messages 3871 Registration date   Status Member Last intervention   965
     
    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
    1. shunesburg69 Posted messages 1061 Registration date   Status Member Last intervention   221
       
      I've never had this issue, it's a strange behavior, and even if the file was saved in ods?
      0
      1. ciney15 > shunesburg69 Posted messages 1061 Registration date   Status Member 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