On 6/10/2011 3:28 PM, Johnny Rosenberg wrote:
<<SNIP>>
Johnny, I have attached a calc sheet showing my expectations. I am also sending it to you off list, in case the attachment does not survive the list.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. JoeYou 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 ジョニー・ローゼンバーグ
Thank you very much. Joe Conner, Poulsbo, WA USA -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
XOR_Example.ods
Description: application/vnd.oasis.opendocument.spreadsheet
