2011/6/10 JOE Conner joeconner2...@gmail.com:
On 6/10/2011 1:55 PM, JOE Conner wrote:
You're welcome. By the way, did it work…?
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
-
To unsubscribe send email tousers-unsubscr...@openoffice.org
For additional commands send email tosy...@openoffice.org
with Subject: help
SNIP
Thanks again Johnny, your equasion =OR(AND(NOT(A1);B1);AND(A1;NOT(B1)))
worked a treat,
I am still mulling over the rest where you lead step by step through macro
creation. I downloaded a
copy of the Star Basic tutorial from
http://api.openoffice.org/basic/man/tutorial/tutorial.pdf to study.
A quick search of it did not show XOR as a key word, but perhaps I did not
search it correctly.
Well, as I showed you, XOR is already a function in OpenOffice.org
BASIC, so it can not be used as a variable name. Or what would you say
about an expression like ”XOR=XOR XOR XOR” (except that it is
meaningless…)?
What I want ultimately, is to be able to type something like ABCDE in cell
A1 and type
FGHIJ in cell B2 and in cell A3 type =XOR(A1;A2) and have a valid string on
XOR'ed
characters, A with F, B with G, C with H, D with I, and E with J.
Thanks again. Joe
You mean bitwise XOR of the character's codes (such as UTF-8, ISO
8859-1 or even ASCII)?
Well, that would be a somewhat more complicated macro. What would you
expect the result to be in that example of yours (ABCDE XOR FGHIJ)?
Regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help