Hi Andreas, thank you for your effort. :)
I got the fail. Our concluded condition is working correctly. Field type -> Conditional Text Condition: [Titel] != "" Then: " " Else: "" Now the big BUT! If I click me through the mail merge assistant I got a document preview where I can scroll through the data sets. The document preview is displaying the whitespace anytime. (this lead me astray) If I print/save the mail merge document I can see that die conditional text is working correctly. :) I will file an error for this document preview behavior. Thank you very much. regards, Sven On Thu, Feb 12, 2015 at 4:23 PM, Andreas Säger <[email protected]> wrote: > So it's a Calc sheet actually. I would simply use Calc to concatenate the > proper field contents and then use that calculated field for the mail > merge. > Something like =TRIM($A2&" "&$B2&" "&$C2) with a column title in the firs > row copied down along the list. > > A database query would be easier to handle because it automatically applies > to the whole record set: > Something like: > SELECT > LTRIM(CONCAT("Title",CONCAT(' ',CONCAT("ForeName",CONCAT(' > ',"LastName"))))) > AS "Full Name", > <other fields> > FROM "Sheet1" > > This looks horrible because there is only a very limited set of functions > when you mis-use a spreadsheet for a database connection. But with the > right > double-quoted names of sheets and columns it will generate a calculated > "Full Name" field on the fly. > Availlable SQL-functions with file based data sources > <http://www.openoffice.org/dba/specifications/file_based_functions.html> > > Doing this in the last element of the chain is difficult. The only resource > I know is > http://openoffice.blogs.com/openoffice/2007/05/suppressing_bla.html > describing a solution for a similar problem. > > > > -- > View this message in context: > http://nabble.documentfoundation.org/Conditional-Whitespace-for-Mail-Merge-tp4139674p4139885.html > Sent from the Users mailing list archive at Nabble.com. > > -- > To unsubscribe e-mail to: [email protected] > 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 > > -- To unsubscribe e-mail to: [email protected] 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
