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.hal...@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 <c...@libreoffice.org>
Reviewed-by: Olivier Hallot <olivier.hal...@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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
