diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-07 09:06:44 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-07 09:06:44 +0000 |
| commit | ed5640d8b587fbcfed7dd7967f3de04b37a76f26 (patch) | |
| tree | 7a5f7c6c9d02226d7471cb3cc8fbbf631b415303 /helpcontent2/source/text/swriter/02/14020000.xhp | |
| parent | Initial commit. (diff) | |
| download | libreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.tar.xz libreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.zip | |
Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'helpcontent2/source/text/swriter/02/14020000.xhp')
| -rw-r--r-- | helpcontent2/source/text/swriter/02/14020000.xhp | 661 |
1 files changed, 661 insertions, 0 deletions
diff --git a/helpcontent2/source/text/swriter/02/14020000.xhp b/helpcontent2/source/text/swriter/02/14020000.xhp new file mode 100644 index 000000000..b72bb1d76 --- /dev/null +++ b/helpcontent2/source/text/swriter/02/14020000.xhp @@ -0,0 +1,661 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * 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"> +<meta> +<topic id="textswriter0214020000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">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_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"/> + +<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="syformula"> +<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> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3150113" xml-lang="en-US">Formula</paragraph> +</tablecell> +</tablerow> +</table> +</section> +</section> +<h2 id="hd_id3150691">Summary of Formula Options</h2> +<h3 id="hd_id3155858">Basic Calculation Functions</h3> +<table id="tbl_id3155870"> + <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> +<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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3156097" xml-lang="en-US">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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3149646" xml-lang="en-US">Multiplication</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3154038" xml-lang="en-US">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</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3145096" xml-lang="en-US">Division</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3149570" xml-lang="en-US">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</paragraph> +</tablecell> +</tablerow> +</table> +<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> +<paragraph role="paragraph" id="par_id3145185" xml-lang="en-US">Sum</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3155312" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153381" xml-lang="en-US">Round</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3145598" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3148687" xml-lang="en-US">Percent</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3155930" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153016" xml-lang="en-US">Square Root</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3153038" xml-lang="en-US" 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.00</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153909" xml-lang="en-US">Power</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3147124" xml-lang="en-US" 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.00</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> +<table id="tbl_id3145218"> + <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> +<paragraph role="paragraph" id="par_id3150339" xml-lang="en-US">|</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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3147012" xml-lang="en-US">Equal</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3147034" xml-lang="en-US">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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US">Not Equal</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3150503" xml-lang="en-US">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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3147553" xml-lang="en-US">Less than or Equal</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3153599" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153729" xml-lang="en-US">Greater than or Equal</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3153751" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3150836" xml-lang="en-US">Less</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3150859" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3150720" xml-lang="en-US">Greater</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3150743" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3148408" xml-lang="en-US">Boolean Or</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3148430" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3149434" xml-lang="en-US">Boolean X Or</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3149457" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3152925" xml-lang="en-US">Boolean And</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3152948" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153938" xml-lang="en-US">Boolean Not</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3153961" xml-lang="en-US" 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> +</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> +<table id="tbl_id3154282"> + <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> +<paragraph role="paragraph" id="par_id3154053" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3145652" xml-lang="en-US">Minimum Value</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3155258" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153993" xml-lang="en-US">Maximum Value</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3154016" xml-lang="en-US" 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.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" 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> + </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" 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 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> +<table id="tbl_id3145120"> + <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> +<paragraph role="paragraph" id="par_id3149507" xml-lang="en-US" 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)</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153340" xml-lang="en-US">Cosine</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3154510" xml-lang="en-US" 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</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3150989" xml-lang="en-US">Tangent</paragraph> +</tablecell> +<tablecell> + <paragraph role="paragraph" id="par_id3151012" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3151032" xml-lang="en-US">Arc Sine</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3151055" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3150615" xml-lang="en-US">Arc Cosine</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3149728" xml-lang="en-US" 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> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153860" xml-lang="en-US">Arc Tangent</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3147057" xml-lang="en-US" 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> +</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" 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 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" 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 role="paragraph" id="par_id941599563922458">Example: SIGN -23 returns -1</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> +<table id="tbl_id3157507"> + <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" localize="false">CHAR</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3152954" xml-lang="en-US">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> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3153005" xml-lang="en-US">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> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3152738" xml-lang="en-US">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> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3148476" xml-lang="en-US">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> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US">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> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3151220" xml-lang="en-US">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> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3146926" xml-lang="en-US">Total number of pages in the document</paragraph> +</tablecell> +</tablerow> +</table> +<h3 id="hd_id3146944">More Defined Values</h3> +<table id="tbl_id3146957"> + <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> +<paragraph role="paragraph" id="par_id3147343" xml-lang="en-US" localize="false">PI</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3147366" xml-lang="en-US" localize="false">3.1415...</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3147393" xml-lang="en-US">Euler's constant</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3147462" xml-lang="en-US" localize="false">E</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3147485" xml-lang="en-US" localize="false">2.71828...</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3145332" xml-lang="en-US">True</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3145355" xml-lang="en-US" localize="false">TRUE</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3145378" xml-lang="en-US">not equal to 0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3150362" xml-lang="en-US">False</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3150385" xml-lang="en-US" localize="false">FALSE</paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3149304" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +</table> +</body> +</helpdocument> |