Re: [libreoffice-users] Printing 18 labels per sheet on Avery A4 sheet L7161
Hi, Not sure if that will work for you, but you can try this: 1) Create your new document2) Select the top-left frame (single click on the border)3) Go Format -> Frame -> properties4) Go to the Borders tab, and then set the internal border to 0,1cm on all sides In my version, this sets the border for all frames on the page and therefore makes the boxes smaller on all sides for text which, as I understand is what you are looking for. I hope this helps. Rémy.Le lundi 08 juin 2020 à 19:33 -0400, Alan B a écrit : > Hello John, > re: [2] same label for all labels on page with other than the > defaultformatting applied to all labels > #1 File > New > Labels#2 Labels dialog, Labels tab -- -- Label text > field : enter desired label text -- Brand: Avery A4, Type: L7161 > Address#3 Click "New Document" button, label text field is repeated > for all labelson page#4 Right-click in text of first label, select > Styles > Edit Style...#5 modify style as desired and click "Apply" > button > All labels now have the same style applied to the text. > Is that what you are trying to do? > > > > On Mon, Jun 8, 2020 at 5:13 PM John Kaufmann wrote: > > On 2020-06-08 11:54, Budge wrote: > > > Two questions please. > > > [1] I am using Avery A4 L7161 adhesive labels and have opened > > > using the > > new>label option which gives me the grid in which to type the > > text. Havingselected font and size I find the print is too close > > to the edge of thelabel. How may I adjust the margin between the > > first line of text and theactual label edge. I think the word is > > kerning and I need to move the texta fraction of the line down on > > the paper? > > On the Labels Format tab, can you not just increase the Top margin > > by,say, a millimeter?[BTW: I don't think the word you want is > > kerning, which refers to aspacing relationship between characters.] > > > > > [2] Once I have typed one label and edited it to suit, is there a > > > quick > > way to copy the one label to all the labels on the the whole sheet? > > I don't know how easily that is done with LO's Labels function, > > which isoptimized for merging addresses from a database. Probably > > someone who useslabels a lot can chime in on that, but I would > > probably be inclined to justformat a page with margins of 7.2mm > > (L/R) and 8.8mm(T/B) and then make a3col x 6 row table full-width > > (66.0mm columns), with row heights 46.5mm.That would give you easy > > access to all labels as table cells, so you couldjust copy-and- > > paste quickly. > > --To unsubscribe e-mail to: > > users+unsubscr...@global.libreoffice.org > > Problems? > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: > > https://wiki.documentfoundation.org/Netiquette > > List archive: https://listarchives.libreoffice.org/global/users/ > > Privacy Policy: https://www.documentfoundation.org/privacy > > > > -- Alan BobaCISSP, CCENT, ITIL v3 Foundations 2011 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Printing 18 labels per sheet on Avery A4 sheet L7161
Hi Alan, No, I was not trying to do that -- Budge [the OP] was -- but I did not know how to answer that part of his post (never did it before). So simple; I'm embarrassed I did not know, but am happy to know it now. Sweet. Thanks, John On 2020-06-08 19:33, Alan B wrote: Hello John, re: [2] same label for all labels on page with other than the default formatting applied to all labels #1 File > New > Labels #2 Labels dialog, Labels tab -- -- Label text field : enter desired label text -- Brand: Avery A4, Type: L7161 Address #3 Click "New Document" button, label text field is repeated for all labels on page #4 Right-click in text of first label, select Styles > Edit Style... #5 modify style as desired and click "Apply" button All labels now have the same style applied to the text. Is that what you are trying to do? On Mon, Jun 8, 2020 at 5:13 PM John Kaufmann wrote: On 2020-06-08 11:54, Budge wrote: Two questions please. [1] I am using Avery A4 L7161 adhesive labels and have opened using the new>label option which gives me the grid in which to type the text. Having selected font and size I find the print is too close to the edge of the label. How may I adjust the margin between the first line of text and the actual label edge. I think the word is kerning and I need to move the text a fraction of the line down on the paper? On the Labels Format tab, can you not just increase the Top margin by, say, a millimeter? [BTW: I don't think the word you want is kerning, which refers to a spacing relationship between characters.] [2] Once I have typed one label and edited it to suit, is there a quick way to copy the one label to all the labels on the the whole sheet? I don't know how easily that is done with LO's Labels function, which is optimized for merging addresses from a database. Probably someone who uses labels a lot can chime in on that, but I would probably be inclined to just format a page with margins of 7.2mm (L/R) and 8.8mm(T/B) and then make a 3col x 6 row table full-width (66.0mm columns), with row heights 46.5mm. That would give you easy access to all labels as table cells, so you could just copy-and-paste quickly. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Printing 18 labels per sheet on Avery A4 sheet L7161
Hello John, re: [2] same label for all labels on page with other than the default formatting applied to all labels #1 File > New > Labels #2 Labels dialog, Labels tab -- -- Label text field : enter desired label text -- Brand: Avery A4, Type: L7161 Address #3 Click "New Document" button, label text field is repeated for all labels on page #4 Right-click in text of first label, select Styles > Edit Style... #5 modify style as desired and click "Apply" button All labels now have the same style applied to the text. Is that what you are trying to do? On Mon, Jun 8, 2020 at 5:13 PM John Kaufmann wrote: > On 2020-06-08 11:54, Budge wrote: > > Two questions please. > > > > [1] I am using Avery A4 L7161 adhesive labels and have opened using the > new>label option which gives me the grid in which to type the text. Having > selected font and size I find the print is too close to the edge of the > label. How may I adjust the margin between the first line of text and the > actual label edge. I think the word is kerning and I need to move the text > a fraction of the line down on the paper? > > On the Labels Format tab, can you not just increase the Top margin by, > say, a millimeter? > [BTW: I don't think the word you want is kerning, which refers to a > spacing relationship between characters.] > > > > [2] Once I have typed one label and edited it to suit, is there a quick > way to copy the one label to all the labels on the the whole sheet? > > I don't know how easily that is done with LO's Labels function, which is > optimized for merging addresses from a database. Probably someone who uses > labels a lot can chime in on that, but I would probably be inclined to just > format a page with margins of 7.2mm (L/R) and 8.8mm(T/B) and then make a > 3col x 6 row table full-width (66.0mm columns), with row heights 46.5mm. > That would give you easy access to all labels as table cells, so you could > just copy-and-paste quickly. > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Printing 18 labels per sheet on Avery A4 sheet L7161
On 2020-06-08 11:54, Budge wrote: Two questions please. [1] I am using Avery A4 L7161 adhesive labels and have opened using the new>label option which gives me the grid in which to type the text. Having selected font and size I find the print is too close to the edge of the label. How may I adjust the margin between the first line of text and the actual label edge. I think the word is kerning and I need to move the text a fraction of the line down on the paper? On the Labels Format tab, can you not just increase the Top margin by, say, a millimeter? [BTW: I don't think the word you want is kerning, which refers to a spacing relationship between characters.] [2] Once I have typed one label and edited it to suit, is there a quick way to copy the one label to all the labels on the the whole sheet? I don't know how easily that is done with LO's Labels function, which is optimized for merging addresses from a database. Probably someone who uses labels a lot can chime in on that, but I would probably be inclined to just format a page with margins of 7.2mm (L/R) and 8.8mm(T/B) and then make a 3col x 6 row table full-width (66.0mm columns), with row heights 46.5mm. That would give you easy access to all labels as table cells, so you could just copy-and-paste quickly. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Re: Printing 18 labels per sheet on Avery A4 sheet L7161
On 6/8/20 9:54 AM, Budge wrote: Two questions please. I am using Avery A4 L7161 adhesive labels and have opened using the new>label option which gives me the grid in which to type the text. Having selected font and size I find the print is too close to the edge of the label. How may I adjust the margin between the first line of text and the actual label edge. I think the word is kerning and I need to move the text a fraction of the line down on the paper? Once I have typed one label and edited it to suit, is there a quick way to copy the one label to all the labels on the the whole sheet? Grateful for your help please. FWIW, I've given up on all word processors' label function. Especially if the label is one third or two thirds inches high. Never works. Instead, I downloaded the Avery free label printing software program. Works every time. -- Ken MacOS 10.14.6 Firefox 70.0.1 Thunderbird 60.8 "My brain is like lightning, a quick flash and it's gone!" -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Second reply with a REAL answer: WAS: Re: [libreoffice-users] Printing 18 labels per sheet on Avery A4 sheet L7161
Budge wrote: Two questions please. I am using Avery A4 L7161 adhesive labels and have opened using the new>label option which gives me the grid in which to type the text. Having selected font and size I find the print is too close to the edge of the label. How may I adjust the margin between the first line of text and the actual label edge. I think the word is kerning and I need to move the text a fraction of the line down on the paper? Once I have typed one label and edited it to suit, is there a quick way to copy the one label to all the labels on the the whole sheet? Grateful for your help please. I searched one more time and found this useful information ... Navagate: File -> New -> Label and do all the normal stuff including ... Label Tab enter text for label content select sheet select label brand select label type Format Tab probably just leave that stuff alonw Options Tab select entire page check Synchronize Content (the printer and setup can also be done here) Select New document Along with the "new document" you will get a little dialog box for "Synchronize Labels" Now ... edit the top left label to achieve your desired formating, edge spacing, etc. Click on the Synchronize Labels button. Done Here is the URL for the YouTube that supplied this knowledge. https://www.youtube.com/watch?time_continue=278=qP3NCdRlO8Q=emb_logo Hope that helps Regards Fred James -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Printing 18 labels per sheet on Avery A4 sheet L7161
Budge wrote: Two questions please. I am using Avery A4 L7161 adhesive labels and have opened using the new>label option which gives me the grid in which to type the text. Having selected font and size I find the print is too close to the edge of the label. How may I adjust the margin between the first line of text and the actual label edge. I think the word is kerning and I need to move the text a fraction of the line down on the paper? Once I have typed one label and edited it to suit, is there a quick way to copy the one label to all the labels on the the whole sheet? Grateful for your help please. What I have seen so far is that the LO label is intended to print from a database (such as a list of addresses, and doesn't allow for what you desire ... and by the way, I desire. Sorry, I am no help there. There is a way to change the top and right margins, but that is the distance from the top and left edges of the sheet to the top and left edges of the top, left label ... not really a good answer, eh? Assuming that one wants all the labels on a sheet to be identical, all I have ever been able to do is (as you say) format one label as desired, select and copy the desired area of that label, and past that into each of the other labels on the sheet ... one at a time. Not much help there, I am sure ... I wish to know this as well, if there is any way to do this. But thank you for asking ... it prompted me to search once again for the answer, although the answers I found (once again) point to stuff that is not in LO, at least not in the version I have. Possibly out of date answers? Possibly the answer would vary a lot between OS's? Regards Fred James -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Printing 18 labels per sheet on Avery A4 sheet L7161
Two questions please. I am using Avery A4 L7161 adhesive labels and have opened using the new>label option which gives me the grid in which to type the text. Having selected font and size I find the print is too close to the edge of the label. How may I adjust the margin between the first line of text and the actual label edge. I think the word is kerning and I need to move the text a fraction of the line down on the paper? Once I have typed one label and edited it to suit, is there a quick way to copy the one label to all the labels on the the whole sheet? Grateful for your help please. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Behavior that seems ... inconsistant.
This is being offered as a "data point" to the user interface development. It may very well be "as expected" but it seemed odd so I thought I'd mention it to see what other folks thought. Here's a sequence of operations I'll call "Case 1": I create a spreadsheet. Column A starts at a number (i.e. 100) and the rest of the column is "=A1+1" and is filled down using the "Fill Down" menu option. This gives us 100,101,102, etc. At the bottom of this new column, I select the bottom entry, do a "Copy" to the clipboard then go down one cell and "Paste" from the clipboard and the correct value goes in, formatting and all. So far, nothing unusual. Now, "Case 2": I take a second spreadsheet and put my starting number in A1 like before. BUT, now I go to row 2 and select A2..A4 (three rows) and hit the button to "Merge and Center Cells" and now I have a big cell in the second position. I put the same formula in it "=A1+1" and it correctly becomes 101. I select that cell again and do a "Copy" to the clipboard, go down one cell and am now on A5. Note, it skipped to the /next/ cell after this enlarged cell. I "Paste" and it creates a duplicate large cell and puts the adjusted formula in it. From what I can see, the operations are consistant. But, now select ths enlarged cell at "A5" (which is A5, A6, A7) and pull down to A8 and do a "Fill down" and it goes wonky. The cells A6, and A7 suddenly become filled with individual values and the "Merge" done previously goes away. It /seems/ (but I might be wrong) that the behavior should have been to turn A8 and subsequent two more cells into one large cell via an implied Merge and then copied the contents of the cell above it into it adjusting the formula appropriately. Thanks for everyone's time. I hope this is helpful in some way. Version: 6.4.4.2 Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff CPU threads: 8; OS: Mac OS X 10.13.6; UI render: default; VCL: osx; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded -- << MCT >> Michael C Tiernan.http://www.linkedin.com/in/mtiernan Non Impediti Ratione Cogatationis Women and cats will do as they please, and men and dogs should relax and get used to the idea. -Robert A. Heinlein -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy