Re: [libreoffice-users] Re: Conditional Whitespace for Mail Merge

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 <villeroy@t-online.de> 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: 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

-- 
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