This is a bug connected to general bug 50488 function XOR as defined in ODFF1.2 is missing in calc.
Erroneously commits were assigned to bug 50822 because of typo in bug number of commit summary: Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=033cce3e0fbb72a9400836923be96c5036aaacb0 fdo#50822 add function XOR to calc as in ODFF1.2 Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9ae96127e5b363e6eea14a0e9459b22f0f7307ca changes to patch "fdo#50822 add function XOR to calc as in ODFF1.2"
Created attachment 62943 [details] testcase