OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido descargar pdf (Pagina 168)

100

101

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 cannot 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.

The Theme Selection dialog appears. This dialog lists the

available themes for the whole spreadsheet.

2) In the Theme Selection dialog, select the theme that you want to

apply to the spreadsheet.

As soon as you select a theme, some of the properties of the

custom styles are applied to the open spreadsheet and are

immediately visible.

3) 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

spreadsheet document.

Using conditional formatting

You can set up cell formats to change depending on conditions that you

specify. For example, in a table of numbers, you can show all the values

above the average in green and all those below the average in red.

Conditional formatting depends upon the use of styles, and the

AutoCalculate feature (Tools > Cell Contents > AutoCalculate)

must be enabled. See Chapter 2 in the Calc Guide for details.

168 Getting Started with OpenOffice.org 3.x

Free eBook Edition

1 2 ... 163 164 165 166 167 168 169 170 171 172 173 ... 441 442

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 168

Comentarios a estos manuales

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 168

Comentarios a estos manuales

Relacionado con productos y manuales para Software De Gráficos OpenOffice.org OpenOffice - 3.2