LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Desktop (http://www.linuxquestions.org/questions/linux-desktop-74/)
-   -   LibreOffice mail merge with conditional text based on database field content (http://www.linuxquestions.org/questions/linux-desktop-74/libreoffice-mail-merge-with-conditional-text-based-on-database-field-content-4175417206/)

garydale 07-17-2012 11:11 AM

LibreOffice mail merge with conditional text based on database field content
 
I'm using LibreOffice 3.5.4.2 (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:

Results.RESULTS.GENDER == "F"

The then part is:

female

and the else part is:

male


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?


All times are GMT -5. The time now is 01:53 AM.