Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.