Translations:Faq/Calc/145/6/en

    From The Document Foundation Wiki

    Please follow all steps :

    1. Copy the range containing the controls
    2. Create a new "work spreadsheet" containing four sheets with same names in the "initial" but with sheets "source" (B) and "target" (D) swapped:
      copie d'écran
      "Work" spreadsheet : sheets B and D swapped
    3. Paste in the sheet D of the "work" spreadsheet
    4. Save (you can use any name) and close the "work" spreadsheet
    5. Reopen the the "work" spreadsheet
    6. Restore the initial positions of sheets:
      copie d'écran
      "Work" spreadsheet : sheets positions restored
    7. Copy the range containing the controls
    8. Paste into the sheet D of the original spreadsheet
    9. Save, close, and reopen the spreadsheet.