summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/04060105.xhp
diff options
context:
space:
mode:
authorGabor Kelemen <kelemeng@gnome.hu>2017-05-18 23:19:03 +0200
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2017-05-30 09:37:17 +0200
commit1ae135d7569571bc38fc1bcf0dfd24610039a86e (patch)
tree9ba80ca7de4275eb87766ef8f6636bd4fd68b21d /source/text/scalc/01/04060105.xhp
parent45f6f1757199dbebd364de8d2e1964e59d0c6f1f (diff)
Mass remove excess spaces from inside tags
This is fallout from the l10n and oldref attribute removal. Some tags were broken into two rows and the second was indented with spaces. The line break was removed along the tags, but those spaces were not. Command I used to catch these: find source/text/ -name "*xhp" | xargs sed -i -e 's#\" *>#\">#g' Change-Id: I6f9bad46cbfb7416950bee8230e358a3dd851def Reviewed-on: https://gerrit.libreoffice.org/37791 Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> Tested-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
Diffstat (limited to 'source/text/scalc/01/04060105.xhp')
-rw-r--r--source/text/scalc/01/04060105.xhp32
1 files changed, 16 insertions, 16 deletions
diff --git a/source/text/scalc/01/04060105.xhp b/source/text/scalc/01/04060105.xhp
index 0a9a1ae53e..6a5b3032de 100644
--- a/source/text/scalc/01/04060105.xhp
+++ b/source/text/scalc/01/04060105.xhp
@@ -42,14 +42,14 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3147505"><bookmark_value>AND function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UND" id="bm_id3145320" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147505" role="heading" level="2" >AND</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3147505" role="heading" level="2">AND</paragraph>
<paragraph xml-lang="en-US" id="par_id3153959" role="paragraph"><ahelp hid="HID_FUNC_UND">Returns TRUE if all arguments are TRUE.</ahelp> If one of the elements is FALSE, this function returns the FALSE value.</paragraph>
<paragraph xml-lang="en-US" id="par_id3146100" role="paragraph">The arguments are either logical expressions themselves (TRUE, 1&lt;5, 2+3=7, B8&lt;10) that return logical values, or arrays (A1:C3) containing logical values.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150374" role="heading" level="3" >Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3150374" role="heading" level="3">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3159123" role="code">AND(LogicalValue1; LogicalValue2 ...LogicalValue30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3150038" role="paragraph">
<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses the value from the range that is in the current column or row. The result is TRUE if the logical value in all cells within the cell range is TRUE.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3149143" role="heading" level="3" >Example</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3149143" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3153123" role="paragraph">The logical values of entries 12&lt;13; 14&gt;12, and 7&lt;6 are to be checked:</paragraph>
<paragraph xml-lang="en-US" id="par_id3145632" role="paragraph">
<item type="input">=AND(12&lt;13;14&gt;12;7&lt;6)</item> returns FALSE.</paragraph>
@@ -74,9 +74,9 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3150141"><bookmark_value>IF function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WENN" id="bm_id3152789" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3150141" role="heading" level="2" >IF</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3150141" role="heading" level="2">IF</paragraph>
<paragraph xml-lang="en-US" id="par_id3148740" role="paragraph"><ahelp hid="HID_FUNC_WENN">Specifies a logical test to be performed.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153325" role="heading" level="3" >Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3153325" role="heading" level="3">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3154558" role="code">IF(Test; ThenValue; OtherwiseValue)</paragraph>
<paragraph xml-lang="en-US" id="par_id3149727" role="paragraph">
<emph>Test</emph> is any value or expression that can be TRUE or FALSE.</paragraph>
@@ -84,10 +84,10 @@
<emph>ThenValue</emph> (optional) is the value that is returned if the logical test is TRUE.</paragraph>
<paragraph xml-lang="en-US" id="par_id3154811" role="paragraph">
<emph>OtherwiseValue</emph> (optional) is the value that is returned if the logical test is FALSE.</paragraph>
- <paragraph xml-lang="en-US" id="par_idN107FA" role="paragraph" localize="false" >
+ <paragraph xml-lang="en-US" id="par_idN107FA" role="paragraph" localize="false">
<embedvar href="text/scalc/00/00000004.xhp#optional"/>
</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3149507" role="heading" level="3" >Examples</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3149507" role="heading" level="3">Examples</paragraph>
<paragraph xml-lang="en-US" id="par_id3150867" role="paragraph">
<item type="input">=IF(A1&gt;5;100;"too small")</item> If the value in A1 is higher than 5, the value 100 is entered in the current cell; otherwise, the text “too small” (without quotes) is entered.</paragraph>
</section>
@@ -95,13 +95,13 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3155954"><bookmark_value>NOT function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NICHT" id="bm_id3145168" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3155954" role="heading" level="2" >NOT</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3155954" role="heading" level="2">NOT</paragraph>
<paragraph xml-lang="en-US" id="par_id3153570" role="paragraph"><ahelp hid="HID_FUNC_NICHT">Complements (inverts) a logical value.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3147372" role="heading" level="3" >Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3147372" role="heading" level="3">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3157996" role="code">NOT(LogicalValue)</paragraph>
<paragraph xml-lang="en-US" id="par_id3148766" role="paragraph">
<emph>LogicalValue</emph> is any value to be complemented.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3149884" role="heading" level="3" >Example</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3149884" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3150132" role="paragraph">
<item type="input">=NOT(A)</item>. If A=TRUE then NOT(A) will evaluate FALSE.</paragraph>
</section>
@@ -109,14 +109,14 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3148394"><bookmark_value>OR function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ODER" id="bm_id3155620" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3148394" role="heading" level="2" >OR</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3148394" role="heading" level="2">OR</paragraph>
<paragraph xml-lang="en-US" id="par_id3156060" role="paragraph"><ahelp hid="HID_FUNC_ODER">Returns TRUE if at least one argument is TRUE.</ahelp> This function returns the value FALSE, if all the arguments have the logical value FALSE.</paragraph>
<paragraph xml-lang="en-US" id="par_id3148771" role="paragraph">The arguments are either logical expressions themselves (TRUE, 1&lt;5, 2+3=7, B8&lt;10) that return logical values, or arrays (A1:C3) containing logical values.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3155517" role="heading" level="3" >Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3155517" role="heading" level="3">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3150468" role="code">OR(LogicalValue1; LogicalValue2 ...LogicalValue30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3155819" role="paragraph">
<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses the value from the range that is in the current column or row.<comment>UFI: first try to fix bugtraq 4905779</comment></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153228" role="heading" level="3" >Example</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3153228" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3154870" role="paragraph">The logical values of entries 12&lt;11; 13&gt;22, and 45=45 are to be checked.</paragraph>
<paragraph xml-lang="en-US" id="par_id3155371" role="paragraph">
<item type="input">=OR(12&lt;11;13&gt;22;45=45)</item> returns TRUE.</paragraph>
@@ -127,11 +127,11 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3156256"><bookmark_value>TRUE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WAHR" id="bm_id3148426" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156256" role="heading" level="2" >TRUE</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3156256" role="heading" level="2">TRUE</paragraph>
<paragraph xml-lang="en-US" id="par_id3155985" role="paragraph"><ahelp hid="HID_FUNC_WAHR">The logical value is set to TRUE.</ahelp> The TRUE() function does not require any arguments, and always returns the logical value TRUE.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153717" role="heading" level="3" >Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3153717" role="heading" level="3">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3152590" role="code">TRUE()</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3147175" role="heading" level="3" >Example</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3147175" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3146148" role="paragraph">If A=TRUE and B=FALSE the following examples appear:</paragraph>
<paragraph xml-lang="en-US" id="par_id3083285" role="paragraph">
<item type="input">=AND(A;B)</item> returns FALSE</paragraph>