1 <?xml version=
"1.0" encoding=
"UTF-8"?>
6 ***********************************************************************
8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
10 * Copyright 2008 by Sun Microsystems, Inc.
12 * OpenOffice.org - a multi-platform office productivity suite
14 * $RCSfile: design.xhp,v $
17 * This file is part of OpenOffice.org.
19 * OpenOffice.org is free software: you can redistribute it and/or modify
20 * it under the terms of the GNU Lesser General Public License version 3
21 * only, as published by the Free Software Foundation.
23 * OpenOffice.org is distributed in the hope that it will be useful,
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
26 * GNU Lesser General Public License version 3 for more details
27 * (a copy is included in the LICENSE file that accompanied this code).
29 * You should have received a copy of the GNU Lesser General Public License
30 * version 3 along with OpenOffice.org. If not, see
31 * <http://www.openoffice.org/license.html>
32 * for a copy of the LGPLv3 License.
34 ************************************************************************
38 <helpdocument version=
"1.0">
40 <topic id=
"textscalcguidedesignxml" indexer=
"include" status=
"PUBLISH">
41 <title xml-lang=
"en-US" id=
"tit">Selecting Themes for Sheets
</title>
42 <filename>/text/scalc/guide/design.xhp
</filename>
49 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3150791"><bookmark_value>theme selection for sheets
</bookmark_value>
50 <bookmark_value>layout;spreadsheets
</bookmark_value>
51 <bookmark_value>cell styles; selecting
</bookmark_value>
52 <bookmark_value>selecting;formatting themes
</bookmark_value>
53 <bookmark_value>sheets;formatting themes
</bookmark_value>
54 <bookmark_value>formats;themes for sheets
</bookmark_value>
55 <bookmark_value>formatting;themes for sheets
</bookmark_value>
57 <comment>mw deleted
"applying;"</comment>
58 <paragraph xml-lang=
"en-US" id=
"hd_id3150791" role=
"heading" level=
"1" l10n=
"U" oldref=
"6"><variable id=
"design"><link href=
"text/scalc/guide/design.xhp" name=
"Selecting Themes for Sheets">Selecting Themes for Sheets
</link>
59 </variable></paragraph>
60 <paragraph xml-lang=
"en-US" id=
"par_id3145786" role=
"paragraph" l10n=
"U" oldref=
"13">$[officename] Calc comes with a predefined set of formatting themes that you can apply to your spreadsheets.
</paragraph>
61 <paragraph xml-lang=
"en-US" id=
"par_id3154490" role=
"paragraph" l10n=
"U" oldref=
"16">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.
</paragraph>
62 <paragraph xml-lang=
"en-US" id=
"par_id3154757" role=
"paragraph" l10n=
"U" oldref=
"17">Before you format a sheet with a theme, you have to apply at least one custom cell style to the cells on the sheet. You can then change the cell formatting by selecting and applying a theme in the
<emph>Theme Selection
</emph> dialog.
</paragraph>
63 <paragraph xml-lang=
"en-US" id=
"par_id3156382" role=
"paragraph" l10n=
"U" oldref=
"18">To apply a custom cell style to a cell, you can open the Styles and Formatting window and, in its lower list box, set the Custom Styles view. A list of the existing custom defined cell styles will be displayed. Double click a name from the Styles and Formatting window to apply this style to the selected cells.
</paragraph>
64 <paragraph xml-lang=
"en-US" id=
"par_id3153963" role=
"paragraph" l10n=
"U" oldref=
"19">To apply a theme to a spreadsheet:
</paragraph>
67 <paragraph xml-lang=
"en-US" id=
"par_id3146920" role=
"listitem" l10n=
"CHG" oldref=
"15">Click the
<emph>Choose Themes
</emph> icon in the
<emph>Tools
</emph> bar.
</paragraph>
68 <embed href=
"text/scalc/02/06080000.xhp#sythemen"/>
69 <paragraph xml-lang=
"en-US" id=
"par_id3148488" role=
"listitem" l10n=
"CHG" oldref=
"20">The
<emph>Theme Selection
</emph> dialog appears. This dialog lists the available themes for the whole spreadsheet and the Styles and Formatting window lists the custom styles for specific cells.
</paragraph>
72 <paragraph xml-lang=
"en-US" id=
"par_id3155114" role=
"listitem" l10n=
"U" oldref=
"9">In the
<emph>Theme Selection
</emph>dialog, select the theme that you want to apply to the spreadsheet.
</paragraph>
75 <paragraph xml-lang=
"en-US" id=
"par_id3150090" role=
"listitem" l10n=
"U" oldref=
"21">Click OK
</paragraph>
76 <paragraph xml-lang=
"en-US" id=
"par_id3150201" role=
"listitem" l10n=
"U" oldref=
"22">As soon as you select another theme in the
<emph>Theme Selection
</emph> dialog, some of the properties of the custom style will be applied to the current spreadsheet. The modifications will be immediately visible in your spreadsheet.
</paragraph>
79 <section id=
"relatedtopics">
81 <embed href=
"text/scalc/guide/autoformat.xhp#autoformat"/>
82 <paragraph xml-lang=
"en-US" id=
"par_id3146979" role=
"paragraph" l10n=
"U" oldref=
"12"><link href=
"text/scalc/02/06080000.xhp" name=
"Theme selection">Theme selection
</link></paragraph>