summaryrefslogtreecommitdiff
path: root/source/text/scalc/guide
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2018-05-07 19:49:50 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2018-05-08 12:29:06 +0200
commit432f47f9ef4498076f9175fcd2f613dd506faa03 (patch)
tree30252127f82a220deaae8bc00c8d36a396dee9f3 /source/text/scalc/guide
parentbc322f3bc59d3d05b61cc229eba17f86d157c8f8 (diff)
Refactor help files with sample files embedded
Change-Id: I46d1147b2a6db931914d332ba6004d1b23b4ea65 Reviewed-on: https://gerrit.libreoffice.org/53954 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/guide')
-rw-r--r--source/text/scalc/guide/datapilot.xhp2
-rw-r--r--source/text/scalc/guide/datapilot_createtable.xhp2
-rw-r--r--source/text/scalc/guide/datapilot_deletetable.xhp2
-rw-r--r--source/text/scalc/guide/datapilot_edittable.xhp2
-rw-r--r--source/text/scalc/guide/datapilot_filtertable.xhp2
-rw-r--r--source/text/scalc/guide/datapilot_grouping.xhp2
-rw-r--r--source/text/scalc/guide/datapilot_tipps.xhp2
-rw-r--r--source/text/scalc/guide/datapilot_updatetable.xhp2
-rw-r--r--source/text/scalc/guide/pivotchart.xhp2
-rw-r--r--source/text/scalc/guide/pivotchart_create.xhp2
-rw-r--r--source/text/scalc/guide/pivotchart_delete.xhp2
-rw-r--r--source/text/scalc/guide/pivotchart_edit.xhp2
-rw-r--r--source/text/scalc/guide/pivotchart_filter.xhp2
-rw-r--r--source/text/scalc/guide/pivotchart_update.xhp2
14 files changed, 14 insertions, 14 deletions
diff --git a/source/text/scalc/guide/datapilot.xhp b/source/text/scalc/guide/datapilot.xhp
index 4a251922df..e69454dd36 100644
--- a/source/text/scalc/guide/datapilot.xhp
+++ b/source/text/scalc/guide/datapilot.xhp
@@ -34,7 +34,7 @@
</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"/>
diff --git a/source/text/scalc/guide/datapilot_createtable.xhp b/source/text/scalc/guide/datapilot_createtable.xhp
index 09d3622c2a..d03151a4d6 100644
--- a/source/text/scalc/guide/datapilot_createtable.xhp
+++ b/source/text/scalc/guide/datapilot_createtable.xhp
@@ -65,7 +65,7 @@
</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"/>
diff --git a/source/text/scalc/guide/datapilot_deletetable.xhp b/source/text/scalc/guide/datapilot_deletetable.xhp
index e20a94ed40..e22c6bf361 100644
--- a/source/text/scalc/guide/datapilot_deletetable.xhp
+++ b/source/text/scalc/guide/datapilot_deletetable.xhp
@@ -34,7 +34,7 @@
</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"/>
diff --git a/source/text/scalc/guide/datapilot_edittable.xhp b/source/text/scalc/guide/datapilot_edittable.xhp
index addd8be378..0c3d67f33e 100644
--- a/source/text/scalc/guide/datapilot_edittable.xhp
+++ b/source/text/scalc/guide/datapilot_edittable.xhp
@@ -39,7 +39,7 @@
<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"/>
diff --git a/source/text/scalc/guide/datapilot_filtertable.xhp b/source/text/scalc/guide/datapilot_filtertable.xhp
index 18edac7e70..f2555119d4 100644
--- a/source/text/scalc/guide/datapilot_filtertable.xhp
+++ b/source/text/scalc/guide/datapilot_filtertable.xhp
@@ -62,7 +62,7 @@
<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"/>
diff --git a/source/text/scalc/guide/datapilot_grouping.xhp b/source/text/scalc/guide/datapilot_grouping.xhp
index 36544be4c1..9a1c9d3ff8 100644
--- a/source/text/scalc/guide/datapilot_grouping.xhp
+++ b/source/text/scalc/guide/datapilot_grouping.xhp
@@ -50,7 +50,7 @@
<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"/>
diff --git a/source/text/scalc/guide/datapilot_tipps.xhp b/source/text/scalc/guide/datapilot_tipps.xhp
index b749d7740d..a8c215117d 100644
--- a/source/text/scalc/guide/datapilot_tipps.xhp
+++ b/source/text/scalc/guide/datapilot_tipps.xhp
@@ -36,7 +36,7 @@
<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"/>
diff --git a/source/text/scalc/guide/datapilot_updatetable.xhp b/source/text/scalc/guide/datapilot_updatetable.xhp
index ee6d09c175..e983925eee 100644
--- a/source/text/scalc/guide/datapilot_updatetable.xhp
+++ b/source/text/scalc/guide/datapilot_updatetable.xhp
@@ -35,7 +35,7 @@
<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"/>
diff --git a/source/text/scalc/guide/pivotchart.xhp b/source/text/scalc/guide/pivotchart.xhp
index cb21b78e57..a4ba085fdf 100644
--- a/source/text/scalc/guide/pivotchart.xhp
+++ b/source/text/scalc/guide/pivotchart.xhp
@@ -27,7 +27,7 @@
<paragraph role="paragraph" id="par_id911525139890364" xml-lang="en-US">Different from static sized tables, where the number of rows and columns are constant, pivot tables can have varying dimensions, depending on the pivot table settings and its data source contents.</paragraph>
<paragraph role="paragraph" id="par_id201525141351484" xml-lang="en-US">Pivot charts tracks the changes in the data issued from a pivot table and adjusts the data series and data range accordingly.</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/pivotchart_create.xhp#pivotchartcreate"/>
diff --git a/source/text/scalc/guide/pivotchart_create.xhp b/source/text/scalc/guide/pivotchart_create.xhp
index 939af2d97a..a4ff84dcf2 100644
--- a/source/text/scalc/guide/pivotchart_create.xhp
+++ b/source/text/scalc/guide/pivotchart_create.xhp
@@ -45,7 +45,7 @@
<paragraph id="par_id1001525165156188" role="listitem" xml-lang="en-US">Click <emph>OK</emph> to close the wizard and create the pivot chart.</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/pivotchart.xhp#pivotchart"/>
diff --git a/source/text/scalc/guide/pivotchart_delete.xhp b/source/text/scalc/guide/pivotchart_delete.xhp
index c341cda2c2..597730164c 100644
--- a/source/text/scalc/guide/pivotchart_delete.xhp
+++ b/source/text/scalc/guide/pivotchart_delete.xhp
@@ -23,7 +23,7 @@
<paragraph role="paragraph" id="par_id141525147903623" xml-lang="en-US">To delete a pivot chart, select the chart and press <emph>Del</emph>.</paragraph>
<paragraph xml-lang="en-US" id="par_id431525148462157" role="note">When deleting a pivot chart, the linked pivot table is not affected.</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/pivotchart.xhp#pivotchart"/>
diff --git a/source/text/scalc/guide/pivotchart_edit.xhp b/source/text/scalc/guide/pivotchart_edit.xhp
index addf477dab..428edacd37 100644
--- a/source/text/scalc/guide/pivotchart_edit.xhp
+++ b/source/text/scalc/guide/pivotchart_edit.xhp
@@ -28,7 +28,7 @@
<embed href="text/shared/guide/chart_legend.xhp#chart_legend"/>
<embed href="text/shared/guide/chart_barformat.xhp#chart_barformat"/>
<embed href="text/schart/01/three_d_view.xhp#three_d_view"/>
- <embed href="text/shared/00/00000004.xhp#samplefile"/>
+
<embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
<section id="relatedtopics">
<embed href="text/scalc/guide/pivotchart.xhp#pivotchart"/>
diff --git a/source/text/scalc/guide/pivotchart_filter.xhp b/source/text/scalc/guide/pivotchart_filter.xhp
index d704583c92..db769233d7 100644
--- a/source/text/scalc/guide/pivotchart_filter.xhp
+++ b/source/text/scalc/guide/pivotchart_filter.xhp
@@ -32,7 +32,7 @@
<paragraph role="paragraph" id="par_id851525167448337" xml-lang="en-US">The buttons have a pop-up action attached to them. If there is some filtering applied, then the arrow turns blue (similar to the pivot table), so it is easier to see when a field has any filter applied.</paragraph>
<paragraph role="paragraph" id="par_id401525167457977" xml-lang="en-US">Existing page fields shows what is filtered: when nothing is filtered "- all -" is shown, when some data is filtered, then "- multiple -" is shown and when only one value is not filtered, the value is shown.</paragraph>
- <embed href="text/shared/00/00000004.xhp#samplefile"/>
+
<embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
<section id="relatedtopics">
diff --git a/source/text/scalc/guide/pivotchart_update.xhp b/source/text/scalc/guide/pivotchart_update.xhp
index e9e9fe9ae2..41cfed9cb2 100644
--- a/source/text/scalc/guide/pivotchart_update.xhp
+++ b/source/text/scalc/guide/pivotchart_update.xhp
@@ -29,7 +29,7 @@
<paragraph id="par_id331525146738273" role="listitem" xml-lang="en-US">Choose <emph>Refresh...</emph> in the context menu of any cell in the pivot table.</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/pivotchart.xhp#pivotchart"/>