Translations:Faq/Calc/145/6/en

From The Document Foundation Wiki
Jump to: navigation, search

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.