Re: [libreoffice-users] Suppress address2 field if blank

At 22:57 10/12/2015 -0500, Dave Boland wrote:
> I have a spreadsheet of Christmas card addresses to print envelopes. 
> Everything works, except the address2 field - it prints a blank line 
> if the field is blank. I was looking for a check box to suppress 
> blank fields, but didn't find one. How do I do this?

Try this:
o Ensure that your fields are separated by paragraph breaks, not line breaks.
o Select the relevant field - in this case <address2>.
o Go to Insert | Section... | Section.
o Under Hide, tick Hide and enter for With Condition: address2 EQ "" .
o Click Insert.
o Apply your data to fields in the normal way.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@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