source/text/scalc/01/04060199.xhp | 140 +++++++++++++++++++-------------------
1 file changed, 70 insertions(+), 70 deletions(-)
New commits:
commit 5d7fd5dd8910f3d7bc98c8a3d452102d133f4ffa
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri Jun 23 19:31:32 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sat Jun 24 13:10:15 2023 +0200
Refactor, no changes.
Change-Id: I11d58e24520d749c30b73913555d478a24806cfc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/153541
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060199.xhp
b/source/text/scalc/01/04060199.xhp
index 2f0be70c8a..d7c050fb11 100644
--- a/source/text/scalc/01/04060199.xhp
+++ b/source/text/scalc/01/04060199.xhp
@@ -19,12 +19,12 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc0104060199xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Operators in $[officename] Calc</title>
+<title id="tit">Operators in $[officename] Calc</title>
<filename>/text/scalc/01/04060199.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3156445"><bookmark_value>formulas; operators</bookmark_value>
+<bookmark branch="index" id="bm_id3156445"><bookmark_value>formulas;
operators</bookmark_value>
<bookmark_value>operators; formula functions</bookmark_value>
<bookmark_value>division sign, see also operators</bookmark_value>
<bookmark_value>multiplication sign, see also operators</bookmark_value>
@@ -35,16 +35,16 @@
<bookmark_value>arithmetical operators</bookmark_value>
<bookmark_value>reference operators</bookmark_value>
</bookmark><comment>mw added 7 new index entries</comment><h1
id="hd_id3156445">Operators in $[officename] Calc</h1>
-<paragraph role="paragraph" id="par_id3155812" xml-lang="en-US">You can use
the following operators in $[officename] Calc:</paragraph>
+<paragraph role="paragraph" id="par_id3155812">You can use the following
operators in $[officename] Calc:</paragraph>
<h2 id="hd_id3153066">Arithmetical Operators</h2>
-<paragraph role="paragraph" id="par_id3148601" xml-lang="en-US">These
operators return numerical results.</paragraph>
+<paragraph role="paragraph" id="par_id3148601">These operators return
numerical results.</paragraph>
<table id="tbl_id3151240">
<tablerow>
<tablecell>
-<paragraph role="tablehead" id="par_id3144768"
xml-lang="en-US">Operator</paragraph>
+<paragraph role="tablehead" id="par_id3144768">Operator</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3157982"
xml-lang="en-US">Name</paragraph>
+<paragraph role="tablehead" id="par_id3157982">Name</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablehead" id="par_id401599494815994">Example</paragraph>
@@ -52,79 +52,79 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3149126" xml-lang="en-US">+
(Plus)</paragraph>
+<paragraph role="tablecontent" id="par_id3149126">+ (Plus)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3150892"
xml-lang="en-US">Addition</paragraph>
+<paragraph role="tablecontent" id="par_id3150892">Addition</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3153247" localize="false"
xml-lang="en-US">1+1</paragraph>
+<paragraph role="tablecontent" id="par_id3153247"
localize="false">1+1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3159204" xml-lang="en-US">-
(Minus)</paragraph>
+<paragraph role="tablecontent" id="par_id3159204">- (Minus)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3145362"
xml-lang="en-US">Subtraction</paragraph>
+<paragraph role="tablecontent" id="par_id3145362">Subtraction</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3153554" localize="false"
xml-lang="en-US">2-1</paragraph>
+<paragraph role="tablecontent" id="par_id3153554"
localize="false">2-1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3153808" xml-lang="en-US">-
(Minus)</paragraph>
+<paragraph role="tablecontent" id="par_id3153808">- (Minus)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3151193"
xml-lang="en-US">Negation</paragraph>
+<paragraph role="tablecontent" id="par_id3151193">Negation</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3154712" localize="false"
xml-lang="en-US">-5</paragraph>
+<paragraph role="tablecontent" id="par_id3154712"
localize="false">-5</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3149873" xml-lang="en-US">*
(asterisk)</paragraph>
+<paragraph role="tablecontent" id="par_id3149873">* (asterisk)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3147504"
xml-lang="en-US">Multiplication</paragraph>
+<paragraph role="tablecontent" id="par_id3147504">Multiplication</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3149055" localize="false"
xml-lang="en-US">2*2</paragraph>
+<paragraph role="tablecontent" id="par_id3149055"
localize="false">2*2</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3151341" xml-lang="en-US">/
(Slash)</paragraph>
+<paragraph role="tablecontent" id="par_id3151341">/ (Slash)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3159260"
xml-lang="en-US">Division</paragraph>
+<paragraph role="tablecontent" id="par_id3159260">Division</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3153027" localize="false"
xml-lang="en-US">9/3</paragraph>
+<paragraph role="tablecontent" id="par_id3153027"
localize="false">9/3</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3156396" xml-lang="en-US">%
(Percent)</paragraph>
+<paragraph role="tablecontent" id="par_id3156396">% (Percent)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3150372"
xml-lang="en-US">Percent</paragraph>
+<paragraph role="tablecontent" id="par_id3150372">Percent</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3145632" localize="false"
xml-lang="en-US">15%</paragraph>
+<paragraph role="tablecontent" id="par_id3145632"
localize="false">15%</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3149722" xml-lang="en-US">^
(Caret)</paragraph>
+<paragraph role="tablecontent" id="par_id3149722">^ (Caret)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3159127"
xml-lang="en-US">Exponentiation</paragraph>
+<paragraph role="tablecontent" id="par_id3159127">Exponentiation</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3157873" localize="false"
xml-lang="en-US">3^2</paragraph>
+<paragraph role="tablecontent" id="par_id3157873"
localize="false">3^2</paragraph>
</tablecell>
</tablerow>
</table>
@@ -132,14 +132,14 @@
<note id="par_id881623862728559">Prefix "-" (negation) has a higher precedence
than "^" (exponentiation). For example -3^2 equals 9, which is the square of a
negative number.</note>
<h2 id="hd_id3152981">Comparative operators</h2>
-<paragraph role="paragraph" id="par_id3157902" xml-lang="en-US">These
operators return either true or false.</paragraph>
+<paragraph role="paragraph" id="par_id3157902">These operators return either
true or false.</paragraph>
<table id="tbl_id3148725">
<tablerow>
<tablecell>
-<paragraph role="tablehead" id="par_id3149889"
xml-lang="en-US">Operator</paragraph>
+<paragraph role="tablehead" id="par_id3149889">Operator</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3150743"
xml-lang="en-US">Name</paragraph>
+<paragraph role="tablehead" id="par_id3150743">Name</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablehead" id="par_id201599495083374">Example</paragraph>
@@ -147,80 +147,80 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3148888" xml-lang="en-US">= (equal
sign)</paragraph>
+<paragraph role="tablecontent" id="par_id3148888">= (equal sign)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3154845"
xml-lang="en-US">Equal</paragraph>
+<paragraph role="tablecontent" id="par_id3154845">Equal</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3154546" localize="false"
xml-lang="en-US">A1=B1</paragraph>
+<paragraph role="tablecontent" id="par_id3154546"
localize="false">A1=B1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3154807" xml-lang="en-US">>
(Greater than)</paragraph>
+<paragraph role="tablecontent" id="par_id3154807">> (Greater
than)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3148580" xml-lang="en-US">Greater
than</paragraph>
+<paragraph role="tablecontent" id="par_id3148580">Greater than</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3145138" localize="false"
xml-lang="en-US">A1>B1</paragraph>
+<paragraph role="tablecontent" id="par_id3145138"
localize="false">A1>B1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3149507" xml-lang="en-US">< (Less
than)</paragraph>
+<paragraph role="tablecontent" id="par_id3149507">< (Less than)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3150145" xml-lang="en-US">Less
than</paragraph>
+<paragraph role="tablecontent" id="par_id3150145">Less than</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3150901" localize="false"
xml-lang="en-US">A1<B1</paragraph>
+<paragraph role="tablecontent" id="par_id3150901"
localize="false">A1<B1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3153078" xml-lang="en-US">>=
(Greater than or equal to)</paragraph>
+<paragraph role="tablecontent" id="par_id3153078">>= (Greater than or equal
to)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3150866" xml-lang="en-US">Greater
than or equal to</paragraph>
+<paragraph role="tablecontent" id="par_id3150866">Greater than or equal
to</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3153111" localize="false"
xml-lang="en-US">A1>=B1</paragraph>
+<paragraph role="tablecontent" id="par_id3153111"
localize="false">A1>=B1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3153004" xml-lang="en-US"><= (Less
than or equal to)</paragraph>
+<paragraph role="tablecontent" id="par_id3153004"><= (Less than or equal
to)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3150335" xml-lang="en-US">Less than
or equal to</paragraph>
+<paragraph role="tablecontent" id="par_id3150335">Less than or equal
to</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3148760" localize="false"
xml-lang="en-US">A1<=B1</paragraph>
+<paragraph role="tablecontent" id="par_id3148760"
localize="false">A1<=B1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3157994" xml-lang="en-US"><>
(Inequality)</paragraph>
+<paragraph role="tablecontent" id="par_id3157994"><>
(Inequality)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3150019"
xml-lang="en-US">Inequality</paragraph>
+<paragraph role="tablecontent" id="par_id3150019">Inequality</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3149878" localize="false"
xml-lang="en-US">A1<>B1</paragraph>
+<paragraph role="tablecontent" id="par_id3149878"
localize="false">A1<>B1</paragraph>
</tablecell>
</tablerow>
</table>
<h2 id="hd_id3145241">Text operators</h2>
-<paragraph role="paragraph" id="par_id3155438" xml-lang="en-US">The operator
combines separate texts into one text.</paragraph>
+<paragraph role="paragraph" id="par_id3155438">The operator combines separate
texts into one text.</paragraph>
<table id="tbl_id3156061">
<tablerow>
<tablecell>
-<paragraph role="tablehead" id="par_id3150566"
xml-lang="en-US">Operator</paragraph>
+<paragraph role="tablehead" id="par_id3150566">Operator</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3153048"
xml-lang="en-US">Name</paragraph>
+<paragraph role="tablehead" id="par_id3153048">Name</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablehead" id="par_id201599494708332">Example</paragraph>
@@ -228,29 +228,29 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3148769" xml-lang="en-US">&
(And)</paragraph>
+<paragraph role="tablecontent" id="par_id3148769">& (And)</paragraph>
</tablecell>
<tablecell>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3157975"><bookmark_value>text concatenation AND</bookmark_value>
+<bookmark branch="index" id="bm_id3157975"><bookmark_value>text concatenation
AND</bookmark_value>
</bookmark>
-<paragraph role="tablecontent" id="par_id3157975" xml-lang="en-US">text
concatenation AND</paragraph>
+<paragraph role="tablecontent" id="par_id3157975">text concatenation
AND</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3157993" xml-lang="en-US">"Sun" &
"day" is "Sunday"</paragraph>
+<paragraph role="tablecontent" id="par_id3157993">"Sun" & "day" is
"Sunday"</paragraph>
</tablecell>
</tablerow>
</table>
<section id="referenceoperators">
<h2 id="hd_id3153550">Reference operators</h2>
-<paragraph role="paragraph" id="par_id3149024" xml-lang="en-US">These
operators return a cell range of zero, one or more cells.</paragraph>
-<paragraph role="paragraph" id="par_id2324900" xml-lang="en-US">Range has the
highest precedence, then intersection, and then finally union.</paragraph>
+<paragraph role="paragraph" id="par_id3149024">These operators return a cell
range of zero, one or more cells.</paragraph>
+<paragraph role="paragraph" id="par_id2324900">Range has the highest
precedence, then intersection, and then finally union.</paragraph>
<table id="tbl_id3154633">
<tablerow>
<tablecell>
-<paragraph role="tablehead" id="par_id3158416"
xml-lang="en-US">Operator</paragraph>
+<paragraph role="tablehead" id="par_id3158416">Operator</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3152822"
xml-lang="en-US">Name</paragraph>
+<paragraph role="tablehead" id="par_id3152822">Name</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablehead" id="par_id521599494740206">Example</paragraph>
@@ -258,38 +258,38 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3156257" xml-lang="en-US">:
(Colon)</paragraph>
+<paragraph role="tablecontent" id="par_id3156257">: (Colon)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3153924"
xml-lang="en-US">Range</paragraph>
+<paragraph role="tablecontent" id="par_id3153924">Range</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3148432" xml-lang="en-US">A1:C108,
A:D or 3:13</paragraph>
+<paragraph role="tablecontent" id="par_id3148432">A1:C108, A:D or
3:13</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3152592" xml-lang="en-US">!
(Exclamation point)</paragraph>
+<paragraph role="tablecontent" id="par_id3152592">! (Exclamation
point)</paragraph>
</tablecell>
<tablecell>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3150606"><bookmark_value>intersection operator</bookmark_value>
+<bookmark branch="index" id="bm_id3150606"><bookmark_value>intersection
operator</bookmark_value>
</bookmark>
-<paragraph role="tablecontent" id="par_id3150606"
xml-lang="en-US">Intersection</paragraph>
+<paragraph role="tablecontent" id="par_id3150606">Intersection</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3083445"
xml-lang="en-US">SUM(A1:B6!B5:C12)</paragraph>
-<paragraph role="tablecontent" id="par_id3150385" xml-lang="en-US">Calculates
the sum of all cells in the intersection; in this example, the result yields
the sum of cells B5 and B6.</paragraph>
+<paragraph role="tablecontent" id="par_id3083445">SUM(A1:B6!B5:C12)</paragraph>
+<paragraph role="tablecontent" id="par_id3150385">Calculates the sum of all
cells in the intersection; in this example, the result yields the sum of cells
B5 and B6.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id4003723" xml-lang="en-US">~
(Tilde)</paragraph>
+<paragraph role="tablecontent" id="par_id4003723">~ (Tilde)</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id838953"
xml-lang="en-US">Concatenation or union</paragraph>
+<paragraph role="tablecontent" id="par_id838953">Concatenation or
union</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id2511978" xml-lang="en-US">Takes two
references and returns a reference list, which is a concatenation of the left
reference followed by the right reference. Double entries are referenced
twice.</paragraph>
+<paragraph role="tablecontent" id="par_id2511978">Takes two references and
returns a reference list, which is a concatenation of the left reference
followed by the right reference. Double entries are referenced
twice.</paragraph>
<paragraph role="paragraph"
id="par_id961672071835372"><input>=COUNT(A1:B2~B2:C3)</input> counts values of
A1:B2 and B2:C3. Note that the cell B2 is counted twice.</paragraph>
<paragraph role="paragraph"
id="par_id401672243346224"><input>=INDEX(A1:B2~C1:D2;2;1;2)</input> selects
cell C2, that is, the first cell of the second row, first column, of the second
range (C1:D2) of the range list.</paragraph>
</tablecell>
