Re: [libreoffice-users] Business cards
On 10/31/2015 07:57 AM, Regina Henschel wrote: Hi Daniel, Daniel schrieb: Just enquiring, can one instead of writing 4 business cards on one page, (where they are all the same), creating each one differently but on the same page? Daniel You can use File > New > Label. That wizard has the ability to insert fields from a database. You can look through the list, whether a predefined size and layout exists, but it is likely, that you need to define your own card size and page layout manually. Don't worry, it is easy to do. Kind regards Regina Another possibility, if you are using linux, is glabels. I use it for spice jar labels and have many different labels on one sheet. -- 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] How to change the line color of the comments once and for all
On 05/21/2015 04:13 AM, Michael Wu wrote: Dear all, In Libreoffice Calc 3.6, the line color of the comments is black. But in Libreoffice Calc 4.3.7, the color is changed. Although we can change the color back to black by Right click the comment -- click [Line] -- change the color, it is really troublesome for all the calc files. Please help to give the setting that we can do once and for all. Thank you and best regards. Michael Have you tried OPTIONS LIBREOFFICE APPEARANCE ? -- 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] Ready-to-use solutions to manage membership + inventory?
On 05/17/2015 06:07 AM, Gilles wrote: Hello Someone I know heads a non-profit organization, and needs a small database to manage membership and inventory (stock). Before building new databases, are there ready-to-use solutions? Thank you. -- View this message in context: http://nabble.documentfoundation.org/Base-Ready-to-use-solutions-to-manage-membership-inventory-tp4148774.html Sent from the Users mailing list archive at Nabble.com. Also, what OS are you using? Windows, Apple, Linux, Android, iWhatever? -- 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] Ready-to-use solutions to manage membership + inventory?
On 05/17/2015 06:07 AM, Gilles wrote: Hello Someone I know heads a non-profit organization, and needs a small database to manage membership and inventory (stock). Before building new databases, are there ready-to-use solutions? Thank you. -- View this message in context: http://nabble.documentfoundation.org/Base-Ready-to-use-solutions-to-manage-membership-inventory-tp4148774.html Sent from the Users mailing list archive at Nabble.com. By Membership, do you mean staff or clients? Inventory? What the organization owns (computers, chairs, etc)? What it gives away (clothes, food, money? What it sells (like a charity store)? -- 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] converting txt to dates
On 19/03/15 08:28 PM, James wrote: Column A has text strings that are DD/MM/ format. I want to make them real dates. I tried these 2 datevalue formulas but I can't make it work. 14/03/2015Err:502 14/03/2015Err:502 =DATEVALUE(TEXT(A1,##/##/)) =DATEVALUE(A2) Highlight the cells Right click FORMAT CELLS NUMBERS tab In the FORMAT CODE block at the bottom, put DD/MM/ -- 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] Graphical Borders in Writer
On 14/03/15 10:34 AM, Gordon Burgess-Parker wrote: I'm using LO 4.4.0.3 on Xubuntu 14.10. I would like to create a document in Writer with a graphical border. Is there any way of doing this? Thanks Gordon FORMAT PAGE BACKGROUND as GRAPHIC Fiddle from there. Reset your margins to compensate for the graphic. You may need to open a graphic program and resize the image to your page size (8.5x11 or whatever). A lot depends on how your printer handles printing to the edges of the paper. Mine will print to left-right fine but always leaves 1/2 in on top-bottom. Therefore, I need something with white at the top bottom to look right. -- 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] Romove all pictures
There are times when I copy paste from websites to Calc. Things like lists of TV stations or Twitter followers. When I do so it also captures all the images and pastes them to the document. This causes a big mess since most of the images cover each other and do not align with their respective text entry. I have to click them one by one and delete them. With a big list this takes a lot of time. Is there a way of removing all images at once? -- 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] Font color based on value
Thanks! For others, I've screen captured one set of conditions to show what I did. I had to set the lower limit to include ABOVE 1 so that empty cells wouldn't turn red. I also set a style for normal entries to ensure they didn't change color somehow. On 16/01/15 01:12 AM, Brian Barker wrote: At 22:37 15/01/2015 -0700, Emil Payne wrote: I'm a home user without a lot of spreadsheet experience. No worries! I have a graph with several lines. I'd like line 1 set so that when I enter a value in the box, that value would stay black if between an upper and lower limit (e.g. 50-100) and to change to a red font if outside that limit. Then line 2 would have a different set of limits as would line 3. Is this possible to automate? At 22:40 15/01/2015 -0700, Emil Payne wrote: Sorry, I meant to insert an image. The red at the top is just a reminder to me of what the limits are. At 22:46 15/01/2015 -0700, Emil Payne wrote: I might as well add the chart too. You can see the mean average of the red graph at 184 (currently). Your first image is of a range of cells but you start by referring to a chart. If you are talking about setting the colour of lines on a chart, I don't see any way to automate that. But I'm guessing that you want the values you enter in cells (not boxes) to assume different text colours depending on their values. That's possible. o Select each range of cells to which you want this aspect to apply and go to Format | Conditional Formatting... . Color scale will give you background colours, but for text colours you probably need Condition. o Set the required conditions for data values. o Select cell styles appropriately - either from existing styles or using the New Style facility to create them on the fly. Text colour is selected on the Font Effects tab of the Cell Style dialogue. Note that - as you require - you can set different conditions for different ranges of data cells, reusing existing cell styles or creating new ones as preferred. 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
[libreoffice-users] Using mean Average in formula
I'm a home user with not a lot of spreadsheet experience. I've got a graph that includes a mean average line. I'd like to take the value of that line (e.g. MV=180) and use it in a formula (e.g. x=4*MV+16) and use that answer to populate a field. How do I get MV into the formula? -- View this message in context: http://nabble.documentfoundation.org/Using-mean-Average-in-formula-tp4136259.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] Font color based on value
I'm a home user without a lot of spreadsheet experience. I have a graph with several lines. I'd like line 1 set so that when I enter a value in the box, that value would stay black if between an upper and lower limit (e.g. 50-100) and to change to a red font if outside that limit. Then line 2 would have a different set of limits as would line 3. Is this possible to automate? I'm doing it by hand right now. -- View this message in context: http://nabble.documentfoundation.org/Font-color-based-on-value-tp4136260.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: Font color based on value
Sorry, I ment to insert an image. The red at the top is just a reminder to me of what the limits are. http://nabble.documentfoundation.org/file/n4136261/23.png -- View this message in context: http://nabble.documentfoundation.org/Font-color-based-on-value-tp4136260p4136261.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: Font color based on value
I might as well add the chart too. You can see the mean average of the red graph at 184 (currently). http://nabble.documentfoundation.org/file/n4136262/07_PM.png -- View this message in context: http://nabble.documentfoundation.org/Font-color-based-on-value-tp4136260p4136262.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: Using mean Average in formula
Here is a screenshot of the graph I have. Notice the mean value line currently located at 184 on the Y axis. http://nabble.documentfoundation.org/file/n4136263/07_PM.png -- View this message in context: http://nabble.documentfoundation.org/Using-mean-Average-in-formula-tp4136259p4136263.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
