[libreoffice-users] Re: Happy New Year all!
Hi all, 12 years after, a new millenium bug ? Open a new spreadsheet, in a cell in the middle of the screen (G15 for example) : change row height to 2 cm or more, paste the following formula, =T(STYLE(Heading))CHAR(HEX2DEC(4D))MID(The Document Foundation;3;1)REPT(RIGHT(Writer);EVEN(PI()/2))CHAR(POWER(LEN(LibreOffice);2))CHAR(32)LEFT(Calc)RIGHT(Math)MID(Draw;2;1)LOWER(SUBSTITUTE(Impress;mpres;))T(tm)MID(Base;2;2)CHAR(10)ROT13(naq )MID(SUBSTITUTE(Harry Potter;r;p);1;FACT(3))LEFT(New York;5)CHAR(ARABIC(CI))RIGHT(SUBSTITUTE(Gérard;d; );3)YEAR(EDATE(TODAY();1))CHAR(10)to LOWER(BASE(32156;33;3)) LibOPROPER(ROT13( grnz)) :) Gérard -- View this message in context: http://nabble.documentfoundation.org/Happy-New-Year-all-tp3623969p3624443.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] Happy New Year all!
W dniu 01.01.2012 01:01, Don C. Myers pisze: The same from me!!! Happy New Year Don On 12/31/2011 06:56 PM, Tom Davies wrote: Happy New Year all! Regards from Tom :) Happy New Year From Poland Mieszko -- For unsubscribe instructions e-mail to: users+h...@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: Happy New Year all!
Gérard Fargeot Brilliant! You made a good start to my New Year. A Happy New Year to you and all on here. Tink. -- View this message in context: http://nabble.documentfoundation.org/Happy-New-Year-all-tp3623969p3624791.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Happy New Year all!
Hi, 2012/1/1 Gérard Fargeot wrote: Hi all, 12 years after, a new millenium bug ? Open a new spreadsheet, in a cell in the middle of the screen (G15 for example) : change row height to 2 cm or more, paste the following formula, =T(STYLE(Heading))CHAR(HEX2DEC(4D))MID(The Document Foundation;3;1)REPT(RIGHT(Writer);EVEN(PI()/2))CHAR(POWER(LEN(LibreOffice);2))CHAR(32)LEFT(Calc)RIGHT(Math)MID(Draw;2;1)LOWER(SUBSTITUTE(Impress;mpres;))T(tm)MID(Base;2;2)CHAR(10)ROT13(naq )MID(SUBSTITUTE(Harry Potter;r;p);1;FACT(3))LEFT(New York;5)CHAR(ARABIC(CI))RIGHT(SUBSTITUTE(Gérard;d; );3)YEAR(EDATE(TODAY();1))CHAR(10)to LOWER(BASE(32156;33;3)) LibOPROPER(ROT13( grnz)) :) Gérard Nice :) Bonne année Happy New Year Frohes neues Jahr from Germany mjk -- SOPA Cabana (by Dan Bull) http://www.youtube.com/watch?feature=player_embeddedv=1w6GtwOvnWM#! -- For unsubscribe instructions e-mail to: users+h...@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] can't print to pages on a single side of paper
Hi :) When you choose File - Print do you get a dialogue-box that gives various options? Is one of the options double-sided or two sided? Ok, that's a bit obvious but obvious things get missed sometimes while looking for a more complicated answer. In the print dialogue-box do you have an option to choose which printer and to set the Properties of the printer? i think there might be an option in there. I doubt printers can be set to over-ride commands and force double-sided printing but it might help us to know what printer you have got. Regards from Tom :) --- On Sat, 31/12/11, Thomas Knierim tknie...@web.de wrote: From: Thomas Knierim tknie...@web.de Subject: Re: [libreoffice-users] can't print to pages on a single side of paper To: users@global.libreoffice.org Date: Saturday, 31 December, 2011, 16:32 or does anybody know how to set the default language of the printer in a configuration file? Am 31.12.2011 um 17:14 schrieb Thomas Knierim: Hi again, I've waited for some updates but it's still not ok! Opensuse 12.1 doesn't has the problem, but I don't know why my favorite distribution (Archlinux) still isn't able to print to side-by-side. Does anybody know how to set up a printer using spadim. I always get the message, the filesystem is read only PLEASE does anybody know how to solve ONE of the problems? ToK Am 08.11.2011 um 19:32 schrieb Thomas Knierim: Hi, I mean to print two pages side by side. The problem is if I print two pages side by side the printer hangs - with libreoffice only. Not with evince (gnome pdf viewer) for example. If I switch the printer language from pdf to ps everything works fine... But I don't want to do it for every job - and by the way: can ps send fonts to the printer? Does libreoffice send fonts to the printer if the printer language is set to pdf? regards Thomas Am 29.10.2011 um 17:05 schrieb webmaster for Kracked Press Productions: The two pages per sheet issue. You want to have them printed side by side? Or one page on one side and the second page on the other side of the sheet? Side by side printed out on a landscape orientation works well, but it is a printer option. Having the pages printed one on each side of the sheet is a duplexing issue. I have been having the same problem with duplexing as well as others. side by side printing Print Page Layout Pages per sheet. 2 will print two page side by side. IT works fine for me. I prefer to have the option of bordering the pages, since it looks better to me. For duplex printing, I have to print it out as a PDF document and print it with the document viewer with the duplex option, instead of printing it directly through LO. LO just does not see or adjust the duplex option on my Epson Artisan printer properly. On 10/29/2011 10:47 AM, Tom Davies wrote: Hi :) In your existing Arch could you just install a virtual machine and try out a few things in there? Alternatively create a new partition on a hard-drive and use that for experimentation. You surely don't need to trash what you do have that is almost perfect in order to just try something a little different! Regards from Tom :) --- On Sat, 29/10/11, Thomas Knierimtknie...@web.de wrote: From: Thomas Knierimtknie...@web.de Subject: Re: [libreoffice-users] can't print to pages on a single side of paper To: users@global.libreoffice.org Date: Saturday, 29 October, 2011, 15:24 OK, that's some kind of confusing: Using Ubuntu everything works out of the box! Where is the difference to other distributions? The Versions are nearly the same: Cups: - OpenSuse: 1.5 - Archlinux: 1.5 - ubuntu: 1.5 Ghostscript - Opensuse: 9.00 - Archlinux: 9.04 - ubuntu: 9.04 hplip - Opensuse: 3.11.10 - Archlinux: 3.11.10 - ubuntu: 3.11.7 libreoffice: - Opensuse: 3.4.2 OOO340m1 (Build: 1206) - Archlinux: 3.4.3 (build unknown since Archlinux is not installed this moment) - ubuntu: 3.4.3 OOO340m1 (build 302) So I go back and install archlinux again to see what happens if I install hplip 3.11.7. Am 29.10.2011 um 01:59 schrieb webmaster for Kracked Press Productions: Sorry, I just say the Device option tap showing PDF as the default. I do not know what PDF means in this context, since my printers may have that as a printer language type, as far as I remember. My HP Inkjet is not a postscript printer, but my Color Laser might be able to deal with that. I did not see Postscript as an option for the Epson inkjet. I sure did not read it having a PDF language option. So something is not right. Could PDF here mean Printer Defined Format for the language used? Can the Postscript type level from driver be kept as the default option somehow? Maybe the Printer Administration shown was a module of LO 3.4 [at least with Ubuntu]? I believe that module of LO was designed to set up the printers to run
Re: [libreoffice-users] can't print to pages on a single side of paper
Hi, No, I haven't a dialog-box for double-sided or two sided. The Options for double sided printing (duplex) is set through the properties of the printer. The Problem is not duplex but Pages per Sheet (don't know if this is correct labeling, my gui is in german: Seiten pro Blatt in Page Layout (Seitenlayout)) Setting Pages per Sheet to two make the printer eject a paper an let him flash a warning light of missing paper (maybe wrong paper size - but I left it to A4). Setting the Printer Language (Druckersprache) from PDF to Postscript (level of the driver) solves the problem... regards ToK Am 01.01.2012 um 16:30 schrieb Tom Davies: Hi :) When you choose File - Print do you get a dialogue-box that gives various options? Is one of the options double-sided or two sided? Ok, that's a bit obvious but obvious things get missed sometimes while looking for a more complicated answer. In the print dialogue-box do you have an option to choose which printer and to set the Properties of the printer? i think there might be an option in there. I doubt printers can be set to over-ride commands and force double-sided printing but it might help us to know what printer you have got. Regards from Tom :) --- On Sat, 31/12/11, Thomas Knierim tknie...@web.de wrote: From: Thomas Knierim tknie...@web.de Subject: Re: [libreoffice-users] can't print to pages on a single side of paper To: users@global.libreoffice.org Date: Saturday, 31 December, 2011, 16:32 or does anybody know how to set the default language of the printer in a configuration file? Am 31.12.2011 um 17:14 schrieb Thomas Knierim: Hi again, I've waited for some updates but it's still not ok! Opensuse 12.1 doesn't has the problem, but I don't know why my favorite distribution (Archlinux) still isn't able to print to side-by-side. Does anybody know how to set up a printer using spadim. I always get the message, the filesystem is read only PLEASE does anybody know how to solve ONE of the problems? ToK Am 08.11.2011 um 19:32 schrieb Thomas Knierim: Hi, I mean to print two pages side by side. The problem is if I print two pages side by side the printer hangs - with libreoffice only. Not with evince (gnome pdf viewer) for example. If I switch the printer language from pdf to ps everything works fine... But I don't want to do it for every job - and by the way: can ps send fonts to the printer? Does libreoffice send fonts to the printer if the printer language is set to pdf? regards Thomas Am 29.10.2011 um 17:05 schrieb webmaster for Kracked Press Productions: The two pages per sheet issue. You want to have them printed side by side? Or one page on one side and the second page on the other side of the sheet? Side by side printed out on a landscape orientation works well, but it is a printer option. Having the pages printed one on each side of the sheet is a duplexing issue. I have been having the same problem with duplexing as well as others. side by side printing Print Page Layout Pages per sheet. 2 will print two page side by side. IT works fine for me. I prefer to have the option of bordering the pages, since it looks better to me. For duplex printing, I have to print it out as a PDF document and print it with the document viewer with the duplex option, instead of printing it directly through LO. LO just does not see or adjust the duplex option on my Epson Artisan printer properly. On 10/29/2011 10:47 AM, Tom Davies wrote: Hi :) In your existing Arch could you just install a virtual machine and try out a few things in there? Alternatively create a new partition on a hard-drive and use that for experimentation. You surely don't need to trash what you do have that is almost perfect in order to just try something a little different! Regards from Tom :) --- On Sat, 29/10/11, Thomas Knierimtknie...@web.de wrote: From: Thomas Knierimtknie...@web.de Subject: Re: [libreoffice-users] can't print to pages on a single side of paper To: users@global.libreoffice.org Date: Saturday, 29 October, 2011, 15:24 OK, that's some kind of confusing: Using Ubuntu everything works out of the box! Where is the difference to other distributions? The Versions are nearly the same: Cups: - OpenSuse: 1.5 - Archlinux: 1.5 - ubuntu: 1.5 Ghostscript - Opensuse: 9.00 - Archlinux: 9.04 - ubuntu: 9.04 hplip - Opensuse: 3.11.10 - Archlinux: 3.11.10 - ubuntu: 3.11.7 libreoffice: - Opensuse: 3.4.2 OOO340m1 (Build: 1206) - Archlinux: 3.4.3 (build unknown since Archlinux is not installed this moment) - ubuntu: 3.4.3 OOO340m1 (build 302) So I go back and install archlinux again to see what happens if I install hplip 3.11.7. Am 29.10.2011 um 01:59 schrieb webmaster for Kracked Press Productions: Sorry, I just say the Device option tap showing PDF as the default. I do not
[libreoffice-users] Ignoring text in calc formula
Hello, I use this formula in calc on a large forecast spreadsheet =sum(e4+d5)-(b5+c5) There has to be some cells with text but the text is not being ignored When it gets to a row with text in a cell it shows #VALUE! I have searched and =sum is supposed to fix this ?? Can you help. Thank you Toni -- For unsubscribe instructions e-mail to: users+h...@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] Ignoring text in calc formula
That formula looks syntactically incorrect. Can you write out what you are trying to sum in ordinary math-kinda formula or in English? - from twohot@device.mobile :) -Original Message- From: Toni Chris PC4 tscri...@talktalk.net Date: Sun, 1 Jan 2012 17:23:45 To: users@global.libreoffice.org Reply-To: users@global.libreoffice.org Subject: [libreoffice-users] Ignoring text in calc formula Hello, I use this formula in calc on a large forecast spreadsheet =sum(e4+d5)-(b5+c5) There has to be some cells with text but the text is not being ignored When it gets to a row with text in a cell it shows #VALUE! I have searched and =sum is supposed to fix this ?? Can you help. Thank you Toni -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Ignoring text in calc formula
Hi Toni, Toni Chris PC4 schrieb: Hello, I use this formula in calc on a large forecast spreadsheet =sum(e4+d5)-(b5+c5) There has to be some cells with text but the text is not being ignored That is right. The operators + - * / calculate only with true numbers. When it gets to a row with text in a cell it shows #VALUE! I have searched and =sum is supposed to fix this ?? Yes it does. Text is treated as 0 for function SUM and as 1 for function PRODUCT. Can you help. In your special case you can use =SUM(E4;D5)-SUM(B5:C5) Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@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] Ignoring text in calc formula
Toni Please advise which LO version you are using and your OS. This will help us determine if the problem is a know issue with a specific version of LO or with a particular OS. For your problem, I was able to replicate the behavior in LO 3.4.4 and try the following: =sum(if(isnumber(b5),-b5,0),if(isnumber(c5),-c5,0),if(isnumber(d5),d5,0,if(isnumber(e5),e5,0)) Alternate =sum(if(isnumber(d5),d5,0),if(isnumber(e5),e5,0))-sum(if(isnumber(b5),b5,0),if(isnumber(c5),c5,0)) I am validating that the data is actually a number (isnumber(cell) = true) and using either the value in the cell if true or 0 if it is not a number. Without redesigning your entire spreadsheet this may be the simplest way to fix your problem. On 01/01/2012 12:23 PM, Toni Chris PC4 wrote: Hello, I use this formula in calc on a large forecast spreadsheet =sum(e4+d5)-(b5+c5) There has to be some cells with text but the text is not being ignored When it gets to a row with text in a cell it shows #VALUE! I have searched and =sum is supposed to fix this ?? Can you help. Thank you Toni -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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] Ignoring text in calc formula
2012/1/1 Jay Lozier jsloz...@gmail.com: Toni Please advise which LO version you are using and your OS. This will help us determine if the problem is a know issue with a specific version of LO or with a particular OS. For your problem, I was able to replicate the behavior in LO 3.4.4 and try the following: =sum(if(isnumber(b5),-b5,0),if(isnumber(c5),-c5,0),if(isnumber(d5),d5,0,if(isnumber(e5),e5,0)) Alternate =sum(if(isnumber(d5),d5,0),if(isnumber(e5),e5,0))-sum(if(isnumber(b5),b5,0),if(isnumber(c5),c5,0)) I am validating that the data is actually a number (isnumber(cell) = true) and using either the value in the cell if true or 0 if it is not a number. Without redesigning your entire spreadsheet this may be the simplest way to fix your problem. Or just replace every ”Cell reference” with ”N(Cell reference)” (for instance ”A1” → ”N(A1)”), whenever there is a chance that there is text in it. This is not needed for SUM if it is implemented correctly. ”=SUM(E4+D5)” doesn't make much sense to me. Should be the same as ”=E4+D5”. ”;” is the parameter delimiter in LibreOffice Calc cell functions, not ”+”: ”=SUM(E4;D5)” does the same thing as the abovem and it gives no error message when one or both of the cells contains a text string. If you want to sum things without the SUM() function, you need to make sure that no text cells are included OR you need to treat them as 0. This can easily be done with the N() function: ”=N(E4)+N(D5)” and ”=SUM(N(E4)+N(D5))” both does the same thing and both of them works no matter if cells contain text or numerical data. However, the last example is a bit necessary, since ”=SUM(E4;D5)” works perfectly without the N() function. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@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] Ignoring text in calc formula
2012/1/1 Johnny Rosenberg gurus.knu...@gmail.com: 2012/1/1 Jay Lozier jsloz...@gmail.com: Toni Please advise which LO version you are using and your OS. This will help us determine if the problem is a know issue with a specific version of LO or with a particular OS. For your problem, I was able to replicate the behavior in LO 3.4.4 and try the following: =sum(if(isnumber(b5),-b5,0),if(isnumber(c5),-c5,0),if(isnumber(d5),d5,0,if(isnumber(e5),e5,0)) Alternate =sum(if(isnumber(d5),d5,0),if(isnumber(e5),e5,0))-sum(if(isnumber(b5),b5,0),if(isnumber(c5),c5,0)) I am validating that the data is actually a number (isnumber(cell) = true) and using either the value in the cell if true or 0 if it is not a number. Without redesigning your entire spreadsheet this may be the simplest way to fix your problem. Or just replace every ”Cell reference” with ”N(Cell reference)” (for instance ”A1” → ”N(A1)”), whenever there is a chance that there is text in it. This is not needed for SUM if it is implemented correctly. ”=SUM(E4+D5)” doesn't make much sense to me. Should be the same as ”=E4+D5”. ”;” is the parameter delimiter in LibreOffice Calc cell functions, not ”+”: ”=SUM(E4;D5)” does the same thing as the abovem and it gives no error message when one or both of the cells contains a text string. If you want to sum things without the SUM() function, you need to make sure that no text cells are included OR you need to treat them as 0. This can easily be done with the N() function: ”=N(E4)+N(D5)” and ”=SUM(N(E4)+N(D5))” both does the same thing and both of them works no matter if cells contain text or numerical data. However, the last example is a bit necessary, Sorry for that typo. I meant ”unnecessary”, fo course. since ”=SUM(E4;D5)” works perfectly without the N() function. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@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: Happy New Year all!
later but maybe not last, A new happy and squirting new 2012 year from Italy :- On 01/01/12 15:14, Tinkerer wrote: Gérard Fargeot Brilliant! You made a good start to my New Year. A Happy New Year to you and all on here. Tink. -- View this message in context: http://nabble.documentfoundation.org/Happy-New-Year-all-tp3623969p3624791.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: LibreOffice 3.4.4 ?
Hi :) I scrolled down and took a screen-shot for you. Notice the scroll-bar down the right-hand side. http://nabble.documentfoundation.org/file/n3625376/LibreOffice-Download-v2.gif LibreOffice-Download-v2.gif The red circle is the download link. Below that is the help-file which is well worth having even though proper documentation is far better http://wiki.documentfoundation.org/Documentation/Publications The arrow is the drop-down (that you already noticed) to change languages. It is usually best to download things by bit-torrent for a smoother download. It can be interrupted and resumed later without any problems. It's usually faster and it helps other people. It's wise to tick the md5sum box as the extra download is very tiny so if you don't bother to use it then it hasn't made much difference but if something goes wrong it allows you to check the download worked well. My neighbour was grumbling that screen-shots as png were too huge and he found it difficult to get them lower than 600k which is the upper-limit for the Wine (Wine Is Not an Emulator (honest guv)) forums. I was quite pleased to see that my png was 72kb and as gif it got halved without losing important information. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-3-4-4-tp3622799p3625376.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: can't print to pages on a single side of paper
Hi :) So is that one of the problems solved? Please could you post the other q1uestions as new mails to the ilst so that you can make the subject-lines relevant to the questions? Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/can-t-print-to-pages-on-a-single-side-of-paper-tp3460824p3625500.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Fw: [libreoffice-users] Re: LibreOffice 3.4.4 - Error: wrong data type.
Hi :) Don't worry about it. It is a bit unkind to complain about fairly new people not thoroughly understanding mailing lists now that most projects use more modern methods such as forums. It is possible to forrward an email to break it out of the thread and start a new thread, so that is what i have done. It still doesn't answer either question tho! Intuitively it might seem that just changing the subject-line should be enough but people really need to write a fresh email and copypaste or type in the address afresh. Just using Reply to doesn't change enough information in the header iof the email apparently. So, sorry about the unhelpfulness so far. Lets hope the next responses deal with the question. Regards from Tom :) --- On Sat, 31/12/11, csanyipal csanyi...@gmail.com wrote: From: csanyipal csanyi...@gmail.com Subject: [libreoffice-users] Re: LibreOffice 3.4.4 - Error: wrong data type. To: users@global.libreoffice.org Date: Saturday, 31 December, 2011, 7:26 Hladůvka Jiří wrote Dne 30.12.2011 23:34, csanyipal napsal(a): Gérard Fargeot wrote I've made a formula translator : http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=41870 You can translate functions or whole formula to a language to an other. Gérard ... and how does this correspond to the original context of http://nabble.documentfoundation.org/LibreOffice-3-4-4-Error-wrong-data-type-tt3614423.html ??? You are right, so I rename the Thread. - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-3-4-4-Error-wrong-data-type-tp3614423p3622735.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Thanks
Hi :) It has been an interesting thread. It's been good to gain an insight into what other people are doing with CSVs. Also congrats on fixing your issue. Regards from Tom :) --- On Fri, 30/12/11, berntie fraeggerm...@yahoo.com wrote: From: berntie fraeggerm...@yahoo.com Subject: [libreoffice-users] Thanks To: users@global.libreoffice.org Date: Friday, 30 December, 2011, 13:18 Thanks for all your tips, guys. They are appreciated. :-) Bernhard -- View this message in context: http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3620975.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] need help on my dictionaries for LibreOffice/OOo
On Fri, 2011-12-30 at 14:43 -0500, webmaster for Kracked Press Productions wrote: I need some guidance with the extent of my dictionary files for LibreOffice and OOo. My largest dictionaries are about 638,000 words in the spelling word .dic file. I need to know how large it too large. I found out this morning that if I compare that word list with a combined list for chemical and medical words, over 98,000 words from that combined list is not in the current .dic word list[s]. Now here it the issue, how far should I take this project? I am going to add all the missing words that are part of the open-source community's lexicon that are not in the current lists, but where do I stop, and how should I format the finalized files? Should there be one super large list, or should I break it up into sub-lists? Should the standard words go into one .dic file, while medical, chemistry, and computer/tech words each have their own .dic file within the .oxt file? Right now, there is an English dictionary [default one?] that includes US, British, Canadian, and some other versions of English put together as one .oxt file, but separate .dic files. I was wondering if that would be the route I should go with my super-size dictionaries. To be honest, 20 years ago the spelling dictionary project I was working on has about 177,000 words and I was told that the English language was about 250,000 words. Now I have looked at a combined word list and it has about 737K words in it and there are more words/terms still needing to be checked. The largest book style dictionary now has 25+ volumes to it when it was only 15 about 15-20 years ago. So I really think the final super-sized dictionary word list could one day go over one million in the next year or two. I just have to figure out if it is worth building a list for LO to that size. Your input would help me make the best US, British, and Canadian English dictionaries out there for LibreOffice. This is for our users to use, so it would be nice for users to let me know what they think. Something to remember: the main dictionary for the language used by LO is a binary file kept in the Installation folder. If a language pack is added, this language is also binary and kept in the same place. These are large files. User created dictionary files (.dic) are kept in the personal settings folder. These are text files. Some time ago, someone asked about dictionary file sizes referring to the user created .dic files. The reply was 22K or less per file seemed like a good number. It was mentioned that OOo would not use a dictionary file if it was too large. The dictionary files .dic) are text documents with the first four lines very important as far as content is concerned. Below is the first four lines for an English user created .dic file followed by a German user created .dic file. OOoUserDict1 OOoUserDict1 lang: en-US ORlang: de-DE type: positive type: positive --- --- It appears like the second line is the one that has to be changed from language to language. the letters before the hyphen are the language (en,English; de, Deutch) and the letters afterward are the country (US, USA; GB, Great Britain; etc.) But with the number of entries you have, you need to find some way to make a binary file that LO can read as a .dic file. From what I remember about the creation of the Austrialian dictionary, it is very time consuming to create the binary files. --Dan -- For unsubscribe instructions e-mail to: users+h...@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