blob: 82062300458ab7292f2f65ed50acec646016f144 (
plain)
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
|
<?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/.
*
-->
<meta>
<topic id="datapilotformatting" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Formatting Pivot Tables</title>
<filename>/text/scalc/guide/datapilot_formatting.xhp</filename>
</topic>
</meta>
<body>
<section id="sectionpivotformat">
<bookmark xml-lang="en-US" branch="index" id="bm_id931656104694657">
<bookmark_value>formatting;pivot tables</bookmark_value>
</bookmark>
<h1 id="hd_id341656099297638"><variable id="h1"><link href="text/scalc/guide/datapilot_formatting.xhp" name="Formatting Pivot Tables">Formatting Pivot Tables</link></variable></h1>
<paragraph id="par_id121656099297641" role="paragraph" xml-lang="en-US">You can format pivot tables cells using specific cell styles.</paragraph>
</section>
<warning id="par_id751656100824556">Direct formatting of pivot tables cells is lost when updating or editing the table.</warning>
<paragraph role="paragraph" id="par_id31656100011920">When creating a pivot table, six new cell styles are added to your document. Format each cell style as needed. The customization of the pivot cell styles will be preserved when updating the pivot table.</paragraph>
<note id="par_id601656100455727">By using cell styles for pivot table formatting, all pivot tables cells in the spreadsheet document will have the same look. In other words, the pivot table cell styles apply to all pivot tables of the document.</note>
<paragraph role="paragraph" id="par_id941656100017412">The six cell styles are:</paragraph>
<list type="unordered">
<listitem>
<paragraph id="par_id181656100070568" role="listitem">Pivot Table Categories</paragraph>
</listitem>
<listitem>
<paragraph id="par_id781656100074986" role="listitem">Pivot Table Corner</paragraph>
</listitem>
<listitem>
<paragraph id="par_id311656100079561" role="listitem">Pivot Table Field</paragraph>
</listitem>
<listitem>
<paragraph id="par_id601656100083888" role="listitem">Pivot Table Result</paragraph>
</listitem>
<listitem>
<paragraph id="par_id521656100088324" role="listitem">Pivot Table Value</paragraph>
</listitem>
<listitem>
<paragraph id="par_id111656100092437" role="listitem">Pivot Table Title</paragraph>
</listitem>
</list>
<warning id="par_id971656104293716">The number format of these cell styles cannot be changed in the cell style itself; you must format it in the data source.</warning>
<embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
<section id="relatedtopics">
<embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
<embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
<embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/>
<embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/>
<embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
<embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/>
<embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
<embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/>
<embed href="text/scalc/guide/pivotchart.xhp#pivotchart"/>
</section>
</body>
</helpdocument>
|
