160 lines
9 KiB
XML
160 lines
9 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<helpdocument version="1.0">
|
|
<!--
|
|
* This file is part of the LibreOffice project.
|
|
*
|
|
* This Source Code Form is subject to the terms of the Mozilla Public
|
|
* License, v. 2.0. If a copy of the MPL was not distributed with this
|
|
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
|
|
*
|
|
* This file incorporates work covered by the following license notice:
|
|
*
|
|
* Licensed to the Apache Software Foundation (ASF) under one or more
|
|
* contributor license agreements. See the NOTICE file distributed
|
|
* with this work for additional information regarding copyright
|
|
* ownership. The ASF licenses this file to you under the Apache
|
|
* License, Version 2.0 (the "License"); you may not use this file
|
|
* except in compliance with the License. You may obtain a copy of
|
|
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
|
|
-->
|
|
|
|
<meta>
|
|
<topic id="textscalc0105110000xml" indexer="include">
|
|
<title id="tit">AutoFormat</title>
|
|
<filename>/text/shared/01/AutoFormat.xhp</filename>
|
|
</topic>
|
|
</meta>
|
|
|
|
<body>
|
|
<bookmark branch="hid/.uno:AutoFormat" id="bm_id9247611" localize="false"/>
|
|
|
|
<bookmark branch="hid/modules/scalc/ui/autoformattable/AutoFormatTableDialog" id="bm_id2998138" localize="false"/>
|
|
<bookmark branch="hid/modules/scalc/ui/autoformattable/@@nowidget@@" id="bm_id2998138" localize="false"/>
|
|
|
|
<bookmark branch="hid/modules/swriter/ui/autoformattable/@@nowidget@@" id="bm_@@nowidget@@" localize="false"/>
|
|
<bookmark branch="hid/modules/swriter/ui/autoformattable/AutoFormatTableDialog" id="bm_id3150249" localize="false"/>
|
|
|
|
<bookmark branch="index" id="bm_id2655415">
|
|
<bookmark_value>tables;AutoFormat function</bookmark_value>
|
|
<bookmark_value>sheet table;AutoFormat function</bookmark_value>
|
|
<bookmark_value>styles;table styles</bookmark_value>
|
|
<bookmark_value>AutoFormat function for tables</bookmark_value>
|
|
</bookmark>
|
|
|
|
<section id="autoformat">
|
|
<h1 id="hd_id3149666"><variable id="autoformat"><link href="text/shared/01/AutoFormat.xhp">AutoFormat Styles</link></variable></h1>
|
|
<paragraph role="paragraph" id="par_id3145367"><variable id="autoformattext"><ahelp hid=".">Use this command to apply an AutoFormat to a selected <switchinline select="appl"><caseinline select="CALC">sheet area</caseinline><defaultinline>table area</defaultinline></switchinline> or to define your own AutoFormats.</ahelp></variable></paragraph>
|
|
</section>
|
|
|
|
<section id="howtoget">
|
|
<embed href="text/shared/00/00040503.xhp#autoformat"/>
|
|
</section>
|
|
|
|
<switch select="appl">
|
|
<case select="CALC">
|
|
<note id="par_id181630332690300">The AutoFormat command is available only if a cell range with at least 3 columns and 3 rows are selected. Otherwise this command will appear grayed out in the menu.</note>
|
|
</case>
|
|
</switch>
|
|
|
|
<bookmark branch="hid/modules/scalc/ui/autoformattable/formatlb" id="bm_id3145645" localize="false"/>
|
|
<bookmark branch="hid/modules/swriter/ui/autoformattable/formatlb" id="bm_id3148770" localize="false"/>
|
|
<h2 id="hd_id3148455">Format</h2>
|
|
<switch select="appl">
|
|
<case select="WRITER">
|
|
<paragraph role="paragraph" id="par_id501694123100254">Choose a predefined AutoFormat to apply to the table.</paragraph>
|
|
</case>
|
|
<case select="CALC">
|
|
<paragraph role="paragraph" id="par_id3145799">Choose a predefined AutoFormat to apply to a selected area in your sheet.</paragraph>
|
|
</case>
|
|
</switch>
|
|
|
|
<embed href="text/shared/00/00000001.xhp#preview_field"/>
|
|
|
|
<bookmark branch="hid/modules/scalc/ui/autoformattable/add" id="bm_id3155600" localize="false"/>
|
|
<bookmark branch="hid/modules/swriter/ui/autoformattable/add" id="bm_id3147174" localize="false"/>
|
|
<h2 id="hd_id3149410">Add</h2>
|
|
<switch select="appl">
|
|
<case select="WRITER">
|
|
<paragraph id="par_id3151185" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/add">Adds a new table style to the list.</ahelp></paragraph>
|
|
<list type="ordered">
|
|
<listitem>
|
|
<paragraph id="par_id3154646" role="listitem">Format a table in your document.</paragraph>
|
|
</listitem>
|
|
<listitem>
|
|
<paragraph id="par_id3156320" role="listitem">Select the table, and then choose <emph>Table - AutoFormat Styles</emph>.</paragraph>
|
|
</listitem>
|
|
<listitem>
|
|
<paragraph id="par_id3153156" role="listitem">Click <emph>Add</emph>.</paragraph>
|
|
</listitem>
|
|
<listitem>
|
|
<paragraph id="par_id3151168" role="listitem">In the <emph>Add AutoFormat</emph> dialog, enter a name, and then click <emph>OK</emph>.</paragraph>
|
|
</listitem>
|
|
</list>
|
|
<bookmark branch="hid/modules/swriter/ui/stringinput/edit" id="bm_id3150278" localize="false"/>
|
|
<paragraph role="paragraph" id="par_id3153391"><ahelp visibility="hidden" hid="modules/swriter/ui/stringinput/edit">Enter a name for the new AutoFormat, and then click<emph> OK</emph>.</ahelp></paragraph>
|
|
</case>
|
|
<case select="CALC">
|
|
<paragraph role="paragraph" id="par_id3154017">Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats. The <emph>Add AutoFormat</emph> dialog then appears.</paragraph>
|
|
<bookmark branch="hid/SC_HID_SC_AUTOFMT_NAME" id="bm_id3153713" localize="false"/>
|
|
<paragraph role="paragraph" id="par_id3153708"><ahelp hid=".">Enter a name and click <emph>OK</emph>. </ahelp></paragraph>
|
|
</case>
|
|
</switch>
|
|
<bookmark branch="hid/modules/swriter/ui/autoformattable/remove" id="bm_id3154280" localize="false"/>
|
|
<h2 id="hd_id3147516">Delete</h2>
|
|
<paragraph id="par_id3150707" role="paragraph">Deletes the selected style. You cannot delete the default style.</paragraph>
|
|
|
|
<bookmark branch="hid/modules/scalc/ui/autoformattable/rename" id="bm_id3153309" localize="false"/>
|
|
<h2 id="hd_id3159223">Rename</h2>
|
|
<paragraph role="paragraph" id="par_id3153064"><ahelp hid=".">Opens a dialog where you can change the name of the selected AutoFormat.</ahelp></paragraph>
|
|
|
|
<bookmark branch="hid/SC_HID_SC_REN_AFMT_NAME" id="bm_id3148608" localize="false"/>
|
|
<paragraph role="paragraph" id="par_id3153912">The <emph>Rename AutoFormat</emph> dialog opens.<ahelp hid="."> Enter the new name of the AutoFormat here.</ahelp></paragraph>
|
|
|
|
<h2 id="hd_id3155961">Formatting</h2>
|
|
<paragraph id="par_id3149022" role="paragraph">Lists the available formatting styles for tables. Click the format that you want to apply, and then click <emph>OK</emph>.</paragraph>
|
|
|
|
<bookmark branch="hid/modules/scalc/ui/autoformattable/numformatcb" id="bm_id3149210" localize="false"/>
|
|
<bookmark branch="hid/modules/swriter/ui/autoformattable/numformatcb" id="bm_id3147526" localize="false"/>
|
|
<h3 id="hd_id3154021">Number format</h3>
|
|
<paragraph id="par_id3150970" role="paragraph">Includes numbering formats in the selected style.</paragraph>
|
|
|
|
<bookmark branch="hid/modules/scalc/ui/autoformattable/bordercb" id="bm_id3150206" localize="false"/>
|
|
<bookmark branch="hid/modules/swriter/ui/autoformattable/bordercb" id="bm_id3154193" localize="false"/>
|
|
<h3 id="hd_id3149530">Borders</h3>
|
|
<paragraph id="par_id3154200" role="paragraph">Includes border styles in the selected style.</paragraph>
|
|
|
|
<bookmark branch="hid/modules/scalc/ui/autoformattable/fontcb" id="bm_id3150364" localize="false"/>
|
|
<bookmark branch="hid/modules/swriter/ui/autoformattable/fontcb" id="bm_id3152954" localize="false"/>
|
|
<h3 id="hd_id3150350">Font</h3>
|
|
<paragraph id="par_id3152961" role="paragraph">Includes font formatting in the selected style.</paragraph>
|
|
|
|
<bookmark branch="hid/modules/scalc/ui/autoformattable/patterncb" id="bm_id3150515" localize="false"/>
|
|
<bookmark branch="hid/modules/swriter/ui/autoformattable/patterncb" id="bm_id3155184" localize="false"/>
|
|
<h3 id="hd_id3155379">Pattern</h3>
|
|
<paragraph id="par_id3151325" role="paragraph">Includes background styles in the selected style.</paragraph>
|
|
|
|
<bookmark branch="hid/modules/scalc/ui/autoformattable/alignmentcb" id="bm_id3146978" localize="false"/>
|
|
<bookmark branch="hid/modules/swriter/ui/autoformattable/alignmentcb" id="bm_id3153675" localize="false"/>
|
|
<h3 id="hd_id3146115">Alignment</h3>
|
|
<paragraph id="par_id3155896" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/alignmentcb">Includes alignment settings in the selected style.</ahelp></paragraph>
|
|
|
|
<bookmark branch="hid/modules/scalc/ui/autoformattable/autofitcb" id="bm_id3152892" localize="false"/>
|
|
<switch select="appl">
|
|
<case select="CALC">
|
|
<h3 id="hd_id3155811">AutoFit width and height</h3>
|
|
<paragraph role="paragraph" id="par_id3148703"><ahelp hid="modules/scalc/ui/autoformattable/autofitcb">When marked, specifies that you want to retain the width and height of the selected cells of the selected format.</ahelp></paragraph>
|
|
</case>
|
|
</switch>
|
|
|
|
<section id="relatedtopics">
|
|
<switch select="appl">
|
|
<case select="CALC">
|
|
<embed href="text/scalc/guide/autoformat.xhp#autoformat"/>
|
|
</case>
|
|
<case select="WRITER">
|
|
<embed href="text/swriter/main0110.xhp#h1"/>
|
|
</case>
|
|
</switch>
|
|
</section>
|
|
</body>
|
|
</helpdocument>
|