Re: [libreoffice-users] Calc: help with VLOOKUP
Le 14/02/2014 23:06, Carl Paulsen a écrit : > > A few hints for vlookups: I find I usually want to add "hard" > references for the array so that it always looks at the intended rows of > the array. To do that, you need to add $ before each cell reference in > the array. So if the array of the function is A1:C100, I enter it as > $A$1:$C$100. This forces vlookup to always look at those cells > regardless of what row the calculation is happening on. Another way of achieving that is to name the array. This has my preference because a named array makes formulae easier to understand. > > Finally, be mindful of the implications of the sort order variable in > the function. If it is 1 or TRUE, the array must be sorted ascending, > and the function returns the nearest value "below" or "before" the > looked up value. If you want to force it to return only exact matches > and/or don't want to or can't sort the array, be sure to set sort order > to 0 or FALSE. +1 to all of these. The 0 (FALSE) parameter is the one I always use by default for the reason you stated (getting an error when no match is found). -- Jean-Francois Nifenecker, Bordeaux -- 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] Change character attributes
Right!! Format > Character > Effects Thanks. Dave Liesse has written on 2/14/2014 8:36 PM: > Pikov, > > This is an option in the Format menu. > > Dave > > > On 2/14/2014 17:30, Pikov Andropov wrote: >> Some word processors permit you to select a bunch of character and >> change the case. >> >> I couldn't find that in LO. I sit in fact there? >> >> Thanks. -- 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] Change character attributes
Pikov, This is an option in the Format menu. Dave On 2/14/2014 17:30, Pikov Andropov wrote: Some word processors permit you to select a bunch of character and change the case. I couldn't find that in LO. I sit in fact there? Thanks. -- 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] Change character attributes
Some word processors permit you to select a bunch of character and change the case. I couldn't find that in LO. I sit in fact there? Thanks. -- 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: Problems between LO and CUPS
Malcolm Moore wrote > LO connects to CUPS on start not when you want to print. So if you have LO > open for a while the connection to CUPS will time out. You need to set > your CUPS timeout short enough so that it will time out eventually but > long enough so that CUPS doesn't drop the connection in normal use. This is bug fdo#56344 which appears to have been resolved in CUPS v1.7.0: https://bugs.freedesktop.org/show_bug.cgi?id=56344 The problem as originally reported in this Users mailing list thread /may/ be related. If it is, then upgrading to a newer CUPS version will be required as the problem was not with LO. Best wishes, Owen. -- View this message in context: http://nabble.documentfoundation.org/Problems-between-LO-and-CUPS-tp4097212p4097305.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: status of Microsoft Office compliance with ODF support?
Jay Lozier wrote > MSO 2010 and earlier did not support ODF 1.2 only ODF 1.1. I saw > somewhere that ODF 1.2 is supported in MSO 2013/Office 365. The official statement was made on the MS Office blog in August 2012: http://blogs.office.com/2012/08/13/new-file-format-options-in-the-new-office/ The "New Office" referred to is MS Office 2013. ODF v1.1 can be opened, edited, and saved under MS Office 2007 + Service Pack 2 and MS Office 2010. This format can also be opened and edited under MS Office 2013. ODF v1.2 can only be opened, edited, and saved under MS Office 2013. The current ODF v1.2 Extended (to be ODF v1.3) is not supported. I am unaware to what degree subsequent corrections to the ODF specification (v1.1 and v1.2) by OASIS have been implemented by Microsoft. Best wishes, Owen. -- View this message in context: http://nabble.documentfoundation.org/status-of-Microsoft-Office-compliance-with-ODF-support-tp4097206p4097304.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
Re: [libreoffice-users] Calc: help with VLOOKUP
Thank you, both! Carl Paulsen has written on 2/14/2014 5:06 PM: > Take a look at the Help entry for vlookup. That entry begins with the > first 3 lines: > >> Vertical search with reference to adjacent cells to the right. This >> function checks if a specific value _is contained in the first column >> of an array_. The function then returns the value in the same row of >> the column named by Index. >> > > Underlining added. In other words, it looks for values in the first > column of the named array, then returns the value in the same row in > whatever column you tell it to (the "Index" column). I'm sure it could > be stated more clearly and more specifically in the details of the Help > entry, but it's there. > > A few hints for vlookups: I find I usually want to add "hard" > references for the array so that it always looks at the intended rows of > the array. To do that, you need to add $ before each cell reference in > the array. So if the array of the function is A1:C100, I enter it as > $A$1:$C$100. This forces vlookup to always look at those cells > regardless of what row the calculation is happening on. > > Without this fixed reference, as the vlookup moves to new cells (e.g. > down a column) the array will also shift down. So for example, if the > looked up value is in cell D1 and the vlookup formula is in E1, the > above array will be searched. But if you then copy that function down > column E, each cell you move down will shift the Array down as a > relative reference. That is, on line E2, the vlookup will look at D2, > then search for that value in the array A2:C101 (not the originally > intended A1:C100). On row 201, the vlookup in E201 will look at the > value in D201 and search for it in the array A201:C300. If the values > you want to search through are only in A1:C100, then your lookup won't > find a match...ever. The $ "hard" references prevent this. > > Finally, be mindful of the implications of the sort order variable in > the function. If it is 1 or TRUE, the array must be sorted ascending, > and the function returns the nearest value "below" or "before" the > looked up value. If you want to force it to return only exact matches > and/or don't want to or can't sort the array, be sure to set sort order > to 0 or FALSE. > > HTH, > Carl > > > > On 2/14/14 3:55 PM, Pikov Andropov wrote: >> Dave Liesse has written on 2/10/2014 4:00 PM: >>> The first problem I see is that your lookup value -- in this case the ID >>> number -- has to be the first column in the lookup array. >> When I moved the ID number to the first column, my VLOOKUP worked! Where >> does it say that that is a requirement? >> > -- 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 developers for hire
Em 14-02-2014 12:18, Daniel A. Rodriguez escreveu: www.collabora.com maybe Thanks a lot. It seems they have expertise in LO. El feb 13, 2014 10:52 PM, "Luis Felipe Marzagao" escribió: Hello: I'd link to fund a bug solving. Where I can I find libreoffice developers for hire? Thanks! -- 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] libreoffice developers for hire
Em 14-02-2014 12:42, Tom Davies escreveu: Hi :) i think it's usually the other way around! Companies hire a dev or few and then give them the task of working on LibreOffice. in the Uk we sometimes describe it by saying they are "on secondment" although that's possibly only in the military. Your company hires your own devs (perhaps part-time?) and tells them what to work on. They would still need to do 1 or 2 of the "Easy hacks" to help familiarise them with the rest of the team (which comprises of many devs "on secondment" from many different companies along with individual volunteers working for no reward). The paid devs could be directed to work on other projects or to split their time between LO and other projects. Hello and tks for replying. Actually, I just need one specifc enhancement implemented. So I think it's not the case of hiring someone for a long time, but just for a "bug fix". It's a one-time job only. There are "cloud sourcing" sites where people promise to pay a much smaller amount for a specific bug to be fixed or for a specific feature to be added. If several people offer rewards for the same bug or feature then it might add up to quite a decent amount. Even if you are the first to offer a reward then it might start to attract other people's attention. Yes, I've opened both the repot in the bug tracker and also a entry on bountysource. But it seems it would only be addressed if someone funds it. Regards from Tom :) Thanks! On 14 February 2014 14:18, Daniel A. Rodriguez wrote: www.collabora.com maybe El feb 13, 2014 10:52 PM, "Luis Felipe Marzagao" escribió: Hello: I'd link to fund a bug solving. Where I can I find libreoffice developers for hire? Thanks! -- 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] Calc: help with VLOOKUP
Take a look at the Help entry for vlookup. That entry begins with the first 3 lines: Vertical search with reference to adjacent cells to the right. This function checks if a specific value _is contained in the first column of an array_. The function then returns the value in the same row of the column named by Index. Underlining added. In other words, it looks for values in the first column of the named array, then returns the value in the same row in whatever column you tell it to (the "Index" column). I'm sure it could be stated more clearly and more specifically in the details of the Help entry, but it's there. A few hints for vlookups: I find I usually want to add "hard" references for the array so that it always looks at the intended rows of the array. To do that, you need to add $ before each cell reference in the array. So if the array of the function is A1:C100, I enter it as $A$1:$C$100. This forces vlookup to always look at those cells regardless of what row the calculation is happening on. Without this fixed reference, as the vlookup moves to new cells (e.g. down a column) the array will also shift down. So for example, if the looked up value is in cell D1 and the vlookup formula is in E1, the above array will be searched. But if you then copy that function down column E, each cell you move down will shift the Array down as a relative reference. That is, on line E2, the vlookup will look at D2, then search for that value in the array A2:C101 (not the originally intended A1:C100). On row 201, the vlookup in E201 will look at the value in D201 and search for it in the array A201:C300. If the values you want to search through are only in A1:C100, then your lookup won't find a match...ever. The $ "hard" references prevent this. Finally, be mindful of the implications of the sort order variable in the function. If it is 1 or TRUE, the array must be sorted ascending, and the function returns the nearest value "below" or "before" the looked up value. If you want to force it to return only exact matches and/or don't want to or can't sort the array, be sure to set sort order to 0 or FALSE. HTH, Carl On 2/14/14 3:55 PM, Pikov Andropov wrote: Dave Liesse has written on 2/10/2014 4:00 PM: The first problem I see is that your lookup value -- in this case the ID number -- has to be the first column in the lookup array. When I moved the ID number to the first column, my VLOOKUP worked! Where does it say that that is a requirement? -- Carl Paulsen Dover, NH 03820 -- 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: help with VLOOKUP
If you look at the help for VLOOKUP, the second sentence says "This function checks if a specific value is contained in the first column of an array." Dave On 2/14/2014 12:55, Pikov Andropov wrote: Dave Liesse has written on 2/10/2014 4:00 PM: The first problem I see is that your lookup value -- in this case the ID number -- has to be the first column in the lookup array. When I moved the ID number to the first column, my VLOOKUP worked! Where does it say that that is a requirement? -- 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: help with VLOOKUP
Dave Liesse has written on 2/10/2014 4:00 PM: > The first problem I see is that your lookup value -- in this case the ID > number -- has to be the first column in the lookup array. When I moved the ID number to the first column, my VLOOKUP worked! Where does it say that that is a requirement? -- 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] Problems between LO and CUPS
Hi Don, https://bugs.freedesktop.org/show_bug.cgi?id=41524 Looks like that's your report :) So it's known and I think you're even a commenter on it. It's been inherited from OOo it looks like. Best, Joel On 02/14/2014 12:44 PM, Don C. Myers wrote: > Hi Malcolm, > > I haven't had the same issue as described in this thread, but it may > be related. I'm running Ubuntu 13.10 and LibreOffice 4.1.5.3 > presently. This situation has happened with all Ubuntu versions and > LibreOffice versions in the last at least year and a half, as I update > Ubuntu every 6 months, and update LibreOffice running the latest > stable version from The Document Foundation as they come out. It has > happened on at least 4 different printers. If I am printing multiple > copies of a document in LibreOffice, lets say 10 copies, LibreOffice > instead of sending 1 print job to the printer telling the printer to > make 10 copies, it sends 10 different print jobs to the printer > printing 1 copy of each. All other programs I run in Ubuntu send 1 > print job for the multiple copies. I found this out by attempting to > print 50 copies of a two page document about a year and a half ago, > which overwhelmed the printer, and then Ubuntu. If I make a pdf of the > document, and then through the document viewer print 50 copies of the > same document, it sends one print job telling the printer to print it > 50 times. So there is something with LibreOffice and printing in > Ubuntu at least, which works differently than all other Linux programs > I have used in Ubuntu. > > Don > > On 02/14/2014 02:24 PM, Malcolm Moore wrote: >> LO connects to CUPS on start not when you want to print >> So if you have LO open for a while the connection to CUPSwill >> time out. You need to set your CUPS timeout short >> enoughso that it will time out eventually but long enough so >> thatCUPS doesn't drop the connection in normal use. >>M >> > -- 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] Problems between LO and CUPS
Hi Malcolm, I haven't had the same issue as described in this thread, but it may be related. I'm running Ubuntu 13.10 and LibreOffice 4.1.5.3 presently. This situation has happened with all Ubuntu versions and LibreOffice versions in the last at least year and a half, as I update Ubuntu every 6 months, and update LibreOffice running the latest stable version from The Document Foundation as they come out. It has happened on at least 4 different printers. If I am printing multiple copies of a document in LibreOffice, lets say 10 copies, LibreOffice instead of sending 1 print job to the printer telling the printer to make 10 copies, it sends 10 different print jobs to the printer printing 1 copy of each. All other programs I run in Ubuntu send 1 print job for the multiple copies. I found this out by attempting to print 50 copies of a two page document about a year and a half ago, which overwhelmed the printer, and then Ubuntu. If I make a pdf of the document, and then through the document viewer print 50 copies of the same document, it sends one print job telling the printer to print it 50 times. So there is something with LibreOffice and printing in Ubuntu at least, which works differently than all other Linux programs I have used in Ubuntu. Don On 02/14/2014 02:24 PM, Malcolm Moore wrote: LO connects to CUPS on start not when you want to print So if you have LO open for a while the connection to CUPSwill time out. You need to set your CUPS timeout short enoughso that it will time out eventually but long enough so thatCUPS doesn't drop the connection in normal use. M -- ** -- 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] Problems between LO and CUPS
LO connects to CUPS on start not when you want to print So if you have LO open for a while the connection to CUPS will time out. You need to set your CUPS timeout short enough so that it will time out eventually but long enough so that CUPS doesn't drop the connection in normal use. M -- 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] status of Microsoft Office compliance with ODF support?
On 14/02/2014, M. Fioretti wrote: > Greetings, > > here is the question, you're welcome to pass it around as much as you > see fit: > > what is the ACTUAL, current status of Microsoft Office compliance with > support for the OpenDocument Format? Is there something specific that > isn't supported yet? What, how.. Case stories, tests, reports, > whatever, all pointers are welcome. Thanks in advance! > See https://www.mail-archive.com/users@global.libreoffice.org/msg26889.html. There is a similar comparison web page for text documents. Search this mailing list or ask m$, -- 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] status of Microsoft Office compliance with ODF support?
On 02/14/2014 09:32 AM, Tom Davies wrote: Hi :) If this is for an article then i am not sure we can really help. Mostly we are all just volunteers and can't give the TDF's official stand-point on any of this. All we can give is anecdotes which doesn't really count as proof! Over the years we have often heard about problems with the MS format on this mailing list but very seldom heard about problems with our format on their systems! Quite why the problems weren't being raised as bug-reports against MS's apparently poor implementation is a bit of a mystery. MS admit to making "accidental" mistakes in their implementation of their own format and we get the blame. It was the same with the Rtf format and even now that MS have lost the court case about their 'accidents' with Rtf people still seem to think that everyone else was to blame. It might be interesting to compare the similarity of the promises for interoperability made by MS for both formats over the years and the types of 'accidents' that both formats have suffered. We know for certain that Excel 2010 and previous versions of MSO implemented ODF support so badly that formulas got replaced by hard-coded values. However, over the years this only got reported to us 1 or 2 times. What we don't know is whether people experienced the problem and took it as a sign to avoid Open Document Formats in favour of proprietary implementations of other formats or whether people were simply not using ODF much at all and so never noticed the problem. Perhaps people expected formats to only work on the systems they were written in, ie that the much vaunted "interoperability" was a complete myth and only applied to machines running the same OS and the same version of the same programs. That certainly seems to be the prevelant attitude amongst office workers i work with. Anyway, i personally think MS Office is only just attempting to correctly implement the format because ODF is only just beginning to be used widely enough that people are beginning to question why it works so well on everything except MS's stuff. Regards from Tom :) On 14 February 2014 13:59, Jay Lozier wrote: On 02/14/2014 06:51 AM, M. Fioretti wrote: Greetings, here is the question, you're welcome to pass it around as much as you see fit: what is the ACTUAL, current status of Microsoft Office compliance with support for the OpenDocument Format? Is there something specific that isn't supported yet? What, how.. Case stories, tests, reports, whatever, all pointers are welcome. Thanks in advance! Marco Marco, MSO 2010 and earlier did not support ODF 1.2 only ODF 1.1. I saw somewhere that ODF 1.2 is supported in MSO 2013/Office 365. Since MS has a history of "improving" their own formats each release I do not know if they have not introduced "improvements" which make the alleged ODF 1.2 effectively a proprietary format. -- Jay Lozier jsloz...@gmail.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 You mean it works so well on the 1% of systems that don't use MS Office? -- 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] Problems between LO and CUPS
Where does the Raspberry PI come in to the picture? On 02/14/2014 10:09 AM, Jean Milot wrote: Hi, See below. Jean Milot - Directeur Technique jmi...@dotriver.eu - www.dotriver.eu Un terminal à 30€ ? testez un Raspberry PI http://bit.ly/1kx0wid Avis d'expert Nr5 nu@ge France : http://bit.ly/MoE4f8 DotRiver est membre du consortium "nuage-France" http://bit.ly/LNIfMr 24 b rue Baldassini, F-69007 Lyon Fixe: +33 (0)4 2746 39 80 Direct: # 87 Hotline: # 89 Fax: # 81 Mob: +33 (0)6 68 15 58 17 Pas à pas, agissons au quotidien pour préserver notre environnement. N'imprimez que si nécessaire, réduisez vos déchets informatiques, économisez l'énergie en utilisant les solutions DotRiver. Le 14/02/2014 15:55, Kracked_P_P---webmaster a écrit : On 02/14/2014 08:55 AM, Jay Lozier wrote: On 02/14/2014 07:40 AM, Jean Milot wrote: Hello, I have some problems between LibreOffice and CUPS. Some of printings don't work. I have a debian server with CUPS and all the printers are configured. In local, i have configured CUPS with the file : /etc/cups/client.conf in order to use the debian server to print. Sometimes, printers disappeared when we want to print, we only see Generic Printer. And we can have all printers but we need to launch twice the task. It seems LibreOffice is not connected to CUPS even if all others software works fine (like Adobe, kpdf, iceweasel ) In order to print, we need to close LO and open again the document or we can go to : File -> Printer settings .. (Fichier -> Paramétrages de l'imprimante .. ) How i can solve this problem ? Thanks for your help. Sincerely, Jean Jean, Are you using a print server? Also, what is the OS LO is running on? If the LO is running on Linux you might try using SAMBA to manage printing. It should be in your repository. Which printers work and which ones do not? These problem concerns all printers. You are using which distro of Linux, Debian, Ubuntu, etc., to run the server on? Debian Wheezy It appears also on Debian Squeeze Are you accessing the print server using a Windows, Mac, or Linux. It sounds like a Linux system, so we could use that version of Linux as well. Debian Wheezy Yes, sometimes the config file for LO on Linux get corrupted, or at least for me it did on Ubuntu. I had troubles with LO not being able to print correctly for duplexing on an Epson printer. Since all of the printers are "attached" to the CUPS system, that was a concern to me. It was fixed by a print option that is no longer part of LO's Linux print "options" anymore. It seems not to need it now. For now, you might want to use Export to PDF or have CUPS-PDF installed locally. You create a PDF version of the document and use you default PDF viewer to print the document out to the correct printer. Have you tried renaming your LO personal profile and then let LO create a new one. That usually work for printer issues, or it did the last time I had a corrupt printer. For me, on Ubuntu 12.04, I go to the hidden folder of ".config/libreoffice" I rename it to ".config/libreoffice-old-date-here" with the date I saved it in the folder name. When LO restarts, it recreates the config folder with a fresh copy. This usually fixed printer issues and errors. I can print if i restart LO. I'm not forced to del or rename my profile folder. Or if i search to mange printers settings in File menu. -- 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] Problems between LO and CUPS
Hi, See below. Jean Milot - Directeur Technique jmi...@dotriver.eu - www.dotriver.eu Un terminal à 30€ ? testez un Raspberry PI http://bit.ly/1kx0wid Avis d'expert Nr5 nu@ge France : http://bit.ly/MoE4f8 DotRiver est membre du consortium "nuage-France" http://bit.ly/LNIfMr 24 b rue Baldassini, F-69007 Lyon Fixe: +33 (0)4 2746 39 80 Direct: # 87 Hotline: # 89 Fax: # 81 Mob: +33 (0)6 68 15 58 17 Pas à pas, agissons au quotidien pour préserver notre environnement. N'imprimez que si nécessaire, réduisez vos déchets informatiques, économisez l'énergie en utilisant les solutions DotRiver. Le 14/02/2014 15:55, Kracked_P_P---webmaster a écrit : On 02/14/2014 08:55 AM, Jay Lozier wrote: On 02/14/2014 07:40 AM, Jean Milot wrote: Hello, I have some problems between LibreOffice and CUPS. Some of printings don't work. I have a debian server with CUPS and all the printers are configured. In local, i have configured CUPS with the file : /etc/cups/client.conf in order to use the debian server to print. Sometimes, printers disappeared when we want to print, we only see Generic Printer. And we can have all printers but we need to launch twice the task. It seems LibreOffice is not connected to CUPS even if all others software works fine (like Adobe, kpdf, iceweasel ) In order to print, we need to close LO and open again the document or we can go to : File -> Printer settings .. (Fichier -> Paramétrages de l'imprimante .. ) How i can solve this problem ? Thanks for your help. Sincerely, Jean Jean, Are you using a print server? Also, what is the OS LO is running on? If the LO is running on Linux you might try using SAMBA to manage printing. It should be in your repository. Which printers work and which ones do not? These problem concerns all printers. You are using which distro of Linux, Debian, Ubuntu, etc., to run the server on? Debian Wheezy It appears also on Debian Squeeze Are you accessing the print server using a Windows, Mac, or Linux. It sounds like a Linux system, so we could use that version of Linux as well. Debian Wheezy Yes, sometimes the config file for LO on Linux get corrupted, or at least for me it did on Ubuntu. I had troubles with LO not being able to print correctly for duplexing on an Epson printer. Since all of the printers are "attached" to the CUPS system, that was a concern to me. It was fixed by a print option that is no longer part of LO's Linux print "options" anymore. It seems not to need it now. For now, you might want to use Export to PDF or have CUPS-PDF installed locally. You create a PDF version of the document and use you default PDF viewer to print the document out to the correct printer. Have you tried renaming your LO personal profile and then let LO create a new one. That usually work for printer issues, or it did the last time I had a corrupt printer. For me, on Ubuntu 12.04, I go to the hidden folder of ".config/libreoffice" I rename it to ".config/libreoffice-old-date-here" with the date I saved it in the folder name. When LO restarts, it recreates the config folder with a fresh copy. This usually fixed printer issues and errors. I can print if i restart LO. I'm not forced to del or rename my profile folder. Or if i search to mange printers settings in File menu. -- 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] status of Microsoft Office compliance with ODF support?
Hi :) If this is for an article then i am not sure we can really help. Mostly we are all just volunteers and can't give the TDF's official stand-point on any of this. All we can give is anecdotes which doesn't really count as proof! Over the years we have often heard about problems with the MS format on this mailing list but very seldom heard about problems with our format on their systems! Quite why the problems weren't being raised as bug-reports against MS's apparently poor implementation is a bit of a mystery. MS admit to making "accidental" mistakes in their implementation of their own format and we get the blame. It was the same with the Rtf format and even now that MS have lost the court case about their 'accidents' with Rtf people still seem to think that everyone else was to blame. It might be interesting to compare the similarity of the promises for interoperability made by MS for both formats over the years and the types of 'accidents' that both formats have suffered. We know for certain that Excel 2010 and previous versions of MSO implemented ODF support so badly that formulas got replaced by hard-coded values. However, over the years this only got reported to us 1 or 2 times. What we don't know is whether people experienced the problem and took it as a sign to avoid Open Document Formats in favour of proprietary implementations of other formats or whether people were simply not using ODF much at all and so never noticed the problem. Perhaps people expected formats to only work on the systems they were written in, ie that the much vaunted "interoperability" was a complete myth and only applied to machines running the same OS and the same version of the same programs. That certainly seems to be the prevelant attitude amongst office workers i work with. Anyway, i personally think MS Office is only just attempting to correctly implement the format because ODF is only just beginning to be used widely enough that people are beginning to question why it works so well on everything except MS's stuff. Regards from Tom :) On 14 February 2014 13:59, Jay Lozier wrote: > > On 02/14/2014 06:51 AM, M. Fioretti wrote: >> >> Greetings, >> >> here is the question, you're welcome to pass it around as much as you >> see fit: >> >> what is the ACTUAL, current status of Microsoft Office compliance with >> support for the OpenDocument Format? Is there something specific that >> isn't supported yet? What, how.. Case stories, tests, reports, >> whatever, all pointers are welcome. Thanks in advance! >> >> Marco > > Marco, > > MSO 2010 and earlier did not support ODF 1.2 only ODF 1.1. I saw somewhere > that ODF 1.2 is supported in MSO 2013/Office 365. Since MS has a history of > "improving" their own formats each release I do not know if they have not > introduced "improvements" which make the alleged ODF 1.2 effectively a > proprietary format. > > -- > Jay Lozier > jsloz...@gmail.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 > -- 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] Problems between LO and CUPS
On 02/14/2014 08:55 AM, Jay Lozier wrote: On 02/14/2014 07:40 AM, Jean Milot wrote: Hello, I have some problems between LibreOffice and CUPS. Some of printings don't work. I have a debian server with CUPS and all the printers are configured. In local, i have configured CUPS with the file : /etc/cups/client.conf in order to use the debian server to print. Sometimes, printers disappeared when we want to print, we only see Generic Printer. And we can have all printers but we need to launch twice the task. It seems LibreOffice is not connected to CUPS even if all others software works fine (like Adobe, kpdf, iceweasel ) In order to print, we need to close LO and open again the document or we can go to : File -> Printer settings .. (Fichier -> Paramétrages de l'imprimante .. ) How i can solve this problem ? Thanks for your help. Sincerely, Jean Jean, Are you using a print server? Also, what is the OS LO is running on? If the LO is running on Linux you might try using SAMBA to manage printing. It should be in your repository. Which printers work and which ones do not? You are using which distro of Linux, Debian, Ubuntu, etc., to run the server on? Are you accessing the print server using a Windows, Mac, or Linux. It sounds like a Linux system, so we could use that version of Linux as well. Yes, sometimes the config file for LO on Linux get corrupted, or at least for me it did on Ubuntu. I had troubles with LO not being able to print correctly for duplexing on an Epson printer. Since all of the printers are "attached" to the CUPS system, that was a concern to me. It was fixed by a print option that is no longer part of LO's Linux print "options" anymore. It seems not to need it now. For now, you might want to use Export to PDF or have CUPS-PDF installed locally. You create a PDF version of the document and use you default PDF viewer to print the document out to the correct printer. Have you tried renaming your LO personal profile and then let LO create a new one. That usually work for printer issues, or it did the last time I had a corrupt printer. For me, on Ubuntu 12.04, I go to the hidden folder of ".config/libreoffice" I rename it to ".config/libreoffice-old-date-here" with the date I saved it in the folder name. When LO restarts, it recreates the config folder with a fresh copy. This usually fixed printer issues and errors. -- 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 developers for hire
www.collabora.com maybe El feb 13, 2014 10:52 PM, "Luis Felipe Marzagao" escribió: > Hello: > > I'd link to fund a bug solving. Where I can I find libreoffice developers > for hire? > > Thanks! > > -- > 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] status of Microsoft Office compliance with ODF support?
On 02/14/2014 06:51 AM, M. Fioretti wrote: Greetings, here is the question, you're welcome to pass it around as much as you see fit: what is the ACTUAL, current status of Microsoft Office compliance with support for the OpenDocument Format? Is there something specific that isn't supported yet? What, how.. Case stories, tests, reports, whatever, all pointers are welcome. Thanks in advance! Marco Marco, MSO 2010 and earlier did not support ODF 1.2 only ODF 1.1. I saw somewhere that ODF 1.2 is supported in MSO 2013/Office 365. Since MS has a history of "improving" their own formats each release I do not know if they have not introduced "improvements" which make the alleged ODF 1.2 effectively a proprietary format. -- Jay Lozier jsloz...@gmail.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
Re: [libreoffice-users] Neat Writer Feature -- Relative Font Sizes
Cley wrote: They are tools. Power users of each tools will find that they are on the "better" side. Some peoples feel that latex, with all the commands everywhere is too >complicated, but when you learn a bit about it it's ok. Same for LibreOffice; there's properties dialog everywhere, multiple levels of styles, and not-always intuitive page management, but when you learn a bit about it it's ok. And in both case, doing anything that's more advanced will require more learning. Setting up the "best" template for your work can be tedious with any tools, LO and latex included. But writing a ~100 lines latex class file to match an (imposed) template is as tedious as setting the correct chain of styles in LO... Regarding the "greater control" statement, it's the same. You can have a lot of control in both, but it's gonna be some work. But I'll concede, one of latex advantages is that it have sensible default settings for various usages :) Excellent summary, and I fully agree. In terms of ease of use, I find that with a program like LO, I can (usually) figure something out by navigating the menus. With LaTeX, I'm performing Google searches to find out the proper syntax to use in preamble commands. I think my LaTeX distribution came with some 1200 document files explaining the various packages etc. If I recall correctly, the documentation for the Microtype package is over 200 letter size pages. The FancyHdr documentation is equally daunting, but necessary to read if you want to customize your headers and footers. With LO, just put the cursor in the footer and type what you want. The wysiwyg interface does make things easier. And, then there's all those surprises on compilation. I recently did a document with several references to dollar figures. The program reminded me that I had to put a "\" in front of every dollar sign "$" because LaTeX translates dollar signs into a special code. With LO, I don't have to worry about those things. All that said, I do truly love LaTeX. I enjoy working with pure text files (very little risk of file corruption) and that final output just can't be beat. Virgil -- 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] Problems between LO and CUPS
On 02/14/2014 07:40 AM, Jean Milot wrote: Hello, I have some problems between LibreOffice and CUPS. Some of printings don't work. I have a debian server with CUPS and all the printers are configured. In local, i have configured CUPS with the file : /etc/cups/client.conf in order to use the debian server to print. Sometimes, printers disappeared when we want to print, we only see Generic Printer. And we can have all printers but we need to launch twice the task. It seems LibreOffice is not connected to CUPS even if all others software works fine (like Adobe, kpdf, iceweasel ) In order to print, we need to close LO and open again the document or we can go to : File -> Printer settings .. (Fichier -> Paramétrages de l'imprimante .. ) How i can solve this problem ? Thanks for your help. Sincerely, Jean Jean, Are you using a print server? Also, what is the OS LO is running on? If the LO is running on Linux you might try using SAMBA to manage printing. It should be in your repository. -- Jay Lozier jsloz...@gmail.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] Problems between LO and CUPS
Hello, I have some problems between LibreOffice and CUPS. Some of printings don't work. I have a debian server with CUPS and all the printers are configured. In local, i have configured CUPS with the file : /etc/cups/client.conf in order to use the debian server to print. Sometimes, printers disappeared when we want to print, we only see Generic Printer. And we can have all printers but we need to launch twice the task. It seems LibreOffice is not connected to CUPS even if all others software works fine (like Adobe, kpdf, iceweasel ) In order to print, we need to close LO and open again the document or we can go to : File -> Printer settings .. (Fichier -> Paramétrages de l'imprimante .. ) How i can solve this problem ? Thanks for your help. Sincerely, Jean -- Jean Milot - Directeur Technique jmi...@dotriver.eu - www.dotriver.eu Un terminal à 30€ ? testez un Raspberry PI http://bit.ly/1kx0wid Avis d'expert Nr5 nu@ge France : http://bit.ly/MoE4f8 DotRiver est membre du consortium "nuage-France" http://bit.ly/LNIfMr 24 b rue Baldassini, F-69007 Lyon Fixe: +33 (0)4 2746 39 80 Direct: # 87 Hotline: # 89 Fax: # 81 Mob: +33 (0)6 68 15 58 17 Pas à pas, agissons au quotidien pour préserver notre environnement. N'imprimez que si nécessaire, réduisez vos déchets informatiques, économisez l'énergie en utilisant les solutions DotRiver. -- 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 "record changes" feature
On Thu, Feb 13, 2014 at 10:54 PM, Brian Barker wrote: > > The option that is indeed present in (recent versions of?) Microsoft Word > but missing in LibreOffice is the display of the original, unedited version > of the document. But you kept a separate copy of that, didn't you? > > Yes, I do have the original. I'm not really concerned about preserving that though. Was just looking for an easy (for me) way to toggle among the three document states, original, edited, edits committed, so that in the process of making my changes I could switch back and forth among the various versions of the document. And the "switching" would occur at the current cursor location. That way there's no mode change like Alt+Tab ing to the original version of the document in another window then scrolling to the current location. -Alan -- 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 "record changes" feature
On Thu, Feb 13, 2014 at 10:55 PM, Jonathon wrote: > > > On February 13, 2014 5:18:58 PM PST, Alan wrote: > > >Is there a way to display the changed document, as if all edits are > accepted, *without* accepting the changes?? IOW, "show changed document". > > Probably not the way you want to do things, but installing OOoSVN, and > regular saves to SVN will let you go back to the document, regardless of > changes accepted/rejected/pending. > > > Never used SVN but have read about it. Actually recall an article several years ago in which the author proposed using SVN for nearly all file storage. For exactly the reason you're describing. This isn't a regular need so I doubt I go to that length to get the result. -Alan -- 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] status of Microsoft Office compliance with ODF support?
Greetings, here is the question, you're welcome to pass it around as much as you see fit: what is the ACTUAL, current status of Microsoft Office compliance with support for the OpenDocument Format? Is there something specific that isn't supported yet? What, how.. Case stories, tests, reports, whatever, all pointers are welcome. Thanks in advance! Marco -- M. Fioretti http://mfioretti.com http://stop.zona-m.net Your own civil rights and the quality of your life heavily depend on how software is used *around* you -- 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] Neat Writer Feature -- Relative Font Sizes
2014-02-13 23:55 GMT+01:00 e-letter : > > OK, fair enough but as a latex user, was amazed to read a claim that > LO provides greater control! :) > They are tools. Power users of each tools will find that they are on the "better" side. Some peoples feel that latex, with all the commands everywhere is too complicated, but when you learn a bit about it it's ok. Same for LibreOffice; there's properties dialog everywhere, multiple levels of styles, and not-always intuitive page management, but when you learn a bit about it it's ok. And in both case, doing anything that's more advanced will require more learning. Setting up the "best" template for your work can be tedious with any tools, LO and latex included. But writing a ~100 lines latex class file to match an (imposed) template is as tedious as setting the correct chain of styles in LO... Regarding the "greater control" statement, it's the same. You can have a lot of control in both, but it's gonna be some work. But I'll concede, one of latex advantages is that it have sensible default settings for various usages :) -- 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