1<?xml version="1.0" encoding="UTF-8"?>
2
3<!--***********************************************************
4 *
5 * Licensed to the Apache Software Foundation (ASF) under one
6 * or more contributor license agreements.  See the NOTICE file
7 * distributed with this work for additional information
8 * regarding copyright ownership.  The ASF licenses this file
9 * to you under the Apache License, Version 2.0 (the
10 * "License"); you may not use this file except in compliance
11 * with the License.  You may obtain a copy of the License at
12 *
13 *   http://www.apache.org/licenses/LICENSE-2.0
14 *
15 * Unless required by applicable law or agreed to in writing,
16 * software distributed under the License is distributed on an
17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
18 * KIND, either express or implied.  See the License for the
19 * specific language governing permissions and limitations
20 * under the License.
21 *
22 ***********************************************************-->
23
24<helpdocument version="1.0">
25<meta>
26<topic id="textscalc0105100000xml" indexer="include" status="PUBLISH">
27<title xml-lang="en-US" id="tit">Styles and Formatting</title>
28<filename>/text/scalc/01/05100000.xhp</filename>
29</topic>
30</meta>
31<body>
32<section id="gestalter">
33<bookmark xml-lang="en-US" branch="index" id="bm_id3150447">
34<bookmark_value>Stylist, see Styles and Formatting window</bookmark_value>
35<bookmark_value>Styles and Formatting window</bookmark_value>
36<bookmark_value>formats; Styles and Formatting window</bookmark_value>
37<bookmark_value>formatting; Styles and Formatting window</bookmark_value>
38<bookmark_value>paint can for applying styles</bookmark_value>
39</bookmark>
40<paragraph xml-lang="en-US" id="hd_id3150447" role="heading" level="1" l10n="CHG"
41oldref="1"><link href="text/scalc/01/05100000.xhp" name="Styles and Formatting">Styles and Formatting</link></paragraph>
42<paragraph xml-lang="en-US" id="par_id3147434" role="paragraph" l10n="CHG" oldref="2">Use the Styles and Formatting window to assign styles to objects and text sections. You can update Styles, modify existing Styles or create new Styles.</paragraph>
43</section>
44<paragraph xml-lang="en-US" id="par_id3149665" role="paragraph" l10n="CHG" oldref="30">The Styles and Formatting <link href="text/shared/00/00000005.xhp#andocken" name="dockable window">dockable window</link> can remain open while editing the document.</paragraph>
45<section id="howtoget">
46<embed href="text/shared/00/00040500.xhp#gestalter"/>
47</section>
48<paragraph xml-lang="en-US" id="hd_id3150012" role="heading" level="2" l10n="U"
49oldref="36">How to apply a cell style:</paragraph>
50<list type="ordered">
51<listitem>
52<paragraph xml-lang="en-US" id="par_id3159155" role="listitem" l10n="U" oldref="37">Select the cell or cell range.</paragraph>
53</listitem>
54<listitem>
55<paragraph xml-lang="en-US" id="par_id3145749" role="listitem" l10n="CHG" oldref="38">Double-click the style in the Styles and Formatting window.</paragraph>
56</listitem>
57</list>
58<bookmark xml-lang="en-US" branch="hid/.uno:ParaStyle" id="bm_id5973914" localize="false"/>
59<bookmark xml-lang="en-US" branch="hid/.uno:ParaStyle" id="bm_id3148456" localize="false"/>
60<paragraph xml-lang="en-US" id="hd_id3153877" role="heading" level="2" l10n="U" oldref="4">Cell Styles</paragraph>
61<paragraph xml-lang="en-US" id="par_id3145801" role="paragraph" l10n="U" oldref="6"><ahelp hid=".uno:ParaStyle">Displays the list of the available Cell Styles for <link href="text/shared/00/00000005.xhp#formatierung" name="indirect cell formatting">indirect cell formatting</link>.</ahelp></paragraph>
62<table id="tbl_id3155602">
63<tablerow>
64<tablecell>
65<paragraph xml-lang="en-US" id="par_id3150751" role="paragraph" l10n="E">
66<image id="img_id3153714" src="sc/res/sf01.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3153714">Icon</alt>
67</image></paragraph>
68</tablecell>
69<tablecell>
70<paragraph xml-lang="en-US" id="par_id3154255" role="paragraph" l10n="U" oldref="5">Cell Styles</paragraph>
71</tablecell>
72</tablerow>
73</table>
74<bookmark xml-lang="en-US" branch="hid/.uno:PageStyle" id="bm_id3839136" localize="false"/>
75<bookmark xml-lang="en-US" branch="hid/.uno:PageStyle" id="bm_id3155336" localize="false"/>
76<paragraph xml-lang="en-US" id="hd_id3153963" role="heading" level="2" l10n="U" oldref="7">Page Styles</paragraph>
77<paragraph xml-lang="en-US" id="par_id3147003" role="paragraph" l10n="CHG" oldref="9"><ahelp hid=".uno:PageStyle">Displays the Page Styles available for indirect page formatting.</ahelp></paragraph>
78<table id="tbl_id3145791">
79<tablerow>
80<tablecell>
81<paragraph xml-lang="en-US" id="par_id3159100" role="paragraph" l10n="E">
82<image id="img_id3149814" src="sw/imglst/sf04.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3149814">Icon</alt>
83</image></paragraph>
84</tablecell>
85<tablecell>
86<paragraph xml-lang="en-US" id="par_id3150361" role="paragraph" l10n="U" oldref="8">Page Styles</paragraph>
87</tablecell>
88</tablerow>
89</table>
90<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLDLG_WATERCAN" id="bm_id3150370" localize="false"/>
91<paragraph xml-lang="en-US" id="hd_id3150202" role="heading" level="2" l10n="U"
92oldref="10">Fill Format Mode</paragraph>
93<paragraph xml-lang="en-US" id="par_id3155531" role="paragraph" l10n="CHG" oldref="12"><ahelp hid="HID_TEMPLDLG_WATERCAN">Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles and Formatting window.</ahelp></paragraph>
94<table id="tbl_id3156445">
95<tablerow>
96<tablecell>
97<paragraph xml-lang="en-US" id="par_id3155087" role="paragraph" l10n="E">
98<image id="img_id3153068" src="res/commandimagelist/sc_fillstyle.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3153068">Icon</alt>
99</image></paragraph>
100</tablecell>
101<tablecell>
102<paragraph xml-lang="en-US" id="par_id3156198" role="paragraph" l10n="U" oldref="11">Fill Format Mode</paragraph>
103</tablecell>
104</tablerow>
105</table>
106<paragraph xml-lang="en-US" id="hd_id3148870" role="heading" level="2" l10n="U"
107oldref="13">How to apply a new style with the paint can:</paragraph>
108<list type="ordered">
109<listitem>
110<paragraph xml-lang="en-US" id="par_id3145078" role="listitem" l10n="CHG" oldref="27">Select the desired style from the Styles and Formatting window.</paragraph>
111</listitem>
112<listitem>
113<paragraph xml-lang="en-US" id="par_id3159098" role="listitem" l10n="U" oldref="28">Click the <emph>Fill Format Mode</emph> icon.</paragraph>
114</listitem>
115<listitem>
116<paragraph xml-lang="en-US" id="par_id3148609" role="listitem" l10n="U" oldref="15">Click a cell to format it, or drag your mouse over a certain range to format the whole range. Repeat this action for other cells and ranges.</paragraph>
117</listitem>
118<listitem>
119<paragraph xml-lang="en-US" id="par_id3149438" role="listitem" l10n="U" oldref="29">Click the <emph>Fill Format Mode</emph> again to exit this mode.</paragraph>
120</listitem>
121</list>
122<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLDLG_NEWBYEXAMPLE" id="bm_id3150891" localize="false"/>
123<paragraph xml-lang="en-US" id="hd_id3153975" role="heading" level="2" l10n="U"
124oldref="16">New Style from Selection</paragraph>
125<paragraph xml-lang="en-US" id="par_id3149499" l10n="CHG" oldref="18"><ahelp hid="HID_TEMPLDLG_NEWBYEXAMPLE">Creates a new style based on the formatting of a selected object.</ahelp> Assign a name for the style in the <link href="text/shared/01/05140100.xhp" name="Create Style">Create Style</link> dialog.</paragraph>
126<table id="tbl_id3152873">
127<tablerow>
128<tablecell>
129<paragraph xml-lang="en-US" id="par_id3150050" role="paragraph" l10n="E">
130<image id="img_id3154649" src="res/commandimagelist/sc_stylenewbyexample.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3154649">Icon</alt>
131</image></paragraph>
132</tablecell>
133<tablecell>
134<paragraph xml-lang="en-US" id="par_id3146963" role="paragraph" l10n="U" oldref="17">New Style from Selection</paragraph>
135</tablecell>
136</tablerow>
137</table>
138<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLDLG_UPDATEBYEXAMPLE" id="bm_id3153486" localize="false"/>
139<paragraph xml-lang="en-US" id="hd_id3153813" role="heading" level="2" l10n="U"
140oldref="19">Update Style</paragraph>
141<paragraph xml-lang="en-US" id="par_id3154707" role="paragraph" l10n="CHG" oldref="21"><ahelp hid="HID_TEMPLDLG_UPDATEBYEXAMPLE">Updates the Style selected in the Styles and Formatting window with the current formatting of the selected object.</ahelp></paragraph>
142<table id="tbl_id3149317">
143<tablerow>
144<tablecell>
145<paragraph xml-lang="en-US" id="par_id3145118" role="paragraph" l10n="E">
146<image id="img_id3155754" src="res/commandimagelist/sc_styleupdatebyexample.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3155754">Icon</alt>
147</image></paragraph>
148</tablecell>
149<tablecell>
150<paragraph xml-lang="en-US" id="par_id3147501" role="paragraph" l10n="U" oldref="20">Update Style</paragraph>
151</tablecell>
152</tablerow>
153</table>
154<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLATE_FMT" id="bm_id3147436" localize="false"/>
155<paragraph xml-lang="en-US" id="par_idN109BE" role="heading" level="2" l10n="NEW">Style List</paragraph>
156<paragraph xml-lang="en-US" id="par_idN109C2" role="paragraph" l10n="NEW"><ahelp hid="HID_TEMPLATE_FMT">Displays the list of the styles from the selected style category.</ahelp></paragraph>
157<paragraph xml-lang="en-US" id="par_idN109D1" role="paragraph" l10n="NEW">In the <link href="text/shared/00/00000005.xhp#kontextmenue" name="context menu">context menu</link> you can choose commands to create a new style, delete a user-defined style, or change the selected style.</paragraph>
158<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLATE_FILTER" id="bm_id3151339" localize="false"/>
159<paragraph xml-lang="en-US" id="hd_id3149053" role="heading" level="2" l10n="CHG"
160oldref="24">Style Groups<comment>UFI: use "groups" to be consistent with Writer</comment></paragraph>
161<paragraph xml-lang="en-US" id="par_id3147299" role="paragraph" l10n="CHG" oldref="25"><ahelp hid="HID_TEMPLATE_FILTER">Lists the available style groups.</ahelp></paragraph>
162</body>
163</helpdocument>
164