source/text/scalc/01/04060105.xhp | 26 ++++++++++++++++++++++---- 1 file changed, 22 insertions(+), 4 deletions(-)
New commits: commit 781da1e8175459f27cca84bed2ca209b3e030067 Author: Olivier Hallot <olivier.hal...@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.hal...@libreoffice.org> Tested-by: Olivier Hallot <olivier.hal...@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> _______________________________________________ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits