1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?>
2cdf0e10cSrcweir<helpdocument version="1.0">
3cdf0e10cSrcweir
4*02dbb15cSAndrew Rist<!--***********************************************************
5cdf0e10cSrcweir *
6*02dbb15cSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one
7*02dbb15cSAndrew Rist * or more contributor license agreements.  See the NOTICE file
8*02dbb15cSAndrew Rist * distributed with this work for additional information
9*02dbb15cSAndrew Rist * regarding copyright ownership.  The ASF licenses this file
10*02dbb15cSAndrew Rist * to you under the Apache License, Version 2.0 (the
11*02dbb15cSAndrew Rist * "License"); you may not use this file except in compliance
12*02dbb15cSAndrew Rist * with the License.  You may obtain a copy of the License at
13*02dbb15cSAndrew Rist *
14*02dbb15cSAndrew Rist *   http://www.apache.org/licenses/LICENSE-2.0
15*02dbb15cSAndrew Rist *
16*02dbb15cSAndrew Rist * Unless required by applicable law or agreed to in writing,
17*02dbb15cSAndrew Rist * software distributed under the License is distributed on an
18*02dbb15cSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
19*02dbb15cSAndrew Rist * KIND, either express or implied.  See the License for the
20*02dbb15cSAndrew Rist * specific language governing permissions and limitations
21*02dbb15cSAndrew Rist * under the License.
22*02dbb15cSAndrew Rist *
23*02dbb15cSAndrew Rist ***********************************************************-->
24*02dbb15cSAndrew Rist
25*02dbb15cSAndrew Rist
26cdf0e10cSrcweir
27cdf0e10cSrcweir
28cdf0e10cSrcweir<meta>
29cdf0e10cSrcweir      <topic id="textscalc0105100000xml" indexer="include" status="PUBLISH">
30cdf0e10cSrcweir         <title xml-lang="en-US" id="tit">Styles and Formatting</title>
31cdf0e10cSrcweir         <filename>/text/scalc/01/05100000.xhp</filename>
32cdf0e10cSrcweir      </topic>
33cdf0e10cSrcweir   </meta>
34cdf0e10cSrcweir   <body>
35cdf0e10cSrcweir      <section id="gestalter">
36cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3150447"><bookmark_value>Stylist, see Styles and Formatting window</bookmark_value>
37cdf0e10cSrcweir         <bookmark_value>Styles and Formatting window</bookmark_value>
38cdf0e10cSrcweir         <bookmark_value>formats; Styles and Formatting window</bookmark_value>
39cdf0e10cSrcweir         <bookmark_value>formatting; Styles and Formatting window</bookmark_value>
40cdf0e10cSrcweir         <bookmark_value>paint can for applying styles</bookmark_value>
41cdf0e10cSrcweir</bookmark>
42cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3150447" role="heading" level="1" l10n="CHG"
43cdf0e10cSrcweir                    oldref="1"><link href="text/scalc/01/05100000.xhp" name="Styles and Formatting">Styles and Formatting</link></paragraph>
44cdf0e10cSrcweir         <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>
45cdf0e10cSrcweir      </section>
46cdf0e10cSrcweir      <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>
47cdf0e10cSrcweir      <section id="howtoget">
48cdf0e10cSrcweir         <embed href="text/shared/00/00040500.xhp#gestalter"/>
49cdf0e10cSrcweir      </section>
50cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="hd_id3150012" role="heading" level="2" l10n="U"
51cdf0e10cSrcweir                 oldref="36">How to apply a cell style:</paragraph>
52cdf0e10cSrcweir      <list type="ordered">
53cdf0e10cSrcweir         <listitem>
54cdf0e10cSrcweir            <paragraph xml-lang="en-US" id="par_id3159155" role="listitem" l10n="U" oldref="37">Select the cell or cell range.</paragraph>
55cdf0e10cSrcweir         </listitem>
56cdf0e10cSrcweir         <listitem>
57cdf0e10cSrcweir            <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>
58cdf0e10cSrcweir         </listitem>
59cdf0e10cSrcweir      </list>
60cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:ParaStyle" id="bm_id5973914" localize="false"/>
61cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:ParaStyle" id="bm_id3148456" localize="false"/>
62cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153877" role="heading" level="2" l10n="U" oldref="4">Cell Styles</paragraph>
63cdf0e10cSrcweir      <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>
64cdf0e10cSrcweir      <table id="tbl_id3155602">
65cdf0e10cSrcweir         <tablerow>
66cdf0e10cSrcweir            <tablecell>
67cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3150751" role="paragraph" l10n="E">
68cdf0e10cSrcweir<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>
69cdf0e10cSrcweir	</image></paragraph>
70cdf0e10cSrcweir            </tablecell>
71cdf0e10cSrcweir            <tablecell>
72cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3154255" role="paragraph" l10n="U" oldref="5">Cell Styles</paragraph>
73cdf0e10cSrcweir            </tablecell>
74cdf0e10cSrcweir         </tablerow>
75cdf0e10cSrcweir      </table>
76cdf0e10cSrcweir
77cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:PageStyle" id="bm_id3839136" localize="false"/>
78cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:PageStyle" id="bm_id3155336" localize="false"/>
79cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153963" role="heading" level="2" l10n="U" oldref="7">Page Styles</paragraph>
80cdf0e10cSrcweir      <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>
81cdf0e10cSrcweir      <table id="tbl_id3145791">
82cdf0e10cSrcweir         <tablerow>
83cdf0e10cSrcweir            <tablecell>
84cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3159100" role="paragraph" l10n="E">
85cdf0e10cSrcweir<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>
86cdf0e10cSrcweir	</image></paragraph>
87cdf0e10cSrcweir            </tablecell>
88cdf0e10cSrcweir            <tablecell>
89cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3150361" role="paragraph" l10n="U" oldref="8">Page Styles</paragraph>
90cdf0e10cSrcweir            </tablecell>
91cdf0e10cSrcweir         </tablerow>
92cdf0e10cSrcweir      </table>
93cdf0e10cSrcweir
94cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLDLG_WATERCAN" id="bm_id3150370" localize="false"/>
95cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3150202" role="heading" level="2" l10n="U"
96cdf0e10cSrcweir                 oldref="10">Fill Format Mode</paragraph>
97cdf0e10cSrcweir      <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>
98cdf0e10cSrcweir      <table id="tbl_id3156445">
99cdf0e10cSrcweir         <tablerow>
100cdf0e10cSrcweir            <tablecell>
101cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3155087" role="paragraph" l10n="E">
102cdf0e10cSrcweir<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>
103cdf0e10cSrcweir	</image></paragraph>
104cdf0e10cSrcweir            </tablecell>
105cdf0e10cSrcweir            <tablecell>
106cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3156198" role="paragraph" l10n="U" oldref="11">Fill Format Mode</paragraph>
107cdf0e10cSrcweir            </tablecell>
108cdf0e10cSrcweir         </tablerow>
109cdf0e10cSrcweir      </table>
110cdf0e10cSrcweir
111cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="hd_id3148870" role="heading" level="2" l10n="U"
112cdf0e10cSrcweir                 oldref="13">How to apply a new style with the paint can:</paragraph>
113cdf0e10cSrcweir      <list type="ordered">
114cdf0e10cSrcweir         <listitem>
115cdf0e10cSrcweir            <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>
116cdf0e10cSrcweir         </listitem>
117cdf0e10cSrcweir         <listitem>
118cdf0e10cSrcweir            <paragraph xml-lang="en-US" id="par_id3159098" role="listitem" l10n="U" oldref="28">Click the <emph>Fill Format Mode</emph> icon.</paragraph>
119cdf0e10cSrcweir         </listitem>
120cdf0e10cSrcweir         <listitem>
121cdf0e10cSrcweir            <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>
122cdf0e10cSrcweir         </listitem>
123cdf0e10cSrcweir         <listitem>
124cdf0e10cSrcweir            <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>
125cdf0e10cSrcweir         </listitem>
126cdf0e10cSrcweir      </list>
127cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLDLG_NEWBYEXAMPLE" id="bm_id3150891" localize="false"/>
128cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153975" role="heading" level="2" l10n="U"
129cdf0e10cSrcweir                 oldref="16">New Style from Selection</paragraph>
130cdf0e10cSrcweir      <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>
131cdf0e10cSrcweir      <table id="tbl_id3152873">
132cdf0e10cSrcweir         <tablerow>
133cdf0e10cSrcweir            <tablecell>
134cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3150050" role="paragraph" l10n="E">
135cdf0e10cSrcweir<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>
136cdf0e10cSrcweir	</image></paragraph>
137cdf0e10cSrcweir            </tablecell>
138cdf0e10cSrcweir            <tablecell>
139cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3146963" role="paragraph" l10n="U" oldref="17">New Style from Selection</paragraph>
140cdf0e10cSrcweir            </tablecell>
141cdf0e10cSrcweir         </tablerow>
142cdf0e10cSrcweir      </table>
143cdf0e10cSrcweir
144cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLDLG_UPDATEBYEXAMPLE" id="bm_id3153486" localize="false"/>
145cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153813" role="heading" level="2" l10n="U"
146cdf0e10cSrcweir                 oldref="19">Update Style</paragraph>
147cdf0e10cSrcweir      <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>
148cdf0e10cSrcweir      <table id="tbl_id3149317">
149cdf0e10cSrcweir         <tablerow>
150cdf0e10cSrcweir            <tablecell>
151cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3145118" role="paragraph" l10n="E">
152cdf0e10cSrcweir<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>
153cdf0e10cSrcweir	</image></paragraph>
154cdf0e10cSrcweir            </tablecell>
155cdf0e10cSrcweir            <tablecell>
156cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3147501" role="paragraph" l10n="U" oldref="20">Update Style</paragraph>
157cdf0e10cSrcweir            </tablecell>
158cdf0e10cSrcweir         </tablerow>
159cdf0e10cSrcweir      </table>
160cdf0e10cSrcweir
161cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLATE_FMT" id="bm_id3147436" localize="false"/>
162cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_idN109BE" role="heading" level="2" l10n="NEW">Style List</paragraph>
163cdf0e10cSrcweir      <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>
164cdf0e10cSrcweir      <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>
165cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLATE_FILTER" id="bm_id3151339" localize="false"/>
166cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3149053" role="heading" level="2" l10n="CHG"
167cdf0e10cSrcweir                 oldref="24">Style Groups<comment>UFI: use "groups" to be consistent with Writer</comment></paragraph>
168cdf0e10cSrcweir      <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>
169cdf0e10cSrcweir   </body>
170cdf0e10cSrcweir</helpdocument>