summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorOlivier Hallot <ohallot@collabora.co.uk>2016-05-21 23:28:39 -0300
committerOlivier Hallot <ohallot@collabora.co.uk>2016-05-22 23:20:05 +0000
commitea6c97353fc81c1e40e5b10cc70d1436e8a8d809 (patch)
tree7c8dc98d8f5bf847a883528fb8dddead7d8de078
parentFix Data menu help file w/ new entries (diff)
downloadhelp-ea6c97353fc81c1e40e5b10cc70d1436e8a8d809.tar.gz
help-ea6c97353fc81c1e40e5b10cc70d1436e8a8d809.zip
Do not translate numbers... (3)
Change-Id: I2480be8d515d210413dc6e732467bdf9c420bdbe Reviewed-on: https://gerrit.libreoffice.org/25279 Reviewed-by: Olivier Hallot <ohallot@collabora.co.uk> Tested-by: Olivier Hallot <ohallot@collabora.co.uk>
-rw-r--r--source/text/scalc/01/04060101.xhp116
1 files changed, 58 insertions, 58 deletions
diff --git a/source/text/scalc/01/04060101.xhp b/source/text/scalc/01/04060101.xhp
index 4c037b35e5..9097b0f900 100644
--- a/source/text/scalc/01/04060101.xhp
+++ b/source/text/scalc/01/04060101.xhp
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
+
<!--
* This file is part of the LibreOffice project.
*
@@ -18,8 +18,8 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
+
+
<meta>
<topic id="textscalc0104060101xml" indexer="include">
<title xml-lang="en-US" id="tit">Database Functions</title>
@@ -32,7 +32,7 @@
<bookmark_value>databases; functions in $[officename] Calc</bookmark_value>
</bookmark>
<paragraph xml-lang="en-US" id="hd_id3148946" role="heading" level="1" l10n="U" oldref="1">Database Functions</paragraph>
- <paragraph xml-lang="en-US" id="par_id3145173" role="paragraph" l10n="U" oldref="2"><variable id="datenbanktext">This section deals with functions used with data organized as one row of data for one record.
+ <paragraph xml-lang="en-US" id="par_id3145173" role="paragraph" l10n="U" oldref="2"><variable id="datenbanktext">This section deals with functions used with data organized as one row of data for one record.
</variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3154016" role="note" l10n="U" oldref="186">The Database category may be confused with a database integrated in $[officename]. However, there is no connection between a database in $[officename] and the Database category in $[officename] Calc.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150329" role="heading" level="3" l10n="U"
@@ -91,7 +91,7 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153816" role="tablecontent" l10n="U" oldref="15">2</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153816" localize="false" role="tablecontent" l10n="U" oldref="15">2</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3151240" role="tablecontent" l10n="U" oldref="16">
@@ -99,29 +99,29 @@
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3156016" role="tablecontent" l10n="U" oldref="17">
+ <paragraph xml-lang="en-US" id="par_id3156016" localize="false" role="tablecontent" l10n="U" oldref="17">
<item type="input">3</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3145073" role="tablecontent" l10n="U" oldref="18">
+ <paragraph xml-lang="en-US" id="par_id3145073" localize="false" role="tablecontent" l10n="U" oldref="18">
<item type="input">9</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154956" role="tablecontent" l10n="U" oldref="19">
+ <paragraph xml-lang="en-US" id="par_id3154956" localize="false" role="tablecontent" l10n="U" oldref="19">
<item type="input">150</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153976" role="tablecontent" l10n="U" oldref="20">
+ <paragraph xml-lang="en-US" id="par_id3153976" localize="false" role="tablecontent" l10n="U" oldref="20">
<item type="input">40</item>
</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150894" role="tablecontent" l10n="U" oldref="21">3</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3150894" localize="false" role="tablecontent" l10n="U" oldref="21">3</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3152870" role="tablecontent" l10n="U" oldref="22">
@@ -129,29 +129,29 @@
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149692" role="tablecontent" l10n="U" oldref="23">
+ <paragraph xml-lang="en-US" id="par_id3149692" localize="false" role="tablecontent" l10n="U" oldref="23">
<item type="input">4</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154652" role="tablecontent" l10n="U" oldref="24">
+ <paragraph xml-lang="en-US" id="par_id3154652" localize="false" role="tablecontent" l10n="U" oldref="24">
<item type="input">10</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149381" role="tablecontent" l10n="U" oldref="25">
+ <paragraph xml-lang="en-US" id="par_id3149381" localize="false" role="tablecontent" l10n="U" oldref="25">
<item type="input">1000</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153812" role="tablecontent" l10n="U" oldref="26">
+ <paragraph xml-lang="en-US" id="par_id3153812" localize="false" role="tablecontent" l10n="U" oldref="26">
<item type="input">42</item>
</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3146965" role="tablecontent" l10n="U" oldref="27">4</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3146965" localize="false" role="tablecontent" l10n="U" oldref="27">4</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3155596" role="tablecontent" l10n="U" oldref="28">
@@ -159,29 +159,29 @@
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3147244" role="tablecontent" l10n="U" oldref="29">
+ <paragraph xml-lang="en-US" id="par_id3147244" localize="false" role="tablecontent" l10n="U" oldref="29">
<item type="input">3</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149871" role="tablecontent" l10n="U" oldref="30">
+ <paragraph xml-lang="en-US" id="par_id3149871" localize="false" role="tablecontent" l10n="U" oldref="30">
<item type="input">10</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3155752" role="tablecontent" l10n="U" oldref="31">
+ <paragraph xml-lang="en-US" id="par_id3155752" localize="false" role="tablecontent" l10n="U" oldref="31">
<item type="input">300</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149052" role="tablecontent" l10n="U" oldref="32">
+ <paragraph xml-lang="en-US" id="par_id3149052" localize="false" role="tablecontent" l10n="U" oldref="32">
<item type="input">51</item>
</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3146097" role="tablecontent" l10n="U" oldref="33">5</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3146097" localize="false" role="tablecontent" l10n="U" oldref="33">5</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3147296" role="tablecontent" l10n="U" oldref="34">
@@ -189,29 +189,29 @@
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150393" role="tablecontent" l10n="U" oldref="35">
+ <paragraph xml-lang="en-US" id="par_id3150393" localize="false" role="tablecontent" l10n="U" oldref="35">
<item type="input">5</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3145236" role="tablecontent" l10n="U" oldref="36">
+ <paragraph xml-lang="en-US" id="par_id3145236" localize="false" role="tablecontent" l10n="U" oldref="36">
<item type="input">11</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150534" role="tablecontent" l10n="U" oldref="37">
+ <paragraph xml-lang="en-US" id="par_id3150534" localize="false" role="tablecontent" l10n="U" oldref="37">
<item type="input">1200</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150375" role="tablecontent" l10n="U" oldref="38">
+ <paragraph xml-lang="en-US" id="par_id3150375" localize="false" role="tablecontent" l10n="U" oldref="38">
<item type="input">48</item>
</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3159121" role="tablecontent" l10n="U" oldref="39">6</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3159121" localize="false" role="tablecontent" l10n="U" oldref="39">6</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3150456" role="tablecontent" l10n="U" oldref="40">
@@ -219,29 +219,29 @@
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3146886" role="tablecontent" l10n="U" oldref="41">
+ <paragraph xml-lang="en-US" id="par_id3146886" localize="false" role="tablecontent" l10n="U" oldref="41">
<item type="input">2</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149945" role="tablecontent" l10n="U" oldref="42">
+ <paragraph xml-lang="en-US" id="par_id3149945" localize="false" role="tablecontent" l10n="U" oldref="42">
<item type="input">8</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3157904" role="tablecontent" l10n="U" oldref="43">
+ <paragraph xml-lang="en-US" id="par_id3157904" localize="false" role="tablecontent" l10n="U" oldref="43">
<item type="input">650</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149352" role="tablecontent" l10n="U" oldref="44">
+ <paragraph xml-lang="en-US" id="par_id3149352" localize="false" role="tablecontent" l10n="U" oldref="44">
<item type="input">33</item>
</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150028" role="tablecontent" l10n="U" oldref="45">7</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3150028" localize="false" role="tablecontent" l10n="U" oldref="45">7</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3145826" role="tablecontent" l10n="U" oldref="46">
@@ -249,29 +249,29 @@
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150743" role="tablecontent" l10n="U" oldref="47">
+ <paragraph xml-lang="en-US" id="par_id3150743" localize="false" role="tablecontent" l10n="U" oldref="47">
<item type="input">2</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154844" role="tablecontent" l10n="U" oldref="48">
+ <paragraph xml-lang="en-US" id="par_id3154844" localize="false" role="tablecontent" l10n="U" oldref="48">
<item type="input">7</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3148435" role="tablecontent" l10n="U" oldref="49">
+ <paragraph xml-lang="en-US" id="par_id3148435" localize="false" role="tablecontent" l10n="U" oldref="49">
<item type="input">300</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3148882" role="tablecontent" l10n="U" oldref="50">
+ <paragraph xml-lang="en-US" id="par_id3148882" localize="false" role="tablecontent" l10n="U" oldref="50">
<item type="input">42</item>
</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150140" role="tablecontent" l10n="U" oldref="51">8</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3150140" localize="false" role="tablecontent" l10n="U" oldref="51">8</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3146137" role="tablecontent" l10n="U" oldref="52">
@@ -279,29 +279,29 @@
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3148739" role="tablecontent" l10n="U" oldref="53">
+ <paragraph xml-lang="en-US" id="par_id3148739" localize="false" role="tablecontent" l10n="U" oldref="53">
<item type="input">1</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3148583" role="tablecontent" l10n="U" oldref="54">
+ <paragraph xml-lang="en-US" id="par_id3148583" localize="false" role="tablecontent" l10n="U" oldref="54">
<item type="input">7</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154556" role="tablecontent" l10n="U" oldref="55">
+ <paragraph xml-lang="en-US" id="par_id3154556" localize="false" role="tablecontent" l10n="U" oldref="55">
<item type="input">200</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3155255" role="tablecontent" l10n="U" oldref="56">
+ <paragraph xml-lang="en-US" id="par_id3155255" localize="false" role="tablecontent" l10n="U" oldref="56">
<item type="input">36</item>
</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3145141" role="tablecontent" l10n="U" oldref="57">9</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3145141" localize="false" role="tablecontent" l10n="U" oldref="57">9</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3153078" role="tablecontent" l10n="U" oldref="58">
@@ -309,29 +309,29 @@
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149955" role="tablecontent" l10n="U" oldref="59">
+ <paragraph xml-lang="en-US" id="par_id3149955" localize="false" role="tablecontent" l10n="U" oldref="59">
<item type="input">3</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150005" role="tablecontent" l10n="U" oldref="60">
+ <paragraph xml-lang="en-US" id="par_id3150005" localize="false" role="tablecontent" l10n="U" oldref="60">
<item type="input">9</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3155951" role="tablecontent" l10n="U" oldref="61">
+ <paragraph xml-lang="en-US" id="par_id3155951" localize="false" role="tablecontent" l10n="U" oldref="61">
<item type="input">1200</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3145169" role="tablecontent" l10n="U" oldref="62">
+ <paragraph xml-lang="en-US" id="par_id3145169" localize="false" role="tablecontent" l10n="U" oldref="62">
<item type="input">44</item>
</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153571" role="tablecontent" l10n="U" oldref="63">10</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153571" localize="false" role="tablecontent" l10n="U" oldref="63">10</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3148761" role="tablecontent" l10n="U" oldref="64">
@@ -339,29 +339,29 @@
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149877" role="tablecontent" l10n="U" oldref="65">
+ <paragraph xml-lang="en-US" id="par_id3149877" localize="false" role="tablecontent" l10n="U" oldref="65">
<item type="input">2</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154327" role="tablecontent" l10n="U" oldref="66">
+ <paragraph xml-lang="en-US" id="par_id3154327" localize="false" role="tablecontent" l10n="U" oldref="66">
<item type="input">8</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3155435" role="tablecontent" l10n="U" oldref="67">
+ <paragraph xml-lang="en-US" id="par_id3155435" localize="false" role="tablecontent" l10n="U" oldref="67">
<item type="input">1000</item>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3145353" role="tablecontent" l10n="U" oldref="68">
+ <paragraph xml-lang="en-US" id="par_id3145353" localize="false" role="tablecontent" l10n="U" oldref="68">
<item type="input">42</item>
</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150662" role="tablecontent" l10n="U" oldref="69">11</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3150662" localize="false" role="tablecontent" l10n="U" oldref="69">11</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -376,7 +376,7 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150568" role="tablecontent" l10n="U" oldref="70">12</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3150568" localize="false" role="tablecontent" l10n="U" oldref="70">12</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -391,7 +391,7 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149393" role="tablecontent" l10n="U" oldref="71">13</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149393" localize="false" role="tablecontent" l10n="U" oldref="71">13</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3153544" role="tablecontent" l10n="U" oldref="72">
@@ -421,7 +421,7 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153920" role="tablecontent" l10n="U" oldref="77">14</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153920" localize="false" role="tablecontent" l10n="U" oldref="77">14</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -430,7 +430,7 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3148429" role="tablecontent" l10n="U" oldref="78">
+ <paragraph xml-lang="en-US" id="par_id3148429" localize="false" role="tablecontent" l10n="U" oldref="78">
<item type="input">&gt;600</item>
</paragraph>
</tablecell>
@@ -439,7 +439,7 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3152588" role="tablecontent" l10n="U" oldref="79">15</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3152588" localize="false" role="tablecontent" l10n="U" oldref="79">15</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -454,7 +454,7 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3083286" role="tablecontent" l10n="U" oldref="80">16</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3083286" localize="false" role="tablecontent" l10n="U" oldref="80">16</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3163823" role="tablecontent" l10n="U" oldref="81">
@@ -462,7 +462,7 @@
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3145083" role="tablecontent" l10n="U" oldref="82">
+ <paragraph xml-lang="en-US" id="par_id3145083" localize="false" role="tablecontent" l10n="U" oldref="82">
<item type="input">5</item>
</paragraph>
</tablecell>
@@ -482,7 +482,7 @@
<paragraph xml-lang="en-US" id="par_id3149453" role="paragraph" l10n="U" oldref="85">
<emph>Database</emph> is the cell range defining the database.</paragraph>
<paragraph xml-lang="en-US" id="par_id3151272" role="paragraph" l10n="U" oldref="86">
-<emph>DatabaseField</emph> specifies the column where the function operates on after the search criteria of the first parameter is applied and the data rows are selected. It is not related to the search criteria itself. Use the number 0 to specify the whole data range. <variable id="quotes">To reference a column by means of the column header name, place quotation marks around the header name.
+<emph>DatabaseField</emph> specifies the column where the function operates on after the search criteria of the first parameter is applied and the data rows are selected. It is not related to the search criteria itself. Use the number 0 to specify the whole data range. <variable id="quotes">To reference a column by means of the column header name, place quotation marks around the header name.
</variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3147083" role="paragraph" l10n="U" oldref="87">
<emph>SearchCriteria</emph> is the cell range containing search criteria. If you write several criteria in one row they are connected by AND. If you write the criteria in different rows they are connected by OR. Empty cells in the search criteria range will be ignored.</paragraph>