Copying and Moving Styles

Apache OpenOffice 4.1 Calc Guide

Chapter 4: Styles and Templates

< Previous Section

Next Section >

• What is a Template?
• What are Styles?
• Types of Styles in Calc
  • Cell Styles
  • Page Styles
• Accessing Styles
• Applying Cell Styles
  • Using the Styles and Formatting Window
  • Using Fill Format Mode
  • Using the Apply Style List
  • Assigning Styles to Shortcut Keys
• Applying Page Styles
• Modifying Styles
  • Style Organizer
  • Cell Style Options
    • Numbers
    • Font
    • Font Effects
    • Alignment
    • Borders
    • Background
    • Cell Protection
  • Page Style Options
    • Page
    • Borders
    • Background
    • Header
    • Footer
    • Sheet
• Creating New (Custom) Styles
  • Creating a New Style Using the Style Dialog
  • Creating a New Style from a Selection
  • Creating a New Style by Dragging and Dropping
• Copying and Moving Styles
• Deleting Styles
• Creating a Spreadsheet from a Template
• Creating a Template
• Editing a Template
  • Updating a Spreadsheet from a Changed Template
• Adding Templates Using the Extension Manager
• Setting a Default Template
  • Setting a Custom Template as the Default
  • Resetting the Default Template
• Associating a Spreadsheet with a Different Template
• Organizing Templates
  • Creating a Template Folder
  • Deleting a Template Folder
  • Moving a Template
  • Deleting a Template
  • Importing a Template
  • Exporting a Template

< Previous Page

Next Page >

Copying and Moving Styles

Use the Template Management dialog to copy a style from one spreadsheet to another or between a spreadsheet and a template instead of recreating it in the second spreadsheet.

1. Click File → Templates → Organize.
2. In the Template Management dialog (Figure 105), set the lists at the bottom to either Templates or Documents, as needed. The default is Templates on the left and Documents on the right.

Figure 105: Choosing to copy styles from a document, not a template.

To copy styles from a file that is not open, click the File button. When you return to this dialog, both lists show the selected file and all currently open documents.

3. Open the folders and find the templates from and to which you want to copy. Double-click on the template or document name, then double-click the Styles icon to show the list of individual styles (Figure 106).

Figure 106: Copying a style from one document to another.

4. To copy a style, hold down the  Ctrl  key and drag the name of the style from one list to the other.
5. Repeat these steps for each style you want to copy. If the receiving template or document has many styles, you may have to scroll down the list to find a specific item. When you are finished, click  Close .