Formatting Spreadsheets Using Themes

From Apache OpenOffice Wiki
Jump to: navigation, search

Formatting Spreadsheets Using Themes

Calc comes with a predefined set of formatting themes that you can apply to your spreadsheets.

It is not possible to add themes to Calc, and they can not be modified. However, you can modify their styles after you apply them to a spreadsheet.

To apply a theme to a spreadsheet:

  1. Click the Choose Themes icon in the Tools toolbar. If this toolbar is not visible, you can show it using View → Toolbars → Tools.
  2. The Theme Selection dialog appears. This dialog lists the available themes for the whole spreadsheet.
AOO41GS05 046.png
Figure 98: Tools toolbar with the Choose Themes icon highlighted
  1. In the Theme Selection dialog, select the theme that you want to apply to the spreadsheet. As soon as you select a theme, some properties of the custom styles are applied to the open spreadsheet and are immediately visible.
  2. Click  OK . If you wish, you can now go to the Styles and Formatting window to modify specific styles. These modifications do not change the theme; they only change the appearance of this specific spreadsheet document.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools