Re: [libreoffice-users] news about LibreOffice
Hi :) Being wiki-pages means it's possible for anyone to contribute. I like the variety of having some articles quite long but others being just really tiny snippets. So far it's all the work of just 1 chap but i am sure he would be willing to help people with wiki-mark-up if they did join in with things. Also there are other people here and on the Documentation Team's mailing list who would be able to help. Another option is for people to quietly post their items and then leave it for the main man to find them and do some styling. Regards from Tom :) On 23 July 2014 20:32, M Henri Day mhenri...@gmail.com wrote: 2014-07-23 18:10 GMT+02:00 Tom Davies tomc...@gmail.com: Hi :) Wow!! Just found this excellent page https://wiki.documentfoundation.org/LOWN/3 by William Gathoye It is not always 100% perfect English but it's a great read and has some quite compelling sections. For example; https://wiki.documentfoundation.org/LOWN/3#LibreOffice_for_Mobile_will_be_soon_a_reality which i really hadn't realised at all. I thought there was a major blocker preventing this and that on-top of having to re-write 100% of the coding first. However it now seems that only 10% of the code needs re-writing! The UI issue seems a lot less of a problem too! I wish that instead of the issues being 1, 2, 3 they gave the date, perhaps in reverse order such as 2014-07-07 2014-07-14 2014-07-21 but it is MUCH easier to see those things in hindsight and it probably wouldn't have occurred to me at the time either. Luckily it is fairly easy to set-up new pages, copypaste contents and then set-up redirects from the old pages. The bit i never figure out is how to get the table-of-contents at the beginning of the page. Just out of curiosity can it be floated off to a different side? (Even if it can it's probably better to keep it where it is to make it consistent with the other wiki-pages) It looks like a huge amount of work has gone into this and it's really great to see it collect together information from so many mailing lists. Good work William! Regards from Tom :) It does indeed look like an excellent source of information, Tom - thanks for the heads-up ! Henri -- 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] Cannot change spacing in Math
Hi :) Sadly attachments don't reach all the people on the mailing list. You can upload it somewhere and give us a link. Nabble is a good way of doing it because it injects the right coding directly into the message-box for you and lets you edit it or move it around. To get to Nabble from the main LibreOffice site go through the getting help page and somewhere around where it talks about mailing-lists it gives a link to Nabble. Regards from Tom :) On 23 July 2014 20:21, v...@ukr.net wrote: Hello! I have a problem: it is impossible to reduce the spacing in the LO Math settings. I go to Format -- Spacing... , then choose Borders in the Category drop-down list, and see that the settings are: Left: 125.93mm Right: 249.32mm Top: 249.37mm Bottom: 1.03mm and I cannot reduce them (see attached screenshot). Is this a bug? And what is more important -- is there a way out of this terrible situation? Regards, Vladimir - v...@ukr.net -- 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
Re: [libreoffice-users] news about LibreOffice
Hello there, The goal of LOWN (it might become a monthly thing) is to collaboratively edit news of the project for project members. People are welcome to join the effort :-) Best, Charles. On 23 juillet 2014 21:54:04 CEST, Tom Davies tomc...@gmail.com wrote: Hi :) Being wiki-pages means it's possible for anyone to contribute. I like the variety of having some articles quite long but others being just really tiny snippets. So far it's all the work of just 1 chap but i am sure he would be willing to help people with wiki-mark-up if they did join in with things. Also there are other people here and on the Documentation Team's mailing list who would be able to help. Another option is for people to quietly post their items and then leave it for the main man to find them and do some styling. Regards from Tom :) On 23 July 2014 20:32, M Henri Day mhenri...@gmail.com wrote: 2014-07-23 18:10 GMT+02:00 Tom Davies tomc...@gmail.com: Hi :) Wow!! Just found this excellent page https://wiki.documentfoundation.org/LOWN/3 by William Gathoye It is not always 100% perfect English but it's a great read and has some quite compelling sections. For example; https://wiki.documentfoundation.org/LOWN/3#LibreOffice_for_Mobile_will_be_soon_a_reality which i really hadn't realised at all. I thought there was a major blocker preventing this and that on-top of having to re-write 100% of the coding first. However it now seems that only 10% of the code needs re-writing! The UI issue seems a lot less of a problem too! I wish that instead of the issues being 1, 2, 3 they gave the date, perhaps in reverse order such as 2014-07-07 2014-07-14 2014-07-21 but it is MUCH easier to see those things in hindsight and it probably wouldn't have occurred to me at the time either. Luckily it is fairly easy to set-up new pages, copypaste contents and then set-up redirects from the old pages. The bit i never figure out is how to get the table-of-contents at the beginning of the page. Just out of curiosity can it be floated off to a different side? (Even if it can it's probably better to keep it where it is to make it consistent with the other wiki-pages) It looks like a huge amount of work has gone into this and it's really great to see it collect together information from so many mailing lists. Good work William! Regards from Tom :) It does indeed look like an excellent source of information, Tom - thanks for the heads-up ! Henri -- 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 -- Envoyé de mon téléphone avec Kaiten Mail. Excusez la brièveté. -- 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] a step in the right direction
As I understand it this is now official government procedure, ie law. Isn't that the case? I also understand that not all government necessarily wants to abide by its own laws, but this directive seems to be binding. Or have I misunderstod the intention? Mark Stanton One small step for mankind... -- 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] scale a Writer document to print on one page
Hello, Also you may have a scale option in your printer driver. But this is vendor dependent. We have this option in Canon drivers for iRC5045, but not for Xerox WorkCenter 5330 (our photocopiers/printers). The PDF option is 2 steps but universal, as Preview.app will then be able to scale down your document without problems. Cheers, Vitorio Delage Académie nationale de médecine Gestion du parc informatique Le 24 juil. 2014 à 03:10, Steve Edmonds steve.edmo...@ptglobal.com a écrit : Hi. May not be the most elegant way, but use the PDF button to create a PDF and print that to one page. Steve On 2014-07-24 12:55, Truett Bobo wrote: I have a Writer document 22” by 17” (landscape) that I would like to print on one page. How can I scale it to accomplish this? I am using the latest versions of Mac OS and LibreOffice. Any help will be greatly appreciated. -- 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] Calc charts, data in record form
All, Looks like I will be keeping my data in Calc for a while - until we have a better idea of what we want (changing a database is a lot of work). However, I need to do some charts, and I have not figured out how to get Calc to give me what I want, so I need a pointer or two. I want line charts, with multiple curves per axis (up to 8). Perhaps something like this: http://www.indiabix.com/data-interpretation/line-charts/ The data is arranged in record format like this: Date Location TemperatureHumidity - - -- - 7/1/14Syracuse 71 79% 7/1/14Albany68 70% 7/1/14Rochester 69 70% 7/8/14Syracuse 82 68% 7/8/14Albany79 67% 7/8/14Rochester 75 66% So how do I end up with one chart that shows three curves for the three cities over time (Location and Date on the X-axis, Temperature on the Y-axis)? I have looked at the docs amd did some Googling, but so far I'm stumped. I know that someone has done this, so there is likely a very easy want to do it. Dave. -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Does exactly what it says on the tin -- 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] Calc charts, data in record form
At 10:37 24/07/2014 -0400, Dave Boland wrote: ... I need to do some charts, and I have not figured out how to get Calc to give me what I want, so I need a pointer or two. I want line charts, with multiple curves per axis (up to 8). Perhaps something like this: http://www.indiabix.com/data-interpretation/line-charts/ The data is arranged in record format like this: Date Location TemperatureHumidity - - -- - 7/1/14Syracuse 71 79% 7/1/14Albany68 70% 7/1/14Rochester 69 70% 7/8/14Syracuse 82 68% 7/8/14Albany79 67% 7/8/14Rochester 75 66% So how do I end up with one chart that shows three curves for the three cities over time (Location and Date on the X-axis, Temperature on the Y-axis)? Er, you presumably want just the date on the horizontal axis, with locations represented by separate lines. What you need to do is to assemble a table in an appropriate fashion for a chart to be possible. You will probably want four columns - for dates and the three locations - with the temperature values in the body of the table. That way, there would be one row for each date. Creating the chart from this would be simple. So how to achieve that table? Well, one way would be simply to enter the data that way in the first place. However the data arises, it may be most convenient to massage it into the required form as you enter it. Note that the way you are currently entering data, you have each date entered three times and each location very many times. That's never a good idea. How many weeks before you enter Sryacuse by mistake? Alternatively, you can simply extract what you need from your existing table into the required one. Your date column would be entered manually or - better if appropriate - filled down from the first two weeks' dates. The body of the table would then have formulae which retrieved the appropriate data from the original table. You might be able to do this using the VLOOKUP() function, but it won't be simple, as you have two conditions to search for: date and location. The simplest solution might be to sort your original table by location (or you could enter the data into three tables in the first place), and then to use VLOOKUP() to search for the appropriate date and harvest the temperature value from within just the relevant part of the original table - that now containing the values for each location. It's probably very much easier if you create three tables in the first place - one for each location. http://www.fastmail.fm - Does exactly what it says on the tin Really? So it sends your mail more quickly than other systems? Wow! 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] Calc charts, data in record form
On Thu, Jul 24, 2014, at 12:33 PM, Brian Barker wrote: At 10:37 24/07/2014 -0400, Dave Boland wrote: Er, you presumably want just the date on the horizontal axis, with locations represented by separate lines. What you need to do is to assemble a table in an appropriate fashion for a chart to be possible. You will probably want four columns - for dates and the three locations - with the temperature values in the body of the table. That way, there would be one row for each date. Creating the chart from this would be simple. So how to achieve that table? Well, one way would be simply to enter the data that way in the first place. However the data arises, it may be most convenient to massage it into the required form as you enter it. Note that the way you are currently entering data, you have each date entered three times and each location very many times. That's never a good idea. How many weeks before you enter Sryacuse by mistake? Alternatively, you can simply extract what you need from your existing table into the required one. Your date column would be entered manually or - better if appropriate - filled down from the first two weeks' dates. The body of the table would then have formulae which retrieved the appropriate data from the original table. You might be able to do this using the VLOOKUP() function, but it won't be simple, as you have two conditions to search for: date and location. The simplest solution might be to sort your original table by location (or you could enter the data into three tables in the first place), and then to use VLOOKUP() to search for the appropriate date and harvest the temperature value from within just the relevant part of the original table - that now containing the values for each location. It's probably very much easier if you create three tables in the first place - one for each location. Brian, Thanks for the insight. The way the data is set up is legacy in that it is from a form used previously. The intent was to create database-like records where data from 12 cities is updated each week. To help eliminate entry mistakes, I use validation so Syracuse never becomes something else. I have made some progress playing with chart settings, but still not where I need to be. I will give the lookup functions a try. Dave, -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Access your email from home and the web -- 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] scale a Writer document to print on one page
On Wed, 23 Jul 2014 17:55:21 -0700 Truett Bobo beaube...@cheerful.com wrote: I have a Writer document 22” by 17” (landscape) that I would like to print on one page. How can I scale it to accomplish this? I am using the latest versions of Mac OS and LibreOffice. Any help will be greatly appreciated. This will depend on your printer. I can't give specific advice regarding Mac OS as I use Linux but their MAY be a scaling menu in the printer driver. The scale ratio would be 2:1. 22 x 17 (tabloid) paper is twice the size of 11 x 8.5 (letter) paper. Discrepancies in driver software may require a bit of experimentation to determine what would fit best. Tom -- To be free is not merely to cast off one's chains, but to live in a way that respects and enhances the freedom of others. - Nelson Mandela ^^ --... ...-- / -.- --. --... -.-. ..-. -.-. Tom Taylor KG7CFC openSUSE 13.1 (64-bit), Kernel 3.11.6-4-default, KDE 4.11.2, AMD Phenom X4 955, GeForce GTX 550 Ti (Nvidia 337.19) 16GB RAM -- 3x1.5TB sata2 -- 128GB-SSD FF 27.0, claws-mail 3.10.0 registered linux user 263467 -- 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] a step in the right direction
HI :) I don't think it's law. I think it's suggested best-practice and general guidelines. A bit like the Ferengi's Rules of Acquisition or the pirate's code, hopefully. Plenty of people will argue against using it, or make excuses or plead ignorance or just not do it = However it's still a fantastic step forwards and one i never expected to see. I'm still kinda in shock about it tbh. Did anyone else here manage to make comments during the public consultation phases? I made a 'few' at the first one but then the whole proposal vanished from view so i thought it would be the usual story. I think maybe people at MS haven't realised what it means or they underestimated it or something. I really don't understand why they didn't bulldoze it out of the way or turn it upside down by bamboozling non-IT people in government. Like i say i am pleasantly shocked and that makes me question about how effective it's likely to be in getting people to use formats that can be used by different programs on different platforms and on into the future. Maybe i am just too old and cynical but it's a bit weird to see a government doing the right thing!! Regards from Tom :) On 24 July 2014 09:08, Mark Stanton m...@vowleyfarm.co.uk wrote: As I understand it this is now official government procedure, ie law. Isn't that the case? I also understand that not all government necessarily wants to abide by its own laws, but this directive seems to be binding. Or have I misunderstod the intention? Mark Stanton One small step for mankind... -- 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
Re: [libreoffice-users] scale a Writer document to print on one page
Hi :) Is that 22 inches by 17 inches??!!?? That is a huge document! Is it huge and trying to print to hundreds of pages or does it just go over a little bit and try to print to 4 or less pages? Print Preview is handy for figuring that out. If it is just a little bit over then simply choosing a different page-size might do the trick. From the menus; Format - Page - Page (it's about the 2nd tab in the pop-up) then the drop-down menu at the very top should say something like US Letter or A4 It is probably on US Letter and just needs to be changed to A4. For some reason computers set-up throughout the rest of the world (well, at least quite a few places but NOT everywhere) are all set to the US Letter despite that size paper only being available in the US (and maybe Canada but not many other places). The entire rest of the world (ok, again probably not absolutely everywhere) have agreed to standardise on A4 and metric systems. A4 is roughly 12 by 8 (more precisely it's 11.69 by 8.27) = or in metric systems that is 29.7cm by 21cm A3 is roughly 18 by 12 and LibreOffice doesn't easily let me go to A2 or larger unless i could create my own customised size that large. Recently i had to shrink an A4 down to A5 and stumbled around a bit. Eventually copying it all into Draw and then selecting everything on the page allowed me to grab the green corner and resize everything. Using the Shift key when resizing makes the aspect-ratio stay the same so the text and images don't get warped. This worked really well with all the various images in my poster but i think i had done something wrong with my text-frames in Writer as i then had to select each line of text, right-click and choose Size and position (or something) and then untick the 2 boxes that force the text to stay the same absolute size and then tick the box that let them change size according to the size of the frame they were in. Luckily i only had 27 lines to do so it was fairly quick but i've been meaning to write in to find out what i had done wrong, or rather to find out how to do the right thing in the first place to make text-frames resize properly. Regards form Tom :) On 24 July 2014 09:29, Vitorio Delage v.del...@academie-medecine.fr wrote: Hello, Also you may have a scale option in your printer driver. But this is vendor dependent. We have this option in Canon drivers for iRC5045, but not for Xerox WorkCenter 5330 (our photocopiers/printers). The PDF option is 2 steps but universal, as Preview.app will then be able to scale down your document without problems. Cheers, Vitorio Delage Académie nationale de médecine Gestion du parc informatique Le 24 juil. 2014 à 03:10, Steve Edmonds steve.edmo...@ptglobal.com a écrit : Hi. May not be the most elegant way, but use the PDF button to create a PDF and print that to one page. Steve On 2014-07-24 12:55, Truett Bobo wrote: I have a Writer document 22” by 17” (landscape) that I would like to print on one page. How can I scale it to accomplish this? I am using the latest versions of Mac OS and LibreOffice. Any help will be greatly appreciated. -- 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 -- 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] Cannot change spacing in Math
Thank you, Regina! Indeed my problem looks exactly as it is described in those bug-reports. I still use the 4.2.3.3 version. I'll try to update as soon as possible. Vladimir On Thu, 24 Jul 2014 01:22:55 +0200 Regina Henschel rb.hensc...@t-online.de wrote: Which version do you use. There was the bug https://bugs.freedesktop.org/show_bug.cgi?id=75525 and the bug https://bugs.freedesktop.org/show_bug.cgi?id=77706. - electric_real...@ukr.net -- 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] MAIL MERGE: Default fields Topic and Subject are only printed in first document
Hi, I've some trouble with the default fields Topic and Subject of the document properties. They are only printed in the first mail merge document if I set the field to the document. At the following documents there are only whitespace. Can anyone confirm my problem? Is it a bug or a misused by myself? regards Sven -- 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] scale a Writer document to print on one page
On 07/24/2014 07:35 AM, Tom Davies wrote: Hi :) Is that 22 inches by 17 inches??!!?? /snip/ 22x17 is what we call in the US B-size. 8½x11 is A-size, and B-size is just twice that. C-size is twice B-size, and so on up thru E-size, then the system is modified. Probably the output is meant for a printer that can print B-size. Or a plotter. --doug -- 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