Re: [libreoffice-users] Conditions

Le 18/03/2012 20:53, Mark Stanton a écrit :
> For my mailmerge I want to set up a conditional paragraph conditional
> on more than one thing.
>
> I've got a database field "Country", and if this is blank or contains
> "Scotland" I want the paragraph hidden.
>
> I *think* the condition ought to be
>
>      NOT Country OR Country EQ 'Scotland'
>
> but it doesn't work.  I thought blanks at the end of the country
> field might cause a problem so I tried
>
>      NOT Country OR 'Scotland' EQ Country
>
> but that didn't work either.
>
> The help states that the fields ought to be written as
>
>      <database>.<table>.<field>
>
> but that doesn't make any difference either and the single condition
> "NOT Country" does work, although it's insufficient for my needs.
>
> Have I got my logic entirely wrong, or can the condition expression
> not have more than one part?

You need double quotes and I guess parenthesis can help as weel, that is:

(NOT Country=="") OR (Country=="Scotland")

equivalent to

(Country<>"") AND (Country<>"Scotland")

--
Jean-Francois Nifenecker, Bordeaux

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted