Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Copying and moving styles"

From Apache OpenOffice Wiki
Jump to: navigation, search
(New page: {{DISPLAYTITLE:Copying, moving, and deleting styles}} {{Documentation/CG3Ch10TOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Creating new styles |NextPage=Docum...)
 
 
(One intermediate revision by one other user not shown)
Line 12: Line 12:
 
<li>In the Template Management dialog, 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.</li>
 
<li>In the Template Management dialog, 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.</li>
  
{{Documentation/Tip| 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 as well as all the currently open documents.}}
+
{{Tip| 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 as well as all the currently open documents.}}
  
 
<li>Open the folders and find the templates from and to which you want to copy. Double-click on the name of the template or document, and then double-click the Styles icon to show the list of individual styles.</li>
 
<li>Open the folders and find the templates from and to which you want to copy. Double-click on the name of the template or document, and then double-click the Styles icon to show the list of individual styles.</li>
Line 21: Line 21:
 
<li>Repeat for each style you want to copy. If the receiving template or document has many styles, you may not see any change unless you scroll down in the list. When you are finished, click '''Close'''.</li>
 
<li>Repeat for each style you want to copy. If the receiving template or document has many styles, you may not see any change unless you scroll down in the list. When you are finished, click '''Close'''.</li>
  
[[Image:StylesTemplMgt2.png|thumb|none|500px|''Copying a style from one document to another.'']]
+
[[Image:Ch4F9_1.png|thumb|none|500px|''Copying a style from one document to another.'']]
 
</ol>
 
</ol>
  

Latest revision as of 21:18, 15 July 2018



Copying and moving styles

Occasionally you may want to copy a style from one spreadsheet to another, or between a spreadsheet and a template, instead of recreating it in the second spreadsheet. You can do this using the Template Management dialog.

  1. Click File > Templates > Organize.
  2. In the Template Management dialog, 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.
  3. Tip.png 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 as well as all the currently open documents.


  4. Open the folders and find the templates from and to which you want to copy. Double-click on the name of the template or document, and then double-click the Styles icon to show the list of individual styles.
  5. To copy a style, hold down the Ctrl key and drag the name of the style from one list to the other.
  6. Choosing to copy styles from a document, not a template.
  7. Repeat for each style you want to copy. If the receiving template or document has many styles, you may not see any change unless you scroll down in the list. When you are finished, click Close.
  8. Copying a style from one document to another.

Deleting styles

You cannot remove (delete) any of Calc’s predefined styles, even if you are not using them.

You can remove any user-defined (custom) styles; but before you do, you should make sure the styles are not in use. If an unwanted style is in use, you will want to replace it with a substitute style.

Replacing styles (and then deleting the unwanted ones) can be very useful if you are dealing with a spreadsheet that has been worked on by several people.

To delete unwanted styles, right-click on them (one at a time) in the Styles and Formatting window and click Delete on the pop-up menu. Select Yes in the confirmation pop-up.


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools