source/text/swriter/02/14020000.xhp | 391 ++++++++++++++++++------------------ 1 file changed, 202 insertions(+), 189 deletions(-)
New commits: commit 4fdcb2d299636adfb9648800336882be96c30984 Author: Pierre <[email protected]> AuthorDate: Fri May 30 21:00:25 2025 +0200 Commit: Olivier Hallot <[email protected]> CommitDate: Mon Jun 9 22:42:16 2025 +0200 tdf#123381 : Int in table formula Change-Id: I4e029fae8312fbd0c6f71881221e7d4193d4eb83 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/186049 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/swriter/02/14020000.xhp b/source/text/swriter/02/14020000.xhp index 4e79cc14a2..0b3302e6da 100644 --- a/source/text/swriter/02/14020000.xhp +++ b/source/text/swriter/02/14020000.xhp @@ -19,13 +19,13 @@ <helpdocument version="1.0"> <meta> <topic id="textswriter0214020000xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Formula</title> +<title id="tit">Formula</title> <filename>/text/swriter/02/14020000.xhp</filename> </topic> </meta> <body> <section id="formula"> -<bookmark xml-lang="en-US" branch="index" id="bm_id3149687"> +<bookmark branch="index" id="bm_id3149687"> <bookmark_value>formulas; in text documents</bookmark_value> <bookmark_value>table formulas; in text documents</bookmark_value> <bookmark_value>operators; in table formulas</bookmark_value> @@ -36,13 +36,13 @@ <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"/> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/@@nowidget@@" id="bm_@@nowidget@@" localize="false"/> +<bookmark branch="hid/SW_HID_TBX_FORMULA_CALC" id="bm_id3155175" localize="false"/> <h1 id="hd_id3149687"><link href="text/swriter/02/14020000.xhp">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> +<paragraph role="paragraph" id="par_id3143270"><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"><emph>Insert Fields</emph></link> and <emph>Edit Fields</emph> dialogs.</paragraph> +<paragraph role="paragraph" id="par_id3149096">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"><emph>Insert Fields</emph></link> and <emph>Edit Fields</emph> dialogs.</paragraph> <section id="howtoget"> <paragraph role="paragraph" id="par_id301663685328962">Go to <menuitem>Table - Edit Formula</menuitem>.</paragraph> <paragraph role="paragraph" id="par_id101599562003431">In the Table toolbar, press the <emph>Insert or Edit Formula</emph> icon.</paragraph> @@ -51,11 +51,11 @@ <table id="tbl_id3153634"> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3155142" xml-lang="en-US"> -<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> +<paragraph role="paragraph" id="par_id3155142"> +<image id="img_id3155148" src="sw/res/sc20556.png" width="1cm" height="1cm"><alt id="alt_id3155148">Formula icon in Table toolbar</alt></image></paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3150113" xml-lang="en-US">Formula</paragraph> +<paragraph role="paragraph" id="par_id3150113">Formula</paragraph> </tablecell> </tablerow> </table> @@ -66,61 +66,61 @@ <table id="tbl_id3155870"> <tablerow> <tablecell> - <paragraph id="par_id221599495805480" role="tablehead" xml-lang="en-US">Operation</paragraph> + <paragraph id="par_id221599495805480" role="tablehead">Operation</paragraph> </tablecell> <tablecell> - <paragraph id="par_id641599495805481" role="tablehead" xml-lang="en-US">Name</paragraph> + <paragraph id="par_id641599495805481" role="tablehead">Name</paragraph> </tablecell> <tablecell> - <paragraph id="par_id121599495851064" role="tablehead" xml-lang="en-US">Example</paragraph> + <paragraph id="par_id121599495851064" role="tablehead">Example</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3149565" xml-lang="en-US">Addition</paragraph> +<paragraph role="paragraph" id="par_id3149565">Addition</paragraph> </tablecell> <tablecell> <paragraph role="paragraph" id="par_id3150563" localize="false">+</paragraph> </tablecell> <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> +<paragraph role="paragraph" id="par_id3149831">Calculates the total.</paragraph> +<paragraph role="paragraph" id="par_id3149845">Example: <A1> + 8</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3156097" xml-lang="en-US">Subtraction</paragraph> +<paragraph role="paragraph" id="par_id3156097">Subtraction</paragraph> </tablecell> <tablecell> <paragraph role="paragraph" id="par_id3150087" localize="false">-</paragraph> </tablecell> <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> +<paragraph role="paragraph" id="par_id3153122">Calculates the difference.</paragraph> +<paragraph role="paragraph" id="par_id3153135">Example: 10 - <B5></paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3149646" xml-lang="en-US">Multiplication</paragraph> +<paragraph role="paragraph" id="par_id3149646">Multiplication</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3154038" xml-lang="en-US">MUL or *</paragraph> +<paragraph role="paragraph" id="par_id3154038">MUL or *</paragraph> </tablecell> <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 displays 63</paragraph> +<paragraph role="paragraph" id="par_id3149965">Calculates the product.</paragraph> +<paragraph role="paragraph" id="par_id3149603">Example: 7 MUL 9 displays 63</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3145096" xml-lang="en-US">Division</paragraph> +<paragraph role="paragraph" id="par_id3145096">Division</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3149570" xml-lang="en-US">DIV or /</paragraph> +<paragraph role="paragraph" id="par_id3149570">DIV or /</paragraph> </tablecell> <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 displays 6.67</paragraph> +<paragraph role="paragraph" id="par_id3149592">Calculates the quotient.</paragraph> +<paragraph role="paragraph" id="par_id3156243">Example: 100 DIV 15 displays 6.67</paragraph> </tablecell> </tablerow> </table> @@ -128,475 +128,488 @@ <table id="tbl_id3148926"> <tablerow> <tablecell> - <paragraph id="par_id121599495989098" role="tablehead" xml-lang="en-US">Function</paragraph> + <paragraph id="par_id121599495989098" role="tablehead">Function</paragraph> </tablecell> <tablecell> - <paragraph id="par_id901599495989100" role="tablehead" xml-lang="en-US">Name</paragraph> + <paragraph id="par_id901599495989100" role="tablehead">Name</paragraph> </tablecell> <tablecell> - <paragraph id="par_id501599496006870" role="tablehead" xml-lang="en-US">Example</paragraph> + <paragraph id="par_id501599496006870" role="tablehead">Example</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3145185" xml-lang="en-US">Sum</paragraph> +<paragraph role="paragraph" id="par_id3145185">Sum</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3155312" xml-lang="en-US" localize="false">SUM</paragraph> +<paragraph role="paragraph" id="par_id3155312" localize="false">SUM</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/sum" id="bm_id3154400" localize="false"/><paragraph role="paragraph" id="par_id3155335"><ahelp hid="modules/swriter/ui/inputwinmenu/sum">Calculates the sum of the selected cells.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3154411">Example: SUM <A2:C2> displays the sum of the values in cells A2 to C2</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3153381" xml-lang="en-US">Round</paragraph> +<paragraph role="paragraph" id="par_id3153381">Round</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3145598" xml-lang="en-US" localize="false">ROUND</paragraph> +<paragraph role="paragraph" id="par_id3145598" localize="false">ROUND</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/round" id="bm_id3154851" localize="false"/><paragraph role="paragraph" id="par_id3145621"><ahelp hid="modules/swriter/ui/inputwinmenu/round">Rounds a number to the specified decimal places.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3154862">Example: 15.678 ROUND 2 displays 15.68</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3148687" xml-lang="en-US">Percent</paragraph> +<paragraph role="paragraph" id="par_id3148687">Percent</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3155930" xml-lang="en-US" localize="false">PHD</paragraph> +<paragraph role="paragraph" id="par_id3155930" localize="false">PHD</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/phd" id="bm_id3149981" localize="false"/><paragraph role="paragraph" id="par_id3155953"><ahelp hid="modules/swriter/ui/inputwinmenu/phd">Calculates a percentage.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3149991">Example: 10 + 15 PHD displays 10.15</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3153016" xml-lang="en-US">Square Root</paragraph> +<paragraph role="paragraph" id="par_id3153016">Square Root</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3153038" xml-lang="en-US" localize="false">SQRT</paragraph> +<paragraph role="paragraph" id="par_id3153038" localize="false">SQRT</paragraph> </tablecell> <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</paragraph> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/sqrt" id="bm_id3153074" localize="false"/><paragraph role="paragraph" id="par_id3153062"><ahelp hid="modules/swriter/ui/inputwinmenu/sqrt">Calculates the square root.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3153882">Example: SQRT 25 displays 5</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3153909" xml-lang="en-US">Power</paragraph> +<paragraph role="paragraph" id="par_id3153909">Power</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3147124" xml-lang="en-US" localize="false">POW</paragraph> +<paragraph role="paragraph" id="par_id3147124" localize="false">POW</paragraph> </tablecell> <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</paragraph> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/pow" id="bm_id3149779" localize="false"/><paragraph role="paragraph" id="par_id3149768"><ahelp hid="modules/swriter/ui/inputwinmenu/pow">Calculates the power of a number.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3149789">Example: 2 POW 8 displays 256</paragraph> </tablecell> </tablerow> </table> -<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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/operators" id="bm_id3150227" localize="false"/><h3 id="hd_id3150216">Operators</h3> +<paragraph role="paragraph" id="par_id3150244"><ahelp hid=".">You can insert various operators in your formula.</ahelp> Choose from the following functions:</paragraph> <table id="tbl_id3145218"> <tablerow> <tablecell> - <paragraph id="par_id61599496064739" role="tablehead" xml-lang="en-US" >Operator</paragraph> + <paragraph id="par_id61599496064739" role="tablehead">Operator</paragraph> </tablecell> <tablecell> - <paragraph id="par_id611599496064740" role="tablehead" xml-lang="en-US" >Name</paragraph> + <paragraph id="par_id611599496064740" role="tablehead">Name</paragraph> </tablecell> <tablecell> - <paragraph id="par_id461599496082741" role="tablehead" xml-lang="en-US" >Example</paragraph> + <paragraph id="par_id461599496082741" role="tablehead">Example</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3150316" xml-lang="en-US">List Separator</paragraph> +<paragraph role="paragraph" id="par_id3150316">List Separator</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3150339" xml-lang="en-US">|</paragraph> +<paragraph role="paragraph" id="par_id3150339">|</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/|" id="bm_id3153110" localize="false"/><paragraph role="paragraph" id="par_id3153099"><ahelp hid="modules/swriter/ui/inputwinmenu/|">Separates the elements in a list.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3155817">Example of using a list:</paragraph> +<paragraph role="paragraph" id="par_id3155830">MIN 10|20|50|<C6>|<A2:B6>|20</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3147012" xml-lang="en-US">Equal</paragraph> +<paragraph role="paragraph" id="par_id3147012">Equal</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3147034" xml-lang="en-US">EQ or ==</paragraph> +<paragraph role="paragraph" id="par_id3147034">EQ or ==</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/eq" id="bm_id3150947" localize="false"/><paragraph role="paragraph" id="par_id3150936"><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">Example: <A1> EQ 2 displays 1, if the content of A1 equals 2</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US">Not Equal</paragraph> +<paragraph role="paragraph" id="par_id3154370">Not Equal</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3150503" xml-lang="en-US">NEQ or !=</paragraph> +<paragraph role="paragraph" id="par_id3150503">NEQ or !=</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/neq" id="bm_id3150537" localize="false"/><paragraph role="paragraph" id="par_id3150526"><ahelp hid="modules/swriter/ui/inputwinmenu/neq">Tests for inequality between selected values.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3147524">Example: <A1> NEQ 2 displays 0 (wrong), if the content of A1 equals 2</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3147553" xml-lang="en-US">Less than or Equal</paragraph> +<paragraph role="paragraph" id="par_id3147553">Less than or Equal</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3153599" xml-lang="en-US" localize="false">LEQ</paragraph> +<paragraph role="paragraph" id="par_id3153599" localize="false">LEQ</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/leq" id="bm_id3151268" localize="false"/><paragraph role="paragraph" id="par_id3153622"><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">Example: <A1> LEQ 2 displays 1 (true), if the content of A1 is less than or equal to 2</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3153729" xml-lang="en-US">Greater than or Equal</paragraph> +<paragraph role="paragraph" id="par_id3153729">Greater than or Equal</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3153751" xml-lang="en-US" localize="false">GEQ</paragraph> +<paragraph role="paragraph" id="par_id3153751" localize="false">GEQ</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/geq" id="bm_id3148887" localize="false"/><paragraph role="paragraph" id="par_id3148876"><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">Example: <A1> GEQ 2 displays 1 (true), if the content of A1 is greater than or equal to 2</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3150836" xml-lang="en-US">Less</paragraph> +<paragraph role="paragraph" id="par_id3150836">Less</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3150859" xml-lang="en-US" localize="false">L</paragraph> +<paragraph role="paragraph" id="par_id3150859" localize="false">L</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/l" id="bm_id3155422" localize="false"/><paragraph role="paragraph" id="par_id3155411"><ahelp hid="modules/swriter/ui/inputwinmenu/l">Tests for values less than a specified value.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3155433">Example: <A1> L 2 displays 1 (true), if the content of A1 is less than 2</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3150720" xml-lang="en-US">Greater</paragraph> +<paragraph role="paragraph" id="par_id3150720">Greater</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3150743" xml-lang="en-US" localize="false">G</paragraph> +<paragraph role="paragraph" id="par_id3150743" localize="false">G</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/g" id="bm_id3147322" localize="false"/><paragraph role="paragraph" id="par_id3147310"><ahelp hid="modules/swriter/ui/inputwinmenu/g">Tests for values greater than a specified value.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3147333">Example: <A1> G 2 displays 1 (true), if the content of A1 is greater than 2</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3148408" xml-lang="en-US">Boolean Or</paragraph> +<paragraph role="paragraph" id="par_id3148408">Boolean Or</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3148430" xml-lang="en-US" localize="false">OR</paragraph> +<paragraph role="paragraph" id="par_id3148430" localize="false">OR</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/or" id="bm_id3150286" localize="false"/><paragraph role="paragraph" id="par_id3150274"><ahelp hid="modules/swriter/ui/inputwinmenu/or">Tests for values matching the Boolean OR.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3150297">Example: 0 OR 0 displays 0 (false), anything else results in 1 (true)</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3149434" xml-lang="en-US">Boolean X Or</paragraph> +<paragraph role="paragraph" id="par_id3149434">Boolean X Or</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3149457" xml-lang="en-US" localize="false">XOR</paragraph> +<paragraph role="paragraph" id="par_id3149457" localize="false">XOR</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/xor" id="bm_id3146992" localize="false"/><paragraph role="paragraph" id="par_id3146980"><ahelp hid="modules/swriter/ui/inputwinmenu/xor">Tests for values matching the Boolean exclusive OR.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3147003">Example: 1 XOR 0 displays 1 (true)</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3152925" xml-lang="en-US">Boolean And</paragraph> +<paragraph role="paragraph" id="par_id3152925">Boolean And</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3152948" xml-lang="en-US" localize="false">AND</paragraph> +<paragraph role="paragraph" id="par_id3152948" localize="false">AND</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/and" id="bm_id3153803" localize="false"/><paragraph role="paragraph" id="par_id3153792"><ahelp hid="modules/swriter/ui/inputwinmenu/and">Tests for values matching the Boolean AND.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3153814">Example: 1 AND 2 displays 1 (true)</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3153938" xml-lang="en-US">Boolean Not</paragraph> +<paragraph role="paragraph" id="par_id3153938">Boolean Not</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3153961" xml-lang="en-US" localize="false">NOT</paragraph> +<paragraph role="paragraph" id="par_id3153961" localize="false">NOT</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/not" id="bm_id3148644" localize="false"/><paragraph role="paragraph" id="par_id3148633"><ahelp hid="modules/swriter/ui/inputwinmenu/not">Tests for values matching the Boolean NOT.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3148655">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"/><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> +<bookmark 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"><ahelp hid=".">You can choose from the following statistical functions:</ahelp></paragraph> <table id="tbl_id3154282"> <tablerow> <tablecell> - <paragraph id="par_id541599496194035" role="tablehead" xml-lang="en-US">Function</paragraph> + <paragraph id="par_id541599496194035" role="tablehead">Function</paragraph> </tablecell> <tablecell> - <paragraph id="par_id481599496194036" role="tablehead" xml-lang="en-US">Name</paragraph> + <paragraph id="par_id481599496194036" role="tablehead">Name</paragraph> </tablecell> <tablecell> - <paragraph id="par_id331599524563749" role="tablehead" xml-lang="en-US">Example</paragraph> + <paragraph id="par_id331599524563749" role="tablehead">Example</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3153176" xml-lang="en-US">Mean</paragraph> +<paragraph role="paragraph" id="par_id3153176">Mean</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3154053" xml-lang="en-US" localize="false">MEAN</paragraph> +<paragraph role="paragraph" id="par_id3154053" localize="false">MEAN</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/mean" id="bm_id3154087" localize="false"/><paragraph role="paragraph" id="par_id3154076"><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">Example: MEAN 10|30|20 displays 20</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3145652" xml-lang="en-US">Minimum Value</paragraph> +<paragraph role="paragraph" id="par_id3145652">Minimum Value</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3155258" xml-lang="en-US" localize="false">MIN</paragraph> +<paragraph role="paragraph" id="par_id3155258" localize="false">MIN</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/min" id="bm_id3155292" localize="false"/><paragraph role="paragraph" id="par_id3155281"><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">Example: MIN 10|30|20 displays 10</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3153993" xml-lang="en-US">Maximum Value</paragraph> +<paragraph role="paragraph" id="par_id3153993">Maximum Value</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3154016" xml-lang="en-US" localize="false">MAX</paragraph> +<paragraph role="paragraph" id="par_id3154016" localize="false">MAX</paragraph> </tablecell> <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</paragraph> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/max" id="bm_id3154737" localize="false"/><paragraph role="paragraph" id="par_id3154726"><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">Example: MAX 10|30|20 displays 30</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id21599557699262" role="paragraph" xml-lang="en-US">Product</paragraph> + <paragraph id="par_id21599557699262" role="paragraph">Product</paragraph> </tablecell> <tablecell> - <paragraph id="par_id141599557699263" role="paragraph" xml-lang="en-US" localize="false">PRODUCT</paragraph> + <paragraph id="par_id141599557699263" role="paragraph" localize="false">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> + <paragraph id="par_id631599557734781" role="paragraph">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> + <paragraph id="par_id31599557699262" role="paragraph">Count</paragraph> </tablecell> <tablecell> - <paragraph id="par_id341599557699263" role="paragraph" xml-lang="en-US" localize="false">COUNT</paragraph> + <paragraph id="par_id341599557699263" role="paragraph" localize="false">COUNT</paragraph> </tablecell> <tablecell> - <paragraph id="par_id331599557734781" role="paragraph" xml-lang="en-US">Counts the number of non empty cells.</paragraph> + <paragraph id="par_id331599557734781" role="paragraph">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"/><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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/functions" id="bm_id3153211" localize="false"/><h3 id="hd_id3153200">Functions</h3> +<paragraph role="paragraph" id="par_id3153226"><ahelp hid=".">You can choose from the following functions:</ahelp></paragraph> <table id="tbl_id3145120"> <tablerow> <tablecell> - <paragraph id="par_id341599524600306" role="tablehead" xml-lang="en-US">Function</paragraph> + <paragraph id="par_id341599524600306" role="tablehead">Function</paragraph> </tablecell> <tablecell> - <paragraph id="par_id521599524600307" role="tablehead" xml-lang="en-US">Name</paragraph> + <paragraph id="par_id521599524600307" role="tablehead">Name</paragraph> </tablecell> <tablecell> - <paragraph id="par_id831599524616362" role="tablehead" xml-lang="en-US">Example</paragraph> + <paragraph id="par_id831599524616362" role="tablehead">Example</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3145156" xml-lang="en-US">Sine</paragraph> +<paragraph role="paragraph" id="par_id3145156">Sine</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3149507" xml-lang="en-US" localize="false">SIN</paragraph> +<paragraph role="paragraph" id="par_id3149507" localize="false">SIN</paragraph> </tablecell> <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) displays 1</paragraph> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/sin" id="bm_id3149541" localize="false"/><paragraph role="paragraph" id="par_id3149530"><ahelp hid="modules/swriter/ui/inputwinmenu/sin">Calculates the sine in radians.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3153312">Example: SIN (PI/2) displays 1</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3153340" xml-lang="en-US">Cosine</paragraph> +<paragraph role="paragraph" id="par_id3153340">Cosine</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3154510" xml-lang="en-US" localize="false">COS</paragraph> +<paragraph role="paragraph" id="par_id3154510" localize="false">COS</paragraph> </tablecell> <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 displays 0.54</paragraph> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/cos" id="bm_id3154544" localize="false"/><paragraph role="paragraph" id="par_id3154533"><ahelp hid="modules/swriter/ui/inputwinmenu/cos">Calculates the cosine in radians.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3154554">Example: COS 1 displays 0.54</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3150989" xml-lang="en-US">Tangent</paragraph> +<paragraph role="paragraph" id="par_id3150989">Tangent</paragraph> </tablecell> <tablecell> - <paragraph role="paragraph" id="par_id3151012" xml-lang="en-US" localize="false">TAN</paragraph> + <paragraph role="paragraph" id="par_id3151012" localize="false">TAN</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/tag" id="bm_id3149380" localize="false"/><paragraph role="paragraph" id="par_id3149369"><ahelp hid="modules/swriter/ui/inputwinmenu/tag">Calculates the tangent in radians.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3149391">Example: TAN <A1></paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3151032" xml-lang="en-US">Arc Sine</paragraph> +<paragraph role="paragraph" id="par_id3151032">Arc Sine</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3151055" xml-lang="en-US" localize="false">ASIN</paragraph> +<paragraph role="paragraph" id="par_id3151055" localize="false">ASIN</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/asin" id="bm_id3150577" localize="false"/><paragraph role="paragraph" id="par_id3150565"><ahelp hid="modules/swriter/ui/inputwinmenu/asin">Calculates the arc sine in radians.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3150588">Example: ASIN 1</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3150615" xml-lang="en-US">Arc Cosine</paragraph> +<paragraph role="paragraph" id="par_id3150615">Arc Cosine</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3149728" xml-lang="en-US" localize="false">ACOS</paragraph> +<paragraph role="paragraph" id="par_id3149728" localize="false">ACOS</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/acos" id="bm_id3153822" localize="false"/><paragraph role="paragraph" id="par_id3149750"><ahelp hid="modules/swriter/ui/inputwinmenu/acos">Calculates the arc cosine in radians.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3153833">Example: ACOS 1</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3153860" xml-lang="en-US">Arc Tangent</paragraph> +<paragraph role="paragraph" id="par_id3153860">Arc Tangent</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3147057" xml-lang="en-US" localize="false">ATAN</paragraph> +<paragraph role="paragraph" id="par_id3147057" localize="false">ATAN</paragraph> </tablecell> <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> +<bookmark branch="hid/modules/swriter/ui/inputwinmenu/atan" id="bm_id3147091" localize="false"/><paragraph role="paragraph" id="par_id3147080"><ahelp hid="modules/swriter/ui/inputwinmenu/atan">Calculates the arc tangent in radians.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3147102">Example: ATAN 1</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id591599557967519" role="paragraph" xml-lang="en-US">Absolute value</paragraph> + <paragraph id="par_id591599557967519" role="paragraph">Absolute value</paragraph> </tablecell> <tablecell> - <paragraph id="par_id811599557967520" role="paragraph" xml-lang="en-US" localize="false">ABS</paragraph> + <paragraph id="par_id811599557967520" role="paragraph" localize="false">ABS</paragraph> </tablecell> <tablecell> - <paragraph id="par_id211593557987787" role="paragraph" xml-lang="en-US">Returns the absolute value of the number.</paragraph> + <paragraph id="par_id211593557987787" role="paragraph">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> + <paragraph id="par_id591599557963519" role="paragraph">Sign</paragraph> </tablecell> <tablecell> - <paragraph id="par_id811596557967520" role="paragraph" xml-lang="en-US" localize="false">SIGN</paragraph> + <paragraph id="par_id811596557967520" role="paragraph" localize="false">SIGN</paragraph> </tablecell> <tablecell> - <paragraph id="par_id211599557987787" role="paragraph" xml-lang="en-US" >Returns the algebraic sign of the number.</paragraph> + <paragraph id="par_id211599557987787" role="paragraph">Returns the algebraic sign of the number.</paragraph> <paragraph role="paragraph" id="par_id941599563922458">Example: SIGN -23 returns -1</paragraph> </tablecell> </tablerow> +<tablerow> + <tablecell> + <paragraph id="par_id591599557963444" role="paragraph">Integer portion</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id8115965579675444" role="paragraph" localize="false">INT</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id211599557987444" role="paragraph">Returns the integer portion of a number.</paragraph> + <paragraph role="paragraph" id="par_id941599563922444">Example: INT 2.6 returns 2</paragraph> + </tablecell> +</tablerow> + </table> <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> +<paragraph role="paragraph" id="par_id3150161">The following document properties are also found under <emph>File - Properties - Statistics</emph>.</paragraph> <table id="tbl_id3157507"> <tablerow> <tablecell> - <paragraph id="par_id901599524662588" role="tablehead" xml-lang="en-US">Name</paragraph> + <paragraph id="par_id901599524662588" role="tablehead">Name</paragraph> </tablecell> <tablecell> - <paragraph id="par_id741599524662589" role="tablehead" xml-lang="en-US">Description</paragraph> + <paragraph id="par_id741599524662589" role="tablehead">Description</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3157538" xml-lang="en-US" localize="false">CHAR</paragraph> +<paragraph role="paragraph" id="par_id3157538" localize="false">CHAR</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3152954" xml-lang="en-US">Number of characters in the document</paragraph> +<paragraph role="paragraph" id="par_id3152954">Number of characters in the document</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3152982" xml-lang="en-US" localize="false">WORD</paragraph> +<paragraph role="paragraph" id="par_id3152982" localize="false">WORD</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3153005" xml-lang="en-US">Number of words in the document</paragraph> +<paragraph role="paragraph" id="par_id3153005">Number of words in the document</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3152715" xml-lang="en-US" localize="false">PARA</paragraph> +<paragraph role="paragraph" id="par_id3152715" localize="false">PARA</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3152738" xml-lang="en-US">Number of paragraphs in the document</paragraph> +<paragraph role="paragraph" id="par_id3152738">Number of paragraphs in the document</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3148453" xml-lang="en-US" localize="false">GRAPH</paragraph> +<paragraph role="paragraph" id="par_id3148453" localize="false">GRAPH</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3148476" xml-lang="en-US">Number of graphics in the document</paragraph> +<paragraph role="paragraph" id="par_id3148476">Number of graphics in the document</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3151091" xml-lang="en-US" localize="false">TABLES</paragraph> +<paragraph role="paragraph" id="par_id3151091" localize="false">TABLES</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US">Number of tables in the document</paragraph> +<paragraph role="paragraph" id="par_id3151114">Number of tables in the document</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3151198" xml-lang="en-US" localize="false">OLE</paragraph> +<paragraph role="paragraph" id="par_id3151198" localize="false">OLE</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3151220" xml-lang="en-US">Number of OLE objects in the document</paragraph> +<paragraph role="paragraph" id="par_id3151220">Number of OLE objects in the document</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3146903" xml-lang="en-US" localize="false">PAGE</paragraph> +<paragraph role="paragraph" id="par_id3146903" localize="false">PAGE</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3146926" xml-lang="en-US">Total number of pages in the document</paragraph> +<paragraph role="paragraph" id="par_id3146926">Total number of pages in the document</paragraph> </tablecell> </tablerow> </table> @@ -604,57 +617,57 @@ <table id="tbl_id3146957"> <tablerow> <tablecell> - <paragraph id="par_id981599524696609" role="tablehead" xml-lang="en-US">Description</paragraph> + <paragraph id="par_id981599524696609" role="tablehead">Description</paragraph> </tablecell> <tablecell> - <paragraph id="par_id101599524696610" role="tablehead" xml-lang="en-US">Name</paragraph> + <paragraph id="par_id101599524696610" role="tablehead">Name</paragraph> </tablecell> <tablecell> - <paragraph id="par_id731599524730168" role="tablehead" xml-lang="en-US">Value</paragraph> + <paragraph id="par_id731599524730168" role="tablehead">Value</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3153562" xml-lang="en-US">PI</paragraph> +<paragraph role="paragraph" id="par_id3153562">PI</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3147343" xml-lang="en-US" localize="false">PI</paragraph> +<paragraph role="paragraph" id="par_id3147343" localize="false">PI</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3147366" xml-lang="en-US" localize="false">3.1415...</paragraph> +<paragraph role="paragraph" id="par_id3147366" localize="false">3.1415...</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3147393" xml-lang="en-US">Euler's constant</paragraph> +<paragraph role="paragraph" id="par_id3147393">Euler's constant</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3147462" xml-lang="en-US" localize="false">E</paragraph> +<paragraph role="paragraph" id="par_id3147462" localize="false">E</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3147485" xml-lang="en-US" localize="false">2.71828...</paragraph> +<paragraph role="paragraph" id="par_id3147485" localize="false">2.71828...</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3145332" xml-lang="en-US">True</paragraph> +<paragraph role="paragraph" id="par_id3145332">True</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3145355" xml-lang="en-US" localize="false">TRUE</paragraph> +<paragraph role="paragraph" id="par_id3145355" localize="false">TRUE</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3145378" xml-lang="en-US">not equal to 0</paragraph> +<paragraph role="paragraph" id="par_id3145378">not equal to 0</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="paragraph" id="par_id3150362" xml-lang="en-US">False</paragraph> +<paragraph role="paragraph" id="par_id3150362">False</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3150385" xml-lang="en-US" localize="false">FALSE</paragraph> +<paragraph role="paragraph" id="par_id3150385" localize="false">FALSE</paragraph> </tablecell> <tablecell> -<paragraph role="paragraph" id="par_id3149304" xml-lang="en-US" localize="false">0</paragraph> +<paragraph role="paragraph" id="par_id3149304" localize="false">0</paragraph> </tablecell> </tablerow> </table>
