[Leaplist] OpenOffice MailMerge Conditional Equations

[Phil Barnett]

On Saturday 13 September 2008 01:40:41 am Bruce Metcalf wrote:
> Fred Moore wrote:
>  > inside OO
>  > F1
>  > index
>  > insert this search term
>  > conditions;in fields and sections
> >
> > make sure you read the portion on 'Conditions and Database Fields"
> > ... I think this is what you really want to use.
>
> Yup, it sure is. Unfortunately nothing in that section refers to any
> operators but ==, !=, null, and not-null. I need numeric comparators to
> select the right subscription notices.
>
>  > and as we discussed before.. field names must be valid field names..
>
> Right. Purged all of the spaces and non-alphanumeric characters from
> field names after the last round.
>
> > BTW.. this has been broken off and on during the last several
> > releases.. make sure you are using something later than OO 2.2..
>
> Version 2.4.1 at the moment. Latest available from the lenny repository.
>
>  >> The problem is that any equation other than == or <> fails to work.
>  >>
>  >> None of the OOo guides, manuals, wikis, or homebrew cheat sheets
>  >> have a list of recognized operators. I've seen ... suggestions that
>  >> OR, AND, and NOT work. Nothing definitive, and nothing at all on
>  >> operators like >, <, >=, <=, GT, LT, GE, or LE....
>
> I'll settle for someone telling me that these comparator functions
> definitely don't work in OOo. At least then I can believe that my time
> spent developing workarounds isn't completely wasted.
>
> Thanks again Fred,
> Bruce

Is there a conditional IF() function?

If so, you could do

somevar = if(x<123,0,1)

if somevar = 1

-- 
"Ninety percent of politicians give the other 10 percent a bad name." -- Henry 
Kissinger

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