summaryrefslogtreecommitdiff
path: root/source/text/scalc
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2016-01-25 20:07:10 +0100
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2016-01-25 21:21:48 +0100
commit6614bedceadcc07ec082c5e926107f27903bda5c (patch)
tree0eedb2f897737cce9d169651b4b8863b2049da98 /source/text/scalc
parentbb4361c2e733c7b5a6a3a4b9d37ec0586c99ccd7 (diff)
fix validation errors by round-trip through helpauthoring extension
lots of missing attributes "id" and "xml-lang" (extension patched to keep bascode tag) Change-Id: I9c5600b6fa133a6b1062803eadb976e043db7a4a
Diffstat (limited to 'source/text/scalc')
-rw-r--r--source/text/scalc/01/02140700.xhp2
-rw-r--r--source/text/scalc/01/func_averageif.xhp2
-rw-r--r--source/text/scalc/01/func_averageifs.xhp2
-rw-r--r--source/text/scalc/01/func_imsinh.xhp2
-rw-r--r--source/text/scalc/01/stat_data.xhp4
-rw-r--r--source/text/scalc/01/statistics.xhp2
-rw-r--r--source/text/scalc/guide/formulas.xhp1
7 files changed, 7 insertions, 8 deletions
diff --git a/source/text/scalc/01/02140700.xhp b/source/text/scalc/01/02140700.xhp
index 1970ef4572..8ad966827e 100644
--- a/source/text/scalc/01/02140700.xhp
+++ b/source/text/scalc/01/02140700.xhp
@@ -19,7 +19,7 @@
-->
<meta>
-<topic id="ID" indexer="Indexer" status="PUBLISH">
+<topic id="ID" indexer="include" status="PUBLISH">
<title xml-lang="en-US" id="tit">Fill Random Numbers</title>
<filename>text/scalc/01/02140700.xhp</filename>
</topic>
diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp
index c41e8e9122..85e19ddcfe 100644
--- a/source/text/scalc/01/func_averageif.xhp
+++ b/source/text/scalc/01/func_averageif.xhp
@@ -35,7 +35,7 @@
The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks ("Criterion") with the exception of the names of functions, cell references and an operation of a string concatenation (&amp;).</paragraph><embed href="text/scalc/01/ODFF.xhp#odff"/>
<paragraph id="par_id278275053653" role="warning" xml-lang="en-US">If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell.<br/>
If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error. </paragraph>
-<paragraph id="par_id37381077012888" role="paragraph" localize="false" xml-lang="en-US"><embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/></paragraph>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
<paragraph id="par_id38832436828097" role="warning" xml-lang="en-US">In all calculations below, range for average calculation contains the row #6, but it is ignored, because it contains text.</paragraph>
<paragraph id="hd_id229513120314273" role="heading" level="4" xml-lang="en-US">Simple usage</paragraph>
<paragraph id="par_id2509201519225446" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"&lt;35")</item></paragraph>
diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp
index 6fb90925ae..882518086c 100644
--- a/source/text/scalc/01/func_averageifs.xhp
+++ b/source/text/scalc/01/func_averageifs.xhp
@@ -41,7 +41,7 @@ The function can have up to 255 arguments, meaning that you can specify 127 crit
If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>
If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error.<br/>
If the range of values for calculating the mean and any range for finding criterion have unequal sizes, the function returns err:502.</paragraph>
-<paragraph id="par_id9397381616478" role="paragraph" localize="false" xml-lang="en-US"><embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/></paragraph>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
<paragraph id="par_id151201977228038" role="warning" xml-lang="en-US">In all examples below, ranges for average calculation contain the row #6, but it is ignored, because it contains text.</paragraph>
<paragraph id="hd_id20733192524041" role="heading" level="4" xml-lang="en-US">Simple usage</paragraph>
<paragraph id="par_id24004653627203" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(B2:B6;B2:B6;">=20")</item></paragraph>
diff --git a/source/text/scalc/01/func_imsinh.xhp b/source/text/scalc/01/func_imsinh.xhp
index 8df95b97a5..7c50b2beda 100644
--- a/source/text/scalc/01/func_imsinh.xhp
+++ b/source/text/scalc/01/func_imsinh.xhp
@@ -64,7 +64,7 @@
</item>
returns 3.62686040784702 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/>
</paragraph>
- <section id="relatedtopics"><br/>
+ <section id="relatedtopics">
<paragraph id="par_id2773214341302" role="paragraph" xml-lang="en-US">
<embedvar href="text/scalc/01/func_imsin.xhp#imsin_head"/>,
<embedvar href="text/scalc/01/func_imcos.xhp#imcos_head"/>,
diff --git a/source/text/scalc/01/stat_data.xhp b/source/text/scalc/01/stat_data.xhp
index edb3c47929..31e5611306 100644
--- a/source/text/scalc/01/stat_data.xhp
+++ b/source/text/scalc/01/stat_data.xhp
@@ -19,7 +19,7 @@
-->
<meta>
-<topic id="ID" indexer="Indexer">
+<topic id="ID" indexer="include">
<title xml-lang="en-US" id="tit">Data</title>
<filename>/text/scalc/01/stat_data.xhp</filename>
</topic>
@@ -551,4 +551,4 @@
</section>
</body>
-</helpdocument> \ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp
index 3ce9fd8a69..5cdd15940c 100644
--- a/source/text/scalc/01/statistics.xhp
+++ b/source/text/scalc/01/statistics.xhp
@@ -19,7 +19,7 @@
-->
<meta>
-<topic id="ID" indexer="Indexer" status="PUBLISH">
+<topic id="ID" indexer="include" status="PUBLISH">
<title xml-lang="en-US" id="tit">Data Statistics in Calc</title>
<filename>/text/scalc/01/statistics.xhp</filename>
</topic>
diff --git a/source/text/scalc/guide/formulas.xhp b/source/text/scalc/guide/formulas.xhp
index eef1d19a60..3c87fb15bb 100644
--- a/source/text/scalc/guide/formulas.xhp
+++ b/source/text/scalc/guide/formulas.xhp
@@ -95,7 +95,6 @@
<paragraph role="paragraph" id="par_id3159171" xml-lang="en-US" l10n="U" oldref="36">Calculates the sum of cells B10 to B14 and adds the value to B8.</paragraph>
</tablecell>
</tablerow>
-<comment>removed row with old row limit of 65536</comment>
</table>
<paragraph role="paragraph" id="par_id3150109" xml-lang="en-US" l10n="U" oldref="30">It is also possible to nest functions in formulas, as shown in the example. You can also nest functions within functions. The Function Wizard assists you with nested functions.</paragraph>
<section id="relatedtopics">