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 <fitojb@ubuntu.com>
(cherry picked from commit b8a7f75e9b05a8f5e9e7c9653e9bffbf579f8fce)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136455

10 files changed, 102 insertions, 35 deletions

diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index a40e388d92..3b3df75b34 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 e69454dd36..6391a629e4 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 4610d17099..92a25abd2e 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 e22c6bf361..29e849cb73 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 eb13ac6915..ab0385e567 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 f2555119d4..3b39683ba1 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 0000000000..8206230045
--- /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 9a1c9d3ff8..174101cfe6 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 a8c215117d..9966532b16 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 e983925eee..9d9beea680 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"/>