Re: [libreoffice-users] Re: base + mailmerge difficulty
If that's still a problem edit the report to insert a page break before Schedule for. Alex On 28/06/15 10:16, Alex McMurchy wrote: A proper report should work. Though I seem to remember some problem about getting page throws in the right place. Alex On 28/06/15 00:10, Gabriele Ponzo wrote: Mail merge is a Writer feature, but also Base reports rely on Writer! So I guess for both cases it's just about arranging a proper report. By the way I hope to have soon some spare time to do some attempts. Il 28/giu/2015 01:00, Andreas Säger ville...@t-online.de ha scritto: Mail merge can not do this. For the same reasons we can not print any invoices where many orders belong to one client. -- 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] Inserting image through link in database
Hi, I have a template in Writer with which I import data from a spreadsheet (via a database link). This way I create multiple versions of the same layout with different content. I would like to vary an image in the file as well. The database contains a relative pathname to the image. Is there a way to do this in Writer, or would I have to resort to programming tricks? Cheers, H. -- Hendrik Maryns Drielandenhoek 24 NL-2034 LV Haarlem +31237370263 +31634861841 (staat meestal uit, enkel nootgevallen) http://hendrikmaryns.name/ === Wat moet ik met signature.asc?!? Kort gezegt: niks, lang antwoort: → http://en.wikipedia.org/wiki/PGP → http://mindprod.com/project/mailreadernewsreader.html Kan je niet spellen?!? Toch wel hoor: → http://hendrikmaryns.name/spelling.php -- 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] base + mailmerge difficulty
Translating form theory in base to a writer document you would have a form that contains two sub forms. The first sub form would be called Students and source it's data from the Students table and contain the controls FirstName and LastName The second sub form would be called Classes and source it's data from the query Query_Schedules and have a control table with ClassId, ClassTitle and CreditHours. I've done this after a MailMerge get 6 separate pages but unfortunately each page is for Jane Doe with her four classes. I might have done something wrong so can have another look later on in the week, someone else can always run with this in the meantime. If this doesn't work I suggest using a macro with a cursor round the students table so in the example database perform the loop 6 times selecting each student in turn. Within the loop perform a mail merge for each individual student. Here's a sample code for for a similar situation, it's an extract it will contain typos and other omissions as it's an extract from something similar that I'd done I also hashed out references to the progress bar - again I can have another look at this later on in the week if this problem hasn't been solved Alex dim document as object dim dispatcher as object dim DatabaseContext As Object dim DataSource As Object dim oMailMerge as Object dim w Dim oCompWin as object Dim oScrollPane as Object document = ThisComponent.CurrentController.Frame dispatcher = createUnoService(com.sun.star.frame.DispatchHelper) DatabaseContext = createUnoService(com.sun.star.sdb.DatabaseContext) DataSource = DatabaseContext.getByName(school) 'Conn=DataSource.getConnection(,) REM Create a NEW status indicator REMoBar = document.createStatusIndicator() REMoBar.start(Started..., 3) REMoBar.Value = 1 ' show progress bar REMoBar.Text = Progressing ... REMProgressValue = 1 REMoBar.Value = ProgressValue If (Not GlobalScope.BasicLibraries.isLibraryLoaded(Tools)) Then GlobalScope.BasicLibraries.LoadLibrary(Tools) End If DirectoryName = DirectoryNameoutofPath(DataSource.Name, /) / REMIf Not FileExists(convertToURL(DirectoryName /arrears strDate)) Then REMmkdir((convertToURL(DirectoryName /arrears strDate)) REMEnd If If FileExists(convertToURL(DirectoryName /reports/ intStudentId 0.odt)) Then kill convertToURL(DirectoryName /reports/ intStudentId 0.odt) End If oMailMerge = CreateUnoService(com.sun.star.text.MailMerge) FOR EACH STUDENT DO oMailMerge.DataSourceName = school oMailMerge.CommandType = 1 oMailMerge.Command = Query_Schedules oMailMerge.OutputType = com.sun.star.text.MailMergeType.FILE oMailMerge.OutputUrl = ConvertToUrl(DirectoryName /reports/ ) oMailMerge.FileNamePrefix = intStudentId oMailMerge.SaveAsSingleFile=True oMailMerge.FileNameFromColumn=False oMailMerge.Filter=Students.StudentId= intStudentId REMoListener1 = createUNOListener(MML_ID_, com.sun.star.text.XMailMergeListener) REMoMailMerge.addMailMergeEventListener(oListener1) oMailMerge.execute(Array()) REMProgressValue = ProgressValue + 1 REMoBar.Text =Converting to PDF file REMoBar.Value = ProgressValue oMailMerge.dispose() DONE On 26/06/15 17:05, Ed Beroset wrote: I'm trying to print out schedules for students using mailmerge and have encountered a problem that I haven't yet been able to solve. Here's what I've done so far. I have created a simple embedded database (named school) in base and I have three tables named Classes, Students and Schedules. Classes has three fields: ClassID (which is the index), ClassTitle and CreditHours. The Students table has StudentID (the index), LastName and FirstName. The Schedules table has PairID (the index) and StudentID and ClassID. Students and Classes are just what you'd expect. Each record in the Schedules table links one student and one class. A schedule is the collection of all classes for a particular student. I have created a simple query for the Schedules table: SELECT Schedules.StudentID StudentID, Students.LastName LastName, Students.FirstName FirstName, Schedules.ClassID ClassID, Classes.ClassTitle ClassTitle, Classes.CreditHours CreditHours FROM Schedules Schedules, Students Students, Classes Classes WHERE Schedules.StudentID = Students.StudentID AND Schedules.ClassID = Classes.ClassID ORDER BY StudentID, ClassID All of that works just fine and I've also created a simple report that uses the query, which also works as expected. Now what I want to do is to create a separate schedule document for each student. I'm attempting to use mailmerge to do that. I have a simple .ott file which has Schedule for FirstName LastName in the header and then a table in the body of the document. It has a header and about 14 rows (the maximum number of classes
Re: [libreoffice-users] Re: base + mailmerge difficulty
A proper report should work. Though I seem to remember some problem about getting page throws in the right place. Alex On 28/06/15 00:10, Gabriele Ponzo wrote: Mail merge is a Writer feature, but also Base reports rely on Writer! So I guess for both cases it's just about arranging a proper report. By the way I hope to have soon some spare time to do some attempts. Il 28/giu/2015 01:00, Andreas Säger ville...@t-online.de ha scritto: Mail merge can not do this. For the same reasons we can not print any invoices where many orders belong to one client. -- 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] Re: LibreOffice's documentation (pdf and online)
Just one vote ... I always download the pdf files, which are really excellent user manuals in a print ready form. They are easy to navigate, have good indexes, can be side-loaded onto a tablet, opened in another window if needed, always available off-line, and so forth. Based on a few comments in this thread, some people don't even seem to know they exist, so perhaps these should be featured on the download pages as well. I just took a look at https://www.libreoffice.org/download/libreoffice-fresh/ and the only mention of the Guides is buried in the Get Help tab. Featuring them a bit more can only add to a professional image. The content in the on-line help files ranges from not very helpful to simply incorrect (obsolete?). Even were this addressed, some obvious method of identifying version-specific might still be tricky. With the pdf books, you can limit your downloads to something suitable for the version of LO you're using. Generally, when someone is preparing files for print they tend to take greater care with accuracy, have better editing, and so forth. This is certainly true for the excellent LO Guides. The lack of consistency (all senses of that word) in the on-line help, however, clearly indicates the lack of any overall guiding hand. Even though attempting to use something like 5.x with 4.2 pdf manuals raises a few issues, a little trolling will show that your chances of getting an answer are better with the 4.2 manuals than with the 5.x help files (although some new methods are only explained there). -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-s-documentation-pdf-and-online-tp4152516p4152922.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
Fwd: [libreoffice-users] Re: How to Turn a Landscape Table by 90 Degrees into a Portrait Table
-- Forwarded message -- From: Andreas Säger ville...@t-online.de Date: Sat, Jun 27, 2015 at 6:48 PM Subject: [libreoffice-users] Re: How to Turn a Landscape Table by 90 Degrees into a Portrait Table To: users@global.libreoffice.org Am 25.06.2015 um 22:37 schrieb Taang Zomi: *How to Turn a Landscape Table by 90 Degrees into a Portrait Table* *LibreOffice 4.4.3.2* Copy the table Open a new spreadsheet document menu:EditPaste-Special... Type: HTML Copy the spreadsheet range. Select some empty cell. menu:EditPaste-Special... [X] Transpose Copy the transposed spreadsheet range Paste-Special as HTML into the Writer document -- 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 == *Dear Andreas,* *Thank you for your kind participation.* *I will try your method. This will be my new experience as I did not use Calc.* *Sincerely,* *Taang Zomi* -- 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] Impress Drawing Object Styles: Headings and Titles
I am a little confused by the Drawing Object Styles called Heading and Title. Are they intended for different uses? What would be a good use case for each of these? Thanks, -- Kevin B. O'Brien zwiln...@gmail.com http://google.me/+kevinobrien “If there are no dogs in Heaven, then when I die I want to go where they went.” - Will Rogers -- 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] Re: LibreOffice's documentation (pdf and online)
Re: Sophi's comment: Online help is what you find on the wiki help but also off line, maintained by developers and l10n team. I'm not disagreeing with the comment, but hoping to clarify something: In thirty plus years, I encountered VERY FEW developers who could produce useful documentation. The mind-set is just different. What developers produce (and should be required to if they don't) should be analogous to source code that can be compiled by actual technical writers - i.e. those with the appropriate mind-set. (Silly analogy, but hopefully useful) Getting an explanation of relativity from Einstein himself might seem like a good idea, but a user (however one cares to define such a creature) would be better served by an explanation offered by an actual Writer who may not be in the same league as AE technically, but understands the gist and has the skills to present it. Good math teachers aren't necessarily good mathematicians at all. -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-s-documentation-pdf-and-online-tp4152516p4152924.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
[libreoffice-users] One more question on Drawing Object styles
There is a style for an object with no line and no fill, but that seems to make everything disappear. I can tell that the object is still there if I work at clicking around the blank screen to select it, but I am at a loos to understand what a use case is for this style. Can anyone enlighten me? Thanks, -- Kevin B. O'Brien zwiln...@gmail.com http://google.me/+kevinobrien “If there are no dogs in Heaven, then when I die I want to go where they went.” - Will Rogers -- 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] One more question on Drawing Object styles
Hi Kevin, Kevin O'Brien schrieb: There is a style for an object with no line and no fill, but that seems to make everything disappear. I can tell that the object is still there if I work at clicking around the blank screen to select it, but I am at a loos to understand what a use case is for this style. Can anyone enlighten me? That is the default style for images and OLE-objects, e.g. Math formula. Kind regards Regina -- 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] Re: LibreOffice's documentation (pdf and online)
On 28.06.2015 04:24, David Allen wrote: [...] It's a loose compilation of answers [...] Thanks for your compilation, David. However - what are your ideas about consequences? To me, it seems rather difficult to improve the situation as whatever the idea is, it is always an awful lot of work to do. Therefore, the only promising strategy seems kind of crowdsourcing the work i.e. make it as easy as possible to contribute so that many many people can collaborate. The historical situation was to have the local F1 help, which is rather difficult to manage and nearly impossible for normal people to contribute. So the folks keen to contribute created the User Guides as supplement which is much easier to contribute to. Nowadays, with all the collaborative internet possibilities, one could think of a better linking of the two by creating a combined help, i.e. a wiki help which allows easy contribution on the one hand but is also context sensitive like the local help. This has been started, but is far from being functional: The wikihelp nicely reacts to F1 if no localhelp is installed, but contribution is not yet implemented. So we have to live with this not yet status for another couple of years, I fear. That's the way I see it. Curious about your improvement proposals. Nino -- 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] Re: base + mailmerge difficulty
-- View this message in context: http://nabble.documentfoundation.org/base-mailmerge-difficulty-tp4152762p4152936.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
[libreoffice-users] Re: Looking for LibreOffice version 4.3 for the Mac
M amp; J Clark wrote When I go to the download LibreOffice website I cannot find this version - I can find a Mac version for higher # operating systems than 10.6.8. Where can I download a trusted copy of LibreOffice 4.3? The archive of LO release builds is here: http://downloadarchive.documentfoundation.org/libreoffice/old/ -- View this message in context: http://nabble.documentfoundation.org/Looking-for-LibreOffice-version-4-3-for-the-Mac-tp4152933p4152945.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
[libreoffice-users] Looking for LibreOffice version 4.3 for the Mac
Hi! I have some old Appleworks documents running on a Mac OS 10.6.8 - I would like to convert these docs to a format that I will be able to use going forward and read that I could use LibreOffice 4.3. (for the Mac) When I go to the download LibreOffice website I cannot find this version - I can find a Mac version for higher # operating systems than 10.6.8. Where can I download a trusted copy of LibreOffice 4.3? - Mary -- 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] Re: Inserting image through link in database
Theoretically a database report should do the trick. -- View this message in context: http://nabble.documentfoundation.org/Inserting-image-through-link-in-database-tp4152900p4152939.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
[libreoffice-users] Re: base + mailmerge difficulty
If that's still a problem edit the report to insert a page break before Schedule for. Alex Been there, tried that, got the t-shirt. An example database with a many-to-many relation, some hundreds example records and a working report with proper page breaks would convince me that this is possible. Meanwhile I did some experiments with mail merge, mail merge event listeners and a self-written report generator which dumps record sets related to the merged letter into a prepared Writer table. For me as a hobbyist programmer this is no fun by any means. It sucks badly. -- View this message in context: http://nabble.documentfoundation.org/base-mailmerge-difficulty-tp4152762p4152937.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