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

[Andras Timar]

 source/text/scalc/01/04060105.xhp |   21 ++++++++++++++++++++-
 1 file changed, 20 insertions(+), 1 deletion(-)

New commits:
commit 0168bad31cf97541695bffec867e078d76abf352
Author: Andras Timar <andras.ti...@collabora.com>
Date:   Wed Oct 9 08:27:34 2013 +0200

    fdo#69509 add help for XOR spreadsheet function
    
    Change-Id: Iffaff83a11d77eb1d7c7025930902c0940ee9b24

diff --git a/source/text/scalc/01/04060105.xhp 
b/source/text/scalc/01/04060105.xhp
index 4417c1e..98bbffd 100644
--- a/source/text/scalc/01/04060105.xhp
+++ b/source/text/scalc/01/04060105.xhp
@@ -159,9 +159,28 @@
          <paragraph xml-lang="en-US" id="par_id3154314" role="paragraph" 
l10n="U" oldref="46">
             <item type="input">=NOT(AND(A;B))</item> returns TRUE</paragraph>
       </section>
+      <section id="Section0">
+<bookmark xml-lang="en-US" branch="index" 
id="bm_id3156257"><bookmark_value>XOR function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_XOR" id="bm_id3148427" 
localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id3156257" role="heading" 
level="2">XOR</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3155987" 
role="paragraph"><ahelp hid="HID_FUNC_XOR">Returns true if an odd number of 
arguments evaluates to TRUE.</ahelp></paragraph>
+         <paragraph xml-lang="en-US" id="par_id3148772" 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="par_id3153547" role="note">When a 
function expects a single value, but you entered a cell range, then the value 
from the cell range is taken that is in the same column or row as the 
formula.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3149028" role="note">If the 
entered range is outside of the current column or row of the formula, the 
function returns the error value #VALUE!</paragraph>
+         <paragraph xml-lang="en-US" id="hd_id3153718" role="heading" 
level="3">Syntax</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3150469" 
role="code">XOR(LogicalValue1; LogicalValue2 ...LogicalValue30)</paragraph>
+         <paragraph xml-lang="en-US" id="hd_id3147176" role="heading" 
level="3">Example</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3083286" role="paragraph">
+            <item type="input">=XOR(TRUE;TRUE)</item> returns FALSE</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3083445" role="paragraph">
+            <item type="input">=XOR(TRUE;TRUE;TRUE)</item> returns 
TRUE</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3154315" role="paragraph">
+            <item type="input">=XOR(FALSE;TRUE)</item> returns TRUE</paragraph>
+      </section>
 </sort>
 <section id="relatedtopics">
          <embed href="text/scalc/01/04060100.xhp#drking"/>
       </section>
    </body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits