Re: [libreoffice-users] Re: Conditional Whitespace for Mail Merge
Hi Andreas, thanks for your reply. I've a Calc-Sheet with address data (linked with Writer it was transformed to a database). In my used Writer (LO 4.4) the query does no work properly. The query described by you would be in my case [my calc sheet].members.title != but only [title] != is interpreted correctly. :-/ (why?) But in my case the whitespace is printed anytime. Condition: [title] != Then: Else: empty field I think there could be a bug? Can you confirm my described behavior? regards, Sven On Wed, Feb 11, 2015 at 8:42 PM, Andreas Säger ville...@t-online.de wrote: Composing the lines of an addressing area is easy to do with a query. Details depend on the type of your database. In Writer you can use a conditional field with a nested data source field like this: If condition: DataSource.QueryName.Title != Then: -- View this message in context: http://nabble.documentfoundation.org/Conditional-Whitespace-for-Mail-Merge-tp4139674p4139762.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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
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 ville...@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+unsubscr...@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+unsubscr...@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
[libreoffice-users] Need help with hierarchy document templates
Hi, I need some help with hierarchy document templates. I created a document template and saved this to my templates. Then I just opened a document based on this first template and saved this document as template to my templates to get the hierarchy. Next I changed the address in my first template und saved, after edit the second template I confirmed the update by my first template but nothing changed in my inherited template. What did I wrong? Can anyone provide some help? regards, Sven -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] MAIL MERGE: Default fields Topic and Subject are only printed in first document
oh well, I'm looking forward that this problem would be fixed soon in one of the next LO versions. regards Sven On Sun, Jul 27, 2014 at 9:21 AM, Alex McMurchy mcmurchy1917-libreoff...@yahoo.co.uk wrote: *Bug 81782[1]* - MAILMERGE: Some fields (Title, Subject, Author) only printed to the first document I see that someone else has now confirmed that the bug has been present for a long time. Alex On Saturday 26 Jul 2014 16:06:26 Sven Schüring wrote: Hi Alex, thanks for your confirmation. I've raised a bug to writer component as followed: https://www.libreoffice.org/get-help/bug/ regards, Sven On Sat, Jul 26, 2014 at 10:05 AM, Alex McMurchy mcmurchy1917-libreoff...@yahoo.co.uk wrote: Sven I can confirm your problem. I see Title/Subject only on the first page irrespective of whether I save the final merged document as a whole or as individual documents. I tested using the Mail Wizard tool. Raise it as a bug and post back here the reference. Alex On Thursday 24 Jul 2014 21:44:16 Sven Schüring wrote: Hi, I've some trouble with the default fields Topic and Subject of the document properties. They are only printed in the first mail merge document if I set the field to the document. At the following documents there are only whitespace. Can anyone confirm my problem? Is it a bug or a misused by myself? regards Sven -- To unsubscribe e-mail to: users+unsubscr...@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 [1] https://bugs.freedesktop.org/show_bug.cgi?id=81782 -- To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] MAIL MERGE: Default fields Topic and Subject are only printed in first document
Hi Alex, thanks for your confirmation. I've raised a bug to writer component as followed: https://www.libreoffice.org/get-help/bug/ regards, Sven On Sat, Jul 26, 2014 at 10:05 AM, Alex McMurchy mcmurchy1917-libreoff...@yahoo.co.uk wrote: Sven I can confirm your problem. I see Title/Subject only on the first page irrespective of whether I save the final merged document as a whole or as individual documents. I tested using the Mail Wizard tool. Raise it as a bug and post back here the reference. Alex On Thursday 24 Jul 2014 21:44:16 Sven Schüring wrote: Hi, I've some trouble with the default fields Topic and Subject of the document properties. They are only printed in the first mail merge document if I set the field to the document. At the following documents there are only whitespace. Can anyone confirm my problem? Is it a bug or a misused by myself? regards Sven -- To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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
[libreoffice-users] MAIL MERGE: Default fields Topic and Subject are only printed in first document
Hi, I've some trouble with the default fields Topic and Subject of the document properties. They are only printed in the first mail merge document if I set the field to the document. At the following documents there are only whitespace. Can anyone confirm my problem? Is it a bug or a misused by myself? regards Sven -- To unsubscribe e-mail to: users+unsubscr...@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
