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.hal...@libreoffice.org>
AuthorDate: Tue Sep 8 08:39:41 2020 -0300
Commit: Olivier Hallot <olivier.hal...@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.hal...@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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
