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.