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>