Re: [libreoffice-users] create custom macro within share location (program files)

Hi Andrew, The link that Tom refers to lead me to several documents of which only one deals with what I want to do (which is install a macro that is global to openoffice/libreoffice). That would be location=share and on Windows the path would be %PROGRAMFILES%\libreoffice 4.0\share\basic\. >Fr

Re: [libreoffice-users] create custom macro within share location (program files)

Hi :) I take it that it's not easy to re-write all the macros in, say Java, into Basic (or the other way around)?  Also I take it that the http://wiki.openoffice.org/wiki/Documentation/Administration_Guide/Using_Custom_Macros_and_Libraries needs significant updating?  Apols and regards from Tom

[libreoffice-users] macro not found when it's there

Hi, I'm fighting LO (and OO) to get some basic stuff working and I think I found a bug. I'm running a Java macro which in turn calls a Basic macro that was installed in the global "share" directory. LO complains that the Java macro (which is being run correctly) is unable to find the followin

Re: [libreoffice-users] create custom macro within share location (program files)

--- On Fri, 6/14/13, Tom Davies wrote: > Hi :) Hi Tom > I take it that it's not easy to re-write all the macros in, > say Java, into Basic (or the other way around)?  No, not easy. At least for me. > Also I > take it that the > http://wiki.openoffice.org/wiki/Documentation/Administration_Gu

Re: [libreoffice-users] Re: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

Hi :) You are making it sound more complicated than it really is.  1.  There is already a bug-report about this.  I doubt everything that anyone does is 100% perfect 100% of the time.  When problems are noticed in LO a bug-report gets posted and then hopefully get worked on.  Similarly with oth

[libreoffice-users] Re: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

Hi, Tom, :-) On 6/14/13 5:46 AM, Tom Davies wrote: Hi :) You are making it sound more complicated than it really is. No, not really. Maurice's point is the abandonment of the horizontal rule breaks his older documents. Readable or not. Steve's point is the breaking of old documents by r

[libreoffice-users] Searching numbers between two values

Hi, I'm using LibreOffice 4.0.3.3 (Build az.: 400m0(Build:3)). BetweenTwoNumbers.ods In the uploaded file BetweenTwoNumbers.ods there are four sheets: between 20-60, Num 1, Num 2, Num 3. On the 'between 20-60' sheet t

[libreoffice-users] DDE Links from calc to writer

Is there such a thing as to many DDE links? Original Message From: Mike Shaul Sent: Thu Jun 13 15:04:39 PDT 2013 To: users@global.libreoffice.org Subject: [libreoffice-users] DDE Links from calc to writer Hello all, I have created a document in writer that has DDE links to a

[libreoffice-users] Re: Searching numbers between two values

Hi This is a possible solution =COUNTIF('Num 1'.A1;L1:L2) where L1 = <20 and L2 = >60 =COUNTIF('Num 2'.A1;L3:L4) where L3 = <20 and L4 = >60 =COUNTIF('Num 3'.A1;L5:L6) where L5 = <20 and L6 = >60 I believe the fourth function is =SUM(J1:J5) ? -- View this message in context: http://nabble.

Re: [libreoffice-users] Searching numbers between two values

At 06:25 14/06/2013 -0700, Csányi Pál wrote: I'm using LibreOffice 4.0.3.3 (Build az.: 400m0(Build:3)). BetweenTwoNumbers.ods In the uploaded file BetweenTwoNumbers.ods there are four sheets: between 20-60, Num 1, Num 2

Re: [libreoffice-users] Re: Searching numbers between two values

At 07:57 14/06/2013 -0700, Pedro Noname wrote: This is a possible solution =COUNTIF('Num 1'.A1;L1:L2) where L1 = <20 and L2 = >60 =COUNTIF('Num 2'.A1;L3:L4) where L3 = <20 and L4 = >60 =COUNTIF('Num 3'.A1;L5:L6) where L5 = <20 and L6 = >60 (You have the inequalities backwards, I think - but no

[libreoffice-users] Re: create custom macro within share location (program files)

Hello, Vieri schrieb: > My goal is to setup some custom macros globally for all users > (location=share). I don't want to include the macros within > location=document because I'll be deploying lots of docs and it > would be a pain to maintain/update macros within every single > odt document. I'd

[libreoffice-users] Re: Searching numbers between two values

Yes, this helps. Thank you! - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061513.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@glo

[libreoffice-users] Re: Searching numbers between two values

Brian Barker wrote > Try: > =COUNTIF('Num 1'.A1:Z99;">20")-COUNTIF('Num 1'.A1:Z99;">=60") > =COUNTIF('Num 2'.A1:Z99;">20")-COUNTIF('Num 2'.A1:Z99;">=60") > =COUNTIF('Num 3'.A1:Z99;">20")-COUNTIF('Num 3'.A1:Z99;">=60") > >>moreover, I don't know how to create fourth function. > > Easy: > =J1+J3+J5

[libreoffice-users] Re: Searching numbers between two values

Now I'm searching the way how to SUM those numbers ( between 20 and 60 ) finded on sheets Num1, Num2, Num 3? BetweenTwoNumbers.ods I uploaded the file again, because I changed it a little. I changed it because I search f

[libreoffice-users] Re: Searching numbers between two values

Brian Barker wrote > Are you sure? When I try this, COUNTIF() looks only at the first > cell of your range (e.g. L1:L2), so would simply count values above > 20 - wrongly including those above 60. You are correct. I apologize. Other options are the COUNTIFS function or SUMPRODUCT. -- View th

Re: [libreoffice-users] Re: Searching numbers between two values

At 08:52 14/06/2013 -0700, Pedro Noname wrote: Brian Barker wrote Are you sure? When I try this, COUNTIF() looks only at the first cell of your range (e.g. L1:L2), so would simply count values above 20 - wrongly including those above 60. You are correct. I apologize. Oh, thanks - but absol

Re: [libreoffice-users] Searching numbers between two values

At 08:48 14/06/2013 -0700, Csányi Pál wrote: Now I'm searching the way how to SUM those numbers ( between 20 and 60 ) found on sheets Num1, Num2, Num 3? BetweenTwoNumbers.ods I uploaded the file again, because I change

[libreoffice-users] Re: Re: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

On Thu, 13 Jun 2013 21:50:52 +0100, Tom Davies wrote: > Congrats Maurice if you were the one that marked-as-duplicate!  Misplaced, I'm afraid! (I raised it because I couidn't find the existing one...) > If Stuart did it then many thanks again to him for all his work.  'twas indeed. Yes -

Re: [libreoffice-users] Re: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

On Thu, Jun 13, 2013 at 1:50 PM, Tom Davies wrote: > Hi :) > It would be really great if more of us could learn how to "mark as > duplicate" and other triaging stuff. Even just a few people here learnt > what is in some of those drop-downs that would be good. I'm completely > hopeless at rememb

[libreoffice-users] Re: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

On Thu, 13 Jun 2013 12:33:14 -0700, V Stuart Foote wrote: > I have started a UX-Advise thread on design review of how Horizontal Rulers > can be reintroduced to the Writer GUI. Great news, Stuart! Good hunting -- /\/\aurice -- To unsubscribe e-mail to: users+unsubscr...@globa

[libreoffice-users] Re: Searching numbers between two values

I found a solution! On can see it in the following uploaded file. BetweenTwoNumbers.ods The function is: =SUMIF('Num 1'.A1;">20";'Num 1'.A1)-SUMIF('Num 1'.A1;">60";'Num 1'.A1)+SUMIF('Num 2'.A1;">20";'Num 2'.A1)-SUMIF('Nu

RE: [libreoffice-users] DDE Links from calc to writer

Thank you Brian That Helped out! It was a stupid mistake. The links were corrupted! -- Shaul's Plumbing and Heating Ltd. 778-397-4850 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting gu

Re: [libreoffice-users] Re: Searching numbers between two values

At 21:58 14/06/2013 -0700, Csányi Pál wrote: I found a solution! You found it? Good! Did you find it in my message some twelve hours before? ;^) The function is: =SUMIF('Num 1'.A1;">20";'Num 1'.A1)-SUMIF('Num 1'.A1;">60";'Num 1'.A1)+SUMIF('Num 2'.A1;">20";'Num 2'.A1)-SUMIF('Num 2'.A1;