summaryrefslogtreecommitdiff
path: root/source
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 /source
parentbd649dfd6750991c54e1509c3b2afeb55d9ef267 (diff)
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>
Diffstat (limited to 'source')
-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>