summaryrefslogtreecommitdiff
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
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>
-rw-r--r--source/text/scalc/01/04060106.xhp21
-rw-r--r--source/text/scalc/01/func_imcos.xhp1
-rw-r--r--source/text/scalc/01/func_imcosh.xhp1
-rw-r--r--source/text/scalc/01/func_imcot.xhp1
-rw-r--r--source/text/scalc/01/func_imcsc.xhp1
-rw-r--r--source/text/scalc/01/func_imcsch.xhp1
-rw-r--r--source/text/scalc/01/func_imsec.xhp1
-rw-r--r--source/text/scalc/01/func_imsech.xhp1
-rw-r--r--source/text/scalc/01/func_imsin.xhp1
-rw-r--r--source/text/scalc/01/func_imsinh.xhp1
-rw-r--r--source/text/scalc/01/func_imtan.xhp1
-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
25 files changed, 14 insertions, 45 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index cb5e71f1c0..08c0ffc7e6 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -79,7 +79,6 @@
<paragraph id="hd_id3149882" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3150128" role="paragraph" xml-lang="en-US"><item type="input">=ACOS(-1)</item> returns 3.14159265358979 (PI radians)</paragraph>
<paragraph id="par_id8792382" role="paragraph" xml-lang="en-US"><item type="input">=DEGREES(ACOS(0.5))</item> returns 60. The cosine of 60 degrees is 0.5.</paragraph><comment>see also COS, SIN, TAN, COT, ASIN, ATAN, ATAN2, ACOT</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -101,7 +100,6 @@
<paragraph id="hd_id3150566" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3145629" role="paragraph" xml-lang="en-US"><item type="input">=ACOSH(1)</item> returns 0.</paragraph>
<paragraph id="par_id951567" role="paragraph" xml-lang="en-US"><item type="input">=ACOSH(COSH(4))</item> returns 4.</paragraph><comment>see also ASINH, ATANH, ACOTH, COSH, SINH, TANH, COTH</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -123,7 +121,6 @@
<paragraph id="hd_id3147538" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3155375" role="paragraph" xml-lang="en-US"><item type="input">=ACOT(1)</item> returns 0.785398163397448 (PI/4 radians).</paragraph>
<paragraph id="par_id8589434" role="paragraph" xml-lang="en-US"><item type="input">=DEGREES(ACOT(1))</item> returns 45. The tangent of 45 degrees is 1.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN, ATAN2</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -144,7 +141,6 @@
<paragraph id="hd_id3083452" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3150608" role="paragraph" xml-lang="en-US"><item type="input">=ACOTH(1.1)</item> returns inverse hyperbolic cotangent of 1.1, approximately 1.52226.</paragraph><comment>see also ACOSH, ASINH, ATANH, COSH, SINH, TANH, COTH</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -173,7 +169,6 @@
<paragraph id="par_id3156100" role="paragraph" xml-lang="en-US"><item type="input">=ASIN(0)</item> returns 0.</paragraph>
<paragraph id="par_id6853846" role="paragraph" xml-lang="en-US"><item type="input">=ASIN(1)</item> returns 1.5707963267949 (PI/2 radians).</paragraph>
<paragraph id="par_id8772240" role="paragraph" xml-lang="en-US"><item type="input">=DEGREES(ASIN(0.5))</item> returns 30. The sine of 30 degrees is 0.5.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ATAN, ATAN2, ACOT</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -194,7 +189,6 @@
<paragraph id="hd_id3153212" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3156120" role="paragraph" xml-lang="en-US"><item type="input">=ASINH(-90)</item> returns approximately -5.1929877.</paragraph>
<paragraph id="par_id4808496" role="paragraph" xml-lang="en-US"><item type="input">=ASINH(SINH(4))</item> returns 4.</paragraph><comment>see also ACOSH, ATANH, ACOTH, COSH, SINH, TANH, COTH</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -216,7 +210,6 @@
<paragraph id="hd_id3154054" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3143229" role="paragraph" xml-lang="en-US"><item type="input">=ATAN(1)</item> returns 0.785398163397448 (PI/4 radians).</paragraph>
<paragraph id="par_id8746299" role="paragraph" xml-lang="en-US"><item type="input">=DEGREES(ATAN(1))</item> returns 45. The tangent of 45 degrees is 1.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN2, ACOT</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -240,7 +233,6 @@
<paragraph id="hd_id3145663" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3154692" role="paragraph" xml-lang="en-US"><item type="input">=ATAN2(20;20)</item> returns 0.785398163397448 (PI/4 radians).</paragraph>
<paragraph id="par_id1477095" role="paragraph" xml-lang="en-US"><item type="input">=DEGREES(ATAN2(12.3;12.3))</item> returns 45. The tangent of 45 degrees is 1.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN, ACOT</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -261,7 +253,6 @@
<paragraph id="hd_id3148450" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3145419" role="paragraph" xml-lang="en-US"><item type="input">=ATANH(0)</item> returns 0.</paragraph><comment>see also ACOSH, ASINH, ACOTH, COSH, SINH, TANH, COTH</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -283,7 +274,6 @@
<paragraph id="hd_id3153579" role="heading" level="3" xml-lang="en-US">Examples</paragraph>
<paragraph id="par_id3147241" role="paragraph" xml-lang="en-US"><item type="input">=COS(PI()*2)</item> returns 1, the cosine of 2*PI radians.</paragraph>
<paragraph id="par_id3147516" role="paragraph" xml-lang="en-US"><item type="input">=COS(RADIANS(60))</item> returns 0.5, the cosine of 60 degrees.</paragraph><comment>see also SIN, TAN, COT, ACOS, ASIN, ATAN, ATAN2, ACOT</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -303,7 +293,6 @@
<paragraph id="hd_id3153234" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3154099" role="paragraph" xml-lang="en-US"><item type="input">=COSH(0)</item> returns 1, the hyperbolic cosine of 0.</paragraph><comment>see also SINH, TANH, COTH, ACOSH, ASINH, ATANH, ACOTH</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -326,7 +315,6 @@
<paragraph id="hd_id3149800" role="heading" level="3" xml-lang="en-US">Examples:</paragraph>
<paragraph id="par_id3148616" role="paragraph" xml-lang="en-US"><item type="input">=COT(PI()/4)</item> returns 1, the cotangent of PI/4 radians.</paragraph>
<paragraph id="par_id3148986" role="paragraph" xml-lang="en-US"><item type="input">=COT(RADIANS(45))</item> returns 1, the cotangent of 45 degrees.</paragraph><comment>see also COS, SIN, TAN, ACOS, ASIN, ATAN, ATAN2, ACOT</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -346,7 +334,6 @@
<paragraph id="hd_id3155422" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3144754" role="paragraph" xml-lang="en-US"><item type="input">=COTH(1)</item> returns the hyperbolic cotangent of 1, approximately 1.3130.</paragraph><comment>see also COSH, SINH, TANH, ACOSH, ASINH, ATANH, ACOTH</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -368,7 +355,6 @@
<paragraph id="hd_id2577161" role="heading" level="3" xml-lang="en-US">Examples</paragraph>
<paragraph id="par_id3736803" role="paragraph" xml-lang="en-US"><item type="input">=CSC(PI()/4)</item> returns approximately 1.4142135624, the inverse of the sine of PI/4 radians.</paragraph>
<paragraph id="par_id6016818" role="paragraph" xml-lang="en-US"><item type="input">=CSC(RADIANS(30))</item> returns 2, the cosecant of 30 degrees.</paragraph><comment>see also SIN, TAN, COT, SEC, ACOS, ASIN, ATAN, ATAN2, ACOT</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -388,7 +374,6 @@
<paragraph id="hd_id6037477" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id5426085" role="paragraph" xml-lang="en-US"><item type="input">=CSCH(1)</item> returns approximately 0.8509181282, the hyperbolic cosecant of 1.</paragraph><comment>see also SINH, TANH, COTH, SECH,ACOSH, ASINH, ATANH, ACOTH</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -1067,7 +1052,6 @@
<paragraph id="hd_id9878918" role="heading" level="3" xml-lang="en-US">Examples</paragraph>
<paragraph id="par_id6935513" role="paragraph" xml-lang="en-US"><item type="input">=SEC(PI()/4)</item> returns approximately 1.4142135624, the inverse of the cosine of PI/4 radians.</paragraph>
<paragraph id="par_id3954287" role="paragraph" xml-lang="en-US"><item type="input">=SEC(RADIANS(60))</item> returns 2, the secant of 60 degrees.</paragraph><comment>see also SIN, TAN, COT, CSC, ACOS, ASIN, ATAN, ATAN2, ACOT</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -1087,7 +1071,6 @@
<paragraph id="hd_id9838764" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id1187764" role="paragraph" xml-lang="en-US"><item type="input">=SECH(0)</item> returns 1, the hyperbolic secant of 0.</paragraph><comment>see also SINH, TANH, COTH, CSCH, ACOSH, ASINH, ATANH, ACOTH</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -1109,7 +1092,6 @@
<paragraph id="hd_id3144969" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3144983" role="paragraph" xml-lang="en-US"><item type="input">=SIN(PI()/2)</item> returns 1, the sine of PI/2 radians.</paragraph>
<paragraph id="par_id3916440" role="paragraph" xml-lang="en-US"><item type="input">=SIN(RADIANS(30))</item> returns 0.5, the sine of 30 degrees.</paragraph><comment>see also COS, TAN, COT, ACOS, ASIN, ATAN, ATAN2, ACOT</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -1129,7 +1111,6 @@
<paragraph id="hd_id3163491" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3163504" role="paragraph" xml-lang="en-US"><item type="input">=SINH(0)</item> returns 0, the hyperbolic sine of 0.</paragraph><comment>see also COSH, TANH, COTH, ACOSH, ASINH, ATANH, ACOTH</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -1214,7 +1195,6 @@
<paragraph id="hd_id3152287" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3152301" role="paragraph" xml-lang="en-US"><item type="input">=TAN(PI()/4) </item>returns 1, the tangent of PI/4 radians.</paragraph>
<paragraph id="par_id1804864" role="paragraph" xml-lang="en-US"><item type="input">=TAN(RADIANS(45))</item> returns 1, the tangent of 45 degrees.</paragraph><comment>see also COS, SIN, COT, ACOS, ASIN, ATAN, ATAN2, ACOT</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
@@ -1234,7 +1214,6 @@
<paragraph id="hd_id3165527" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3165541" role="paragraph" xml-lang="en-US"><item type="input">=TANH(0)</item> returns 0, the hyperbolic tangent of 0.</paragraph><comment>see also COSH, SINH, COTH, ACOSH, ASINH, ATANH, ACOTH</comment>
-<embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
diff --git a/source/text/scalc/01/func_imcos.xhp b/source/text/scalc/01/func_imcos.xhp
index 14a69e332d..770a3cdca1 100644
--- a/source/text/scalc/01/func_imcos.xhp
+++ b/source/text/scalc/01/func_imcos.xhp
@@ -60,7 +60,6 @@
<item type="input">=IMCOS(2)</item><br/>
returns -0.416146836547142 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/>
</paragraph>
- <embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
<paragraph id="par_id208171544029884" role="paragraph" localize="false" xml-lang="en-US">
diff --git a/source/text/scalc/01/func_imcosh.xhp b/source/text/scalc/01/func_imcosh.xhp
index e21a6c9af4..adcff30190 100644
--- a/source/text/scalc/01/func_imcosh.xhp
+++ b/source/text/scalc/01/func_imcosh.xhp
@@ -60,7 +60,6 @@
<item type="input">=IMCOSH(2)</item><br/>
returns 3.76219569108363 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/>
</paragraph>
- <embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
<paragraph id="par_id127621276212762" role="paragraph" localize="false" xml-lang="en-US">
diff --git a/source/text/scalc/01/func_imcot.xhp b/source/text/scalc/01/func_imcot.xhp
index 889e6b4ddb..753ebdf9b3 100644
--- a/source/text/scalc/01/func_imcot.xhp
+++ b/source/text/scalc/01/func_imcot.xhp
@@ -64,7 +64,6 @@
<item type="input">=IMCOT(2)</item><br/>
returns -0.457657554360286 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/>
</paragraph>
- <embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
<paragraph id="par_id766137661376613" role="paragraph" localize="false" xml-lang="en-US">
diff --git a/source/text/scalc/01/func_imcsc.xhp b/source/text/scalc/01/func_imcsc.xhp
index 3f89050186..b585d45d9a 100644
--- a/source/text/scalc/01/func_imcsc.xhp
+++ b/source/text/scalc/01/func_imcsc.xhp
@@ -64,7 +64,6 @@
<item type="input">=IMCSC(2)</item><br/>
returns 1.09975017029462 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/>
</paragraph>
- <embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
<paragraph id="par_id933269332693326" role="paragraph" localize="false" xml-lang="en-US">
diff --git a/source/text/scalc/01/func_imcsch.xhp b/source/text/scalc/01/func_imcsch.xhp
index 51e437b420..f01660acee 100644
--- a/source/text/scalc/01/func_imcsch.xhp
+++ b/source/text/scalc/01/func_imcsch.xhp
@@ -64,7 +64,6 @@
<item type="input">=IMCSCH(2)</item><br/>
returns 0.275720564771783 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/>
</paragraph>
- <embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
<paragraph id="par_id981669816698166" role="paragraph" localize="false" xml-lang="en-US">
diff --git a/source/text/scalc/01/func_imsec.xhp b/source/text/scalc/01/func_imsec.xhp
index b498326db2..ee19ce11c5 100644
--- a/source/text/scalc/01/func_imsec.xhp
+++ b/source/text/scalc/01/func_imsec.xhp
@@ -64,7 +64,6 @@
<item type="input">=IMSEC(2)</item><br/>
returns -2.40299796172238 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/>
</paragraph>
- <embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
<paragraph id="par_id57381738213791" role="paragraph" localize="false" xml-lang="en-US">
diff --git a/source/text/scalc/01/func_imsech.xhp b/source/text/scalc/01/func_imsech.xhp
index 82ce87aa1e..f38d3277fd 100644
--- a/source/text/scalc/01/func_imsech.xhp
+++ b/source/text/scalc/01/func_imsech.xhp
@@ -64,7 +64,6 @@
<item type="input">=IMSECH(2)</item><br/>
returns 0.26580222883408 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/>
</paragraph>
- <embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
<paragraph id="par_id26960257451996" role="paragraph" localize="false" xml-lang="en-US">
diff --git a/source/text/scalc/01/func_imsin.xhp b/source/text/scalc/01/func_imsin.xhp
index 1e166feb77..8dc39f13ac 100644
--- a/source/text/scalc/01/func_imsin.xhp
+++ b/source/text/scalc/01/func_imsin.xhp
@@ -60,7 +60,6 @@
<item type="input">=IMSIN(2)</item><br/>
returns 0.909297426825682 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/>
</paragraph>
- <embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
<paragraph id="par_id2773214341302" role="paragraph" localize="false" xml-lang="en-US">
diff --git a/source/text/scalc/01/func_imsinh.xhp b/source/text/scalc/01/func_imsinh.xhp
index fdd34e4ddc..4b41f6835b 100644
--- a/source/text/scalc/01/func_imsinh.xhp
+++ b/source/text/scalc/01/func_imsinh.xhp
@@ -60,7 +60,6 @@
<item type="input">=IMSINH(2)</item><br/>
returns 3.62686040784702 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/>
</paragraph>
- <embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
<paragraph id="par_id2773214341302" localize="false" role="paragraph" xml-lang="en-US">
diff --git a/source/text/scalc/01/func_imtan.xhp b/source/text/scalc/01/func_imtan.xhp
index 79a801939f..79bbae1502 100644
--- a/source/text/scalc/01/func_imtan.xhp
+++ b/source/text/scalc/01/func_imtan.xhp
@@ -64,7 +64,6 @@
<item type="input">=IMTAN(2)</item><br/>
returns -2.18503986326152 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/>
</paragraph>
- <embed href="text/shared/00/00000004.xhp#samplefile"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
<paragraph id="par_id2479417868613" role="paragraph" localize="false" xml-lang="en-US">
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"/>