Re: [libreoffice-users] Re: New User: Three Questions
On Thu, 28 Jul 2011, Tom Davies wrote: My understanding of hard-links is sketchy but i think they don't create copies of files http://www.cyberciti.biz/tips/understanding-unixlinux-symbolic-soft-and-hard-links.html Hard links use another node for the same file; that's equivalent to making copies. Each directory has a limited, but large, number of nodes available. That's why a partition can be out of space while not completely filled if there are several thousand tiny files in it. Rich -- 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: Base record access unacceptably slow
Heinz, I completely agree. LO without a function Base won't fly. Either TDF recognizes this - by DOING something - or we have our answer. Tom On 07/28/2011 05:08 AM, Heinrich Stoellinger wrote: Hallo Andreas, In my view, BASE falling apart would mean LO's death sentence in the long run! Anybody in even the simplest business environment will want to write documents based on data stored in business-critical databases (and I think I am right in assumung that relational DBs have been the standard now for decades!). Does anybody REALLY think that a package like LO can survive if it ignores such an important sector of users? I sure don't!!! Gruesse aus Salzburg Heinz On Thu, 28 Jul 2011 12:18:49 +0200, Andreas Säger ville...@t-online.de wrote: Am 28.07.2011 08:15, Heinrich Stoellinger wrote: I am not giving up hope yet for LO 3.4.2 - especially since it targets business... Isn't there a OpenSource fork of MySQL called MariaDB?!? Regards H Dear Heinrich, Face it: There is not a single LO developer doing anything Base related. The Base component will fall apart sooner or later. Writer's mail merge and bibliography will be spreadsheets, form controls will be mere gimmicks and nobody except you and me and some hundreds of professionals will notice the severe loss. Grüße aus NRW, Andreas -- 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] Doubt about digital signature
Hi :) Do you have any personal info stored in Tools - Options - LibreOffice - UserData I seem to remember some weird bug about this sort of thing not working unless there was some personal data in there? Even if it's fictitious or so generic that it doesn't get traced back you you as an individual it seemed to help with something like this a few months ago. I could be wrong as Jay brilliantly fixed the problem last time so this is probably some other issue Regards from Tom :) From: planas jsloz...@gmail.com To: users@global.libreoffice.org Sent: Wed, 27 July, 2011 23:54:27 Subject: Re: [libreoffice-users] Doubt about digital signature Hi Grasiela, On Wed, 2011-07-27 at 12:00 -0300, Grasiela Peccini wrote: Hi, I need information about digital signature. I don't know if i'm working with a bug or it's a normal behavior of LibreOffice. The steps: 1- User saves a document and signs it, when is requested the PIN 2 - User makes changes on the document, saves it and signs it again 3 - Here is the point. The PIN is no longer requested. A new request is made only when the smart card is removed from the reader or when the LibreOffice is closed and reopened. I'm using LibreOffice 3.3.0, on Windows XP. I've done the same test on LibreOffice 3.4, with the same results. Thanks a lot, Grasip. -- Eu quase nada sei, mas desconfio de muita coisa. Guimarães Rosa Are saving the document with a password using FILESAVE AS and selecting Save with Password? When I tested this with file with a password, I was asked for it every time I opened the file. I do not use a smart card so the behavior may be caused by the smart card. -- Jay Lozier jsloz...@gmail.com -- 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 -- 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: Base record access unacceptably slow
Don, Seems like a reasonable request to me, and I'll up the ante. Where the ^%$ is the management - The Document Foundation - in all this, right now, today? Do they even watch this list? In short, do they give a damn that the only theoretically viable alternative to Access (for ordinary users) is in real trouble? Why aren't they showing up here with some clarifying position statement? I'm desperate for time, a fix, and vision of a long-term solution to this mess. I have work to do today, a lot of it, and I can't do it. I can't solve the problem, and other than by implementing the regress-your-java solution idea (which I have yet to be successful with). No one else is solving it, either. For some, migrating to another backend is not a challenge. For the rest of us, it's unknown territory. I researched this a bit, and while there certainly IS stuff out there about how to do it, there's not a lot, and there are multiple levels of challenge with this solution anyway. Personally, I'm definitely up for taking this on (what option do I really have?), but do we really have to straggle through the mountains one by one, eventually meeting on the other side, those who make it, to talk about the experience? So, I propose two things: 1. Anyone who has TDF connections - please get on the phone and update them. The question is this, I think: how important, going forward, is Base, to them? If they are going to support it, today would be a very good day to do it. If not, yank the code, stop telling people they have a db component in LO, and start getting honest. 2. If LO's in trouble with the current sun-Java, so's OO. Where's Apache in this situation? Again, where's *TDF*? Why aren't they and Apache working together on this? Looks rather like a leadership problem, to me. 2. On the assumption that those of use who need a working db are going to have to find the way home ourselves (as I said, I need to get work done TODAY, and I'm not kidding) - a. Can someone more Linux-clever than I lay out clearly the steps involve in implementing the solution found at the end of this thread - http://www.oooforum.org/forum/viewtopic.phtml?t=125253postdays=0postorder=ascstart=0 http://www.oooforum.org/forum/viewtopic.phtml?t=125253postdays=0postorder=ascstart=0. As I pointed on in another post last night, I tried it and simply got in over my head. This is a decent short-term solution. b. Can we work together to lay out the steps to set up an alternative back end? I'm going to start on sqlite, Others may wish to work on a different db engine. Then let's get the procedure out where it can be seen and used by others. c. Let's get altruistic about the poor bloke who, this morning, is about to set up a Base db using a java-run backend: Could someone put a notice in the documentation updating people about the current situation? It's not right for us to keep this information only on this list. Now I'm off to fully regress my java (I don't see a problem with this), while I work on getting sqlite and Base to play together. Tom On 07/28/2011 09:16 AM, Don C. Myers wrote: Hi Tom, When the first problems showed up for me about 6 months ago, it was recommended to go back to the Java 1.6.0.22 from 1.6.0.24. I have my database on 4 computers, and could never make things work with getting a previous version installed, so I gave up and just tolerated the situation. Also, I had security concerns going backwards since, as I understand it, among other things updated Java versions have have security issues fixed. I'm relatively good with Ubuntu, but far from an expert. What we all know is that Java is the problem. Can someone give us instructions on how to use the LibreOffice front end with a database that doesn't require Java. I see that you had said that LibreOffice may be moving to sqlite? Is that a solution that anyone could help us with? Don On 07/28/2011 04:04 AM, Tom Cloyd wrote: , On 07/28/2011 12:53 AM, Tom Cloyd wrote: On 07/28/2011 12:44 AM, Alexander Thurgood wrote: Le 27/07/11 18:14, Tom Cloyd a écrit : That command appears to have cut 5 seconds off the record pointer move test, and also off the full db search test I ran previously. Well better than nothing I suppose, but I do sympathise. Did the JDK/JRE change suggested by someone else help any further ? Alex Am just about to make the switch - will let you know asap! I'm very hopeful. And I've decided to switch to sqlite when I'm not so rushed. Have heard that that's where LO's going anyway. Tom Ug. This is getting ugly really fast. I'm really not on home ground here at all. After 15 minutes of trying to make sense of what I found at http://archive.canonical.com/ubuntu/pool/partner/s/sun-java6/, I downloaded sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb and sun-java6-jre_6.22-0ubuntu1~10.04_all.deb, following the thread at
Re: [libreoffice-users] Re: Base record access unacceptably slow
Hi :) I agree too but i think we have to agitate to get something done. So far the only response i got was an unhelpful RMS quote. I have a Gandhi one First they ignore you, then they laugh at you, then they fight you, then you win.. Which means we have all 4 steps to work through but since some fairly major companies would benefit it might be possible to get through most of those steps quite fast. Could TDF join http://montyprogram.com/commercial/ Would that help? TDF is not the type of organisation where we wait to see what they do. It's up to us to work out what we need and from who and go get it. Regards from Tom :) From: Tom Cloyd t...@tomcloyd.com To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 17:06:15 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow Heinz, I completely agree. LO without a function Base won't fly. Either TDF recognizes this - by DOING something - or we have our answer. Tom On 07/28/2011 05:08 AM, Heinrich Stoellinger wrote: Hallo Andreas, In my view, BASE falling apart would mean LO's death sentence in the long run! Anybody in even the simplest business environment will want to write documents based on data stored in business-critical databases (and I think I am right in assumung that relational DBs have been the standard now for decades!). Does anybody REALLY think that a package like LO can survive if it ignores such an important sector of users? I sure don't!!! Gruesse aus Salzburg Heinz On Thu, 28 Jul 2011 12:18:49 +0200, Andreas Säger ville...@t-online.de wrote: Am 28.07.2011 08:15, Heinrich Stoellinger wrote: I am not giving up hope yet for LO 3.4.2 - especially since it targets business... Isn't there a OpenSource fork of MySQL called MariaDB?!? Regards H Dear Heinrich, Face it: There is not a single LO developer doing anything Base related. The Base component will fall apart sooner or later. Writer's mail merge and bibliography will be spreadsheets, form controls will be mere gimmicks and nobody except you and me and some hundreds of professionals will notice the severe loss. Grüße aus NRW, Andreas -- 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 -- 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: Base record access unacceptably slow
Has anybody suggested that this command should an option when saving when ever records are deleted? On 7/27/2011 12:14 PM, Tom Cloyd wrote: SHUTDOWN COMPACT -- 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: Base record access unacceptably slow
Hi, Different ones of us have tried this. It is a Java issue. I keep my database compacted on a regular basis. Thank you for trying to be of assistance. Don On 07/28/2011 12:45 PM, Paul D. Mirowsky wrote: Has anybody suggested that this command should an option when saving when ever records are deleted? On 7/27/2011 12:14 PM, Tom Cloyd wrote: SHUTDOWN COMPACT -- *** * -- 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: Base record access unacceptably slow
Tom Cloyd wrote: much clipped to save space 2. If LO's in trouble with the current sun-Java, so's OO. Where's Apache in this situation? Again, where's *TDF*? Why aren't they and Apache working together on this? Looks rather like a leadership problem, to me. Tom, the other points I can not speak to but Apache does not have the code to work with yet. There are people working on getting it so that work can get started. Base is one of the problem areas that I plan to help work on, maybe a move to another DB engine is the answer. As side note: There are sections on the two forums for base tutorials. [1] http://user.services.openoffice.org/en/forum/viewforum.php?f=83 [2] http://www.oooforum.org/forum/viewforum.phtml?f=10 I am no expert on Base so can not say how much the links will help but hopefully they will help some. Andy -- 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: Base record access unacceptably slow
Hi, Le 28/07/2011 18:10, Heinrich Stoellinger a écrit : In my view LO/OO do NOT require Java, neither on Linux nor on Windows. AFAIK, LO/OOo currently *DO* require Java for Base to simply work. TDF have announced they would get rid of the java-isms in the code. This implies a major rewrite of Base, though. -- Jean-Francois Nifenecker, Bordeaux -- 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: Base record access unacceptably slow
Hi Tom, Thank you for your great ideas and suggestions. Starting with Java 1.6.0_24, this problem arose with both OpenOffice Base and LibreOffice Base. The problems were documented on an OpenOffice forum that I searched when the problem first arose. Another alternative would be for LibreOffice to have its own embedded version of Java that works instead of using the system Java. One person a month or so ago posted here as to the exact reason the issue has happened. He felt the problem would be corrected when Java was again updated. I was greatly disappointed when 1.6.0_26 came out and the issue was still here. My data base has about 2500 entries with complete contact information, and then a separate text area I use to keep a running record of my contacts with each person. Before Java 1.6.0_24 going from the first record to last last record was almost instantaneous. Now if is painful. I wait patiently for the 20 to 25 seconds for it to happen on my fastest computer, a quad core AMD 910 with 8 gigs of ram. It is slower on my other ones. Then paging backwards through the database, I can click 5 records and each one appears instantly, then before the 6th record there is a pause. This happens consistently. 5 records, pause, 5 records, pause. I need a database. I need one that works proficiently in Linux. I was so glad when Base was added to OpenOffice. I used it for years without issue until about 6 months ago. Don On 07/28/2011 12:22 PM, Tom Cloyd wrote: Don, Seems like a reasonable request to me, and I'll up the ante. Where the ^%$ is the management - The Document Foundation - in all this, right now, today? Do they even watch this list? In short, do they give a damn that the only theoretically viable alternative to Access (for ordinary users) is in real trouble? Why aren't they showing up here with some clarifying position statement? I'm desperate for time, a fix, and vision of a long-term solution to this mess. I have work to do today, a lot of it, and I can't do it. I can't solve the problem, and other than by implementing the regress-your-java solution idea (which I have yet to be successful with). No one else is solving it, either. For some, migrating to another backend is not a challenge. For the rest of us, it's unknown territory. I researched this a bit, and while there certainly IS stuff out there about how to do it, there's not a lot, and there are multiple levels of challenge with this solution anyway. Personally, I'm definitely up for taking this on (what option do I really have?), but do we really have to straggle through the mountains one by one, eventually meeting on the other side, those who make it, to talk about the experience? So, I propose two things: 1. Anyone who has TDF connections - please get on the phone and update them. The question is this, I think: how important, going forward, is Base, to them? If they are going to support it, today would be a very good day to do it. If not, yank the code, stop telling people they have a db component in LO, and start getting honest. 2. If LO's in trouble with the current sun-Java, so's OO. Where's Apache in this situation? Again, where's *TDF*? Why aren't they and Apache working together on this? Looks rather like a leadership problem, to me. 2. On the assumption that those of use who need a working db are going to have to find the way home ourselves (as I said, I need to get work done TODAY, and I'm not kidding) - a. Can someone more Linux-clever than I lay out clearly the steps involve in implementing the solution found at the end of this thread - http://www.oooforum.org/forum/viewtopic.phtml?t=125253postdays=0postorder=ascstart=0 http://www.oooforum.org/forum/viewtopic.phtml?t=125253postdays=0postorder=ascstart=0. As I pointed on in another post last night, I tried it and simply got in over my head. This is a decent short-term solution. b. Can we work together to lay out the steps to set up an alternative back end? I'm going to start on sqlite, Others may wish to work on a different db engine. Then let's get the procedure out where it can be seen and used by others. c. Let's get altruistic about the poor bloke who, this morning, is about to set up a Base db using a java-run backend: Could someone put a notice in the documentation updating people about the current situation? It's not right for us to keep this information only on this list. Now I'm off to fully regress my java (I don't see a problem with this), while I work on getting sqlite and Base to play together. Tom On 07/28/2011 09:16 AM, Don C. Myers wrote: Hi Tom, When the first problems showed up for me about 6 months ago, it was recommended to go back to the Java 1.6.0.22 from 1.6.0.24. I have my database on 4 computers, and could never make things work with getting a previous version installed, so I gave up and just tolerated the situation. Also, I had security concerns going backwards since,
Re: [libreoffice-users] Re: Base record access unacceptably slow
I'm up for it! (Love that quote!) Maybe leaking this issue to the press would get some attention?? Tom C. On 07/28/2011 10:29 AM, Tom Davies wrote: Hi :) I agree too but i think we have to agitate to get something done. So far the only response i got was an unhelpful RMS quote. I have a Gandhi one First they ignore you, then they laugh at you, then they fight you, then you win.. Which means we have all 4 steps to work through but since some fairly major companies would benefit it might be possible to get through most of those steps quite fast. Could TDF join http://montyprogram.com/commercial/ Would that help? TDF is not the type of organisation where we wait to see what they do. It's up to us to work out what we need and from who and go get it. Regards from Tom :) From: Tom Cloydt...@tomcloyd.com To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 17:06:15 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow Heinz, I completely agree. LO without a function Base won't fly. Either TDF recognizes this - by DOING something - or we have our answer. Tom On 07/28/2011 05:08 AM, Heinrich Stoellinger wrote: Hallo Andreas, In my view, BASE falling apart would mean LO's death sentence in the long run! Anybody in even the simplest business environment will want to write documents based on data stored in business-critical databases (and I think I am right in assumung that relational DBs have been the standard now for decades!). Does anybody REALLY think that a package like LO can survive if it ignores such an important sector of users? I sure don't!!! Gruesse aus Salzburg Heinz On Thu, 28 Jul 2011 12:18:49 +0200, Andreas Sägerville...@t-online.de wrote: Am 28.07.2011 08:15, Heinrich Stoellinger wrote: I am not giving up hope yet for LO 3.4.2 - especially since it targets business... Isn't there a OpenSource fork of MySQL called MariaDB?!? Regards H Dear Heinrich, Face it: There is not a single LO developer doing anything Base related. The Base component will fall apart sooner or later. Writer's mail merge and bibliography will be spreadsheets, form controls will be mere gimmicks and nobody except you and me and some hundreds of professionals will notice the severe loss. Grüße aus NRW, Andreas -- 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 -- 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] Shrinking buttons
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a spreadsheet containing 39 sheets, of which 21 are duplicates of one another. They represent tables in a restaurant. On an average laptop or desktop, everything is fine. When I load this up on a netbook with lousy resolution (1024x600), every time I save the file, the buttons on the 21 sheets get smaller and smaller till they some of them have a height of .06cm making them unusable. I leave the screen scaling at 100%. I manually went thru 10 of the sheets and using the forms control tool reset each button to its proper dimensions. Everything looked good as I went from sheet to sheet. I saved the file and brought it back up and the height that was .50cm is now .33cm or .31cm. Why they are different is a mystery. Another save and reload AND SOME OF THE BUTTONS are smaller still. I have no code that attempts to manipulate the buttons, so I conclude that LO is making the changes, and is making these changes permanent across saves. If I move the file back to my development laptop, its trashed. I understand scaling due to resolution issues, but rewriting my code permanently has got to be a bug. I tested this on Fedora 14 as OpenOffice and Fedora 15 as LibreOffice. Both display the identical problem. I can supply additional details, as the whole story has some additional twists, but I'd like to know if this will be taken as a serious issue. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 IM:billgradw...@gmail.com (No email please-IM only) -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk4xlOkACgkQ7Orvev+eC8pjqQCbBadkTrBEznB0UjH8OAM/qRAP 0mwAoLEXYNCs9dYHwuo4DZZDqqfI+WSm =0qkh -END PGP SIGNATURE- -- 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: Base record access unacceptably slow
Hi :) I think it's more a case of working on several fronts within TDF. 1. joining the Steering-Discuss mailing list and promoting the cause there. 2. working out a few large organisations that could put resources towards it. What would they gain? Canonical (of Ubuntu fame) and RedHat might reduce a blocker that stops people from leaving Windows. Google migth gain an OpenSource database that they could adapt to add to their Cloud initiative, Google-Docs. All three would increase the level of support they could sell to companies and perhaps even to individuals. Support contracts are one of the main money spinners in OpenSource. 3. find places where devs are. Preferably ones that are familiar with working on database issues and see if we can encourage some to work on Base. But they would have to be happy about releasing the code under copy-left rather than copyright agreements to keep things OpenSource. There might be other OpenSource programs that rely on Base in some way that might be willing to encourage some of their devs to take the opportunity to steer things in a useful direction for their needs. Errr, some of these ideas might be daft and i am very likely missing some other positive directions. As for the press it's better if outsiders see TDF in a positive light so that people are attracted to the quagmire that is Base and pleased to join in and fix it. Regards from Tom :) From: Tom Cloyd t...@tomcloyd.com To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 18:16:57 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow I'm up for it! (Love that quote!) Maybe leaking this issue to the press would get some attention?? Tom C. On 07/28/2011 10:29 AM, Tom Davies wrote: Hi :) I agree too but i think we have to agitate to get something done. So far the only response i got was an unhelpful RMS quote. I have a Gandhi one First they ignore you, then they laugh at you, then they fight you, then you win.. Which means we have all 4 steps to work through but since some fairly major companies would benefit it might be possible to get through most of those steps quite fast. Could TDF join http://montyprogram.com/commercial/ Would that help? TDF is not the type of organisation where we wait to see what they do. It's up to us to work out what we need and from who and go get it. Regards from Tom :) From: Tom Cloydt...@tomcloyd.com To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 17:06:15 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow Heinz, I completely agree. LO without a function Base won't fly. Either TDF recognizes this - by DOING something - or we have our answer. Tom On 07/28/2011 05:08 AM, Heinrich Stoellinger wrote: Hallo Andreas, In my view, BASE falling apart would mean LO's death sentence in the long run! Anybody in even the simplest business environment will want to write documents based on data stored in business-critical databases (and I think I am right in assumung that relational DBs have been the standard now for decades!). Does anybody REALLY think that a package like LO can survive if it ignores such an important sector of users? I sure don't!!! Gruesse aus Salzburg Heinz On Thu, 28 Jul 2011 12:18:49 +0200, Andreas Sägerville...@t-online.de wrote: Am 28.07.2011 08:15, Heinrich Stoellinger wrote: I am not giving up hope yet for LO 3.4.2 - especially since it targets business... Isn't there a OpenSource fork of MySQL called MariaDB?!? Regards H Dear Heinrich, Face it: There is not a single LO developer doing anything Base related. The Base component will fall apart sooner or later. Writer's mail merge and bibliography will be spreadsheets, form controls will be mere gimmicks and nobody except you and me and some hundreds of professionals will notice the severe loss. Grüße aus NRW, Andreas -- 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 -- 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 -- 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
Re: [libreoffice-users] Re: Base record access unacceptably slow
Once again I find myself agreeing with you, on all fronts. I'm also keenly aware that I'm maxed out right now and must first get my db running (via java regression) then get some work done. Hours I don't have have been lost this morning trying to decide what to do about all this, and I must get something moving forward, immediately. Will return. Tom C On 07/28/2011 12:02 PM, Tom Davies wrote: Hi :) I think it's more a case of working on several fronts within TDF. 1. joining the Steering-Discuss mailing list and promoting the cause there. 2. working out a few large organisations that could put resources towards it. What would they gain? Canonical (of Ubuntu fame) and RedHat might reduce a blocker that stops people from leaving Windows. Google migth gain an OpenSource database that they could adapt to add to their Cloud initiative, Google-Docs. All three would increase the level of support they could sell to companies and perhaps even to individuals. Support contracts are one of the main money spinners in OpenSource. 3. find places where devs are. Preferably ones that are familiar with working on database issues and see if we can encourage some to work on Base. But they would have to be happy about releasing the code under copy-left rather than copyright agreements to keep things OpenSource. There might be other OpenSource programs that rely on Base in some way that might be willing to encourage some of their devs to take the opportunity to steer things in a useful direction for their needs. Errr, some of these ideas might be daft and i am very likely missing some other positive directions. As for the press it's better if outsiders see TDF in a positive light so that people are attracted to the quagmire that is Base and pleased to join in and fix it. Regards from Tom :) From: Tom Cloydt...@tomcloyd.com To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 18:16:57 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow I'm up for it! (Love that quote!) Maybe leaking this issue to the press would get some attention?? Tom C. On 07/28/2011 10:29 AM, Tom Davies wrote: Hi :) I agree too but i think we have to agitate to get something done. So far the only response i got was an unhelpful RMS quote. I have a Gandhi one First they ignore you, then they laugh at you, then they fight you, then you win.. Which means we have all 4 steps to work through but since some fairly major companies would benefit it might be possible to get through most of those steps quite fast. Could TDF join http://montyprogram.com/commercial/ Would that help? TDF is not the type of organisation where we wait to see what they do. It's up to us to work out what we need and from who and go get it. Regards from Tom :) From: Tom Cloydt...@tomcloyd.com To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 17:06:15 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow Heinz, I completely agree. LO without a function Base won't fly. Either TDF recognizes this - by DOING something - or we have our answer. Tom On 07/28/2011 05:08 AM, Heinrich Stoellinger wrote: Hallo Andreas, In my view, BASE falling apart would mean LO's death sentence in the long run! Anybody in even the simplest business environment will want to write documents based on data stored in business-critical databases (and I think I am right in assumung that relational DBs have been the standard now for decades!). Does anybody REALLY think that a package like LO can survive if it ignores such an important sector of users? I sure don't!!! Gruesse aus Salzburg Heinz On Thu, 28 Jul 2011 12:18:49 +0200, Andreas Sägerville...@t-online.de wrote: Am 28.07.2011 08:15, Heinrich Stoellinger wrote: I am not giving up hope yet for LO 3.4.2 - especially since it targets business... Isn't there a OpenSource fork of MySQL called MariaDB?!? Regards H Dear Heinrich, Face it: There is not a single LO developer doing anything Base related. The Base component will fall apart sooner or later. Writer's mail merge and bibliography will be spreadsheets, form controls will be mere gimmicks and nobody except you and me and some hundreds of professionals will notice the severe loss. Grüße aus NRW, Andreas -- 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 -- 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:
Re: [libreoffice-users] Re: Base record access unacceptably slow
Hi :) Apache are far behind TDF in this. They are about where TDF was about 11 months ago; with no infrastructure and bloated code filled with nonsense entangling the useful stuff. TDF is not traditional hierarchical organisation where they run things and we wait for them to do stuff. There is no them and us there is only us and some more of us. We need some of us that have experience and knowledge about databases to join in with management levels by joining Steering-Discuss and finding ways to manage a drive forwards for Base. We need to manage this not sitwait. Regards from Tom :) From: Andy Brown a...@the-martin-byrd.net To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 17:57:32 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow Tom Cloyd wrote: much clipped to save space 2. If LO's in trouble with the current sun-Java, so's OO. Where's Apache in this situation? Again, where's *TDF*? Why aren't they and Apache working together on this? Looks rather like a leadership problem, to me. Tom, the other points I can not speak to but Apache does not have the code to work with yet. There are people working on getting it so that work can get started. Base is one of the problem areas that I plan to help work on, maybe a move to another DB engine is the answer. As side note: There are sections on the two forums for base tutorials. [1] http://user.services.openoffice.org/en/forum/viewforum.php?f=83 [2] http://www.oooforum.org/forum/viewforum.phtml?f=10 I am no expert on Base so can not say how much the links will help but hopefully they will help some. Andy -- 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 -- 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: Base record access unacceptably slow
Hi :) It might be a good idea to post a bug-report http://wiki.documentfoundation.org/BugReport I think the guide helps you look-up to see if there is already a bug-report about it but if you don't have time for that just post the reoprt and worry about it later. Triagers can mark bugs as duplicates quite quickly when they are on a roll. Regards from Tom :) From: Paul D. Mirowsky p_mirow...@bentaxna.com To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 17:45:05 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow Has anybody suggested that this command should an option when saving when ever records are deleted? On 7/27/2011 12:14 PM, Tom Cloyd wrote: SHUTDOWN COMPACT -- 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 -- 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] Doubt about digital signature
Hi Alex, Tom I'm using Windows XP and the user information is correctly stored... Regards, Grasip. On Thu, Jul 28, 2011 at 1:12 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Do you have any personal info stored in Tools - Options - LibreOffice - UserData I seem to remember some weird bug about this sort of thing not working unless there was some personal data in there? Even if it's fictitious or so generic that it doesn't get traced back you you as an individual it seemed to help with something like this a few months ago. I could be wrong as Jay brilliantly fixed the problem last time so this is probably some other issue Regards from Tom :) From: planas jsloz...@gmail.com To: users@global.libreoffice.org Sent: Wed, 27 July, 2011 23:54:27 Subject: Re: [libreoffice-users] Doubt about digital signature Hi Grasiela, On Wed, 2011-07-27 at 12:00 -0300, Grasiela Peccini wrote: Hi, I need information about digital signature. I don't know if i'm working with a bug or it's a normal behavior of LibreOffice. The steps: 1- User saves a document and signs it, when is requested the PIN 2 - User makes changes on the document, saves it and signs it again 3 - Here is the point. The PIN is no longer requested. A new request is made only when the smart card is removed from the reader or when the LibreOffice is closed and reopened. I'm using LibreOffice 3.3.0, on Windows XP. I've done the same test on LibreOffice 3.4, with the same results. Thanks a lot, Grasip. -- Eu quase nada sei, mas desconfio de muita coisa. Guimarães Rosa Are saving the document with a password using FILESAVE AS and selecting Save with Password? When I tested this with file with a password, I was asked for it every time I opened the file. I do not use a smart card so the behavior may be caused by the smart card. -- Jay Lozier jsloz...@gmail.com -- 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 -- 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 -- Eu quase nada sei, mas desconfio de muita coisa. Guimarães Rosa -- 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: Base record access unacceptably slow
Heinrich, On Thu, 2011-07-28 at 08:15 +0200, Heinrich Stoellinger wrote: Hi Tom, Just my - maybe naive - 2 pennies worth of comments: As I mentioned before, I have been using OO/LO for years together with BASE with MySQL (which - also sigh) now belongs to Oracle as well. As a connector to the DB I have tried out the Java version (always had trouble with it one way or the other!) as well as ODBC/UNIXODBC (which is what I am now using under Linux and which works sort of!). With MySQL there is also the native connector which I would actually prefer to use - but, yes you guess right - does NOT work on either LO 3.3.3 or 3.4.1 under Linux. A bit confusing, isn't it! I am not giving up hope yet for LO 3.4.2 - especially since it targets business... Isn't there a OpenSource fork of MySQL called MariaDB?!? Regards H MariaDB is an OSS fork of MySQL, it is available from the Ubuntu repositories, I assume Debian and other Linux distros. It apparently is only available for Linux and Windows, no Mac version listed on their downloads. Their homepage is mariadb.org On Thu, 28 Jul 2011 00:19:26 +0200, Tom Cloyd t...@tomcloyd.com wrote: Thanks, Andreas. To summarize what I learned from that second link: I need to install sun-java6-jre_6.22-0ubuntu1~10.04 into a directory of my choosing, then direct LO to use this special older version (which, it is reported, does not cause the awful slowdown we're experiencing). Look like a short-term solution I can live with. Give me hope that I get back to work, later today The long-term solution appears entirely opaque, however. Is the problem being reported to Oracle (who I presume is behind the latest sun-java updates). Is this an Oracle plot to blow OO and LO opensource dbs out of the water? Is there any hope we can cut this dependancy upon a java version that is now associated with Oracle? Sigh. Tom On 07/27/2011 02:26 AM, Andreas Säger wrote: The Base documentation: http://openoffice.org/projects/documentation/downloads/directory/Base/Mid%20level%20Base%20tutorial My chrystal ball tells me that you run LibreOffice with a recent Java version under Linux, therefore this is the solution to your problem: http://www.oooforum.org/forum/viewtopic.phtml?t=125253 -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- Jay Lozier jsloz...@gmail.com -- 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] Shrinking buttons
Biil On Thu, 2011-07-28 at 10:57 -0600, Bill Gradwohl wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a spreadsheet containing 39 sheets, of which 21 are duplicates of one another. They represent tables in a restaurant. On an average laptop or desktop, everything is fine. When I load this up on a netbook with lousy resolution (1024x600), every time I save the file, the buttons on the 21 sheets get smaller and smaller till they some of them have a height of .06cm making them unusable. I leave the screen scaling at 100%. I manually went thru 10 of the sheets and using the forms control tool reset each button to its proper dimensions. Everything looked good as I went from sheet to sheet. I saved the file and brought it back up and the height that was .50cm is now .33cm or .31cm. Why they are different is a mystery. Another save and reload AND SOME OF THE BUTTONS are smaller still. I have no code that attempts to manipulate the buttons, so I conclude that LO is making the changes, and is making these changes permanent across saves. If I move the file back to my development laptop, its trashed. I understand scaling due to resolution issues, but rewriting my code permanently has got to be a bug. I tested this on Fedora 14 as OpenOffice and Fedora 15 as LibreOffice. Both display the identical problem. I can supply additional details, as the whole story has some additional twists, but I'd like to know if this will be taken as a serious issue. Please file a bug, I do not what the issue is. I have never seen any behavior like this myself. If you could give more details may be (very may be) someone monitoring the list may know what is happening. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 IM:billgradw...@gmail.com (No email please-IM only) -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk4xlOkACgkQ7Orvev+eC8pjqQCbBadkTrBEznB0UjH8OAM/qRAP 0mwAoLEXYNCs9dYHwuo4DZZDqqfI+WSm =0qkh -END PGP SIGNATURE- -- Jay Lozier jsloz...@gmail.com -- 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: Base record access unacceptably slow
Hi Tom, Tom Cloyd wrote (28-07-11 18:06) I completely agree. LO without a function Base won't fly. Either TDF recognizes this - by DOING something - or we have our answer. Well, the challenges with base are known. This does not mean that there is an instant solution. However the fast growing support for TDF and from interested people with developing skills, make that there are reasons for some optimism :-) Maybe the LibreOffice conference or another hackers event is a good opportunity too to make so first steps, share experience ... Regards, Cor -- - Cor - http://nl.libreoffice.org -- 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] Calc row filter extraction
Hi all, I have a 'data' spreadsheet sheet for my family medical aid on LO 3.3.1 with multiple columns and different information in each column. Please see the text example I include below. What I would ideally like to do is have rows on sheet A, where Column D is the same, linked onto another sheet(B). My next requirement is to group all the like column B on sheet B, C and link them onto sheet D but group them according to column B and SUM the amounts from sheets B, C. I have included a brief text example below: Sheet A A B C D E 20-July SVP SBP Robert 200 20-July STP SPG Hazel 100 21-July STP SBP Robert 180 22-July SVP SBP Robert 50 23-July STP SBP Hazel 400 Sheet B A B C D E 20-July SVP SBP Robert 200 21-July STP SBP Robert 180 22-July SVP SBP Robert 50 Sheet C A B C D E 20-July STP SPG Hazel 100 23-July STP SBP Hazel 400 Sheet D A B C D E STP SBP Robert 100 STP SBP Hazel 500 SVP SBP Robert 250 I have done some googling regarding row extraction and have also investigated the SUMIF command. and whilst I can get a total of all the STP's, I cannot SUM it by user at STP. The SUMD command has also raised its head but I cannot figure out how to get it to work in conjunction with SUMIF. Any help appreciated, even telling me MySQL is a better option. My problem is that the data is Sheet A is ever growing and being edited by a basic Excel user, and sheets b-D need to reflect those changes made on sheet A. Again, Any Help Appreciated -- Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A) http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO -- 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: (help macro base)Open form with a button form another form with filter
Hi Sorry if this is a silly question but, how do I switch the focus from one form to another? Thanks 2011/7/28 Alexander Thurgood alex.thurg...@gmail.com Le 28/07/11 15:40, rogerio dandrea a écrit : Hi Rogerio, ThisDatabaseDocument.FormDocuments.getByName( animal3 ).open odoc=thiscomponent oform=odoc.drawpage.forms.getbyindex(0) 'define o filtro para achar os registros sfilter = chr(34) Cad chr(34) chr(61) myindex print sfilter oform.filter = sfilter oform.applyfilter= True oform.reload ' recarrega o formulario com o filtro pelo na teoria pois não esta funcionando 'reload the form with the filter apply dont work I could be wrong here, but you could try setting the focus on one of this form's controls before attempting to reload, or alternatively you might find you have to reload the first form that was opened in order to get the second one to update. From memory, I think that there was a discussion about this on the old OpenOffice.org dba discuss or user list. Alex -- 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 -- 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: Connect ODBC / JDBC Firebird database - LibreOffice 3.3.3 - Windows XP
Le 28/07/11 20:31, Giovanni Romero Pérez a écrit : Ciao Giovanni, Thank you very much. I did what you said and all is OK. Glad I could be of some help. Since the Firebird server is on Windows, the string to connect is: firebirdsql:servername/3050:C:\\FOLDER\\DATABASE.FDB Ah, OK, thanks for the OS specific details. Alex -- 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] Can't set each level of a bullet list style
In Libreoffice Writer, I am trying to make a document with bullets, but not continuously. So I have some bullets, then some paragraphs or other text, then more bullets. But I realized that whenever I turned bullets back on, it was resetting the bullet style to the default. It became a hassle to have to set the distance of the bullet from the left side, the amount of spacing between the right side of the bullet and my text, etc. So I turned to List Styles under Styles and Formatting. This is where my real problem started. I noticed that Libreoffice supports up to 10 levels of bullet or number lists. I noticed that if I went to Format -- Bullets and Numbering, I could set a different type of bullet for each level under the Options tab. I just had to highlight 1, switch to the Bullets tab, and pick the type of bullet I wanted. Then I could switch back to the Options tab, highlight 2, switch to the Bullets tab, pick another type of bullet (or even the same type of bullet as 1), and so on. However, when I tried to do this which a list style, it didn't work. All I could do was set the same type of bullet for 1-10, because whenever I highlighted 1 and switched to the Options tab to choose a bullet, the 1 was deselected by the time I switched back to the Options tab. This is getting very frustrating. If I can set a different type of bullet for each level of bullet under Format -- Bullets and Numbering, why can't I do the same when I make a custom list style to save time? Thanks in advance to anyone who can help! -- 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] Calc row filter extraction
Hi Hylton, On Thu, 2011-07-28 at 21:50 +0200, Hylton Conacher (ZR1HPC) wrote: Hi all, I have a 'data' spreadsheet sheet for my family medical aid on LO 3.3.1 with multiple columns and different information in each column. Please see the text example I include below. What I would ideally like to do is have rows on sheet A, where Column D is the same, linked onto another sheet(B). My next requirement is to group all the like column B on sheet B, C and link them onto sheet D but group them according to column B and SUM the amounts from sheets B, C. I have included a brief text example below: Sheet A A B C D E 20-July SVP SBP Robert 200 20-July STP SPG Hazel 100 21-July STP SBP Robert 180 22-July SVP SBP Robert 50 23-July STP SBP Hazel 400 Sheet B A B C D E 20-July SVP SBP Robert 200 21-July STP SBP Robert 180 22-July SVP SBP Robert 50 Sheet C A B C D E 20-July STP SPG Hazel 100 23-July STP SBP Hazel 400 Sheet D A B C D E STP SBP Robert 100 STP SBP Hazel 500 SVP SBP Robert 250 I have done some googling regarding row extraction and have also investigated the SUMIF command. and whilst I can get a total of all the STP's, I cannot SUM it by user at STP. The SUMD command has also raised its head but I cannot figure out how to get it to work in conjunction with SUMIF. Any help appreciated, even telling me MySQL is a better option. My problem is that the data is Sheet A is ever growing and being edited by a basic Excel user, and sheets b-D need to reflect those changes made on sheet A. Again, Any Help Appreciated -- Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A) http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO If I understand your problem, you want conditionally add data based on a selection criteria from different sheets. I believe sumif works best using columns from on one sheet. I wonder if using an intermediate sheet using vlookup and sum these results might work. One issue, vlookup is to have a unique lookup parameter in the selection column. -- Jay Lozier jsloz...@gmail.com -- 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: Base record access unacceptably slow
Am 28.07.2011 19:05, Jean-Francois Nifenecker wrote: Hi, Le 28/07/2011 18:10, Heinrich Stoellinger a écrit : In my view LO/OO do NOT require Java, neither on Linux nor on Windows. AFAIK, LO/OOo currently *DO* require Java for Base to simply work. TDF have announced they would get rid of the java-isms in the code. This implies a major rewrite of Base, though. No, this is not true. You can use any non-Java database in OOo. You can build queries and forms manually in design view, and you can use external document templates for reporting. Both built-in report generators use Java. IMHO Calc outperforms both report generators anyway. Hit F4 in Writer or Calc, right-clickOpen the dBase Bibliography. All the functionality of a flat (unrelational) dBase connection is there. You can connect, query, edit data through forms and dump any row set into office documents. -- 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: QUESTION: Libreoffice documents constantly need recovery
I have the same problem with L.O Writer 3.4.1 in Ubuntu 10.10. L.O. uses java 1.6.0_26. Also I downloaded the deb packages from the web page (not from PPA) Is there any news about this problem? Another question, where is located the log file with the error reported by L.O.? -- View this message in context: http://nabble.documentfoundation.org/QUESTION-Libreoffice-documents-constantly-need-recovery-tp2515584p3208186.html Sent from the Users mailing list archive at Nabble.com. -- 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: New User: Three Questions
On 07/27/2011 06:46 PM, Rich Shepard wrote: On Wed, 27 Jul 2011, NoOp wrote: I only referred to that as it shows making a ~/.fonts folder etc. Please create and put the BakerSignet font in there see if LO picks it up. Not really, as I don't know what the astrisk is in '1152a___.*' - I know of no fonts that are listed as .* Nor are there any fonts that use a .atm extension. .atm is used for the Adobe Type Manager font catalog/file ATM fonts are generally Type 1 fonts with an .pfb, .afm and .pfm (and possibly .pfa) files. So I'm still confused. The asterisk means multiple suffixes. In this case, 1152a___.afm, 1152a___.inf, 1152a___.pfb, and 1152a___.pfm. I mistyped afm as atm. Got it. Well, I guess LO is different from other apps in that it cannot see fonts in /usr/share/fonts, but does in ~/.fonts. Very strange. Regardless, I will make softlinks in ~/.fonts to the directories in /usr/share/fonts. ... Might be an issue with the slackware build - you might consider filing a bug report. It gets even more interesting; I was experimenting with some old Adobe FrameMaker .pfb files used FontForge to convert a .pdb to the respective .pfa .afm files. Placed those in ~/.fonts and LO 3.3.3 and OOo 3.2.1 pick up the font just fine. However, LO 3.4.2 rc2 (pre-release) and OOo-Dev 3.4.0 do not. I'll file a bug on those if I get time in the next few days. -- 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: Base record access unacceptably slow
On 07/28/2011 12:50 PM, Andreas Säger wrote: Am 28.07.2011 19:05, Jean-Francois Nifenecker wrote: Hi, Le 28/07/2011 18:10, Heinrich Stoellinger a écrit : In my view LO/OO do NOT require Java, neither on Linux nor on Windows. AFAIK, LO/OOo currently *DO* require Java for Base to simply work. TDF have announced they would get rid of the java-isms in the code. This implies a major rewrite of Base, though. No, this is not true. You can use any non-Java database in OOo. You can build queries and forms manually in design view, and you can use external document templates for reporting. Both built-in report generators use Java. IMHO Calc outperforms both report generators anyway. Hit F4 in Writer or Calc, right-clickOpen the dBase Bibliography. All the functionality of a flat (unrelational) dBase connection is there. You can connect, query, edit data through forms and dump any row set into office documents. http://www.libreoffice.org/get-help/system-requirements/ quote For certain features of the software - but not most - Java is required. Java is notably required for Base. /quote -- 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: QUESTION: Libreoffice documents constantly need recovery
Hi Juan, On Fri, Jul 29, 2011 at 2:02 AM, Juan Carlos juanzeppe...@hotmail.com wrote: I have the same problem with L.O Writer 3.4.1 in Ubuntu 10.10. L.O. uses java 1.6.0_26. Also I downloaded the deb packages from the web page (not from PPA) Is there any news about this problem? It's not actually an erroneous behavior. It depends how you close the document(s). For example, if you work on a doc, save it, leave it open (and, therefore, leave LibreOffice open), and then exit Ubuntu perfectly normally then, the next time you open LibreOffice, you will be prompted to recover the docs as if some horrible disaster had happened, even though there has been no data loss or anything. If you don't want this behavior to happen then, before you exit Ubuntu, cleanly close your doc(s) and cleanly exit your LibreOffice, and THEN exit Ubuntu. The above was just an example of when it happens. It can happen in other circumstances, too. It's actually considered to be perfectly normal AFAIK. Microsoft Office 2010, for instance, behaves in pretty much the same way. It irritates me as well, but you'd have to file a feature request to ask for the behavior to be re-examined and possibly re-designed. HTH. Another question, where is located the log file with the error reported by L.O.? I can't remember off-hand. -- David Nelson -- 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