04060105.xhp (bd727bc8) 04060105.xhp (65523e0f)
1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
4<!--***********************************************************
5 *
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements. See the NOTICE file
8 * distributed with this work for additional information

--- 165 unchanged lines hidden (view full) ---

174 <paragraph xml-lang="en-US" id="par_id3149027K" role="note" l10n="CHG">If the entered range is outside of the current column or row of the formula, the function returns the error value #VALUE!</paragraph>
175 <paragraph xml-lang="en-US" id="hd_id3155517K" role="heading" level="3" l10n="U"
176 oldref="22">Syntax</paragraph>
177 <paragraph xml-lang="en-US" id="par_id3150468K" role="code" l10n="U">XOR(Value1; Value2 ...Value30)</paragraph>
178 <paragraph xml-lang="en-US" id="par_id3155819K" role="paragraph" l10n="CHG" oldref="24">
179
180<emph>Value1; Value2 ...Value30</emph> are added modulo 2. TRUE is returned if the result of this addition is 1;
181FALSE is returned if the result of this addition is 0.<comment>UFI: first try to fix bugtraq 4905779</comment></paragraph>
1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
4<!--***********************************************************
5 *
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements. See the NOTICE file
8 * distributed with this work for additional information

--- 165 unchanged lines hidden (view full) ---

174 <paragraph xml-lang="en-US" id="par_id3149027K" role="note" l10n="CHG">If the entered range is outside of the current column or row of the formula, the function returns the error value #VALUE!</paragraph>
175 <paragraph xml-lang="en-US" id="hd_id3155517K" role="heading" level="3" l10n="U"
176 oldref="22">Syntax</paragraph>
177 <paragraph xml-lang="en-US" id="par_id3150468K" role="code" l10n="U">XOR(Value1; Value2 ...Value30)</paragraph>
178 <paragraph xml-lang="en-US" id="par_id3155819K" role="paragraph" l10n="CHG" oldref="24">
179
180<emph>Value1; Value2 ...Value30</emph> are added modulo 2. TRUE is returned if the result of this addition is 1;
181FALSE is returned if the result of this addition is 0.<comment>UFI: first try to fix bugtraq 4905779</comment></paragraph>
182 <paragraph xml-lang="en-US" id="hd_id3153228K" role="heading" level="3" l10n="U">Examples:</paragraph>
183
184 <paragraph xml-lang="en-US" id="par_id3155371K" role="paragraph" l10n="U">
185 <item type="input">=XOR(12&lt;11;13&gt;22;10)</item> returns TRUE since this converts to (1+0+10) mod 2 = 0 </paragraph>
186 <paragraph xml-lang="en-US" id="par_id3158412K" role="paragraph" l10n="U">
187 <item type="input">=XOR(FALSE;TRUE)</item> returns TRUE.</paragraph>
182<paragraph xml-lang="en-US" id="hd_id3153228K" role="heading" level="3" l10n="U">Examples:</paragraph>
183<paragraph xml-lang="en-US" id="par_id3155371K" role="paragraph" l10n="U">
184<item type="input">=XOR(12&lt;11;13&gt;22;10)</item> returns TRUE since this converts to (1+0+10) mod 2 = 0</paragraph>
185<paragraph xml-lang="en-US" id="par_id3158412K" role="paragraph" l10n="U">
186<item type="input">=XOR(FALSE;TRUE)</item> returns TRUE.</paragraph>
188</section>
189</sort>
190<section id="relatedtopics">
191 <embed href="text/scalc/01/04060100.xhp#drking"/>
192 </section>
193 </body>
194</helpdocument>
187</section>
188</sort>
189<section id="relatedtopics">
190 <embed href="text/scalc/01/04060100.xhp#drking"/>
191 </section>
192 </body>
193</helpdocument>