AllLangHelp_scalc.mk | 1
source/text/scalc/guide/datapilot.xhp | 8 +-
source/text/scalc/guide/datapilot_createtable.xhp | 7 +-
source/text/scalc/guide/datapilot_deletetable.xhp | 9 +--
source/text/scalc/guide/datapilot_edittable.xhp | 5 +
source/text/scalc/guide/datapilot_filtertable.xhp | 15 ++++-
source/text/scalc/guide/datapilot_formatting.xhp | 64 ++++++++++++++++++++++
source/text/scalc/guide/datapilot_grouping.xhp | 12 +---
source/text/scalc/guide/datapilot_tipps.xhp | 8 +-
source/text/scalc/guide/datapilot_updatetable.xhp | 8 +-
10 files changed, 102 insertions(+), 35 deletions(-)
New commits:
commit 4e1b00e5d940b647b550b3314985ebb775be2543
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri Jun 24 18:25:25 2022 -0300
Commit: Adolfo Jayme Barrientos <fit...@ubuntu.com>
CommitDate: Mon Jun 27 04:54:10 2022 +0200
tdf#149218 Add pivot table formatting help page
Change-Id: I807b0e62998bac85cf0cf348d57cb1f99b1dc742
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136411
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index a40e388d9..3b3df75b3 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -353,6 +353,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/guide/database_sort \
helpcontent2/source/text/scalc/guide/datapilot \
helpcontent2/source/text/scalc/guide/datapilot_createtable \
+ helpcontent2/source/text/scalc/guide/datapilot_formatting \
helpcontent2/source/text/scalc/guide/datapilot_deletetable \
helpcontent2/source/text/scalc/guide/datapilot_edittable \
helpcontent2/source/text/scalc/guide/datapilot_filtertable \
diff --git a/source/text/scalc/guide/datapilot.xhp
b/source/text/scalc/guide/datapilot.xhp
index e69454dd3..6391a629e 100644
--- a/source/text/scalc/guide/datapilot.xhp
+++ b/source/text/scalc/guide/datapilot.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,7 +16,6 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalcguidedatapilotxml" indexer="include" status="PUBLISH">
@@ -30,8 +27,8 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3150448"><bookmark_value>pivot table function;
introduction</bookmark_value>
<bookmark_value>DataPilot, see pivot table function</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3150448" xml-lang="en-US"
level="1"><variable id="datapilot"><link href="text/scalc/guide/datapilot.xhp"
name="Pivot Table">Pivot Table</link>
-</variable></paragraph>
+<h1 id="hd_id3150448"><variable id="datapilot"><link
href="text/scalc/guide/datapilot.xhp" name="Pivot Table">Pivot Table</link>
+</variable></h1>
<paragraph role="paragraph" id="par_id3156024" xml-lang="en-US">The
<emph>pivot table</emph> (formerly known as <emph>DataPilot</emph>) allows you
to combine, compare, and analyze large amounts of data. You can view different
summaries of the source data, you can display the details of areas of interest,
and you can create reports.</paragraph>
<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US">A table that
has been created as a <link href="text/scalc/01/12090000.xhp" name="pivot
table">pivot table</link> is an interactive table. Data can be arranged,
rearranged or summarized according to different points of view.</paragraph>
@@ -39,6 +36,7 @@
<section id="relatedtopics">
<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_formatting.xhp#h1"/>
<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_tipps.xhp#datapilot_tipps"/>
diff --git a/source/text/scalc/guide/datapilot_createtable.xhp
b/source/text/scalc/guide/datapilot_createtable.xhp
index 4610d1709..92a25abd2 100644
--- a/source/text/scalc/guide/datapilot_createtable.xhp
+++ b/source/text/scalc/guide/datapilot_createtable.xhp
@@ -30,8 +30,8 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3148491"><bookmark_value>pivot tables</bookmark_value>
<bookmark_value>pivot table function; calling up and
applying</bookmark_value>
</bookmark>
-<paragraph xml-lang="en-US" id="hd_id3148491" role="heading"
level="1"><variable id="datapilot_createtable"><link
href="text/scalc/guide/datapilot_createtable.xhp" name="Creating Pivot
Tables">Creating Pivot Tables</link>
-</variable></paragraph>
+<h1 id="hd_id3148491"><variable id="datapilot_createtable"><link
href="text/scalc/guide/datapilot_createtable.xhp" name="Creating Pivot
Tables">Creating Pivot Tables</link>
+</variable></h1>
<list type="ordered">
<listitem>
<paragraph xml-lang="en-US" id="par_id3156023"
role="listitem">Position the cursor within a range of cells containing values,
row and column headings.</paragraph>
@@ -65,11 +65,12 @@
</listitem>
</list>
<paragraph xml-lang="en-US" id="par_id3154020" role="paragraph">Exit the
Pivot Table dialog by pressing OK. A <emph>Filter</emph> button will now be
inserted, or a page button for every data field that you dropped in the
<emph>Filters</emph> area. The pivot table is inserted further down.</paragraph>
-
+
<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_edittable.xhp#datapilot_edittable"/>
+ <embed href="text/scalc/guide/datapilot_formatting.xhp#h1"/>
<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"/>
diff --git a/source/text/scalc/guide/datapilot_deletetable.xhp
b/source/text/scalc/guide/datapilot_deletetable.xhp
index e22c6bf36..29e849cb7 100644
--- a/source/text/scalc/guide/datapilot_deletetable.xhp
+++ b/source/text/scalc/guide/datapilot_deletetable.xhp
@@ -30,16 +30,17 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153726"><bookmark_value>pivot table function; deleting
tables</bookmark_value>
<bookmark_value>deleting;pivot tables</bookmark_value>
</bookmark>
-<paragraph xml-lang="en-US" id="hd_id3153726" role="heading"
level="1"><variable id="datapilot_deletetable"><link
href="text/scalc/guide/datapilot_deletetable.xhp" name="Deleting Pivot
Tables">Deleting Pivot Tables</link>
-</variable></paragraph>
+<h1 id="hd_id3153726"><variable id="datapilot_deletetable"><link
href="text/scalc/guide/datapilot_deletetable.xhp" name="Deleting Pivot
Tables">Deleting Pivot Tables</link>
+</variable></h1>
<paragraph xml-lang="en-US" id="par_id3154014" role="paragraph">In order
to delete a pivot table, click any cell in the pivot table, then choose
<emph>Delete</emph> in the context menu.</paragraph>
- <paragraph xml-lang="en-US" id="par_id141525148751543" role="warning">If
you delete a pivot table linked to a pivot chart, the pivot chart is also
deleted. A dialog box opens to confirm the pivot chart deletion.</paragraph>
-
+ <warning id="par_id141525148751543">If you delete a pivot table linked
to a pivot chart, the pivot chart is also deleted. A dialog box opens to
confirm the pivot chart deletion.</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_formatting.xhp#h1"/>
<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_tipps.xhp#datapilot_tipps"/>
diff --git a/source/text/scalc/guide/datapilot_edittable.xhp
b/source/text/scalc/guide/datapilot_edittable.xhp
index eb13ac691..ab0385e56 100644
--- a/source/text/scalc/guide/datapilot_edittable.xhp
+++ b/source/text/scalc/guide/datapilot_edittable.xhp
@@ -30,8 +30,8 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3148663"><bookmark_value>pivot table function; editing
tables</bookmark_value>
<bookmark_value>editing;pivot tables</bookmark_value>
</bookmark>
-<paragraph xml-lang="en-US" id="hd_id3148663" role="heading"
level="1"><variable id="datapilot_edittable"><link
href="text/scalc/guide/datapilot_edittable.xhp" name="Editing Pivot
Tables">Editing Pivot Tables</link>
-</variable></paragraph>
+<h1 id="hd_id3148663"><variable id="datapilot_edittable"><link
href="text/scalc/guide/datapilot_edittable.xhp" name="Editing Pivot
Tables">Editing Pivot Tables</link>
+</variable></h1>
<paragraph xml-lang="en-US" id="par_id3150868" role="paragraph">Click
one of the buttons in the pivot table and hold the mouse button down. A special
symbol will appear next to the mouse pointer.</paragraph>
<paragraph xml-lang="en-US" id="par_id3145786" role="paragraph">By
dragging the button to a different position in the same row you can alter the
order of the columns. If you drag a button to the left edge of the table into
the row headings area, you can change a column into a row.</paragraph>
<paragraph xml-lang="en-US" id="par_id1648915" role="paragraph">In the
Pivot Table dialog, you can drag a button to the <emph>Filters</emph> area to
create a button and a listbox on top of the pivot table. The listbox can be
used to filter the pivot table by the contents of the selected item. You can
use drag-and-drop within the pivot table to use another page field as a
filter.</paragraph>
@@ -46,6 +46,7 @@
<embed
href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
<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_formatting.xhp#h1"/>
<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"/>
diff --git a/source/text/scalc/guide/datapilot_filtertable.xhp
b/source/text/scalc/guide/datapilot_filtertable.xhp
index f2555119d..3b39683ba 100644
--- a/source/text/scalc/guide/datapilot_filtertable.xhp
+++ b/source/text/scalc/guide/datapilot_filtertable.xhp
@@ -1,4 +1,5 @@
-<?xml version="1.0" encoding="UTF-8"?><helpdocument version="1.0">
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -28,7 +29,7 @@
<bookmark_value>pivot table function; filtering tables</bookmark_value>
<bookmark_value>filtering;pivot tables</bookmark_value>
</bookmark>
-<paragraph id="hd_id3150792" role="heading" xml-lang="en-US"
level="1"><variable id="datapilot_filtertable"><link
href="text/scalc/guide/datapilot_filtertable.xhp" name="Filtering Pivot
Tables">Filtering Pivot Tables</link></variable></paragraph>
+<h1 id="hd_id3150792"><variable id="datapilot_filtertable"><link
href="text/scalc/guide/datapilot_filtertable.xhp" name="Filtering Pivot
Tables">Filtering Pivot Tables</link></variable></h1>
<paragraph id="par_id3153192" role="paragraph" xml-lang="en-US">You can use
filters to remove unwanted data from a pivot table.</paragraph>
<paragraph id="par_id3150441" role="paragraph" xml-lang="en-US">Click the
<emph>Filter</emph> button in the sheet to call up the dialog for the filter
conditions. Alternatively, call up the context menu of the pivot table and
select the <emph>Filter</emph> command. The <link
href="text/scalc/01/12090103.xhp" name="Filter"><emph>Filter</emph></link>
dialog appears. Here you can filter the pivot table.</paragraph>
<paragraph id="par_id315044199" role="paragraph" xml-lang="en-US">You can also
click the arrow on a button in the pivot table to show a pop-up window. In this
pop-up window, you can edit the visibility settings of the associated
field.</paragraph>
@@ -64,7 +65,15 @@
</listitem></list>
<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_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"/>
+<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_formatting.xhp#h1"/>
+ <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>
diff --git a/source/text/scalc/guide/datapilot_formatting.xhp
b/source/text/scalc/guide/datapilot_formatting.xhp
new file mode 100644
index 000000000..820623004
--- /dev/null
+++ b/source/text/scalc/guide/datapilot_formatting.xhp
@@ -0,0 +1,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>
diff --git a/source/text/scalc/guide/datapilot_grouping.xhp
b/source/text/scalc/guide/datapilot_grouping.xhp
index 9a1c9d3ff..174101cfe 100644
--- a/source/text/scalc/guide/datapilot_grouping.xhp
+++ b/source/text/scalc/guide/datapilot_grouping.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
- <helpdocument version="1.0">
+<helpdocument version="1.0">
<meta>
<topic id="textscalcguidedatapilot_groupingxml" indexer="include"
status="PUBLISH">
<title id="tit" xml-lang="en-US">Grouping Pivot Tables</title>
@@ -33,8 +28,8 @@
<bookmark_value>pivot table function;grouping table entries</bookmark_value>
<bookmark_value>ungrouping entries in pivot tables</bookmark_value>
</bookmark>
-<paragraph role="heading" id="par_idN10643" xml-lang="en-US"
level="1"><variable id="datapilot_grouping"><link
href="text/scalc/guide/datapilot_grouping.xhp">Grouping Pivot Tables</link>
-</variable></paragraph><comment>see
http://specs.openoffice.org/calc/compatibility/grouping.sxw</comment><paragraph
role="paragraph" id="par_idN10661" xml-lang="en-US">The resulting pivot table
can contain many different entries. By grouping the entries, you can improve
the visible result.</paragraph>
+<h1 id="par_idN10643"><variable id="datapilot_grouping"><link
href="text/scalc/guide/datapilot_grouping.xhp">Grouping Pivot Tables</link>
+</variable></h1><comment>see
http://specs.openoffice.org/calc/compatibility/grouping.sxw</comment><paragraph
role="paragraph" id="par_idN10661" xml-lang="en-US">The resulting pivot table
can contain many different entries. By grouping the entries, you can improve
the visible result.</paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_idN10667" xml-lang="en-US">Select a cell
or range of cells in the pivot table.</paragraph>
@@ -55,6 +50,7 @@
<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_formatting.xhp#h1"/>
<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_tipps.xhp#datapilot_tipps"/>
diff --git a/source/text/scalc/guide/datapilot_tipps.xhp
b/source/text/scalc/guide/datapilot_tipps.xhp
index a8c215117..9966532b1 100644
--- a/source/text/scalc/guide/datapilot_tipps.xhp
+++ b/source/text/scalc/guide/datapilot_tipps.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,7 +16,6 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalcguidedatapilot_tippsxml" indexer="include"
status="PUBLISH">
@@ -30,8 +27,8 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3148663"><bookmark_value>pivot table function; preventing data
overwriting</bookmark_value>
<bookmark_value>output ranges of pivot tables</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3148663" xml-lang="en-US"
level="1"><variable id="datapilot_tipps"><link
href="text/scalc/guide/datapilot_tipps.xhp" name="Selecting Pivot Table Output
Ranges">Selecting Pivot Table Output Ranges</link>
-</variable></paragraph>
+<h1 id="hd_id3148663"><variable id="datapilot_tipps"><link
href="text/scalc/guide/datapilot_tipps.xhp" name="Selecting Pivot Table Output
Ranges">Selecting Pivot Table Output Ranges</link>
+</variable></h1>
<paragraph role="paragraph" id="par_id3154123" xml-lang="en-US">Click the
button <emph>More</emph> in the <emph>Pivot Table</emph> dialog. The dialog
will be extended.</paragraph>
<paragraph role="paragraph" id="par_id3153771" xml-lang="en-US">You can select
a named range in which the pivot table is to be created, from the <emph>Results
to</emph> box. If the results range does not have a name, enter the coordinates
of the upper left cell of the range into the field to the right of the
<emph>Results to</emph> box. You can also click on the appropriate cell to have
the coordinates entered accordingly.</paragraph>
<paragraph role="paragraph" id="par_id3146974" xml-lang="en-US">If you mark
the <emph>Ignore empty rows</emph> check box, they will not be taken into
account when the pivot table is created.</paragraph>
@@ -42,6 +39,7 @@
<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_formatting.xhp#h1"/>
<embed
href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/>
<embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/>
<embed
href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
diff --git a/source/text/scalc/guide/datapilot_updatetable.xhp
b/source/text/scalc/guide/datapilot_updatetable.xhp
index e983925ee..9d9beea68 100644
--- a/source/text/scalc/guide/datapilot_updatetable.xhp
+++ b/source/text/scalc/guide/datapilot_updatetable.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,7 +16,6 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalcguidedatapilot_updatetablexml" indexer="include"
status="PUBLISH">
@@ -32,8 +29,8 @@
<bookmark_value>recalculating;pivot tables</bookmark_value>
<bookmark_value>updating;pivot tables</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3150792" xml-lang="en-US"
level="1"><variable id="datapilot_updatetable"><link
href="text/scalc/guide/datapilot_updatetable.xhp" name="Updating Pivot
Tables">Updating Pivot Tables</link>
-</variable></paragraph>
+<h1 id="hd_id3150792"><variable id="datapilot_updatetable"><link
href="text/scalc/guide/datapilot_updatetable.xhp" name="Updating Pivot
Tables">Updating Pivot Tables</link>
+</variable></h1>
<paragraph role="paragraph" id="par_id3154684" xml-lang="en-US">If the data of
the source sheet has been changed, $[officename] recalculates the pivot table.
To recalculate the table, choose <emph>Data - Pivot Table - Refresh</emph>. Do
the same after you have imported an Excel pivot table into $[officename]
Calc.</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
@@ -41,6 +38,7 @@
<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_formatting.xhp#h1"/>
<embed
href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/>
<embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/>
<embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
