Re: [libreoffice-users] Writer stopped printing form letters
Hi. Did anything change from the last time you printed these (LO, OS). Is the printer plugged in or networked. I had this once but can't remember what caused it or how I fixed it. Steve On 2014-09-22 16:30, Gary Dale wrote: Something I've been doing for years now has stopped working. I print tickets using Writer 5 to a page. The tickets have a stub portion and are numbered so that the stub and ticket portion have the same number. The number field gets inserted twice on each ticket. The number field is almost the only text. The tickets are actually designed separately and imported as a background graphic. The numbers increase by some amount for the second, third, etc. tickets so that the subsequent sheets can have consecutively numbered tickets. This makes cutting and assembly into books easy. By connecting to a Calc spreadsheet I can print off as many as I need with unique numbers. Except this time when I get to the Mail Merge dialogue, select the records I want to print then hit print, the dialogue closes but the printer selection never opens. I've tried this on another document that I'd printed earlier and got the same result. For some reason form letter printing seems to be broken. Is anyone else having this problem? BTW: running Debian/Jessie with LibreOffice Version: 4.3.1.2, Build ID: 430m0(Build:2). -- 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] Writer stopped printing form letters
Something I've been doing for years now has stopped working. I print tickets using Writer 5 to a page. The tickets have a stub portion and are numbered so that the stub and ticket portion have the same number. The number field gets inserted twice on each ticket. The number field is almost the only text. The tickets are actually designed separately and imported as a background graphic. The numbers increase by some amount for the second, third, etc. tickets so that the subsequent sheets can have consecutively numbered tickets. This makes cutting and assembly into books easy. By connecting to a Calc spreadsheet I can print off as many as I need with unique numbers. Except this time when I get to the Mail Merge dialogue, select the records I want to print then hit print, the dialogue closes but the printer selection never opens. I've tried this on another document that I'd printed earlier and got the same result. For some reason form letter printing seems to be broken. Is anyone else having this problem? BTW: running Debian/Jessie with LibreOffice Version: 4.3.1.2, Build ID: 430m0(Build:2). -- 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] Printing "Brochure" with Writer -- margins
Hi :) This question is less about technical issues and more about psychology. I'm certain that Marc has no trouble with the technical aspects of this. He's a long-term contributor to TDF and has set-up some pretty amazing resources on the wiki and website fronts. The problem with setting things up to make it easy to produce a booklet/brochure is in getting new users to use them. New users will often start off not even realising they need to create a brochure. So they will open some old letter or normal document and delete out the words to get the page blank and then start typing stuff in. Maybe after putting all the content in THAT's when they start thinking about printing out as a brochure. One way i sometimes try to handle that is to take the work off them. Then copy&paste-special as "unformatted text" and then try to get the images either from one document to another or get the original images. Another approach that also runs into problems is to be 'helpful' by suggesting this or that the person could do to get to a brochure. Another approach that fails is to kinda train them how to convert their document, or how to start the right way from scratch. I've tried lots of ways and all of them seem to cause different problems with people. I'm sure that's the problem that Marc is anticipating too. Regards from Tom :) On 21 September 2014 13:26, Brian Barker wrote: > At 15:17 19/09/2014 -0400, Marc Paré wrote: > >> I am just trying to make the routine of publishing music concert programs >> as easy for new office staff as possible (I am director for an early music >> group). One way to print the concert programs in booklet format is to have >> the office staff type up the concert program in Writer and at the point of >> printing, choose the "brochure layout" option in the Printer window tab >> "Page Layout". This method works perfectly and allows for any new person to >> the music office to just step in and print concert programs in very few >> steps that require practically no brochure layout knowledge -- extremely >> user friendly to use. >> >> My question is, when the printed brochure comes out, there is a lot of >> wasted space at the top and bottom of the brochure pages. Is there a way to >> make use of this space? ... For example, have the printed words start >> higher up the page and also down the page? >> > > Yes. > > Is this something that could be suggested as a bug or put on a wishlist? >> > > No need. > > At 05:44 20/09/2014 -0400, Marc Paré wrote: > >> The "brochure" option prints a Writer doc automatically in booklet form >> and figures out the pagination automatically -- so, a user can easily print >> out "booklets" by doing practically no setup at all ... no styling needed. >> > > Actually, page format is *only* controlled by a page style, so you always > have a page style or styles in every document, even if you only ever use > the default Default page style. (Don't be frightened of styles!) > > As far as I can tell, even if I change the body length ... for example >> set the 8.5X11 inch page to a top and bottom margin of "0.00 inches" ... >> the brochure (booklet) will still be printed with the same top/bottom gaps >> of spaces at the top/bottom of the booklet. >> > > The problem - as already suggested by Mark Bourne - is that you are not > using the brochure facility in the best way. (I think this is an example of > where Microsoft Word does things differently; are you perhaps guilty of > Wordthink?) If you rely on Writer to scale your text to the brochure size, > you will need to choose font sizes and picture sizes and so on which come > right in the brochure when printed - instead of using the actually sizes > you want, as you would do normally. > > To create brochures most conveniently, set your original document page > size to the actual size of the page as printed - in your case 5.5 by 8.5 > inches in portrait orientation. Set the font sizes as you actually want to > see them in the brochure. As you create the text, you will see the > pagination as it will actually appear. When you print, using the Brochure > option, ensure that the printer settings are 8.5 by 11 inches and landscape > orientation. You will find this much easier and the margin settings in your > page style(s) should be reflected in what you get. > > It would be very useful, if there were a way to make use of the white >> space through the initial Writer document before going to the >> "Print->Brochure" option. This would allow ALL Writer users to print out >> brochure-booklets without any prepping of styles. >> > > Why not prepare the page style (half-size, portrait, margins, possibly > including page numbers, ... whatever) yourself and save this as a template? > This can include the printer settings, so that Letter, landscape, and even > Brochure will all be set without your users having to think about them. > > I trust this helps. > > Brian Barker > > > -- > To unsubscribe e-mail to: users+unsubscr.
[libreoffice-users] Re: Printing "Brochure" with Writer -- margins
Thanks! Exactly what I needed. I have redone my booklets as 5.5x8.5 as you suggested and tweaked the margins. When I go to print, I still choose the "Brochure" option and this prints out a nice booklet where I am in control of the margins. Nice! Cheers, Marc Le 2014-09-20 09:13, Mark Bourne a écrit : Marc Paré wrote: As far as I can tell, even if I change the body length ... for example set the 8.5X11 inch page to a top and bottom margin of "0.00 inches" ... the brochure (booklet) will still be printed with the same top/bottom gaps of spaces at the top/bottom of the booklet. It would be very useful, if there were a way to make use of the white space through the initial Writer document before going to the "Print->Brochure" option. This would allow ALL Writer users to print out brochure-booklets without any prepping of styles. I think the problem is that the proportions of an 8.5x11" page are different from the proportions of half a page (which is 5.5x8.5"), so a simple scaling doesn't work. When content created at 8.5x11" is scaled to fit on half a page, the 8.5" side become 5.5", while the 11" side is scaled by the same proportion to 7.1" - less than the 8.5" height which is actually available. Try creating the content with the page size set to 5.5x8.5" (or 8.5x13.1" if that makes it easier to adapt the existing content), then print that as a brochure on 8.5x11" paper. (Doesn't help you much using US paper sizes, but for those using the European "A" sizes - A4, A5, etc. - this isn't so much of a problem; those sizes are designed so that the proportions remain the same when a page is cut in half) Mark. -- Marc Paré m...@marcpare.com http://www.parEntreprise.com parEntreprise.com Supports OpenDocument Formats (ODF) parEntreprise.com Supports http://www.LibreOffice.org -- 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] Fill down with a twist
At 13:44 19/09/2014 +0200, Martin F Krafft wrote: At 11:37 19/09/2014 +0100, Tom Davies wrote: At 09:01 19/09/2014 +0200, Martin F Krafft wrote: If a cell A1 contains '=B1' and I fill-down from A1 to A3, I get references to B2 and B3 for the two new cells. Is it possible to fill down, but scan right? E.g. make A2 become C1 and A3 become D1? Maybe what you are looking for is something involving Edit - "Paste Special" - tick the "transpose" box This does almost what I want, except it copies values, and it does not insert references. So use Edit | Paste Special... and tick both Transpose and Link under Options. Voilà! Note that your intermediate column copy of your data can be out of the way elsewhere on the sheet, out of any print range - or even on a separate sheet. I trust this helps. Brian Barker -- 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] Printing "Brochure" with Writer -- margins
At 15:17 19/09/2014 -0400, Marc Paré wrote: I am just trying to make the routine of publishing music concert programs as easy for new office staff as possible (I am director for an early music group). One way to print the concert programs in booklet format is to have the office staff type up the concert program in Writer and at the point of printing, choose the "brochure layout" option in the Printer window tab "Page Layout". This method works perfectly and allows for any new person to the music office to just step in and print concert programs in very few steps that require practically no brochure layout knowledge -- extremely user friendly to use. My question is, when the printed brochure comes out, there is a lot of wasted space at the top and bottom of the brochure pages. Is there a way to make use of this space? ... For example, have the printed words start higher up the page and also down the page? Yes. Is this something that could be suggested as a bug or put on a wishlist? No need. At 05:44 20/09/2014 -0400, Marc Paré wrote: The "brochure" option prints a Writer doc automatically in booklet form and figures out the pagination automatically -- so, a user can easily print out "booklets" by doing practically no setup at all ... no styling needed. Actually, page format is *only* controlled by a page style, so you always have a page style or styles in every document, even if you only ever use the default Default page style. (Don't be frightened of styles!) As far as I can tell, even if I change the body length ... for example set the 8.5X11 inch page to a top and bottom margin of "0.00 inches" ... the brochure (booklet) will still be printed with the same top/bottom gaps of spaces at the top/bottom of the booklet. The problem - as already suggested by Mark Bourne - is that you are not using the brochure facility in the best way. (I think this is an example of where Microsoft Word does things differently; are you perhaps guilty of Wordthink?) If you rely on Writer to scale your text to the brochure size, you will need to choose font sizes and picture sizes and so on which come right in the brochure when printed - instead of using the actually sizes you want, as you would do normally. To create brochures most conveniently, set your original document page size to the actual size of the page as printed - in your case 5.5 by 8.5 inches in portrait orientation. Set the font sizes as you actually want to see them in the brochure. As you create the text, you will see the pagination as it will actually appear. When you print, using the Brochure option, ensure that the printer settings are 8.5 by 11 inches and landscape orientation. You will find this much easier and the margin settings in your page style(s) should be reflected in what you get. It would be very useful, if there were a way to make use of the white space through the initial Writer document before going to the "Print->Brochure" option. This would allow ALL Writer users to print out brochure-booklets without any prepping of styles. Why not prepare the page style (half-size, portrait, margins, possibly including page numbers, ... whatever) yourself and save this as a template? This can include the printer settings, so that Letter, landscape, and even Brochure will all be set without your users having to think about them. I trust this helps. Brian Barker -- 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] Seeking for list moderators
Hi, Ram 'Gurumukhi' wrote on 2014-09-21 at 06:29: I am finding no time to contribute to Libreoffice Community, can you please remove me from this moderator's list? of course, I have removed you as moderator of the users list. Thanks for your work! Florian -- 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] Seeking for list moderators
Hi Florian, I am finding no time to contribute to Libreoffice Community, can you please remove me from this moderator's list? Thanks, Ram On Sat, May 4, 2013 at 5:29 PM, Florian Effenberger < flo...@documentfoundation.org> wrote: > Hello, > > RD Vaishnav wrote on 2013-05-04 13:49: > >> i m interested in becoming moderator for mailing list. and is it fine if >> i check mails just twice or thrice a day?? and thanks for the opportunity. >> > > thanks a lot! I've just made you moderator of the users list. ;-) > Of course, it's totally fine to check mails even just once a day. There's > no obligation to read everything in time - sorry if my mail sounded that > way. I just want to make sure that people moderating the list are also > actually reading it, that's it. :) > > So, welcome on board! > Florian > -- 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