Re: [libreoffice-users] Calc formula ...
Brian Barker b.m.bar...@btinternet.com wrote: At 10:28 11/03/2015 +1300, David Love wrote: What I want, in simple terms, is to determine the average number of steps I am taking every week. Hopefully, this explanation will answer the questions reaided. Not really! I think you've confirmed that the 1 figure is irrelevant in the calculation. But your earlier statements that if day 1 reaches a production of 10,000 units I want this figure entered and If days 1+2+3+4 total, say, 42,500 I want ... to show the average of 10,265 both indicate that the required result does not depend on other daily values. These contradict the idea that you simply want the true average of all seven values. Unsurprisingly, you can calculate averages using the AVERAGE() function. Incidentally, doesn't all this cry out for a table instead of a list? Put a week date (or date range) in column A, as you suggest. Enter your data for the days of that week in columns B to H of the same row. It's then particularly simple to calculate averages in column I. At the bottom of the columns, you could calculate averages for each weekday - and perhaps discover that you need to be more active on Thursdays! Ha! I constructed a table, as you suggested and, yes, it does meet my requirements. Thanks for the suggestion, Brian. David -- David Love Dogs wag their tail with their whole heart. -- 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] Calc formula ...
Using LinuxMint v17.1 Rebecca with MATE DE and LibreOffic v4.2.7.2 Build ID 420M0(Build2) I have a three column spreadsheet. Column A. Date - The dates are consecutive Column B. Production - The Production has a daily target of 10,000 units and each production period is of seven days. Column C. a formula every seventh cell. Is it possible to construct a formula which will show in the seventh cell of column C the average for the number of days of production i.e. if day 1 reaches a production of 10,000 units I want this figure entered into the seventh cell in column C. If days 1+2+3+4 total, say, 42,500 I want the seventh cell in column C to show the average of 10,265. In other words I want the average shown for the actual days of production each seven day period. DL -- David Love Can atheists get insurance for acts of God? -- 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] Emailing documents...
Tom Davies tomc...@gmail.com wrote: On 23 October 2014 05:12, David Love z...@zed.net.nz wrote: Using LO v4.2.6.3 on LinuxMint v17 Qiana MATE. I have two email clients on the computer. Thunderbird, which is set up for my wife's use, and MessengerPro which I use. LO has been set up to point to MessengerPro /usr/local/bin/messengerpro for sending documents by email but does not honour that path, inasmuch as it opens Thunderbird each time. My wife does not have a user account on the computer and I have not set one up as it would confuse her. She only uses the computer for email, browsing the internet and playing card games. LinuxMint Control Panel contains a Preferred Applications facility but the only choices in Email are Thunderbird and KMail. Is anyone able to suggest how I may solve the problem, please? Hi :) Does Chapter 10 in the Getting Started guide help at all? https://wiki.documentfoundation.org/Documentation/Publications Unfortunately. no! Hopefully someone else can give a more tailored answer or maybe just ask the right questions in order to incover the answer. Good luck and regards from Tom :) I hope so, too. I have put this problem to the LionuxMint Forum, too, but as it appears to be a LO probable,m in not heeding the correct path, I thought this mailing list was the more appropriate place. David -- David Love Do more than anyone expects, and pretty soon everyone will expect more -- 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] Emailing documents...
Using LO v4.2.6.3 on LinuxMint v17 Qiana MATE. I have two email clients on the computer. Thunderbird, which is set up for my wife's use, and MessengerPro which I use. LO has been set up to point to MessengerPro /usr/local/bin/messengerpro for sending documents by email but does not honour that path, inasmuch as it opens Thunderbird each time. My wife does not have a user account on the computer and I have not set one up as it would confuse her. She only uses the computer for email, browsing the internet and playing card games. LinuxMint Control Panel contains a Preferred Applications facility but the only choices in Email are Thunderbird and KMail. Is anyone able to suggest how I may solve the problem, please? David -- David Love Divorce, n. The past tense of marriage -- 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] LibreOffice - Base...
David Love z...@zed.net.nz wrote: Using LinuxMint v17.0 Qiana qith the MATE DE. Have followed with interest the recent discussins on Base and have decided to try and learn how to use it, using PostGreSQL as the backend. But - and there is always one of those :-) - how many of the multitude of postgrsql files in Synaptic do I need to install, please. Thank you NoOp, Wolfgang Keller and Alex Thurgood for your prompt and helpful suggestions. I have downloaded amd installed all the files suggested and will now read the documentation to see whether my geriatric brain can understand it. Will report back in due course.. David -- David Love COMPUTER LITERACY? You mean my computer can READ?! -- 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] LibreOffice - Base...
Using LinuxMint v17.0 Qiana qith the MATE DE. Have followed with interest the recent discussins on Base and have decided to try and learn how to use it, using PostGreSQL as the backend. But - and there is always one of those :-) - how many of the multitude of postgrsql files in Synaptic do I need to install, please. David -- David Love Oxymoron: smokeless cigarette -- 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: Spell Check Dictionary
MR ZenWiz mrzen...@gmail.com wrote: The longest word in any English language is the name of a small town in Wales - Llanfairpwllgwyngyllgogerychwyrndrobwyantysiliogogogoch (see Wikipedia if you're curious about what and where this is). I had thought it was 56 letters, but this one is 59. Hmm. Sorry, that's the second longest. The longest is in the North Island of New Zealand. Taumatawhakatangihangakoauauotamateaturipukakapikimaungahoronukupokaiwhenuakitanatahu (85 letters) which means The summit where Tamatea, the man with the big knees, the climber of mountains, the land-swallower who travelled about, played his nose flute to his loved one See http://en.wikipedia.org/wiki/List_of_long_place_names David -- David Love Dogs think they are human. Cats believe they are God -- 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: Can't open the file which is exported from crastal report
peterhuang peter_hu...@zippy.com.tw wrote: Thanks your very much. the file link as below http://forum.openoffice.org/zh/forum/download/file.php?id=941 I think it is just a regular doc file, and it is exported from crystal report. Our company are looking for a good office software to replace MS-OFFICE 2003, and our ERP system is using crystal report to output doc file. My os is windows 7 64 bit (traditional chinese), and libreoffice is version 4.1.1.2. the openoffice version is 3.1.4 I downloaded this file and saved it to my local document folder. but the situation is the same. I can open it by openoffice, but it doesn't work on libreoffice. Using LinuxMint x64 and LlibreOfficeVersion 4.0.2.2 (Build ID: 400m0(Build:2)) File opens without any problem. However, I cannot read it as I haven't got the appropriate fonts loaded. Looks as if it might be a LibreOffice/Windows problem. David -- David Love Can it be a coincidence that STRESSED is DESSERTS spelled backwards -- 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: Sequentially numberted tickets...
Hi Nino Nino Novak nn.l...@kflog.org wrote: Am 08.08.2013 06:53, schrieb David Love: I have been asked to design and print numbered tickets for an event being organised by a Club to which my wife belongs. How I'd do it (it's from memory, so bear with me for little glitches): Thank you for the prompt reply and my apologies for the delay in replying to you. 1. Set up a Calc spreadsheet and enter a header (e.g.number) and the desired numbers (1 to 150 or even 001 to 150 by chosing a custom number format with two preceeding zeroes) into a column Did that without problems. 2. design a nice text page with all 4 tickets in it (you could also try going with labels but for just 4 tickts per page I'd rather go with copypaste instead of fumbling with labels) O.K. Although I did have some trouble grouping all elements. 3. assign the spreadsheet from #1 as data source (for later use as mailmerge, from memory: File New Database connect to existing spreadsheet) Perfect! 4. on your above designed ticket page, press F4 to open the spreadsheet from above as data source No problem. 5. enter (simply dragdrop) column header field into the appropriate place in stub and repeat this for the ticket Went without a hitch. 6. after every SECOND field enter next record switch (Insert field others database next record) but NOT after the fourth ticket (as a page break always triggers a next record switch) This is where I've gone wrong and I cannot figure out how. As I understood it, on the stub and ticket of tickets number 2, 3, 4, I do what you suggest above. Is that correct? and then, as it will be a new page, the numbering will continue in sequence until we reach the end of the records. Is that correct 7. Print as mailmerge (or form letter or whatever it's called) into 1 document I do this by Printing to file. The first ticket is correct. Tickets number 2, 3 and 4 are not numbered. It then goes to the next page where the first ticket is numbered 2 and the other three are not numbered. And so it goes on until the end of the records. Each page is the next number. I notice that when I have Next Record highlighted and click Insert, all that happens is a thin grey vertical line appears where I click. I would have thought the words next record would have appeared. Am I wrong? 8. review the document and if necessary correctrepeat some of the above steps I am at a loss as to what I should do next. 9. print the merged documents, 10. enter perforation (I use a sewing machine, works perfectly if you use a thin needle and adjust the step width appropriately) 11. cut tickets apart :-) Enjoy learning ;-) My enjoyment is leading to grinding of teeth in frustration David -- David Love A running mate is a husband who dared to talk back -- 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 - selecting all items...
In most Linux programs, holding down the Ctrl key and pressing A selects all items but this does not appear to work in Writer. Am I missing something? I have looked in Help but cannot find anything to assist. Can someone lead me in the right direction, please? David -- David Love Use what talent you possess. The woods would be very silent if no birds sang except those that sang best. -- 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 - grouping objects...
How do I select all frames and Group them, please. Whatever I do, the Group item in FormatGroup is greyed out. I cannot find anything aplicable in the Help File. Can someone point me in the right direction, please? David -- David Love CURSOR: An expert in four-letter words. -- 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] Writer - selecting all items...
Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Ctrl A usually works. Have you selected 1 things and then pressed Ctrl A to select all the rest? But doesn't in this case. Yes, have tried by selecting single frame and then pressing Ctrl A to select all the others. Same result - doesn't select the remainder. Is this related to the other question? If you have loads of shapes and text-boxes and things it might be better to copyPaste those into a Draw document to do all this sort of thing Regards from Tom :) If you mean the one about Grouping, then Yes. Did as you suggested but ran into some difficulties. Only the first two lines of each text frame (total 2) were pasted into Draw (although the frame was the correct size. Then created the whole item in Draw. That was successful. Copied and pasted to Write and found that I couldn't then enter a frame into which I can insert a database field. This is all tied up with my previous posting seeking advice regarding sequential numbering of tickets. What I'm trying to do is avoid the necessity of having to create the number of tickets I need and typing the number on each one. At 100 - 150 tickets that is very laborious :-( David -- David Love Not a morning person' doesn't even BEGIN to cover it... -- 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: Sequentially numberted tickets...
Nino Novak nn.l...@kflog.org wrote: Hi David, Am 08.08.2013 06:53, schrieb David Love: I have been asked to design and print numbered tickets for an event being organised by a Club to which my wife belongs. How I'd do it (it's from memory, so bear with me for little glitches): 1. Set up a Calc spreadsheet and enter a header (e.g.number) and the desired numbers (1 to 150 or even 001 to 150 by chosing a custom number format with two preceeding zeroes) into a column [snip] Thanks, Nino. I will give it a go and report back. David -- David Love Do more than anyone expects, and pretty soon everyone will expect more -- 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] Sequentially numberted tickets...
I have been asked to design and print numbered tickets for an event being organised by a Club to which my wife belongs. Starting from the left edge: (a) in the first third details of the event and a number. This is the stub (b) in the remaining two thirds there is an image to the left and then details of the event. This is the ticket (c) each ticket has two numbers (both the same) printed to justify right on the stub and on the ticket (d) each ticket spans the width of an A4 page (f) there are four tickets to an A4 page (g) the ticket will be perforated between the stub and the ticket to allow for easy detachment (h) Designing the ticket is not a problem. But how do I ensure that the numbers are printed sequentially in groups of two? Is it possible to do this on LibreOffice? I realise that it is possible to number each ticket on a A4 page and then print it but as it is looking like 150 tickets that looks like a lot of work. David -- David Love A lie gets halfway around the world before the truth has a chance to get its pants on. -- 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