ONLYOFFICE XOR: Odd Parity, Two Choices and Exactly-One Checks
Use ONLYOFFICE XOR with a complete three-input truth table, distinguish odd parity from exactly one and build a reproducible two-choice rule.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
XOR returns TRUE when an odd number of its logical inputs are true. With two inputs, that means exactly one is true. With three inputs, all three true also returns TRUE, so XOR is not a general “choose exactly one” test.
Availability and version history
- Introduced: The first introduction release and date are not established by the checked sources.
- Availability: Currently documented in ONLYOFFICE’s rolling Spreadsheet Editor help; no final supported-version endpoint is established.
- Scope: Docs and Desktop Editors release separately. The shared help does not establish every older build or mobile client’s behavior.
- Checked: October 14, 2026, against the official XOR reference. Examples were independently evaluated as logical models; these cases were not tested in the native application.
Syntax and the parity rule
=XOR(logical1, [logical2], ...)
The official XOR reference requires the first logical condition, permits later ones, and documents up to 255 logical values. An odd count of true inputs returns TRUE; an even count, including zero, returns FALSE.
Use Boolean values or explicit conditions such as B2="Yes". Optional brackets are notation and are not typed into the formula. The examples use English names and comma separators. The short page does not enumerate every text, numeric or blank-cell conversion.
Two choices: exactly one delivery option
Create DeliveryChoice. Put Order, Delivery and Collection in A1:C1. Enter the following text labels without quote characters:
| Row | Order | Delivery | Collection |
|---|---|---|---|
| 2 | R301 | Yes | No |
| 3 | R302 | No | Yes |
| 4 | R303 | Yes | Yes |
| 5 | R304 | No | No |
Put One choice in D1. Enter =XOR(B2="Yes",C2="Yes") in D2 and fill through D5. Expected results are TRUE,TRUE,FALSE,FALSE.
In E2 enter =IF(D2,"One option","Check choices") and fill through E5. Expect One option,One option,Check choices,Check choices. R303 selected both options and R304 selected neither; the rule rejects both situations.
For comparison, put =OR(B2="Yes",C2="Yes") in F2 and fill to F5. Expected results are TRUE,TRUE,TRUE,FALSE. OR accepts both choices, while the two-input XOR does not.
Three inputs: all eight combinations
Create ThreeFlags with Flag A, Flag B, Flag C, XOR, True count and Exactly one in A1:F1. Enter logical values using =TRUE() or =FALSE() so A2:C9 contains all the combinations shown below.
| Row | A | B | C | Expected D | Expected E | Expected F |
|---|---|---|---|---|---|---|
| 2 | FALSE | FALSE | FALSE | FALSE | 0 | FALSE |
| 3 | FALSE | FALSE | TRUE | TRUE | 1 | TRUE |
| 4 | FALSE | TRUE | FALSE | TRUE | 1 | TRUE |
| 5 | FALSE | TRUE | TRUE | FALSE | 2 | FALSE |
| 6 | TRUE | FALSE | FALSE | TRUE | 1 | TRUE |
| 7 | TRUE | FALSE | TRUE | FALSE | 2 | FALSE |
| 8 | TRUE | TRUE | FALSE | FALSE | 2 | FALSE |
| 9 | TRUE | TRUE | TRUE | TRUE | 3 | FALSE |
Enter these formulas in row 2, then fill D2:F2 through row 9:
- D2:
=XOR(A2,B2,C2) - E2:
=IF(A2,1,0)+IF(B2,1,0)+IF(C2,1,0) - F2:
=E2=1
The explicit IF expressions convert each logical flag to a counting indicator without assuming arithmetic coercion of a Boolean cell. E makes the number of true inputs visible. Row 9 is the important counterexample: XOR is TRUE with three true inputs, but Exactly one is FALSE.
Adding another true input reverses the result
Keep the original table intact. Put With false in H1 and With true in I1. Enter =XOR(A2,B2,C2,FALSE()) in H2 and =XOR(A2,B2,C2,TRUE()) in I2. Fill through row 9.
H matches D in every row because adding a false input leaves the true count unchanged. I is the opposite of D: TRUE,FALSE,FALSE,TRUE,FALSE,TRUE,TRUE,FALSE. Adding one true input changes odd to even and even to odd.
This makes XOR useful for parity-style logical checks. It does not by itself validate every input or supply a general error-detection system.
Official examples and practical limits
On VendorXOR, put =XOR(1>0,2>0) in A1; expect FALSE because both conditions are true. Put =XOR(1>0,2<0) in A2; expect TRUE because only one condition is true. These are the two examples described in the official page.
Do not replace a two-choice formula with a three-choice XOR without revisiting the intended rule. If the requirement is exactly one among three flags, use the explicit count comparison above. A shared “exclusive OR” name does not remove the documented odd-parity behavior.
Mixed-type references, native error propagation, array evaluation and version-specific limits beyond the current documented argument count remain untested. Inspect the individual conditions before interpreting the final flag.