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