[libreoffice-users] Specialty Dictionaries

2012-07-05 Thread Simon Cropper
Hi All, I saw over the last month discussions regarding special dictionaries. What became of this? How easy is it to create special dictionaries? Are there any resources regarding their construction? I know you can import 1 by 1 but I have 20,000 items to add. Also are composite words

Re: [libreoffice-users] Specialty Dictionaries

2012-07-05 Thread Tom Davies
Hi :) I think i would create a new specialist list and add 2 or 3 words to it.  Then look for the file to see what format it uses and then copypaste tons of words in at a time.  For combined words i would add a - in the middle, eg Eucalyptus-vulgaris but i think that is a bit of a kludge. 

RE: [libreoffice-users] Re: CALC - How to count blank cells?

2012-07-05 Thread Tom Davies
Hi :) +1 The same problem happens in Excel too.  I tend to make those buffer-zones  quite small so they help emphasise the totals rows or columns.  Regards from Tom :)  --- On Thu, 5/7/12, Dennis E. Hamilton dennis.hamil...@acm.org wrote: From: Dennis E. Hamilton dennis.hamil...@acm.org

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-07-05 Thread Andreas Säger
Am 04.07.2012 17:42, Ken Springer wrote: For the ordinary user, not only does LO need to explain the basics by using =FUNCTION(number ; text ; range ; vector ) and =FUNCTION( function_number(x) ; function_text(x) ; function_range(x) ; function_vector(x) ) with explanations, you need examples

[libreoffice-users] Re: a little math problem with Calc

2012-07-05 Thread Andreas Säger
Am 05.07.2012 03:50, alex sato wrote: Hi, I have a problem with functions I made. Let's say I create the function: Function Test (n) dim r(3) r(0)=int(n) r(1)=n-r(0) r(2)=r(1)*100 r(3)=int(r(2)) Test = r End Function Then, in a empty spreadsheet take the following steps: -select A1:D1 -press

[libreoffice-users] Re: a little math problem with Calc

2012-07-05 Thread Andreas Säger
Am 05.07.2012 11:43, Andreas Säger wrote: E1: input value A1: =INT($E1) B1: =$E1-$A1 C1: =$B1*100 D1: =INT($C1) This is how it works in all spreadsheet applications. It applies to any other row where you copy the formulas to. You may even save this simple calculation in xls(x) format and it

Re: [libreoffice-users] Specialty Dictionaries

2012-07-05 Thread Simon Cropper
Tom, Yeah, I have thought of both these things. Have hacked a standard file before, particularly in MS Word. Easily done assuming it is a text file and not a binary file. The problem is the binomial. I also thought of the concatenation string but most of the single characters have been used

[libreoffice-users] Re: You made me smile today .... Re: Re: stubborn macro security

2012-07-05 Thread Andreas Säger
Am 05.07.2012 03:34, Andrew Douglas Pitonyak wrote: You made me smile today when I read your post: Just wanted to mention it... Thanks for your smile. Very much appreciated. :) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF output???

2012-07-05 Thread Rogier F. van Vlissingen
The solution and the probable cause... In the end, this problem was fixable, by using 'clear direct formatting' in the areas affected. (Could not do whole doc lest we wipe out italics and such). The amazing fact was that the problem did not manifest in a PDF at the subdocument level, it just

Re: [libreoffice-users] Specialty Dictionaries

2012-07-05 Thread webmaster-Kracked_P_P
With the word list system for LO's dictionaries, I have found no info regards how to used a two word combo. All I have been able to do is have a word list in a .dic file withing an .oxt file. Having a term with two parts, like your example, is something I have not found how to do. As

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-07-05 Thread Ken Springer
On 7/5/12 2:41 AM, Andreas Säger wrote: snip All this had been written hundreds of times for dozends of spreadsheets applications in books, web-pages, mailing lists and forums. People don't read this. I know, but I have a hard time blaming X percent of them. I run into many users who have

[libreoffice-users] Libre Office printing documents 1/8 of original size and in landscape mode - Help

2012-07-05 Thread Pastel Painter
When I print my documents, they are printing about 1/8 of the original (letter) size, and are being rotated to landscape mode. When I check the document in print preview, the document looks like I expect it to - taking up the full page, etc. I have no idea as to why it is doing this or what to

Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF output???

2012-07-05 Thread Fernand Vanrie
Rogier , Its not worth a issue, its user related due to serial direct formating, spaces folowd by spaces etc..When checking the underlying XML you can sea lots of unused tags and sometimes the PDF-creator is confused :-) The solution and the probable cause... In the end, this problem was

Re: [libreoffice-users] Libre Office printing documents 1/8 of original size and in landscape mode - Help

2012-07-05 Thread Regina Henschel
Hi, Pastel Painter schrieb: When I print my documents, they are printing about 1/8 of the original (letter) size, and are being rotated to landscape mode. When I check the document in print preview, the document looks like I expect it to - taking up the full page, etc. I have no idea as to why

Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF output???

2012-07-05 Thread Rogier F. van Vlissingen
Hmm, disappointing though. I cannot see how these kinds of things can be avoided if you are editing a manuscript, and I never had such problems in the past with OO in 2002, with a book that certainly went through just as many revisions. I am clueless anymore how to fix it. If I fix one, another

Re: [libreoffice-users] Libre Office printing documents 1/8 of original size and in landscape mode - Help

2012-07-05 Thread webmaster-Kracked_P_P
On 07/05/2012 01:39 PM, Regina Henschel wrote: Hi, Pastel Painter schrieb: When I print my documents, they are printing about 1/8 of the original (letter) size, and are being rotated to landscape mode. When I check the document in print preview, the document looks like I expect it to - taking

Re: [libreoffice-users] Specialty Dictionaries

2012-07-05 Thread nvrk
On Thu, Jul 5, 2012 at 3:06 AM, Simon Cropper simoncrop...@fossworkflowguides.com wrote: Yeah, I have thought of both these things. Have hacked a standard file before, particularly in MS Word. Easily done assuming it is a text file and not a binary file. The problem is the binomial. I also

Re: [libreoffice-users] a little math problem with Calc

2012-07-05 Thread Steve Edmonds
Hi. I tried your function but made the last line Test = r(3). It does return 17. My guess is that by the completion of r(2)=r(1)*100 the value is very slightly less than 18 and int then produces 17. steve On 5/07/12 1:50 PM, alex sato wrote: Hi, I have a problem with functions I made.

Re: [libreoffice-users] a little math problem with Calc

2012-07-05 Thread Steve Edmonds
Hi. In fact if I change your function r(3)=(r(2)-18)*10 Test = r(3) the result is -2.8421709430404E-005 showing that 17 would be correct. For these situations I often add my own tolerance to limit sensitivity r(3)=int(r(2)+1e-9) steve On 5/07/12 1:50 PM, alex sato wrote: Hi, I have

RE: [libreoffice-users] a little math problem with Calc

2012-07-05 Thread Dennis E. Hamilton
What I found interesting was that Calc (in LO 3.3.2) did not have that problem: Have A1 hold 11.18 Then A2 = INT(100*(A1-INT(A1))) works just fine. I think it would be safest to do A3 = ROUND(100*(A1-INT(A1))) though. -Original Message- From: Steve Edmonds

Re: [libreoffice-users] a little math problem with Calc

2012-07-05 Thread alex sato
There is no problem using formula in a cell to make the calculation. The problem occurs only in a macro (using ooBasic). I used the Test macro just to show my problem. I don't know if it was expected or if it is a bug. If it is not a bug I wish to understand why and what I could do to get what I

Re: [libreoffice-users] a little math problem with Calc

2012-07-05 Thread Regina Henschel
Hi, alex sato schrieb: Hi, I have a problem with functions I made. Let's say I create the function: Function Test (n) dim r(3) r(0)=int(n) r(1)=n-r(0) r(2)=r(1)*100 r(3)=int(r(2)) Test = r End Function Then, in a empty spreadsheet take the following steps: -select A1:D1 -press [F2] -Insert

Re: [libreoffice-users] Specialty Dictionaries

2012-07-05 Thread Simon Cropper
On 06/07/12 05:26, nvrk wrote: On Thu, Jul 5, 2012 at 3:06 AM, Simon Cropper simoncrop...@fossworkflowguides.com wrote: Yeah, I have thought of both these things. Have hacked a standard file before, particularly in MS Word. Easily done assuming it is a text file and not a binary file. The

Re: [libreoffice-users] a little math problem with Calc

2012-07-05 Thread alex sato
Regina, thanks for your answer. But can you tell me how to call Calc functions inside the macro? I searched in docs and in the Google and don't found any clue. By the way, just now I tought the possibility to rewrite math functions using string to encode the number to avoid error because I

[libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?

2012-07-05 Thread leeand00
Okay for anyone who's interested I submitted the bug here: http://bugs.mysql.com/bug.php?id=65832thanks=sub Enjoy! -- View this message in context: http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3993950.html Sent from the Users mailing

[libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?

2012-07-05 Thread leeand00
I also posted it here: https://www.libreoffice.org/get-help/bug/ -- View this message in context: http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3993952.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe