1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
|
<?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>
|
