xref: /trunk/main/helpcontent2/source/text/scalc/01/05100000.xhp (revision 17fc61f3a15bef512c3b3b900ca61de59fe4462d)
1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?>
2cdf0e10cSrcweir
302dbb15cSAndrew Rist<!--***********************************************************
4cdf0e10cSrcweir *
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
12cdf0e10cSrcweir *
1302dbb15cSAndrew Rist *   http://www.apache.org/licenses/LICENSE-2.0
14cdf0e10cSrcweir *
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.
21cdf0e10cSrcweir *
2202dbb15cSAndrew Rist ***********************************************************-->
2302dbb15cSAndrew Rist
24c2b55da1Smseidel<helpdocument version="1.0">
25cdf0e10cSrcweir<meta>
26cdf0e10cSrcweir<topic id="textscalc0105100000xml" indexer="include" status="PUBLISH">
27cdf0e10cSrcweir<title xml-lang="en-US" id="tit">Styles and Formatting</title>
28cdf0e10cSrcweir<filename>/text/scalc/01/05100000.xhp</filename>
29cdf0e10cSrcweir</topic>
30cdf0e10cSrcweir</meta>
31cdf0e10cSrcweir<body>
32cdf0e10cSrcweir<section id="gestalter">
33c2b55da1Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3150447">
34c2b55da1Smseidel<bookmark_value>Stylist, see Styles and Formatting window</bookmark_value>
35cdf0e10cSrcweir<bookmark_value>Styles and Formatting window</bookmark_value>
36cdf0e10cSrcweir<bookmark_value>formats; Styles and Formatting window</bookmark_value>
37cdf0e10cSrcweir<bookmark_value>formatting; Styles and Formatting window</bookmark_value>
38cdf0e10cSrcweir<bookmark_value>paint can for applying styles</bookmark_value>
39cdf0e10cSrcweir</bookmark>
40*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3150447" role="heading" level="1" l10n="CHG"><link href="text/scalc/01/05100000.xhp" name="Styles and Formatting">Styles and Formatting</link></paragraph>
41*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3147434" role="paragraph" l10n="CHG">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>
42cdf0e10cSrcweir</section>
43*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3149665" role="paragraph" l10n="CHG">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>
44cdf0e10cSrcweir<section id="howtoget">
45cdf0e10cSrcweir<embed href="text/shared/00/00040500.xhp#gestalter"/>
46cdf0e10cSrcweir</section>
47*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3150012" role="heading" level="2" l10n="U">How to apply a cell style:</paragraph>
48cdf0e10cSrcweir<list type="ordered">
49cdf0e10cSrcweir<listitem>
50*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3159155" role="listitem" l10n="U">Select the cell or cell range.</paragraph>
51cdf0e10cSrcweir</listitem>
52cdf0e10cSrcweir<listitem>
53*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3145749" role="listitem" l10n="CHG">Double-click the style in the Styles and Formatting window.</paragraph>
54cdf0e10cSrcweir</listitem>
55cdf0e10cSrcweir</list>
56cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:ParaStyle" id="bm_id5973914" localize="false"/>
57cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:ParaStyle" id="bm_id3148456" localize="false"/>
58*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3153877" role="heading" level="2" l10n="U">Cell Styles</paragraph>
59*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3145801" role="paragraph" l10n="U"><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>
60cdf0e10cSrcweir<table id="tbl_id3155602">
61cdf0e10cSrcweir<tablerow>
62cdf0e10cSrcweir<tablecell>
63cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id3150751" role="paragraph" l10n="E">
64cdf0e10cSrcweir<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>
65cdf0e10cSrcweir</image></paragraph>
66cdf0e10cSrcweir</tablecell>
67cdf0e10cSrcweir<tablecell>
68*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3154255" role="paragraph" l10n="U">Cell Styles</paragraph>
69cdf0e10cSrcweir</tablecell>
70cdf0e10cSrcweir</tablerow>
71cdf0e10cSrcweir</table>
72cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:PageStyle" id="bm_id3839136" localize="false"/>
73cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:PageStyle" id="bm_id3155336" localize="false"/>
74*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3153963" role="heading" level="2" l10n="U">Page Styles</paragraph>
75*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3147003" role="paragraph" l10n="CHG"><ahelp hid=".uno:PageStyle">Displays the Page Styles available for indirect page formatting.</ahelp></paragraph>
76cdf0e10cSrcweir<table id="tbl_id3145791">
77cdf0e10cSrcweir<tablerow>
78cdf0e10cSrcweir<tablecell>
79cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id3159100" role="paragraph" l10n="E">
80cdf0e10cSrcweir<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>
81cdf0e10cSrcweir</image></paragraph>
82cdf0e10cSrcweir</tablecell>
83cdf0e10cSrcweir<tablecell>
84*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3150361" role="paragraph" l10n="U">Page Styles</paragraph>
85cdf0e10cSrcweir</tablecell>
86cdf0e10cSrcweir</tablerow>
87cdf0e10cSrcweir</table>
88cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLDLG_WATERCAN" id="bm_id3150370" localize="false"/>
89*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3150202" role="heading" level="2" l10n="U">Fill Format Mode</paragraph>
90*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3155531" role="paragraph" l10n="CHG"><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>
91cdf0e10cSrcweir<table id="tbl_id3156445">
92cdf0e10cSrcweir<tablerow>
93cdf0e10cSrcweir<tablecell>
94cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id3155087" role="paragraph" l10n="E">
95cdf0e10cSrcweir<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>
96cdf0e10cSrcweir</image></paragraph>
97cdf0e10cSrcweir</tablecell>
98cdf0e10cSrcweir<tablecell>
99*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3156198" role="paragraph" l10n="U">Fill Format Mode</paragraph>
100cdf0e10cSrcweir</tablecell>
101cdf0e10cSrcweir</tablerow>
102cdf0e10cSrcweir</table>
103*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3148870" role="heading" level="2" l10n="U">How to apply a new style with the paint can:</paragraph>
104cdf0e10cSrcweir<list type="ordered">
105cdf0e10cSrcweir<listitem>
106*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3145078" role="listitem" l10n="CHG">Select the desired style from the Styles and Formatting window.</paragraph>
107cdf0e10cSrcweir</listitem>
108cdf0e10cSrcweir<listitem>
109*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3159098" role="listitem" l10n="U">Click the <emph>Fill Format Mode</emph> icon.</paragraph>
110cdf0e10cSrcweir</listitem>
111cdf0e10cSrcweir<listitem>
112*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3148609" role="listitem" l10n="U">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>
113cdf0e10cSrcweir</listitem>
114cdf0e10cSrcweir<listitem>
115*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3149438" role="listitem" l10n="U">Click the <emph>Fill Format Mode</emph> again to exit this mode.</paragraph>
116cdf0e10cSrcweir</listitem>
117cdf0e10cSrcweir</list>
118cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLDLG_NEWBYEXAMPLE" id="bm_id3150891" localize="false"/>
119*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3153975" role="heading" level="2" l10n="U">New Style from Selection</paragraph>
120*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3149499" l10n="CHG"><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>
121cdf0e10cSrcweir<table id="tbl_id3152873">
122cdf0e10cSrcweir<tablerow>
123cdf0e10cSrcweir<tablecell>
124cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id3150050" role="paragraph" l10n="E">
125cdf0e10cSrcweir<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>
126cdf0e10cSrcweir</image></paragraph>
127cdf0e10cSrcweir</tablecell>
128cdf0e10cSrcweir<tablecell>
129*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3146963" role="paragraph" l10n="U">New Style from Selection</paragraph>
130cdf0e10cSrcweir</tablecell>
131cdf0e10cSrcweir</tablerow>
132cdf0e10cSrcweir</table>
133cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLDLG_UPDATEBYEXAMPLE" id="bm_id3153486" localize="false"/>
134*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3153813" role="heading" level="2" l10n="U">Update Style</paragraph>
135*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3154707" role="paragraph" l10n="CHG"><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>
136cdf0e10cSrcweir<table id="tbl_id3149317">
137cdf0e10cSrcweir<tablerow>
138cdf0e10cSrcweir<tablecell>
139cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id3145118" role="paragraph" l10n="E">
140cdf0e10cSrcweir<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>
141cdf0e10cSrcweir</image></paragraph>
142cdf0e10cSrcweir</tablecell>
143cdf0e10cSrcweir<tablecell>
144*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3147501" role="paragraph" l10n="U">Update Style</paragraph>
145cdf0e10cSrcweir</tablecell>
146cdf0e10cSrcweir</tablerow>
147cdf0e10cSrcweir</table>
148cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLATE_FMT" id="bm_id3147436" localize="false"/>
149cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_idN109BE" role="heading" level="2" l10n="NEW">Style List</paragraph>
150cdf0e10cSrcweir<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>
151cdf0e10cSrcweir<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>
152cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TEMPLATE_FILTER" id="bm_id3151339" localize="false"/>
153*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3149053" role="heading" level="2" l10n="CHG">Style Groups<comment>UFI: use "groups" to be consistent with Writer</comment></paragraph>
154*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3147299" role="paragraph" l10n="CHG"><ahelp hid="HID_TEMPLATE_FILTER">Lists the available style groups.</ahelp></paragraph>
155cdf0e10cSrcweir</body>
156cdf0e10cSrcweir</helpdocument>
157