[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.timar at 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<5, 2+3=7, B8<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>