[Libreoffice-commits] help.git: source/text
Olivier Hallot
ohallot at collabora.co.uk
Sun May 22 23:20:32 UTC 2016
source/text/scalc/01/04060101.xhp | 116 +++++++++++++++++++-------------------
1 file changed, 58 insertions(+), 58 deletions(-)
New commits:
commit ea6c97353fc81c1e40e5b10cc70d1436e8a8d809
Author: Olivier Hallot <ohallot at collabora.co.uk>
Date: Sat May 21 23:28:39 2016 -0300
Do not translate numbers... (3)
Change-Id: I2480be8d515d210413dc6e732467bdf9c420bdbe
Reviewed-on: https://gerrit.libreoffice.org/25279
Reviewed-by: Olivier Hallot <ohallot at collabora.co.uk>
Tested-by: Olivier Hallot <ohallot at collabora.co.uk>
diff --git a/source/text/scalc/01/04060101.xhp b/source/text/scalc/01/04060101.xhp
index 4c037b3..9097b0f 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">>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>
More information about the Libreoffice-commits
mailing list