[Libreoffice-commits] help.git: source/text

Olivier Hallot olivier.hallot at libreoffice.org
Tue May 1 14:26:43 UTC 2018 

 source/text/scalc/06/calcsamplefiles.xhp          |    2 +-
 source/text/scalc/guide/datapilot.xhp             |    4 ++++
 source/text/scalc/guide/datapilot_createtable.xhp |    5 ++++-
 source/text/scalc/guide/datapilot_deletetable.xhp |    3 +++
 source/text/scalc/guide/datapilot_edittable.xhp   |    6 ++++--
 source/text/scalc/guide/datapilot_filtertable.xhp |    5 ++++-
 source/text/scalc/guide/datapilot_grouping.xhp    |    3 +++
 source/text/scalc/guide/datapilot_tipps.xhp       |    3 +++
 source/text/scalc/guide/datapilot_updatetable.xhp |    3 +++
 9 files changed, 29 insertions(+), 5 deletions(-)

New commits:
commit 665722ee28553846ab82d76d953ee1d4f2ed6bda
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
Date:   Tue May 1 11:23:25 2018 -0300

    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 at libreoffice.org>
    Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>

diff --git a/source/text/scalc/06/calcsamplefiles.xhp b/source/text/scalc/06/calcsamplefiles.xhp
index 7d7df8d87..c7e3eccf6 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 d42eab56f..4a251922d 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 3e15c4306..09d3622c2 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 c53abbf18..e20a94ed4 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 b70c7edf0..addd8be37 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 b176c9716..18edac7e7 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 a12b97954..36544be4c 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 1239b3ff6..b749d7740 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 d94e17cde..ee6d09c17 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>

More information about the Libreoffice-commits mailing list