Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Desktop
User Name
Linux - Desktop This forum is for the discussion of all Linux Software used in a desktop context.


  Search this Thread
Old 07-17-2012, 10:11 AM   #1
Registered: Feb 2007
Posts: 122

Rep: Reputation: 22
LibreOffice mail merge with conditional text based on database field content

I'm using LibreOffice (Debian/Wheezy) and am having an awful time trying to get conditional text to work.

As an example, I have a database field that contains a single letter (either F or M) denoting gender. I want to replace that with either "female" or "male" in the actual document, based on whether the current record refers to a female or male.

I have a conditional text function, where the function is:


The then part is:


and the else part is:


Unfortunately the output page always says female no matter what the database field contains.

I have other fields that I'm similarly trying to do a relatively straightforward translation on without any luck.

Either conditional text doesn't work at all or I'm missing something. Given that the latter is far more likely, can someone point out what I'm doing wrong?


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge for address labels in LibreOffice Lossenelin Linux - Software 0 04-17-2012 10:21 PM
LXer: LibreOffice Tips: Inserting QurĂ¢??an text in LibreOffice Writer LXer Syndicated Linux News 0 04-16-2012 02:50 PM
Helios : Using tab on text field having content proposals, crashes my application mb12mb Programming 1 09-12-2010 02:32 AM
renaming text files based upon a pattern in their content Spacepup Linux - General 1 07-28-2005 01:43 PM
Text based mail readers Harman27 Linux - Software 1 06-13-2005 10:49 AM

All times are GMT -5. The time now is 05:48 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration