[Leaplist] OpenOffice MailMerge Conditional Equations

[Bruce Metcalf]

Gang,

I know I posted about this before, but either the wisdom didn't sink in 
or the software has changed (again). Sorry if this is a repeat:

I'm trying to print a form letter using OpenOffice Writer, pulling data 
from OpenOffice Base. This is a renewal form for several different 
organizations, and has to be tailored depending on which groups someone 
is a member of and if they have paid their dues yet.

So far, I've been able to use the "Hidden Paragraph" feature to hide 
irrelevant lines. I can also set the condition to be 
(Fieldname=="constant") to select lines appropriate only for some 
classes of member. These are working fine.

The problem is that any equation other than == or <> fails to work. The 
big issue is with the magazine. I want to print one line if 
(Subscription<"118"), another if (Subscription>"121"), and a third if 
((Subscription>"117)and(Subscription<"122")). Yeah, I know it's reverse 
logic in OOo, but that's not the source of the trouble.

None of the OOo guides, manuals, wikis, or homebrew cheat sheets have a 
list of recognized operators. I've seen examples of ==, <>, and EQ, and 
suggestions that OR, AND, and NOT work. Nothing definitive, and nothing 
at all on operators like >, <, >=, <=, GT, LT, GE, or LE, which would be 
really helpful here.

Any and all answers, ideas, suggestions, and links will be appreciated.

Bruce

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.