Re: [libreoffice-users] need help on my dictionaries for LibreOffice/OOo

2012-01-01 Thread Dan Lewis
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.

Re: [libreoffice-users] Thanks

2012-01-01 Thread Tom Davies
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 wrote: From: berntie Subject: [libreoffice-users] Thanks To: users@global.libreoffice.

Fw: [libreoffice-users] Re: LibreOffice 3.4.4 - Error: wrong data type.

2012-01-01 Thread Tom Davies
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

[libreoffice-users] Re: can't print to pages on a single side of paper

2012-01-01 Thread Tom
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

[libreoffice-users] Re: LibreOffice 3.4.4 ?

2012-01-01 Thread Tom
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 wort

Re: [libreoffice-users] Re: Happy New Year all!

2012-01-01 Thread yahoo-pier_andreit
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

Re: [libreoffice-users] Ignoring text in calc formula

2012-01-01 Thread Johnny Rosenberg
2012/1/1 Johnny Rosenberg : > 2012/1/1 Jay Lozier : >> 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 beh

Re: [libreoffice-users] Ignoring text in calc formula

2012-01-01 Thread Johnny Rosenberg
2012/1/1 Jay Lozier : > 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 follo

Re: [libreoffice-users] Ignoring text in calc formula

2012-01-01 Thread Jay Lozier
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),-b

Re: [libreoffice-users] Ignoring text in calc formula

2012-01-01 Thread Regina Henschel
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 wit

Re: [libreoffice-users] Ignoring text in calc formula

2012-01-01 Thread Onyeibo Oku
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" Date: Sun, 1 Jan 2012 17:23:45 T

[libreoffice-users] Ignoring text in calc formula

2012-01-01 Thread Toni & Chris PC4
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 yo

Re: [libreoffice-users] can't print to pages on a single side of paper

2012-01-01 Thread Thomas Knierim
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 La

Re: [libreoffice-users] can't print to pages on a single side of paper

2012-01-01 Thread 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

Re: [libreoffice-users] Re: Happy New Year all!

2012-01-01 Thread Manfred J. Krause
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 D

[libreoffice-users] Re: Happy New Year all!

2012-01-01 Thread Tinkerer
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 unsub

Re: [libreoffice-users] Happy New Year all!

2012-01-01 Thread Ian Samson
Well, it's a sunny, hot and rain-less Johannesburg. Happy New Year to everyone. * Ian D. Samson * On 1 January 2012 14:32, Cor Nouws wrote: > Tom Davies wrote (01-01-12 00:56) > > Happy New Year all! >> > > Thanks - happy new year to

Re: [libreoffice-users] Happy New Year all!

2012-01-01 Thread Mieszko Kaczmarczyk
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.libreoffi

[libreoffice-users] Re: [libreoffice-website] Re: [libreoffice-marketing] Happy New Year from Brazil

2012-01-01 Thread Carlo Strata
Happy New Year to Everyone from Italy in a Beautiful Sunny Day! ;-) We will build even more in 2012, I'm sure, all together!!! Carlo Il 31/12/2011 21:20, sn ha scritto: Wish You a Very Happy New Year to All LibreOffice Members. On Sat, Dec 31, 2011 at 8:31 PM, Oleksa Stasevych< oleksiy.stase

Re: [libreoffice-users] Happy New Year all!

2012-01-01 Thread Cor Nouws
Tom Davies wrote (01-01-12 00:56) Happy New Year all! Thanks - happy new year to all from a rainy & warm Netherlands :-) -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing

[libreoffice-users] Re: Happy New Year all!

2012-01-01 Thread Gérard Fargeot
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