[Libreoffice-commits] help.git: source/text
Olivier Hallot (via logerrit)
logerrit at kemper.freedesktop.org
Tue Sep 8 13:19:39 UTC 2020
source/text/scalc/01/04060199.xhp | 153 ++++++-------
source/text/swriter/02/14020000.xhp | 412 +++++++++++++++++++++++-------------
2 files changed, 342 insertions(+), 223 deletions(-)
New commits:
commit e1165b2f11d933a273f13631e400f9ad5980d134
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
AuthorDate: Tue Sep 8 08:39:41 2020 -0300
Commit: Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Tue Sep 8 15:19:17 2020 +0200
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 at libreoffice.org>
diff --git a/source/text/scalc/01/04060199.xhp b/source/text/scalc/01/04060199.xhp
index 2928f11e9..5ad22dbed 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>
diff --git a/source/text/swriter/02/14020000.xhp b/source/text/swriter/02/14020000.xhp
index 4526bdf4e..0a6578132 100644
--- a/source/text/swriter/02/14020000.xhp
+++ b/source/text/swriter/02/14020000.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="textswriter0214020000xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Formula</title>
@@ -30,505 +25,634 @@
</meta>
<body>
<section id="formel">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3149687"><bookmark_value>operators; in formulas</bookmark_value>
-<bookmark_value>statistical functions</bookmark_value>
-<bookmark_value>trigonometric functions</bookmark_value>
-<bookmark_value>pages;number of</bookmark_value>
-<bookmark_value>variables;document properties</bookmark_value>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149687">
+<bookmark_value>formulas; in text documents</bookmark_value>
+<bookmark_value>operators; in table formulas</bookmark_value>
+<bookmark_value>statistical functions in tables</bookmark_value>
+<bookmark_value>mathematical functions in tables</bookmark_value>
+<bookmark_value>trigonometric functions in tables</bookmark_value>
+<bookmark_value>pages;number of pages in table formulas</bookmark_value>
+<bookmark_value>variables;document properties in table formulas</bookmark_value>
<bookmark_value>arithmetical operators in formulas</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/@@nowidget@@" id="bm_@@nowidget@@" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SW_HID_TBX_FORMULA_CALC" id="bm_id3155175" localize="false"/>
-<paragraph role="heading" id="hd_id3149687" xml-lang="en-US" level="1"><link href="text/swriter/02/14020000.xhp" name="Formula">Formula</link></paragraph>
+<h1 id="hd_id3149687"><link href="text/swriter/02/14020000.xhp" name="Formula">Formula</link></h1>
<paragraph role="paragraph" id="par_id3143270" xml-lang="en-US"><ahelp hid=".">Opens a submenu, from which you can insert a formula into the cell of a table.</ahelp> Place the cursor in a cell in the table or at the position in the document where you want the result to appear. Click the<emph> Formula </emph>icon and choose the desired formula from the submenu.</paragraph>
</section>
<paragraph role="paragraph" id="par_id3149096" xml-lang="en-US">The formula appears in the input line. To specify a range of cells in a table, select the desired cells with the mouse. The corresponding cell references also appear in the input line. Enter additional parameters, as necessary, and click <emph>Apply</emph> to confirm your entry. You can also enter the formula directly if you know the appropriate syntax. This is necessary, for example, in the <link href="text/swriter/01/04090000.xhp" name="Insert Fields"><emph>Insert Fields</emph></link> and <emph>Edit Fields</emph> dialogs.</paragraph>
+<section id="howtoget">
+ <paragraph role="paragraph" id="par_id621599564033048">With the cursor in a table, press <keycode>F2</keycode></paragraph>
+<paragraph role="paragraph" id="par_id101599562003431">In the Table toolbar, press the <emph>Formula</emph> icon.</paragraph>
<section id="syformel">
<table id="tbl_id3153634">
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3155142" xml-lang="en-US">
-<image id="img_id3155148" src="sw/res/sc20556.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155148" xml-lang="en-US">Icon</alt>
- </image></paragraph>
+<image id="img_id3155148" src="sw/res/sc20556.png" width="1cm" height="1cm"><alt id="alt_id3155148" xml-lang="en-US">Formula icon in Table toolbar</alt></image></paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150113" xml-lang="en-US">Formula</paragraph>
</tablecell>
</tablerow>
</table>
</section>
-<paragraph role="heading" id="hd_id3150691" xml-lang="en-US" level="2">Summary of Formula Options</paragraph>
-<paragraph role="heading" id="hd_id3155858" xml-lang="en-US" level="3">Basic Calculation Functions</paragraph>
+</section>
+<h2 id="hd_id3150691">Summary of Formula Options</h2>
+<h3 id="hd_id3155858">Basic Calculation Functions</h3>
<table id="tbl_id3155870">
-<tablerow>
-<tablecell colspan="" rowspan="">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id221599495805480" role="tablehead" xml-lang="en-US" >Operation</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id641599495805481" role="tablehead" xml-lang="en-US" >Name</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id121599495851064" role="tablehead" xml-lang="en-US" >Example</paragraph>
+ </tablecell>
+ </tablerow>
+<tablerow>
+<tablecell>
<paragraph role="paragraph" id="par_id3149565" xml-lang="en-US">Addition</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150563" localize="false">+</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3149831" xml-lang="en-US">Calculates the total.</paragraph>
<paragraph role="paragraph" id="par_id3149845" xml-lang="en-US">Example: <A1> + 8</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3156097" xml-lang="en-US">Subtraction</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150087" localize="false">-</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153122" xml-lang="en-US">Calculates the difference</paragraph>
<paragraph role="paragraph" id="par_id3153135" xml-lang="en-US">Example: 10 - <B5></paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3149646" xml-lang="en-US">Multiplication</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3154038" xml-lang="en-US">MUL or *</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3149965" xml-lang="en-US">Calculates the product.</paragraph>
<paragraph role="paragraph" id="par_id3149603" xml-lang="en-US">Example: 7 MUL 9</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3145096" xml-lang="en-US">Division</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3149570" xml-lang="en-US">DIV or /</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3149592" xml-lang="en-US">Calculates the quotient</paragraph>
<paragraph role="paragraph" id="par_id3156243" xml-lang="en-US">Example: 100 DIV 15</paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph role="heading" id="hd_id3156260" xml-lang="en-US" level="3">Basic Functions in the Submenu</paragraph>
+<h3 id="hd_id3156260">Basic Functions in the Submenu</h3>
<table id="tbl_id3148926">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id121599495989098" role="tablehead" xml-lang="en-US" >Function</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id901599495989100" role="tablehead" xml-lang="en-US" >Name</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id501599496006870" role="tablehead" xml-lang="en-US" >Example</paragraph>
+ </tablecell>
+ </tablerow>
+
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3145185" xml-lang="en-US">Sum</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3155312" xml-lang="en-US">SUM</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/sum" id="bm_id3154400" localize="false"/><paragraph role="paragraph" id="par_id3155335" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/sum">Calculates the sum of the selected cells.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3154411" xml-lang="en-US">Example: SUM <A2:C2> displays the sum of the values in cells A2 to C2</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153381" xml-lang="en-US">Round</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3145598" xml-lang="en-US">ROUND</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/round" id="bm_id3154851" localize="false"/><paragraph role="paragraph" id="par_id3145621" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/round">Rounds a number to the specified decimal places.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3154862" xml-lang="en-US">Example: 15.678 ROUND 2 displays 15.68</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3148687" xml-lang="en-US">Percent</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3155930" xml-lang="en-US">PHD</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/phd" id="bm_id3149981" localize="false"/><paragraph role="paragraph" id="par_id3155953" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/phd">Calculates a percentage</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3149991" xml-lang="en-US">Example: 10 + 15 PHD displays 10.15</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153016" xml-lang="en-US">Square Root</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153038" xml-lang="en-US">SQRT</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/sqrt" id="bm_id3153074" localize="false"/><paragraph role="paragraph" id="par_id3153062" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/sqrt">Calculates the square root.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3153882" xml-lang="en-US">Example: SQRT 25 displays 5.00</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153909" xml-lang="en-US">Power</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3147124" xml-lang="en-US">POW</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/pow" id="bm_id3149779" localize="false"/><paragraph role="paragraph" id="par_id3149768" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/pow">Calculates the power of a number.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3149789" xml-lang="en-US">Example: 2 POW 8 displays 256.00</paragraph>
</tablecell>
</tablerow>
</table>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/operators" id="bm_id3150227" localize="false"/><paragraph role="heading" id="hd_id3150216" xml-lang="en-US" level="3">Operators</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/operators" id="bm_id3150227" localize="false"/><h3 id="hd_id3150216">Operators</h3>
<paragraph role="paragraph" id="par_id3150244" xml-lang="en-US"><ahelp hid=".">You can insert various operators in your formula.</ahelp> Choose from the following functions:</paragraph>
<table id="tbl_id3145218">
-<tablerow>
-<tablecell colspan="" rowspan="">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id61599496064739" role="tablehead" xml-lang="en-US" >Operator</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id611599496064740" role="tablehead" xml-lang="en-US" >Name</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id461599496082741" role="tablehead" xml-lang="en-US" >Example</paragraph>
+ </tablecell>
+ </tablerow>
+<tablerow>
+<tablecell>
<paragraph role="paragraph" id="par_id3150316" xml-lang="en-US">List Separator</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150339" xml-lang="en-US">|</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/|" id="bm_id3153110" localize="false"/><paragraph role="paragraph" id="par_id3153099" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/|">Separates the elements in a list.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3155817" xml-lang="en-US">Example of using a list:</paragraph>
<paragraph role="paragraph" id="par_id3155830" xml-lang="en-US">MIN 10|20|50|<C6>|<A2:B6>|20</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3147012" xml-lang="en-US">Equal</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3147034" xml-lang="en-US">EQ or ==</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/eq" id="bm_id3150947" localize="false"/><paragraph role="paragraph" id="par_id3150936" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/eq">Checks if selected values are equal.</ahelp> If they are unequal, the result is zero, otherwise 1 (true) appears.</paragraph>
<paragraph role="paragraph" id="par_id3150961" xml-lang="en-US">Example: <A1> EQ 2 displays 1, if the content of A1 equals 2.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US">Not Equal</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150503" xml-lang="en-US">NEQ or !=</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/neq" id="bm_id3150537" localize="false"/><paragraph role="paragraph" id="par_id3150526" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/neq">Tests for inequality between selected values.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3147524" xml-lang="en-US">Example: <A1> NEQ 2 displays 0 (wrong), if the content of A1 equals 2.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3147553" xml-lang="en-US">Less than or Equal</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153599" xml-lang="en-US">LEQ</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/leq" id="bm_id3151268" localize="false"/><paragraph role="paragraph" id="par_id3153622" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/leq">Tests for values less than or equal to a specified value.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3151280" xml-lang="en-US">Example: <A1> LEQ 2 displays 1 (true), if the content of A1 is less than or equal to 2.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153729" xml-lang="en-US">Greater than or Equal</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153751" xml-lang="en-US">GEQ</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/geq" id="bm_id3148887" localize="false"/><paragraph role="paragraph" id="par_id3148876" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/geq">Tests for values greater than or equal to a specified value</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3148898" xml-lang="en-US">Example: <A1> GEQ 2 displays 1 (true), if the content of A1 is greater than or equal to 2.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150836" xml-lang="en-US">Less</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150859" xml-lang="en-US">L</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/l" id="bm_id3155422" localize="false"/><paragraph role="paragraph" id="par_id3155411" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/l">Tests for values less than a specified value</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3155433" xml-lang="en-US">Example: <A1> L 2 displays 1 (true), if the content of A1 is less than 2.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150720" xml-lang="en-US">Greater</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150743" xml-lang="en-US">G</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/g" id="bm_id3147322" localize="false"/><paragraph role="paragraph" id="par_id3147310" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/g">Tests for values greater than a specified value</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3147333" xml-lang="en-US">Example: <A1> G 2 displays 1 (true), if the content of A1 is greater than 2.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3148408" xml-lang="en-US">Boolean Or</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3148430" xml-lang="en-US">OR</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/or" id="bm_id3150286" localize="false"/><paragraph role="paragraph" id="par_id3150274" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/or">Tests for values matching the Boolean OR</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3150297" xml-lang="en-US">Example: 0 OR 0 displays 0 (false), anything else results in 1 (true)</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3149434" xml-lang="en-US">Boolean X Or</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3149457" xml-lang="en-US">XOR</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/xor" id="bm_id3146992" localize="false"/><paragraph role="paragraph" id="par_id3146980" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/xor">Tests for values matching the Boolean exclusive OR</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3147003" xml-lang="en-US">Example: 1 XOR 0 displays 1 (true)</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3152925" xml-lang="en-US">Boolean And</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3152948" xml-lang="en-US">AND</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/and" id="bm_id3153803" localize="false"/><paragraph role="paragraph" id="par_id3153792" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/and">Tests for values matching the Boolean AND</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3153814" xml-lang="en-US">Example: 1 AND 2 displays 1 (true)</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153938" xml-lang="en-US">Boolean Not</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153961" xml-lang="en-US">NOT</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/not" id="bm_id3148644" localize="false"/><paragraph role="paragraph" id="par_id3148633" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/not">Tests for values matching the Boolean NOT</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3148655" xml-lang="en-US">Example: NOT 1 (true) displays 0 (false)</paragraph>
</tablecell>
</tablerow>
</table>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/statistics" id="bm_id3154251" localize="false"/><paragraph role="heading" id="hd_id3154240" xml-lang="en-US" level="3">Statistical Functions</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/statistics" id="bm_id3154251" localize="false"/><h3 id="hd_id3154240">Statistical Functions</h3>
<paragraph role="paragraph" id="par_id3154263" xml-lang="en-US"><ahelp hid=".">You can choose from the following statistical functions:</ahelp></paragraph>
<table id="tbl_id3154282">
-<tablerow>
-<tablecell colspan="" rowspan="">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id541599496194035" role="tablehead" xml-lang="en-US" >Function</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id481599496194036" role="tablehead" xml-lang="en-US" >Name</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id331599524563749" role="tablehead" xml-lang="en-US" >Example</paragraph>
+ </tablecell>
+ </tablerow>
+<tablerow>
+<tablecell>
<paragraph role="paragraph" id="par_id3153176" xml-lang="en-US">Mean</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3154053" xml-lang="en-US">MEAN</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/mean" id="bm_id3154087" localize="false"/><paragraph role="paragraph" id="par_id3154076" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/mean">Calculates the arithmetic mean of the values in an area or a list.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3145625" xml-lang="en-US">Example: MEAN 10|30|20 displays 20</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3145652" xml-lang="en-US">Minimum Value</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3155258" xml-lang="en-US">MIN</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/min" id="bm_id3155292" localize="false"/><paragraph role="paragraph" id="par_id3155281" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/min">Calculates the minimum value in an area or a list.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3155304" xml-lang="en-US">Example: MIN 10|30|20 displays 10</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153993" xml-lang="en-US">Maximum Value</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3154016" xml-lang="en-US">MAX</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/max" id="bm_id3154737" localize="false"/><paragraph role="paragraph" id="par_id3154726" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/max">Calculates the maximum value in an area or a list.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3154748" xml-lang="en-US">Example: MAX 10|30|20 displays 30.00</paragraph>
</tablecell>
</tablerow>
+<tablerow>
+ <tablecell>
+ <paragraph id="par_id21599557699262" role="paragraph" xml-lang="en-US" >Product</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id141599557699263" role="paragraph" xml-lang="en-US" >PRODUCT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id671599563830630">Calculates the product of the selected cells.</paragraph>
+ <paragraph id="par_id631599557734781" role="paragraph" xml-lang="en-US" >Example: PRODUCT <A2:C2> displays the product of the values in cells A2 to C2</paragraph>
+ </tablecell>
+</tablerow>
+<tablerow>
+ <tablecell>
+ <paragraph id="par_id31599557699262" role="paragraph" xml-lang="en-US" >Count</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id341599557699263" role="paragraph" xml-lang="en-US" >COUNT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id331599557734781" role="paragraph" xml-lang="en-US" >Counts the number of non empty cells.</paragraph>
+ <paragraph role="paragraph" id="par_id141599563739504">Example: COUNT <A2:C2> displays the number of non empty cells in A2 to C2.</paragraph>
+ </tablecell>
+</tablerow>
</table>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/functions" id="bm_id3153211" localize="false"/><paragraph role="heading" id="hd_id3153200" xml-lang="en-US" level="3">Trigonometric Functions </paragraph>
-<paragraph role="paragraph" id="par_id3153226" xml-lang="en-US"><ahelp hid=".">You can choose from the following trigonometric functions:</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/functions" id="bm_id3153211" localize="false"/><h3 id="hd_id3153200">Functions</h3>
+<paragraph role="paragraph" id="par_id3153226" xml-lang="en-US"><ahelp hid=".">You can choose from the following functions:</ahelp></paragraph>
<table id="tbl_id3145120">
-<tablerow>
-<tablecell colspan="" rowspan="">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id341599524600306" role="tablehead" xml-lang="en-US" >Function</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id521599524600307" role="tablehead" xml-lang="en-US" >Name</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id831599524616362" role="tablehead" xml-lang="en-US" >Example</paragraph>
+ </tablecell>
+ </tablerow>
+<tablerow>
+<tablecell>
<paragraph role="paragraph" id="par_id3145156" xml-lang="en-US">Sine</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3149507" xml-lang="en-US">SIN</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/sin" id="bm_id3149541" localize="false"/><paragraph role="paragraph" id="par_id3149530" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/sin">Calculates the sine in radians</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3153312" xml-lang="en-US">Example: SIN (PI/2)</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153340" xml-lang="en-US">Cosine</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3154510" xml-lang="en-US">COS</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/cos" id="bm_id3154544" localize="false"/><paragraph role="paragraph" id="par_id3154533" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/cos">Calculates the cosine in radians.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3154554" xml-lang="en-US">Example: COS 1</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150989" xml-lang="en-US">Tangent</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3151012" xml-lang="en-US">TAN</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/tag" id="bm_id3149380" localize="false"/><paragraph role="paragraph" id="par_id3149369" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/tag">Calculates the tangent in radians.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3149391" xml-lang="en-US">Example: TAN <A1></paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3151032" xml-lang="en-US">Arc Sine</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3151055" xml-lang="en-US">ASIN</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/asin" id="bm_id3150577" localize="false"/><paragraph role="paragraph" id="par_id3150565" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/asin">Calculates the arc sine in radians.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3150588" xml-lang="en-US">Example: ASIN 1</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150615" xml-lang="en-US">Arc Cosine</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3149728" xml-lang="en-US">ACOS</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/acos" id="bm_id3153822" localize="false"/><paragraph role="paragraph" id="par_id3149750" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/acos">Calculates the arc cosine in radians.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3153833" xml-lang="en-US">Example: ACOS 1</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153860" xml-lang="en-US">Arc Tangent</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3147057" xml-lang="en-US">ATAN</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inputwinmenu/atan" id="bm_id3147091" localize="false"/><paragraph role="paragraph" id="par_id3147080" xml-lang="en-US"><ahelp hid="modules/swriter/ui/inputwinmenu/atan">Calculates the arc tangent in radians.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3147102" xml-lang="en-US">Example: ATAN 1</paragraph>
</tablecell>
</tablerow>
+<tablerow>
+ <tablecell>
+ <paragraph id="par_id591599557967519" role="paragraph" xml-lang="en-US" >Absolute value</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id811599557967520" role="paragraph" xml-lang="en-US" >ABS</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id211593557987787" role="paragraph" xml-lang="en-US" >Returns the absolute value of the number.</paragraph>
+ <paragraph role="paragraph" id="par_id301599563956612">Example: ABS -34 returns 34</paragraph>
+ </tablecell>
+</tablerow>
+<tablerow>
+ <tablecell>
+ <paragraph id="par_id591599557963519" role="paragraph" xml-lang="en-US" >Sign</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id811596557967520" role="paragraph" xml-lang="en-US" >SIGN</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id211599557987787" role="paragraph" xml-lang="en-US" >Returns the algebraic sign of the number.</paragraph>
+ <paragraph role="paragraph" id="par_id941599563922458">Example: SIGN -23 returns -1</paragraph>
+ </tablecell>
+</tablerow>
</table>
-<paragraph role="heading" id="hd_id3150888" xml-lang="en-US" level="3">Variables for document properties</paragraph>
+<h3 id="hd_id3150888">Variables for document properties</h3>
<paragraph role="paragraph" id="par_id3150161" xml-lang="en-US">The following document properties are also found under <emph>File - Properties - Statistics</emph>.</paragraph>
<table id="tbl_id3157507">
-<tablerow>
-<tablecell colspan="" rowspan="">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id901599524662588" role="tablehead" xml-lang="en-US" >Name</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id741599524662589" role="tablehead" xml-lang="en-US" >Description</paragraph>
+ </tablecell>
+ </tablerow>
+<tablerow>
+<tablecell>
<paragraph role="paragraph" id="par_id3157538" xml-lang="en-US">CHAR</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3152954" xml-lang="en-US">Number of characters in the document</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3152982" xml-lang="en-US">WORD</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3153005" xml-lang="en-US">Number of words in the document</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3152715" xml-lang="en-US">PARA</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3152738" xml-lang="en-US">Number of paragraphs in the document</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3148453" xml-lang="en-US">GRAPH</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3148476" xml-lang="en-US">Number of graphics in the document</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3151091" xml-lang="en-US">TABLES</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US">Number of tables in the document</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3151198" xml-lang="en-US">OLE</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3151220" xml-lang="en-US">Number of OLE objects in the document</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3146903" xml-lang="en-US">PAGE</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3146926" xml-lang="en-US">Total number of pages in the document</paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph role="heading" id="hd_id3146944" xml-lang="en-US" level="3">More Defined Values</paragraph>
+<h3 id="hd_id3146944">More Defined Values</h3>
<table id="tbl_id3146957">
-<tablerow>
-<tablecell colspan="" rowspan="">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id981599524696609" role="tablehead" xml-lang="en-US" >Description</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id101599524696610" role="tablehead" xml-lang="en-US" >Name</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id731599524730168" role="tablehead" xml-lang="en-US" >Value</paragraph>
+ </tablecell>
+ </tablerow>
+<tablerow>
+<tablecell>
<paragraph role="paragraph" id="par_id3153562" xml-lang="en-US">PI</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3147343" xml-lang="en-US">PI</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3147366" xml-lang="en-US">3.1415...</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3147393" xml-lang="en-US">Euler's constant</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3147462" xml-lang="en-US">E</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3147485" xml-lang="en-US">2.71828...</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3145332" xml-lang="en-US">True</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3145355" xml-lang="en-US">TRUE</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3145378" xml-lang="en-US">not equal to 0</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150362" xml-lang="en-US">False</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3150385" xml-lang="en-US">FALSE</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="paragraph" id="par_id3149304" xml-lang="en-US">0</paragraph>
</tablecell>
</tablerow>
More information about the Libreoffice-commits
mailing list