2011/6/10 JOE Conner <[email protected]>: > > > 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 [email protected] >> For additional commands send email [email protected] >> 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 [email protected] For additional commands send email to [email protected] with Subject: help
