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\. From the LO/OO GUI I can't create any NEW macros within the global container (grayed out). And I haven't found any option to enable it. So there's obviously some kind of security reason that I don't know how to circumvent. The only document within Tom's links that should do what I want is the following: http://wiki.openoffice.org/wiki/Documentation/Administration_Guide/Using_Custom_Macros_and_Libraries To Make a Custom OpenOffice.org Basic Library Available to All Users on a Network The basic idea of this guide is to create my macros within my user profile folder and then copy them to the global share folder. However, note how the guide suggests to include in script.xlc and dialog.xlc: the library xlink:href should point to $(USER)/basic...etc. I find that wrong (or not what I want). I understand that $(USER) points to the user profile folder where I first wrote my macros. It doesn't point to the global share folder. So maybe it does make the macros available in OO/LO on that PC as global macros BUT it is required to keep a copy of the macros in the $USER dir. Am I right? What I would like to do (or at least that's what I feel should be done) is not to COPY the macros from a user dir to the global share dir but to MOVE them. So if I do that then the library xlink:href in script.xlc and dialog.xlc should point to something like $(INST)/share/basic/MyLibraryName/script.xlb/. Doing so doesn't make LO or OO complain BUT I don't see my library listed in the gloabl macros tree mode. So I can't run my macros in the global share. As I stated in another e-mail on this list, I managed to actually install my custom BASIC macros within the global share by creating my own extension .oxt file. So I'd be happy with that except for the fact that I can't also bundle my JAVA macros in my extension oxt file. So I'm stuck in the middle: I can install my Java macros by copying them over to the global share (and they work!) but I can0t do the same with Basic macros; and on the other hand I can deploy my Basic macros with a custom extension but not my Java macros. I can combine both methods to do what I need (ie. install custom Basic and Java macros in the global share) but that doesn't sound clean or efficient. Any more ideas? Thanks, Vieri --- On Thu, 6/13/13, Andrew Douglas Pitonyak and...@pitonyak.org wrote: Openoffice stores individual macros in modules. Modules are stored in libraries, and libraries are stored in macro containers. Three things can be macro containers, documents, your user space, and one that is global to OpenOffice. It sounds like you desire to add a macro that is global to OpenOffice. I have never done this It is not enabled on my Linux system, is it available to you to do from the GUI when you are logged in as an administrator? I expect that the Link from Tom Davis is the best you can find, since I don't see an ability to set the Macro location directories in the configuration. On 06/12/2013 02:26 AM, Vieri wrote: Hi, This is probably trivial but I'm not capable of correctly creating new custom macros within %PROGRAMFILES%\LibreOffice 4.0\share\basic\ (Windows 7). 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 also like to avoid location=user (or location=application - I don't remember which is which) because I have PCs that are being used by lots of users and copying/syncing user macros to each user profile on every machine would be a waste of space and network bandwidth. That's why I was hoping to install and update all my macros within the main LO application. Another even better way would be to tell the LO application that my custom macros can be found on a remote server, eg. something like location=url. This way, I'd maintain my macros on my web/ftp/webdav/whatever server (just one single copy) and forget about syncing them with each and every LO client installation. Any ideas? Vieri -- 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] 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 :) From: Vieri rentor...@yahoo.com To: users@global.libreoffice.org Sent: Friday, 14 June 2013, 8:02 Subject: 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\. From the LO/OO GUI I can't create any NEW macros within the global container (grayed out). And I haven't found any option to enable it. So there's obviously some kind of security reason that I don't know how to circumvent. The only document within Tom's links that should do what I want is the following: http://wiki.openoffice.org/wiki/Documentation/Administration_Guide/Using_Custom_Macros_and_Libraries To Make a Custom OpenOffice.org Basic Library Available to All Users on a Network The basic idea of this guide is to create my macros within my user profile folder and then copy them to the global share folder. However, note how the guide suggests to include in script.xlc and dialog.xlc: the library xlink:href should point to $(USER)/basic...etc. I find that wrong (or not what I want). I understand that $(USER) points to the user profile folder where I first wrote my macros. It doesn't point to the global share folder. So maybe it does make the macros available in OO/LO on that PC as global macros BUT it is required to keep a copy of the macros in the $USER dir. Am I right? What I would like to do (or at least that's what I feel should be done) is not to COPY the macros from a user dir to the global share dir but to MOVE them. So if I do that then the library xlink:href in script.xlc and dialog.xlc should point to something like $(INST)/share/basic/MyLibraryName/script.xlb/. Doing so doesn't make LO or OO complain BUT I don't see my library listed in the gloabl macros tree mode. So I can't run my macros in the global share. As I stated in another e-mail on this list, I managed to actually install my custom BASIC macros within the global share by creating my own extension .oxt file. So I'd be happy with that except for the fact that I can't also bundle my JAVA macros in my extension oxt file. So I'm stuck in the middle: I can install my Java macros by copying them over to the global share (and they work!) but I can0t do the same with Basic macros; and on the other hand I can deploy my Basic macros with a custom extension but not my Java macros. I can combine both methods to do what I need (ie. install custom Basic and Java macros in the global share) but that doesn't sound clean or efficient. Any more ideas? Thanks, Vieri --- On Thu, 6/13/13, Andrew Douglas Pitonyak and...@pitonyak.org wrote: Openoffice stores individual macros in modules. Modules are stored in libraries, and libraries are stored in macro containers. Three things can be macro containers, documents, your user space, and one that is global to OpenOffice. It sounds like you desire to add a macro that is global to OpenOffice. I have never done this It is not enabled on my Linux system, is it available to you to do from the GUI when you are logged in as an administrator? I expect that the Link from Tom Davis is the best you can find, since I don't see an ability to set the Macro location directories in the configuration. On 06/12/2013 02:26 AM, Vieri wrote: Hi, This is probably trivial but I'm not capable of correctly creating new custom macros within %PROGRAMFILES%\LibreOffice 4.0\share\basic\ (Windows 7). 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 also like to avoid location=user (or location=application - I don't remember which is which) because I have PCs that are being used by lots of users and copying/syncing user macros to each user profile on every machine would be a waste of space and network bandwidth. That's why I was hoping to install and update all my macros within the main LO application. Another even better way would be to tell the LO application that my custom macros can be found on a remote server, eg. something like location=url. This way, I'd maintain my macros on my web/ftp/webdav/whatever server (just one single copy) and forget about syncing them with each and every LO client installation. Any
[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 following Basic macro: library: 'HMAN_SaveDoc' module: 'HMAN' method: 'SaySomething' location: 'share' However, as you can see in the screenshots I'm attaching, that macro is available (I can run it manually). Does anyone have any suggestions before I file a bug report? Thanks, Vieri -- 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] create custom macro within share location (program files)
--- On Fri, 6/14/13, Tom Davies tomdavie...@yahoo.co.uk 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_Guide/Using_Custom_Macros_and_Libraries needs significant updating? It doesn't fully address what I'm trying to do. Regards, Vieri -- 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] 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 other programs using the ODF formats. Even if the bug-report doesn't get fixed quickly then at least there is a record of the problem. If the problem affects enough people then it probably gets listed in the Release Notes. The question is how can we attract more devs and once they have started working on some parts of LO how can we attract them into fixing old problems rather than just going off to some other project? 2. Formats are likely to grow and change in the future. LO uses ODF 1.2 (Extended) and hopefully the departures from normal 1.2 are documented. If you want to return to pure 1.2 then it's fairly easy to look up the ISO standard for that. If you want to return to 1.1, or the 1.0 then again it's reasonably easy to look up the specs for those too. Those specs closely match the way it's implemented in the various programs that use the format. 3. You can find programs that still use the older formats. Even LO can be switched to using older formats. See Tools - Options - Load/Save - General 4. The devs have created a new format for LO that wraps up the 3 older formats, 1.2 (not extended), 1.1 and 1.0 and are calling it something like 1.2 Extended (compat). Files created using that format will be able to be read by legacy software that can only read 1.0 or only 1.1. Presumably at some point we are going to find the options listed in Tools - Options - Load/Save - General to drop from 4 formats back down to 2. The whole point of ODF is that even if or when programs do abandon a particular version of it that format is still readable because the format is implemented as specified. The point is NOT to condemn us all to sticking with an unchanging format for the next few hundred years! Change is inevitable. Documenting those changes is part of the aim of ODF so that old files can be read. This is going waaay off-topic again. Regards from Tom :) From: Ken Springer snowsh...@q.com To: users@global.libreoffice.org Sent: Friday, 14 June 2013, 0:32 Subject: [libreoffice-users] Re: LO 4.0.3.3: 'Insert: Horizontal rule' is missing On 6/13/13 5:12 PM, Tom Davies wrote: Hi :) Hmm, there are many reasons for preferring non-MS. Backwards compatibility is just 1 of the issues. Current compatibility with it's own current formats is another. A third is whether it's current formats work with non-MS products that do follow the OOXML ISO standard. Regards from Tom :) Preferring MS or not, or any other format, isn't the point here. It's accessing the old files regardless of format, which even LO appears to be abandoning. You can't have it both ways, use ODT because the standards will remain unchanged so old files can be accessed while accepting a decision that prevents the accurate opening of the old files. -- Ken Mac OS X 10.8.4 Firefox 20.0 Thunderbird 17.0.5 LibreOffice 4.0.3.3 -- 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
[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 removing the horizontal rule is the same type of practice for which people bad mouth MS. snip 3. You can find programs that still use the older formats. Even LO can be switched to using older formats. See Tools - Options - Load/Save - General So, I guess if Maurice still wants to use the horizontal rule ( or any other deprecated features) he should abandon the current LO and use the older programs? Pray tell, if you drop the horizontal rule from the new version, how do you load and save a document that has a horizontal rule? 4. The devs have created a new format for LO that wraps up the 3 older formats, 1.2 (not extended), 1.1 and 1.0 and are calling it something like 1.2 Extended (compat). Files created using that format will be able to be read by legacy software that can only read 1.0 or only 1.1. Presumably at some point we are going to find the options listed in Tools - Options - Load/Save - General to drop from 4 formats back down to 2. I submit that files created by the new format will only load correctly in the older software if the features in the new documents are supported in the old software. The whole point of ODF is that even if or when programs do abandon a particular version of it that format is still readable because the format is implemented as specified. The point is NOT to condemn us all to sticking with an unchanging format for the next few hundred years! Change is inevitable. Documenting those changes is part of the aim of ODF so that old files can be read. Readable does not equate to useable, which I think is Maurice's point. Making the file readable by legacy software is rather a waste of time anyway, since the legacy software will eventually be broken by the evolution of the different OSes. Making older files with the legacy formats useable, not just readable, is a valid goal. That saves the user having to take the time to redo the document when it's a document that is still being used. Such as a template. Even if the new software can't save in the old format, if you read the old format 100% correctly, then all you have to do is Save As in the new format. And the user gets on with life. I would have to agree with Maurice, dropping the horizontal rule is dumb, especially if it now takes more work at the user's end to create one with HTML tags. One of the reasons for computers is to get rid of having to do repetitive things by the human. Have the computer do it. For me, it's becoming a moot point. I'd rather pay for program(s) that do what I need without issues (never 100% possible, but I'm finding more possible than with LO) and constantly mess with free software. Thunderbird is the other program for me that is on very thin ice. This is going waaay off-topic again. True, but it's a good conversation. :-) -- Ken Mac OS X 10.8.4 Firefox 20.0 Thunderbird 17.0.5 LibreOffice 4.0.3.3 -- 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] Searching numbers between two values
Hi,
I'm using LibreOffice 4.0.3.3 (Build az.: 400m0(Build:3)).
BetweenTwoNumbers.ods
http://nabble.documentfoundation.org/file/n4061491/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 there are three functions to determine how many
numbers can find on sheets Num 1, Num 2 and Num 3 respectivly ( one by one )
and there is a fourth function that sholud count that at once on all Num 1-3
sheets.
As one can see, none of these three functions works:
=COUNTIF('Num 1'.A1;AND('Num 1'.A120;'Num 1'.A160))
=COUNTIF('Num 2'.A3;AND('Num 2'.A320;'Num 2'.A360))
=COUNTIF('Num 3'.A5;AND('Num 3'.A520;'Num 3'.A560))
moreover, I don't know how to create fourth function.
Can one advice me how to go further?
-
Best Regards from
Pál
--
View this message in context:
http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491.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] DDE Links from calc to writer
Is there such a thing as to many DDE links? Original Message From: Mike Shaul m...@shaulph.ca 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 spreadsheet I created in calc. It has recently been acting funny, when I change a value in the calc spreadsheet it used to change all the values in the document in writer. Now, about 80% of the writer document responds to the changes in calc but about 20% does not. Could this be due to having too many links? I have about 3400 DDE links. I'm using: LibreOffice 3.5.4.2 Linux mint Cinnamon I should also say that on a scale from 1-10 on computer knowledge I'm at best a 5. Thank you in advance, -Mike -- 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 -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. -- 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] 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
http://nabble.documentfoundation.org/file/n4061491/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 there are
three functions to determine how many numbers
can find on sheets Num 1, Num 2 and Num 3
respectively ( one by one ) and there is a
fourth function that should count that at once on all Num 1-3 sheets.
As one can see, none of these three functions works:
=COUNTIF('Num 1'.A1;AND('Num 1'.A120;'Num 1'.A160))
=COUNTIF('Num 2'.A3;AND('Num 2'.A320;'Num 2'.A360))
=COUNTIF('Num 3'.A5;AND('Num 3'.A520;'Num 3'.A560))
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
(!)
I trust this helps.
Brian Barker
--
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: 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 also like to avoid location=user (or location=application - I don't remember which is which) because I have PCs that are being used by lots of users and copying/syncing user macros to each user profile on every machine would be a waste of space and network bandwidth. That's why I was hoping to install and update all my macros within the main LO application. Another even better way would be to tell the LO application that my custom macros can be found on a remote server, eg. something like location=url. This way, I'd maintain my macros on my web/ftp/webdav/whatever server (just one single copy) and forget about syncing them with each and every LO client installation. Any ideas? My solution at work is like this: I maintain several macros for all users as a personal basic library. If they are running correctly, I export the library to a public network share. Other users have to import the library - only once, if imported as reference. This is quite useful, because I can update the public library when necessary without further work on the clients. HTH Stefan -- System: opensuse 12.3 - 64-bit -- 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: 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...@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: 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
(!)
I trust this helps.
Yes, this helps.
-
Best Regards from
Pál
--
View this message in context:
http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061514.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: 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 http://nabble.documentfoundation.org/file/n4061519/BetweenTwoNumbers.ods I uploaded the file again, because I changed it a little. I changed it because I search for a function which I can put in to just one cell of the 'between 20-60' sheet. - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061519.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] 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 absolutely no need! Other options are the COUNTIFS function or SUMPRODUCT. Yes: I thought of SUMPRODUCT() too, but didn't see how to use it conveniently. Brian Barker -- 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] 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
http://nabble.documentfoundation.org/file/n4061519/BetweenTwoNumbers.ods
I uploaded the file again, because I changed it
a little. I changed it because I search for a
function which I can put in to just one cell of the 'between 20-60' sheet.
Try:
=SUMIF('Num 1'.A1:Z99;20)-SUMIF('Num
1'.A1:Z99;=60)+SUMIF('Num
2'.A1:Z99;20)-SUMIF('Num
2'.A1:Z99;=60)+SUMIF('Num 3'.A1:Z99;20)-SUMIF('Num 3'.A1:Z99;=60)
There may be neater solutions!
I trust this helps.
Brian Barker
--
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: 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 - many thanks, Stuart. -- /\/\aurice -- 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] Re: LO 4.0.3.3: 'Insert: Horizontal rule' is missing
On Thu, Jun 13, 2013 at 1:50 PM, Tom Davies tomdavie...@yahoo.co.uk 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 remembering that sort of thing but there is a competition coming up soon and it would be great if the Users List were able to walk off with some of the prizes. It's a t-shirt rather than a cup or trophy for the top 10 so it's a tad more useful! In general we don't want users playing around with the stuff on top unless they take a little time to get involved with QA - mainly because there are nuances and more times than not users mark something incorrectly (like updating the version when tested against a newer release which is not the correct workflow) and then QA has to go and reverse everything and explain policies. For anyone interested in learning about QA stuff I recommend reading https://wiki.documentfoundation.org/QA/BugTriage which breaks down workflow relatively well. And yes, I do invite everyone to participate in our triage competition/event and to join our QA channel where you'll find quite a few helpful people to get you started :) Hope that didn't come off as rough, just want to be clear that the top section is meant to be for people who know what they are doing - and learning requires individuals to be a little proactive. Plenty of people (myself included) offer help all the time, definitely willing to meet people half way if they want to join - you (Tom) know more than most that we could surely use the help :) Warm Regards, Joel -- *Joel Madero* LibreOffice QA Volunteer jmadero@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] 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...@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: Searching numbers between two values
I found a solution! On can see it in the following uploaded file.
BetweenTwoNumbers.ods
http://nabble.documentfoundation.org/file/n4061578/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('Num 2'.A1;60;'Num
2'.A1)+SUMIF('Num 3'.A1;20;'Num 3'.A1)-SUMIF('Num 3'.A1;60;'Num 3'.A1)
Is there a simpler way to do it?
-
Best Regards from
Pál
--
View this message in context:
http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061578.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] 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 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: 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;60;'Num 2'.A1)+SUMIF('Num
3'.A1;20;'Num 3'.A1)-SUMIF('Num 3'.A1;60;'Num 3'.A1)
You seemed to want to exclude 60 (as well as 20)
from your range to be summed. If so, you need =60 (three times), not 60.
Is there a simpler way to do it?
Yes, there is. If the third parameter of SUMIF()
- SumRange - is missing, the values found in
the first parameter - Range - are summed
instead. Since your third parameters are all the
same as your first parameters, you can omit
them. Oh, look: that's what I did in my earlier suggestion!
Brian Barker
--
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
