diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-09-08 08:39:41 -0300 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-09-08 15:19:17 +0200 |
commit | e1165b2f11d933a273f13631e400f9ad5980d134 (patch) | |
tree | 0809f62ee089f1fd2aee53a8c09632405f02f925 /source/text/scalc | |
parent | 5b2fdb324ae69febd7af11b10ce6882d98894ebd (diff) |
tdf#136510 New Writer table functions PRODUCT, ABS.
PRODUCT, ABS, COUNT, SIGN
Change-Id: I14d33cbb101ee7146bc54d73121805c883dfe7bc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/102248
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
-rw-r--r-- | source/text/scalc/01/04060199.xhp | 153 |
1 files changed, 74 insertions, 79 deletions
diff --git a/source/text/scalc/01/04060199.xhp b/source/text/scalc/01/04060199.xhp index 2928f11e99..5ad22dbed5 100644 --- a/source/text/scalc/01/04060199.xhp +++ b/source/text/scalc/01/04060199.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc0104060199xml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Operators in $[officename] Calc</title> @@ -39,261 +34,261 @@ <bookmark_value>comparisons;operators in Calc</bookmark_value> <bookmark_value>arithmetical operators</bookmark_value> <bookmark_value>reference operators</bookmark_value> -</bookmark><comment>mw added 7 new index entries</comment><paragraph role="heading" id="hd_id3156445" xml-lang="en-US" level="1">Operators in $[officename] Calc</paragraph> +</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="heading" id="hd_id3153066" xml-lang="en-US" level="2">Arithmetical Operators</paragraph> +<h2 id="hd_id3153066">Arithmetical Operators</h2> <paragraph role="paragraph" id="par_id3148601" xml-lang="en-US">These operators return numerical results.</paragraph> <table id="tbl_id3151240"> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id3144768" xml-lang="en-US">Operator</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id3157982" xml-lang="en-US">Name</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<tablecell> + <paragraph role="tablehead" id="par_id401599494815994">Example</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3149126" xml-lang="en-US">+ (Plus)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3150892" xml-lang="en-US">Addition</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3153247" xml-lang="en-US">1+1</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3159204" xml-lang="en-US">- (Minus)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3145362" xml-lang="en-US">Subtraction</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3153554" xml-lang="en-US">2-1</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3153808" xml-lang="en-US">- (Minus)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3151193" xml-lang="en-US">Negation</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3154712" xml-lang="en-US">-5</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3149873" xml-lang="en-US">* (asterisk)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3147504" xml-lang="en-US">Multiplication</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3149055" xml-lang="en-US">2*2</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3151341" xml-lang="en-US">/ (Slash)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3159260" xml-lang="en-US">Division</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3153027" xml-lang="en-US">9/3</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3156396" xml-lang="en-US">% (Percent)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3150372" xml-lang="en-US">Percent</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3145632" xml-lang="en-US">15%</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3149722" xml-lang="en-US">^ (Caret)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3159127" xml-lang="en-US">Exponentiation</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3157873" xml-lang="en-US">3^2</paragraph> </tablecell> </tablerow> </table> -<paragraph role="heading" id="hd_id3152981" xml-lang="en-US" level="2">Comparative operators</paragraph> +<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> <table id="tbl_id3148725"> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id3149889" xml-lang="en-US">Operator</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id3150743" xml-lang="en-US">Name</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<tablecell> + <paragraph role="tablehead" id="par_id201599495083374">Example</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3148888" xml-lang="en-US">= (equal sign)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3154845" xml-lang="en-US">Equal</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3154546" xml-lang="en-US">A1=B1</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3154807" xml-lang="en-US">> (Greater than)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3148580" xml-lang="en-US">Greater than</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3145138" xml-lang="en-US">A1>B1</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3149507" xml-lang="en-US">< (Less than)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3150145" xml-lang="en-US">Less than</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3150901" xml-lang="en-US">A1<B1</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3153078" xml-lang="en-US">>= (Greater than or equal to)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3150866" xml-lang="en-US">Greater than or equal to</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3153111" xml-lang="en-US">A1>=B1</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3153004" xml-lang="en-US"><= (Less than or equal to)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3150335" xml-lang="en-US">Less than or equal to</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3148760" xml-lang="en-US">A1<=B1</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3157994" xml-lang="en-US"><> (Inequality)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3150019" xml-lang="en-US">Inequality</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3149878" xml-lang="en-US">A1<>B1</paragraph> </tablecell> </tablerow> </table> -<paragraph role="heading" id="hd_id3145241" xml-lang="en-US" level="2">Text operators</paragraph> +<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> <table id="tbl_id3156061"> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id3150566" xml-lang="en-US">Operator</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id3153048" xml-lang="en-US">Name</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<tablecell> +<paragraph role="tablehead" id="par_id201599494708332">Example</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3148769" xml-lang="en-US">& (And)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <bookmark xml-lang="en-US" 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> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3157993" xml-lang="en-US">"Sun" & "day" is "Sunday"</paragraph> </tablecell> </tablerow> </table> -<paragraph role="heading" id="hd_id3153550" xml-lang="en-US" level="2">Reference operators</paragraph> +<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> <table id="tbl_id3154633"> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id3158416" xml-lang="en-US">Operator</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id3152822" xml-lang="en-US">Name</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<tablecell> + <paragraph role="tablehead" id="par_id521599494740206">Example</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3156257" xml-lang="en-US">: (Colon)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3153924" xml-lang="en-US">Range</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3148432" xml-lang="en-US">A1:C108</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3152592" xml-lang="en-US">! (Exclamation point)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <bookmark xml-lang="en-US" branch="index" id="bm_id3150606"><bookmark_value>intersection operator</bookmark_value> </bookmark> <paragraph role="tablecontent" id="par_id3150606" xml-lang="en-US">Intersection</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<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> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id4003723" xml-lang="en-US">~ (Tilde)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id838953" xml-lang="en-US">Concatenation or union</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<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. See note below this table.</paragraph> </tablecell> </tablerow> </table> -<paragraph role="note" id="par_id181890" xml-lang="en-US">Reference concatenation using a tilde character was implemented lately. When a formula with the tilde operator exists in a document that is opened in old versions of the software, an error is returned. A reference list is not allowed inside an array expression.</paragraph> +<note id="par_id181890">Reference concatenation using a tilde character was implemented lately. When a formula with the tilde operator exists in a document that is opened in old versions of the software, an error is returned. A reference list is not allowed inside an array expression.</note> </body> </helpdocument> |