[Libreoffice-commits] help.git: source/text

[Olivier Hallot]

 source/text/scalc/01/04060105.xhp |   26 ++++++++++++++++++++++----
 1 file changed, 22 insertions(+), 4 deletions(-)

New commits:
commit 781da1e8175459f27cca84bed2ca209b3e030067
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
Date:   Mon Mar 12 18:37:52 2018 -0300

    tdf#99611 improve function AND() documentation
    
    Added details on handling non logical arguments in
    Calc logical functions.
    
    Change-Id: I416fbe9443777a7a7bdfa9d3f61bdf072aff476b
    Reviewed-on: https://gerrit.libreoffice.org/51176
    Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>
    Tested-by: Olivier Hallot <olivier.hallot at libreoffice.org>

diff --git a/source/text/scalc/01/04060105.xhp b/source/text/scalc/01/04060105.xhp
index 6a5b3032d..983053c99 100644
--- a/source/text/scalc/01/04060105.xhp
+++ b/source/text/scalc/01/04060105.xhp
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
+
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,8 +18,8 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
- 
-	
+
+
 <meta>
       <topic id="textscalc0104060105xml" indexer="include">
          <title xml-lang="en-US" id="tit">Logical Functions</title>
@@ -32,8 +32,26 @@
       <bookmark_value>functions; logical functions</bookmark_value>
 </bookmark>
 <paragraph xml-lang="en-US" id="hd_id3153484" role="heading" level="1">Logical Functions</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3149312" role="paragraph"><variable id="logischtext">This category contains the <emph>Logical</emph> functions. 
+      <paragraph xml-lang="en-US" id="par_id3149312" role="paragraph"><variable id="logischtext">This category contains the <emph>Logical</emph> functions.
 </variable></paragraph>
+<paragraph role="heading" id="hd_id631520887352751" level="3" xml-lang="en-US">Handling non-logical arguments in logical functions</paragraph>
+<list type="unordered">
+    <listitem>
+        <paragraph id="par_id431520887384579"  role="listitem" xml-lang="en-US">Zero (0) is equivalent to FALSE and all other numbers are equivalent to TRUE.</paragraph>
+    </listitem>
+    <listitem>
+        <paragraph id="par_id881520887475288"  role="listitem" xml-lang="en-US">Empty cells and text in cells are ignored.</paragraph>
+    </listitem>
+    <listitem>
+        <paragraph id="par_id461520887504085"  role="listitem" xml-lang="en-US">A #VALUE error is raised if all arguments are ignored.</paragraph>
+    </listitem>
+    <listitem>
+        <paragraph id="par_id591520888006686"  role="listitem" xml-lang="en-US">A #VALUE error is raised if one argument is direct text (not text in a cell).</paragraph>
+    </listitem>
+    <listitem>
+        <paragraph id="par_id321520889630477"  role="listitem" xml-lang="en-US">Errors as argument lead to an error.</paragraph>
+    </listitem>
+</list>
       <section id="howtoget">
          <embed href="text/scalc/00/00000404.xhp#eikalo"/>
       </section>