Add more links between pivot tables and charts

Fix id duplicity

Change-Id: I72520764bcf68f25299a05be619b8624d5ca5d1c
Reviewed-on: https://gerrit.libreoffice.org/53697
Tested-by: Jenkins <ci@libreoffice.org>
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

9 files changed, 29 insertions, 5 deletions

diff --git a/source/text/scalc/06/calcsamplefiles.xhp b/source/text/scalc/06/calcsamplefiles.xhp
index 7d7df8d87d..c7e3eccf64 100644
--- a/source/text/scalc/06/calcsamplefiles.xhp
+++ b/source/text/scalc/06/calcsamplefiles.xhp
@@ -21,7 +21,7 @@
         <paragraph role="paragraph" id="par_id161521663319918" xml-lang="en-US"><object data="media/files/scalc/trigon.ods" id="ods_id61521548603544" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph>
     </section>
     <section id="pivot">
-        <paragraph role="paragraph" id="par_id161521663314918" xml-lang="en-US"><object data="media/files/scalc/pivot.ods" id="ods_id61521548603544" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph>
+        <paragraph role="paragraph" id="par_id161521563314918" xml-lang="en-US"><object data="media/files/scalc/pivot.ods" id="ods_id61521548603544" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph>
     </section>
     </body>
 </helpdocument>
diff --git a/source/text/scalc/guide/datapilot.xhp b/source/text/scalc/guide/datapilot.xhp
index d42eab56fe..4a251922df 100644
--- a/source/text/scalc/guide/datapilot.xhp
+++ b/source/text/scalc/guide/datapilot.xhp
@@ -34,6 +34,8 @@
 </variable></paragraph>
 <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>
+<embed href="text/shared/00/00000004.xhp#samplefile"/>
+<embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
 <section id="relatedtopics">
 <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
 <embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/>
@@ -41,6 +43,8 @@
 <embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
 <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_createtable.xhp b/source/text/scalc/guide/datapilot_createtable.xhp
index 3e15c4306b..09d3622c2a 100644
--- a/source/text/scalc/guide/datapilot_createtable.xhp
+++ b/source/text/scalc/guide/datapilot_createtable.xhp
@@ -65,6 +65,8 @@
          </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>Page Fields</emph> area. The pivot table is inserted further down.</paragraph>
+      <embed href="text/shared/00/00000004.xhp#samplefile"/>
+      <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"/>
@@ -73,6 +75,7 @@
          <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>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/guide/datapilot_deletetable.xhp b/source/text/scalc/guide/datapilot_deletetable.xhp
index c53abbf180..e20a94ed40 100644
--- a/source/text/scalc/guide/datapilot_deletetable.xhp
+++ b/source/text/scalc/guide/datapilot_deletetable.xhp
@@ -34,6 +34,8 @@
 </variable></paragraph>
       <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>
+      <embed href="text/shared/00/00000004.xhp#samplefile"/>
+      <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"/>
@@ -41,6 +43,7 @@
          <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"/>
+         <embed href="text/scalc/guide/pivotchart.xhp#pivotchart"/>
       </section>
    </body>
 </helpdocument>
diff --git a/source/text/scalc/guide/datapilot_edittable.xhp b/source/text/scalc/guide/datapilot_edittable.xhp
index b70c7edf00..addd8be378 100644
--- a/source/text/scalc/guide/datapilot_edittable.xhp
+++ b/source/text/scalc/guide/datapilot_edittable.xhp
@@ -39,7 +39,8 @@
       <paragraph xml-lang="en-US" id="par_id3156442" role="paragraph">To edit the pivot table, click a cell inside the pivot table and open the context menu. In the context menu you find the command <emph>Edit Layout</emph>, which displays the <emph>Pivot Table</emph> dialog for the current pivot table.</paragraph>
       <paragraph xml-lang="en-US" id="par_id2666096" role="paragraph">In the pivot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields.</paragraph>
       <paragraph xml-lang="en-US" id="par_id266609688" role="paragraph">You can assign custom display names to fields, field members, subtotals (with some restrictions), and grand totals inside pivot tables. A custom display name is assigned to an item by overwriting the original name with another name.</paragraph>
-
+      <embed href="text/shared/00/00000004.xhp#samplefile"/>
+      <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"/>
@@ -48,6 +49,7 @@
          <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>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/guide/datapilot_filtertable.xhp b/source/text/scalc/guide/datapilot_filtertable.xhp
index b176c97164..18edac7e70 100644
--- a/source/text/scalc/guide/datapilot_filtertable.xhp
+++ b/source/text/scalc/guide/datapilot_filtertable.xhp
@@ -62,7 +62,10 @@
 <paragraph id="par_id0720201001344884" role="paragraph" xml-lang="en-US">You can also open the pop-up window by positioning the cell cursor at the button and pressing <switchinline select="sys"><caseinline select="MAC">Command
 </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+D.</paragraph>
 </listitem></list>
+<embed href="text/shared/00/00000004.xhp#samplefile"/>
+<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"/>
+    <embed href="text/scalc/guide/pivotchart.xhp#pivotchart"/>
 </section>
 </body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/guide/datapilot_grouping.xhp b/source/text/scalc/guide/datapilot_grouping.xhp
index a12b979541..36544be4c1 100644
--- a/source/text/scalc/guide/datapilot_grouping.xhp
+++ b/source/text/scalc/guide/datapilot_grouping.xhp
@@ -50,6 +50,8 @@
 <paragraph role="paragraph" id="par_idN10682" xml-lang="en-US">To remove a grouping, click inside the group, then choose <emph>Data - Group and Outline - Ungroup</emph>.</paragraph>
 </listitem>
 </list>
+<embed href="text/shared/00/00000004.xhp#samplefile"/>
+<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"/>
@@ -57,6 +59,7 @@
 <embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
 <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_tipps.xhp b/source/text/scalc/guide/datapilot_tipps.xhp
index 1239b3ff6d..b749d7740d 100644
--- a/source/text/scalc/guide/datapilot_tipps.xhp
+++ b/source/text/scalc/guide/datapilot_tipps.xhp
@@ -36,6 +36,8 @@
 <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>
 <paragraph role="paragraph" id="par_id3145273" xml-lang="en-US">If the <emph>Identify categories</emph> check box is marked, the categories will be identified by their headings and assigned accordingly when the pivot table is created.</paragraph>
+<embed href="text/shared/00/00000004.xhp#samplefile"/>
+<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"/>
@@ -44,6 +46,7 @@
 <embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/>
 <embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
 <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_updatetable.xhp b/source/text/scalc/guide/datapilot_updatetable.xhp
index d94e17cde1..ee6d09c175 100644
--- a/source/text/scalc/guide/datapilot_updatetable.xhp
+++ b/source/text/scalc/guide/datapilot_updatetable.xhp
@@ -35,6 +35,8 @@
 <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>
 <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/shared/00/00000004.xhp#samplefile"/>
+<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"/>
@@ -43,6 +45,7 @@
 <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>