Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?
ok,data pilot works.i tried it earlier also but somehow missed the 'clicking data field and change the function' part.thanks for the link @stefan. @andreas, could not understand how to use sumproduct in my case.is it not a way of multiplication? in my case, i am trying to filter the data. regards, On 25 January 2012 23:07, Andreas Säger ville...@t-online.de wrote: Am 25.01.2012 18:26, Stefan Weigel wrote: Hi, Am 25.01.2012 17:16, schrieb soumalya ray: say,in one column gender of the participants are written (male/female).in next column height of the participant is written.now i want to count how many females have height=1.55 metre. +1 for the data pilot. For single values you may try SUMPRODUCT(condition1;**condition2;...) -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- For 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: what is the alternative of countifs function in libreoffice?
Am 26.01.2012 09:42, soumalya ray wrote: ok,data pilot works.i tried it earlier also but somehow missed the 'clicking data field and change the function' part.thanks for the link @stefan. @andreas, could not understand how to use sumproduct in my case.is it not a way of multiplication? in my case, i am trying to filter the data. regards, SUMPRODUCT($A$1:$A$5=this;$B$1:$B$5=that) A1*B1 = 1 or 0 A2*B2 = 1 or 0 A3*B3 = 1 or 0 A4*B4 = 1 or 0 A5*B5 = 1 or 0 - Result: Sum of products -- For 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] Base - No SDBC driver found!!
Hi All As always I seem to be battling again with my Database!! I've just updated to Linux Mint 12 KDE which includes LO. BUT it would not even run on my new set-up. So I removed it and installed OO in it's place. The new OO did not seem to like my 'Input Form' so I re-created it. BUT - it takes for ever to save and most of the time DOES NOT save the information!! (This is a problem I've had with both OO and LO) So I removed OO and re-installed LO 3.4.3 and jdk 1.6.0_21. Now when I try to Open my DB I get the error No SDBC driver found!! I've Googled about this and it looks as if this is a known current Bug that has not been fixed. I even tried to create a new Database (which it did OK) and then renaming my old file to this name but I still get the same error!! Is there an answer to this - I HAVE to get my DB up again URGENTLY Thanks a lot / Ian Whitfield Pretoria /// -- For 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] Base - No SDBC driver found!!
Ian, no panic, what is the external database you are connected to ? or are you using the embeded database the error No SDBC driver found looks like you odb document lost the connection with a external database Greetz Fernand As always I seem to be battling again with my Database!! I've just updated to Linux Mint 12 KDE which includes LO. BUT it would not even run on my new set-up. So I removed it and installed OO in it's place. The new OO did not seem to like my 'Input Form' so I re-created it. BUT - it takes for ever to save and most of the time DOES NOT save the information!! (This is a problem I've had with both OO and LO) So I removed OO and re-installed LO 3.4.3 and jdk 1.6.0_21. Now when I try to Open my DB I get the error No SDBC driver found!! I've Googled about this and it looks as if this is a known current Bug that has not been fixed. I even tried to create a new Database (which it did OK) and then renaming my old file to this name but I still get the same error!! Is there an answer to this - I HAVE to get my DB up again URGENTLY Thanks a lot / Ian Whitfield Pretoria /// -- For 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] Base - No SDBC driver found!!
On 26/01/2012 13:29, Fernand Vanrie wrote: no panic, what is the external database you are connected to ? or are you using the embeded database the error No SDBC driver found looks like you odb document lost the connection with a external database / /Thanks Fernand I'm using the embeded database - HSQL. I would LIKE to get away from this but the couple of times I tried in the past were a complete failure!! Greetings back to you Ian Whitfield Pretoria./ / -- For 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] Base - No SDBC driver found!!
Ian, in these case you can panic :-) can you still open your odb doc and check your tables ? if not open the doc with tool to unzip the content and check if the data file is still present On 26/01/2012 13:29, Fernand Vanrie wrote: no panic, what is the external database you are connected to ? or are you using the embeded database the error No SDBC driver found looks like you odb document lost the connection with a external database / /Thanks Fernand I'm using the embeded database - HSQL. I would LIKE to get away from this but the couple of times I tried in the past were a complete failure!! Greetings back to you Ian Whitfield Pretoria./ / -- For 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] Base - No SDBC driver found!!
On Thu, 2012-01-26 at 13:49 +0200, Ian Whitfield wrote: On 26/01/2012 13:29, Fernand Vanrie wrote: no panic, what is the external database you are connected to ? or are you using the embeded database the error No SDBC driver found looks like you odb document lost the connection with a external database / /Thanks Fernand I'm using the embeded database - HSQL. Hello Ian, Well, it sounds as if somewhere along the line you started picking up the HSQLdb jar distributed by the upstream project, rather then the jar file distributed with the application. This has been a recurring problem, fixed and then un-fixed a couple of times. Not to worry though, no real harm done. So - did you by any chance update the java settings in LibO to include the HSQLdb distributed jar so that you could connect to an external HSQLdb server? If so, simply back that out and the problem will correct itself. //drew -- For 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 - No SDBC driver found!!
Am 26.01.2012 12:49, Ian Whitfield wrote: I'm using the embeded database - HSQL. I would LIKE to get away from this but the couple of times I tried in the past were a complete failure!! http://user.services.openoffice.org/en/forum/viewtopic.php?f=61t=46324p=214069hilit=hsqldb#p214049 -- For 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: one language in the installer libre office
On 2012-01-25 8:08 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: If something is really easy to implement in one OS but difficult or impossible in another then i think that it would be dumb to hold it back in the one and criticise the devs for not implementing it in the other. If we play to the weaknesses of all the OSes to ensure that LO appears the same on all OSes then it's going to be pretty bad in all. This *ass-u-me-s* that this would be difficult to do in Windows, which no one has even *claimed*, let alone substantiated. Tom, again, please *stop* spreading FUD - it only makes you look bad (well, only makes you look *worse*, which I admit is kind of hard to do)... -- For 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] Base - No SDBC driver found!!
On 26/01/2012 14:38, Ian Whitfield wrote: I'm using the embeded database - HSQL. I would LIKE to get away from this but the couple of times I tried in the past were a complete failure!! Greetings back to you Thanks All!! *To Fernand* - Both copies of my .odb file are the same size (640Mb) and if I move a copy to the Windows machine I can 'see' all my tables, DB, forms etc. (not sure how to do this in Mint) One thing that is funny though is that if I check the permissions on the file it is owned by me and my group but all the permissions are greyed out and I can not seem to change this!!?? odb. is *not* multi user, when the document is open on a other machine of by a other user everyting is grayed out *To Drew* - I got the java file from the Java site and I have activated it under ToolsOptionsJava. But again whenever I go back to look at it - its not there. Base seems NOT to be keeping this setting!! *To Andreas* - The link you sent me seems to cover how to instal HSQL - but isn't this the embeded DB?? Its there by default. Sorry don't follow this. Thanks again Ian Whitfield Pretoria -- For 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] Base - No SDBC driver found!!
On 26/01/2012 16:15, Fernand Vanrie wrote: odb. is *not* multi user, when the document is open on a other machine of by a other user everyting is grayed out OK - fine. But how do I reset/reverse this?? -- For 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] No longer able to open a ODB file
When I try to open this file: http://db.tt/CN65sXtn I am presented with the Filter Selection dialog, from which I choose ODF database. I next get a 'General Error'. Clicking on 'Tables' gives: The connection to the data source Books' could not be established. The driver class could not be loaded. Clicking More gives three errors The connection to the data source Books' could not be established. Error code: 1000 The driver class '' could not be loaded. SQL Status: HY000 The driver class '' could not be loaded. and the file remains inaccessible. One day the file worked and saved without problem. The next day it does not open on any machine. A similar database opens without problem. Is there a way to recover this file? -- For 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] Base - No SDBC driver found!!
On 26/01/2012 16:32, Ian Whitfield wrote: On 26/01/2012 16:15, Fernand Vanrie wrote: odb. is *not* multi user, when the document is open on a other machine of by a other user everyting is grayed out OK - fine. But how do I reset/reverse this?? make sure nobody is connected or has opened the odb or make a copy with a new name and open this copy then everiting must been editable -- For 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 - No SDBC driver found!!
Am 26.01.2012 15:15, Fernand Vanrie wrote: *To Andreas* - The link you sent me seems to cover how to instal HSQL - but isn't this the embeded DB?? Its there by default. Sorry don't follow this. http://hsqldb.org is a database engine in Java. My receipt is about moving an embedded HSQLDB v1.8 out of the Base jail so it can be used as a fully functional multi-user db in server mode or in cached mode (single user on local machine but fully functional and independent of the frontend). Current HSQLDB version is 2.5. -- For 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] No longer able to open a ODB file
Scott , this is not a odb file , its comming from a older oo version (1.2) could be a swx, sxc, sxd, but as far as i know there was no database for 1.2 When I try to open this file: http://db.tt/CN65sXtn I am presented with the Filter Selection dialog, from which I choose ODF database. I next get a 'General Error'. Clicking on 'Tables' gives: The connection to the data source Books' could not be established. The driver class could not be loaded. Clicking More gives three errors The connection to the data source Books' could not be established. Error code: 1000 The driver class '' could not be loaded. SQL Status: HY000 The driver class '' could not be loaded. and the file remains inaccessible. One day the file worked and saved without problem. The next day it does not open on any machine. A similar database opens without problem. Is there a way to recover this file? -- For 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] I am really disappointed about libreOffice
Hi :) Yes, just rename your user-profile http://wiki.documentfoundation.org/Documentation/UserProfile and/or install one of the stable versions from the proper official website http://www.libreoffice.org/download/ and keep away from alph or beta testing unless you really want to test and try out new features before the official release dates (like previewing a film before the box-office opening) Regards from Tom :) --- On Thu, 26/1/12, Tanstaafl tansta...@libertytrek.org wrote: From: Tanstaafl tansta...@libertytrek.org Subject: Re: [libreoffice-users] I am really disappointed about libreOffice To: users@global.libreoffice.org Date: Thursday, 26 January, 2012, 12:38 On 2012-01-25 4:03 PM, Thomas Wunner th.wun...@gmx.de wrote: But now I am really disappointed about your software. LibreOffice crashed in my previous version while trying to do table calculation (typing the = sign caused the error). In LibreOffice 3.4.2 000340m1 (Build:1206) I got this error message: terminate called after throwing an instance of 'com::sun::star::loader::CannotActivateFactoryException' In my opinion this blooper should not happen with your about 10 years openSource in office suite development! And I seriously think about to use only openOffice in future. Community openSource software means also to check the software before releasing. Thomas, There was a *massive* amount of code refactoring in the 3.4.x release that stripped out *tons* of old/outdated code, and that will make working with the code much easier down the road. It sounds like you may have encountered an issue with some corruption in your user profile, which can just as easily happen in Openoffice (so switching to it will *not* make you immune to something similar in the future). You would be unwise to make a knee-jerk decision based on one little thing like this, especially when using a major new version that you were *warned* may have some issues (you *did* read the release notes, right?). Also, fyi, 3.4.3 was the version of the 3.4.x series that was recommended for people to switch to as the new stable version, so complaining about a version that is older than that with known issues, without at *least* switching to the most current version first, is just dumb. I understand that 3.5 will do something similar, but probably with less serious chances of breakage. I *always* wait until at least two or 3 point releases of a major version update before switching en masse to it On other possibility - do you *upgrade* (install over the top of the old version) when updating, or do you do a full uninstall/reinstall? I *always* uninstall the old version first (leaving my user profile), the install the new version (started doing this a long time ago when I encountered occasional problems when installing the new version on top of the old version)... Charles -- For 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 -- For 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] No longer able to open a ODB file
Fernand, Thanks for the answer, although I admit I'm seriously puzzled by that. The file has been in use for a couple years and at least originally was a ODB. Most recently being opened and used without problem in LO 3.4.x on a weekly basis. Any ideas on how to recover at least the table data from the file? On 1/26/12 10:30 AM, Fernand Vanrie wrote: Scott , this is not a odb file , its comming from a older oo version (1.2) could be a swx, sxc, sxd, but as far as i know there was no database for 1.2 When I try to open this file: http://db.tt/CN65sXtn I am presented with the Filter Selection dialog, from which I choose ODF database. I next get a 'General Error'. Clicking on 'Tables' gives: The connection to the data source Books' could not be established. The driver class could not be loaded. Clicking More gives three errors The connection to the data source Books' could not be established. Error code: 1000 The driver class '' could not be loaded. SQL Status: HY000 The driver class '' could not be loaded. and the file remains inaccessible. One day the file worked and saved without problem. The next day it does not open on any machine. A similar database opens without problem. Is there a way to recover this file? -- For 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 - No SDBC driver found!!
Hi :) The HSqlDb version that is embedded in Base is a bit poor compared to using the proper version of HSqlDb and then use that as a back end with Base as the front-end. I think the result is that it looks like 2 files but works a LOT better. It's just the implementation inside Base is less than great. There are other back-ends that might be better if you are going for a larger database but HSqlDb is quite good and very fast if the database is going to be fairly small. For example Postgresql or MariaDb/MySql might be great for a large database but not so great for a simple address book or something. Regards from Tom :) --- On Thu, 26/1/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: Base - No SDBC driver found!! To: users@global.libreoffice.org Date: Thursday, 26 January, 2012, 16:18 Am 26.01.2012 15:15, Fernand Vanrie wrote: *To Andreas* - The link you sent me seems to cover how to instal HSQL - but isn't this the embeded DB?? Its there by default. Sorry don't follow this. http://hsqldb.org is a database engine in Java. My receipt is about moving an embedded HSQLDB v1.8 out of the Base jail so it can be used as a fully functional multi-user db in server mode or in cached mode (single user on local machine but fully functional and independent of the frontend). Current HSQLDB version is 2.5. -- For 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 -- For 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] No longer able to open a ODB file
Scott , no, because it is no longer a zip archive, were you normaly can find a archive with the data file. i supose the original odb is overwritten by a other file ? open the file with a text-editor, you wil find some meta-data en scrambled information hopes you find somewhere a backup :-) Greetz Fernand Fernand, Thanks for the answer, although I admit I'm seriously puzzled by that. The file has been in use for a couple years and at least originally was a ODB. Most recently being opened and used without problem in LO 3.4.x on a weekly basis. Any ideas on how to recover at least the table data from the file? On 1/26/12 10:30 AM, Fernand Vanrie wrote: Scott , this is not a odb file , its comming from a older oo version (1.2) could be a swx, sxc, sxd, but as far as i know there was no database for 1.2 When I try to open this file: http://db.tt/CN65sXtn I am presented with the Filter Selection dialog, from which I choose ODF database. I next get a 'General Error'. Clicking on 'Tables' gives: The connection to the data source Books' could not be established. The driver class could not be loaded. Clicking More gives three errors The connection to the data source Books' could not be established. Error code: 1000 The driver class '' could not be loaded. SQL Status: HY000 The driver class '' could not be loaded. and the file remains inaccessible. One day the file worked and saved without problem. The next day it does not open on any machine. A similar database opens without problem. Is there a way to recover this file? -- For 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] No longer able to open a ODB file
Fernand, I have restored a backup from a month ago. Since December was a relatively slow month, not too much has been lost. Thanks much, though, for confirming that this file is of no use. Scott On 1/26/12 10:48 AM, Fernand Vanrie wrote: Scott , no, because it is no longer a zip archive, were you normaly can find a archive with the data file. i supose the original odb is overwritten by a other file ? open the file with a text-editor, you wil find some meta-data en scrambled information hopes you find somewhere a backup :-) Greetz Fernand Fernand, Thanks for the answer, although I admit I'm seriously puzzled by that. The file has been in use for a couple years and at least originally was a ODB. Most recently being opened and used without problem in LO 3.4.x on a weekly basis. Any ideas on how to recover at least the table data from the file? On 1/26/12 10:30 AM, Fernand Vanrie wrote: Scott , this is not a odb file , its comming from a older oo version (1.2) could be a swx, sxc, sxd, but as far as i know there was no database for 1.2 When I try to open this file: http://db.tt/CN65sXtn I am presented with the Filter Selection dialog, from which I choose ODF database. I next get a 'General Error'. Clicking on 'Tables' gives: The connection to the data source Books' could not be established. The driver class could not be loaded. Clicking More gives three errors The connection to the data source Books' could not be established. Error code: 1000 The driver class '' could not be loaded. SQL Status: HY000 The driver class '' could not be loaded. and the file remains inaccessible. One day the file worked and saved without problem. The next day it does not open on any machine. A similar database opens without problem. Is there a way to recover this file? -- For 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] Mail Merge print from Query instead of table.
LibreOffice 3.3.4 on Mint 11 If I print a mail merge form that is created from a* table*, then in the print dialogue the correct table is selected. This is what I expect to happen. However a mail merge form that is created from a valid *query* (that is based on multiple tables) requires me to select the query to be used when in the Print dialogue. Has anybody any suggestions as to the difference in behaviour and a method to ensure that the query is selected in the Print dialogue. -- View this message in context: http://nabble.documentfoundation.org/Mail-Merge-print-from-Query-instead-of-table-tp3690941p3690941.html Sent from the Users mailing list archive at Nabble.com. -- For 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] No longer able to open a ODB file
On Thu, 2012-01-26 at 17:30 +0100, Fernand Vanrie wrote: Scott , this is not a odb file , its comming from a older oo version (1.2) could be a swx, sxc, sxd, but as far as i know there was no database for 1.2 Hi Fernand, Scott, It is, was, an ODF database file it seems. The physical file structure, however, is corrupt. Using zip -FF, two times, gets some parts in readable shape: a couple of forms, well enough to tell the name of the woman that created them, date last edited, etc. That it was created with LibO 3.3 on 32bit windows. I can pull the control types, the field names they are attached to, etc. - so one could salvage forms fairly easily, IMO, didn't actually try moving them to a non-corrupt, new, file. The _data_ however - some, or all, may be there, at least there is a 241K block of bytes left after the two forms and manifest.xml and a couple other files are accounted for. However trying to recover any of that would be a rather more laborious endeavor and quite frankly costly...so unless this is some rather valuable stuff..I'd call it a bin_bucket case. For what it's worth if you are still using LibO 3.3 I would really recommend upgrading to 3.4.5 today! Best wishes, //drew When I try to open this file: http://db.tt/CN65sXtn I am presented with the Filter Selection dialog, from which I choose ODF database. I next get a 'General Error'. Clicking on 'Tables' gives: The connection to the data source Books' could not be established. The driver class could not be loaded. Clicking More gives three errors The connection to the data source Books' could not be established. Error code: 1000 The driver class '' could not be loaded. SQL Status: HY000 The driver class '' could not be loaded. and the file remains inaccessible. One day the file worked and saved without problem. The next day it does not open on any machine. A similar database opens without problem. Is there a way to recover this file? -- For 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: QuickStarter
Thanks to everyone who responded to me about Quickstarter preventing me from loading the latest version of LibreOffice. All the suggestions presumed that I had an earlier version of LibreOffice installed, which I did not. My fault for not being more specific in my request for help. I tried all the suggestions, but none of them worked. I took the path of least resistance and downloaded an earlier version of the program. All is OK now. Thanks again. Carole -- For 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] No longer able to open a ODB file
On Thu, 2012-01-26 at 17:30 +0100, Fernand Vanrie wrote: Scott , this is not a odb file , its comming from a older oo version (1.2) could be a swx, sxc, sxd, but as far as i know there was no database for 1.2 When I try to open this file: http://db.tt/CN65sXtn I am presented with the Filter Selection dialog, from which I choose ODF database. I next get a 'General Error'. Clicking on 'Tables' gives: The connection to the data source Books' could not be established. The driver class could not be loaded. Clicking More gives three errors The connection to the data source Books' could not be established. Error code: 1000 The driver class '' could not be loaded. SQL Status: HY000 The driver class '' could not be loaded. and the file remains inaccessible. One day the file worked and saved without problem. The next day it does not open on any machine. A similar database opens without problem. Is there a way to recover this file? I just downloaded this file. Then I changed the extention from .odb to .zip and tried to unzip it. I got the following Error message: Archive: /home/dan/Downloads-64/Books.zip [/home/dan/Downloads-64/Books.zip] End-of-central-directory signature not found. Either this file is not a zipfile, or it constitutes one disk of a multi-part archive. In the latter case the central directory and zipfile comment will be found on the last disk(s) of this archive. zipinfo: cannot find zipfile directory in one of /home/dan/Downloads-64/Books.zip or /home/dan/Downloads-64/Books.zip.zip, and cannot find /home/dan/Downloads-64/Books.zip.ZIP, period. Recovery of the file is unlikely. I also opened the file using Gedit (text editor). It was showing a combination of UTF-8 characters and invalid characters. Here is a section that is all UTF-8 characters: office:document-meta xmlns:office=urn:oasis:names:tc:opendocument:xmlns:office:1.0 xmlns:xlink=http://www.w3.org/1999/xlink; xmlns:dc=http://purl.org/dc/elements/1.1/; xmlns:meta=urn:oasis:names:tc:opendocument:xmlns:meta:1.0 xmlns:ooo=http://openoffice.org/2004/office; xmlns:grddl=http://www.w3.org/2003/g/data-view#; office:version=1.2 grddl:transformation=http://docs.oasis-open.org/office/1.2/xslt/odf2rdf.xsl; office:metadc:date2011-01-15T14:02:55.95/dc:datedc:creatorCarolyn Friedemann/dc:creatormeta:editing-durationPT2M32S/meta:editing-duration meta:editing-cycles4/meta:editing-cyclesmeta:generatorLibreOffice/3.3$Win32 LibreOffice_project/330m19 $Build-5/meta:generatormeta:document-statistic meta:table-count=0 meta:image-count=0 meta:object-count=0 meta:page-count=1 meta:paragraph-count=0 meta:word-count=0 meta:character-count=0//office:meta/office:document-metaPK Maybe someone can make some sense of this. I'm no sure what the office : version =1.2 means. There was no such version. OOo went from 1.0 to 1.1.5 and then to 2.0. -- Dan -- For 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] No longer able to open a ODB file
Maybe I am missing the point, but I've just downloaded your file and opened it with BASE. It has 304 records in the archived books table and 503 in the books table. Maybe worth the time for you to try again. On 26 January 2012 16:55, drew d...@baseanswers.com wrote: On Thu, 2012-01-26 at 17:30 +0100, Fernand Vanrie wrote: Scott , this is not a odb file , its comming from a older oo version (1.2) could be a swx, sxc, sxd, but as far as i know there was no database for 1.2 Hi Fernand, Scott, It is, was, an ODF database file it seems. The physical file structure, however, is corrupt. Using zip -FF, two times, gets some parts in readable shape: a couple of forms, well enough to tell the name of the woman that created them, date last edited, etc. That it was created with LibO 3.3 on 32bit windows. I can pull the control types, the field names they are attached to, etc. - so one could salvage forms fairly easily, IMO, didn't actually try moving them to a non-corrupt, new, file. The _data_ however - some, or all, may be there, at least there is a 241K block of bytes left after the two forms and manifest.xml and a couple other files are accounted for. However trying to recover any of that would be a rather more laborious endeavor and quite frankly costly...so unless this is some rather valuable stuff..I'd call it a bin_bucket case. For what it's worth if you are still using LibO 3.3 I would really recommend upgrading to 3.4.5 today! Best wishes, //drew When I try to open this file: http://db.tt/CN65sXtn I am presented with the Filter Selection dialog, from which I choose ODF database. I next get a 'General Error'. Clicking on 'Tables' gives: The connection to the data source Books' could not be established. The driver class could not be loaded. Clicking More gives three errors The connection to the data source Books' could not be established. Error code: 1000 The driver class '' could not be loaded. SQL Status: HY000 The driver class '' could not be loaded. and the file remains inaccessible. One day the file worked and saved without problem. The next day it does not open on any machine. A similar database opens without problem. Is there a way to recover this file? -- For 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 -- Peter Lacey -- For 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] Base - No SDBC driver found!!
Hi, I have several .odb files. I have one computer where I do all of the updating to the databases generally. I copy the odb file to three other computers which are not networked so I have the databases current on those machines. However, I can edit the databases on any machine without any issues. I'm running Ubuntu 11.10 and currently LibreOffice 3.4.5. Don On 01/26/2012 10:32 AM, Ian Whitfield wrote: On 26/01/2012 16:15, Fernand Vanrie wrote: odb. is *not* multi user, when the document is open on a other machine of by a other user everyting is grayed out OK - fine. But how do I reset/reverse this?? -- ** -- For 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] Problem pasting spreadsheet cells into Impress
Hi :) No problems on WinXp Sp3 but a really doddery old machine. LO version 3.4.3 Hmmm, doesn't look quite right as lettering is a bit larger so i guess i should have pasted without formatting. Regards from Tom :) --- On Thu, 26/1/12, Tanstaafl tansta...@libertytrek.org wrote: From: Tanstaafl tansta...@libertytrek.org Subject: Re: [libreoffice-users] Problem pasting spreadsheet cells into Impress To: users@global.libreoffice.org Date: Thursday, 26 January, 2012, 16:56 On 2012-01-13 4:17 PM, Tanstaafl tansta...@libertytrek.org wrote: Hi everyone, Can anyone confirm this as a bug, or explain why it is such a problem? I have been meaning to report this since forever, but I do it so rarely that I just haven't... Whenever I try to copy some cells from a spreadsheet and paste the into an Impress Presentation Libreoffice (and Openoffice used to do the same thing) totally locks up goes into never-never land, and I have to kill it. The only way to paste from a spreadsheet into a Presentation that I have found is to do Paste Special, then take the Default 'calc8' format, and that pastes perfectly. What is up with this? Why doesn't it just 'Paste' as calc8 format?? Anyone?? This is just a normal, standard installation, nothing has been tweaked, and it does this on every PC in our office, and has for a long time. Something is not right... -- For 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 -- For 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] No longer able to open a ODB file
On Thu, 2012-01-26 at 17:09 +, Oldlace wrote: Maybe I am missing the point snip or not - just downloaded it a second time - it's opening without a problem now..small difference the first downloaded file is 252K the new one is 1.5Meg.. //drew It has 304 records in the archived books table and 503 in the books table. Maybe worth the time for you to try again. On 26 January 2012 16:55, drew d...@baseanswers.com wrote: On Thu, 2012-01-26 at 17:30 +0100, Fernand Vanrie wrote: Scott , this is not a odb file , its comming from a older oo version (1.2) could be a swx, sxc, sxd, but as far as i know there was no database for 1.2 Hi Fernand, Scott, It is, was, an ODF database file it seems. The physical file structure, however, is corrupt. Using zip -FF, two times, gets some parts in readable shape: a couple of forms, well enough to tell the name of the woman that created them, date last edited, etc. That it was created with LibO 3.3 on 32bit windows. I can pull the control types, the field names they are attached to, etc. - so one could salvage forms fairly easily, IMO, didn't actually try moving them to a non-corrupt, new, file. The _data_ however - some, or all, may be there, at least there is a 241K block of bytes left after the two forms and manifest.xml and a couple other files are accounted for. However trying to recover any of that would be a rather more laborious endeavor and quite frankly costly...so unless this is some rather valuable stuff..I'd call it a bin_bucket case. For what it's worth if you are still using LibO 3.3 I would really recommend upgrading to 3.4.5 today! Best wishes, //drew When I try to open this file: http://db.tt/CN65sXtn I am presented with the Filter Selection dialog, from which I choose ODF database. I next get a 'General Error'. Clicking on 'Tables' gives: The connection to the data source Books' could not be established. The driver class could not be loaded. Clicking More gives three errors The connection to the data source Books' could not be established. Error code: 1000 The driver class '' could not be loaded. SQL Status: HY000 The driver class '' could not be loaded. and the file remains inaccessible. One day the file worked and saved without problem. The next day it does not open on any machine. A similar database opens without problem. Is there a way to recover this file? -- For 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 -- Peter Lacey -- For 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] Mouseover box for menue options
Hi :) Someone found a erally easy way to do this but i can't remember which list! Is it something to do with the theme your OS is set at? Apols and regards from Tom :) --- On Wed, 25/1/12, Ealadin31 a...@arbizo.net wrote: From: Ealadin31 a...@arbizo.net Subject: [libreoffice-users] Mouseover box for menue options To: users@global.libreoffice.org Date: Wednesday, 25 January, 2012, 13:27 Hi I was wondering what or how to change the gray background color to see the fonts better. The fonts are black but the background is dark gray and i cannot see the menu item information. Can someone let me know what this process is to change it. -- View this message in context: http://nabble.documentfoundation.org/Mouseover-box-for-menue-options-tp3687680p3687680.html Sent from the Users mailing list archive at Nabble.com. -- For 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 -- For 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] No longer able to open a ODB file
That is a new copy of the file. On 1/26/12 11:32 AM, drew wrote: or not - just downloaded it a second time - it's opening without a problem now..small difference the first downloaded file is 252K the new one is 1.5Meg.. -- For 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] No longer able to open a ODB file
On Thu, 2012-01-26 at 12:08 -0500, Dan Lewis wrote: snip Maybe someone can make some sense of this. I'm no sure what the office : version =1.2 means. There was no such version. OOo went from 1.0 to 1.1.5 and then to 2.0. Hi Dan, It's referring to the ODF version in this case, though would need to look at the entire line to be certain. //drew -- For 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] what is the alternative of countifs function in libreoffice?
Hi :) That link tries to download the Pdf version but this link lets you see all the chapters and doesn't try to download anything until after you have had a look around at what you might be downloading http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide I dunno why but some people get furious about links that force a download! The single chapter is pretty tiny file-size but i guess some people have very restricted limits and of course some people just enjoy getting angry about anything. Regards from Tom :) --- On Wed, 25/1/12, Stefan Weigel stefan.wei...@bildungskreis.org wrote: From: Stefan Weigel stefan.wei...@bildungskreis.org Subject: Re: [libreoffice-users] what is the alternative of countifs function in libreoffice? To: users@global.libreoffice.org Date: Wednesday, 25 January, 2012, 17:26 Hi, Am 25.01.2012 17:16, schrieb soumalya ray: say,in one column gender of the participants are written (male/female).in next column height of the participant is written.now i want to count how many females have height =1.55 metre. Use DataPilot. (Chosse: Data → DataPilot → Start). Your problem is exactly what it was invented for. Here is the LibreOffice manual: http://wiki.documentfoundation.org/images/5/52/0308CG3-DataPilot.pdf :-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- For 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 -- For 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: Printer always selects PDF instead of Postscript
Hi :) Sadly some dialogues do appear to be different/missing in certain DEs. We have only noticed the 1 example so far afaik but where there is one there may be others. Happily, now is a great time to post bug-reports or add comments to old reports to confirm where things are still not quite right in your opinion. Sometimes old bug-reports from OOo need to be re-posted against LO because so much divergence has already happened that it would be good to know what issues people still want fixed. A LOT of old problems are getting fixed and sometimes not even by focussing on the individual bug-reports because code-clean-up is likely to have fixed a whole bunch of issues (and perhaps created a few new ones that need to be cleared-up quickly). Sometimes it might just be your opinion and people decided to go the other way but often such decisions are up for discussion and possibly changing. This is a great time to get involved with just bug-reporting but stepping it up to doing triaging and anything more just helps you get even more out of the project :) Regards from Tom :) --- On Tue, 24/1/12, John Jason Jordan joh...@comcast.net wrote: From: John Jason Jordan joh...@comcast.net Subject: Re: [libreoffice-users] Re: Printer always selects PDF instead of Postscript To: users@global.libreoffice.org Date: Tuesday, 24 January, 2012, 19:28The appearance of the snip / dialog boxes might be different (size, color, borders, etc.), but the options should always be the same, right? As an unrelated issue ... snip / ... annoying behavior has persisted through my travels through OpenSuse, Debian, Fedora, and KDE, Gnome, and now Xfce, and continues after moving from OOo to Libreoffice. -- For 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: LO 3.5 RC 1, Calc - Failed xls import due to CaseWare function?
Hi :) I don't know whether support for CaseWare is planned or not. It might be possible to write a plug-in/add-on/Extension if you know someone keen to try that sort of thing - or even get really involved with the devs community to write one in the main branch of LO. I have heard that it is easier to bring an extension into the main branch than to try to write it from scratch but i suspect it's 6 of one and half-dozen of the other. I think probably it's best to just post a bug-report about it and then see if you can get someone involved further later. http://wiki.documentfoundation.org/BugReport Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/LO-3-5-RC-1-Calc-Failed-xls-import-due-to-CaseWare-function-tp3685408p3691324.html Sent from the Users mailing list archive at Nabble.com. -- For 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] No longer able to open a ODB file
Hi Scott, Scott D Friedemann schrieb: When I try to open this file: http://db.tt/CN65sXtn I would like to look at it, but cannot get it. Perhaps send it to me directly? Kind regards Regina -- For 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] No longer able to open a ODB file
Regina, I've put the file back on the Web and will leave it there for a while. http://db.tt/CN65sXtn On 1/26/12 1:25 PM, Regina Henschel wrote: Hi Scott, Scott D Friedemann schrieb: When I try to open this file: http://db.tt/CN65sXtn I would like to look at it, but cannot get it. Perhaps send it to me directly? Kind regards Regina -- For 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] How to transfer styles among documents created from the same template?
I have custom document template, and from this template a handful software manuals were authored. Styles were used extensively. Now it's time to modernize the look of the manuals, but we don't want to repeat the style changes in all manuals. (That's what styles are for, aren't they?) With MS Word (2000), the .doc files recorded the template. Styles can be marked so that when they were changed while editing one of the .doc files, that style changes were propagated to the template. Later, when one of the other .doc files was opened, it copied all styles from the template (automatically), which effectivly updates the other file as well. What is the workflow with LibreOffice to propagate style changes between .doc files created from the same template? I looked at the documentation and help pages around the template manager, but found only means to copy styles manually. Is there something that works more automated? -- Hannes -- For 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] Base question - report exception on faultless query
I'm trying to produce a report based on a query, trying to being the operative phrase. I have a query, it works just fine. I use the report wizard to produce a report based on the query (I haven't worked out how to do that manually yet). It presents me with the correct fields. I've arranged them the way I want them, at least in a very basic form 'cos I'm still testing. Running the report gives me four errors, SQL status S1000 An error occurred while creating the report, An exception of type com.sun.star.lang.WrappedTargetException was caught. (Alright, that was info, not strictly speaking an error I s'pose), and two errors that both say Syntax error in SQL expression. What SQL expression would that be then? Since my query runs correctly? Mark Stanton One small step for mankind... -- For 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: Mysterious spacing problem
Tom wrote: Are you looking for mono-spaced fonts? A font that has all characters the same fixed width? There are plenty out there. No, these are conventional fonts. Certain characters are spaced wrongly in Libre Office (but are correctly spaced in other applications). -- For 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] No longer able to open a ODB file
The two uploads to DropBox, Books.odb are the same. The document fails to load because it has been truncated -- it is not all there. The beginning of the Zip is present, but the end is not there. That is why it doesn't open as an ODF document and as a Zip document either. (The .odb is a Zip file carrying an ODF Database document.) Scrolling through the document in a hex editor, the following parts are present: mimetype forms/Obj21/meta.xml forms/Obj21/settings.xml forms/Obj21/content.xml forms/Obj21/manifest.rdf forms/Obj21/Configurations2/images/Bitmaps (empty) [... more empty Configuration cruft (this is all an ODT document that is embedded in the ODB to provide the form] forms/Obj21/styles.xml forms/Obj31/meta.xml forms/Obj31/settings.xml forms/Obj31/content.xml forms/Obj31/manifest.rdf forms/Obj31/Configurations2/ ... the usual forms/Obj31/styles.xml database/data There are no Zip records after the database/data header and there is no global directory at the end. - Dennis -Original Message- From: Scott D Friedemann [mailto:sc...@friedemann.us] Sent: Thursday, January 26, 2012 11:30 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] No longer able to open a ODB file Regina, I've put the file back on the Web and will leave it there for a while. http://db.tt/CN65sXtn On 1/26/12 1:25 PM, Regina Henschel wrote: Hi Scott, Scott D Friedemann schrieb: When I try to open this file: http://db.tt/CN65sXtn I would like to look at it, but cannot get it. Perhaps send it to me directly? Kind regards Regina -- For 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 -- For 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] No longer able to open a ODB file
The database/data beginning is there, but it is incomplete. I did not examine the header closely to see how much data was lost in the truncation of the file. -Original Message- From: Regina Henschel [mailto:rb.hensc...@t-online.de] Sent: Thursday, January 26, 2012 12:44 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] No longer able to open a ODB file Hi Scott, Scott D Friedemann schrieb: Regina, I've put the file back on the Web and will leave it there for a while. http://db.tt/CN65sXtn I got a file with 250KB. I have opened it with IZarc, which tried to repair it. I have tried to repair it with Zip Repair and with DiskInternals Zip Repair Tool. In all cases I see the forms but the data folder is empty. Normally the data folder holds the database itself and the queries. I cannot determine, whether the data folder is really empty, but you cannot recover it with this tools. :( Kind regards Regina -- For 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 -- For 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: QuickStarter
Hi people, I had the same problem as Carole. Am running Windows7 64bit I have never used Libre Office before. So the error message is quite perplexing. I have tried a few times with no luck. Both re downloading and running the setup.exe from the unpack folder. Then the penny dropped. I have Open Office installed on this PC. So just end the Open Office Quickstarter as per previous reply and it installed very quickly. Have not had a chance to look at everything yet, but hope this helps someone. Bob -- View this message in context: http://nabble.documentfoundation.org/Quickstarter-tp3686375p3691593.html Sent from the Users mailing list archive at Nabble.com. -- For 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] Problem pasting spreadsheet cells into Impress
Hi, Tanstaafl wrote (13-01-12 22:17) Whenever I try to copy some cells from a spreadsheet and paste the into an Impress Presentation Libreoffice (and Openoffice used to do the same thing) totally locks up goes into never-never land, and I have to kill it. No problem for me in 3.5.0rc1 (only I tested now). So please give more details, as others to help finding where the problem might be. Thanks, -- - Cor - http://nl.libreoffice.org -- For 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] Writer
I've linked the address book of Thunderbird to LibreOffice, the same as how I linked it with OpenOffice: File/Wizards/Address Data Source/Thunderbird - NEXT. When writing a letter, or creating a label, I access the Data Source (F4), I access the Personal Address book. I then highlight the address I want, click the Data to Text icon, check the Text button, then proceed to highlight and move from the Database columns box on the left to the box on the right, all in the proper format for an address label. When I exit the Data to Text box, the address label format does not keep as I entered, using LibreOffice. I always have to reformat the text (which is time consuming and annoying). However, when I used OpenOffice, the format DID keep, so I didn't have to waste time formatting again. Why the difference? Why doesn't the format keep in LibreOffice? This is not only very annoying, it's also very embarrassing when demonstrating LibreOffice. Greg -- For 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] Writer
Hi Greg, Gregory Forster wrote (27-01-12 00:13) [...] then proceed to highlight and move from the Database columns box on the left to the box on the right, all in the proper format for an address label. What kind of format do you mean? When I exit the Data to Text box, the address label format does not keep as I entered, using LibreOffice. I always have to reformat the text (which is time consuming and annoying). What changes in formatting (thus what / how do you have to change)? Thanks for your further explanation, -- - Cor - http://nl.libreoffice.org -- For 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] Base question - report exception on faultless query
On 01/26/2012 04:03 PM, Dan Lewis wrote: On Thu, 2012-01-26 at 20:30 +, Mark Stanton wrote: I'm trying to produce a report based on a query, trying to being the operative phrase. I have a query, it works just fine. I use the report wizard to produce a report based on the query (I haven't worked out how to do that manually yet). It presents me with the correct fields. I've arranged them the way I want them, at least in a very basic form 'cos I'm still testing. Running the report gives me four errors, SQL status S1000 An error occurred while creating the report, An exception of type com.sun.star.lang.WrappedTargetException was caught. (Alright, that was info, not strictly speaking an error I s'pose), and two errors that both say Syntax error in SQL expression. Check this link: https://issues.apache.org/ooo/show_bug.cgi?id=110535. Skimming the bug report the problem appeared to be not fully qualifying the field names in a JOIN. the field id exists in both tables and must be qualified by table1.id and table2.id. Why it would not throw an error earlier I do not know. What SQL expression would that be then? Since my query runs correctly? Mark Stanton One small step for mankind... Some details would be nice. For example, what is the SQL for your query? (You will find it if you right click the query and select Edi in SQL. What were your selections in the Report Wizard? There should be some clues in the answers to these questions. --Dan -- Jay Lozier jsloz...@gmail.com -- For 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: Mysterious spacing problem
On 01/26/2012 03:49 PM, Séamas Ó Brógáin wrote: Tom wrote: Are you looking for mono-spaced fonts? A font that has all characters the same fixed width? There are plenty out there. No, these are conventional fonts. Certain characters are spaced wrongly in Libre Office (but are correctly spaced in other applications). Is this a screen resolution or a printing problem. Could you specify which font(s) are troublesome? Also, I forgot - what OS are you using? -- Jay Lozier jsloz...@gmail.com -- For 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: QuickStarter
On 01/26/2012 03:57 PM, bob.frew wrote: Hi people, I had the same problem as Carole. Am running Windows7 64bit I have never used Libre Office before. So the error message is quite perplexing. I have tried a few times with no luck. Both re downloading and running the setup.exe from the unpack folder. Then the penny dropped. I have Open Office installed on this PC. So just end the Open Office Quickstarter as per previous reply and it installed very quickly. This is known behavior when OO or LO are installed on Windows. If the quickstarter for either is open, the default behavior is startup automatically, installing LO will fail. Have not had a chance to look at everything yet, but hope this helps someone. Bob -- View this message in context: http://nabble.documentfoundation.org/Quickstarter-tp3686375p3691593.html Sent from the Users mailing list archive at Nabble.com. -- Jay Lozier jsloz...@gmail.com -- For 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] Writer
On 1/26/2012 5:20 PM, Cor Nouws wrote: Hi Greg, Gregory Forster wrote (27-01-12 00:13) [...] then proceed to highlight and move from the Database columns box on the left to the box on the right, all in the proper format for an address label. What kind of format do you mean? When I exit the Data to Text box, the address label format does not keep as I entered, using LibreOffice. I always have to reformat the text (which is time consuming and annoying). What changes in formatting (thus what / how do you have to change)? Thanks for your further explanation, First, I highlight First Name in the box on the left. Then I click the between the two boxes to move the First Name to the box on the right. Then I move the cursor to the end of First Name in the right box and press the space bar. Then I highlight Last Name in the left box, click the in the middle to move the Last Name to the right box, so I have: First Name Last Name, then I move the cursor to the end of Last Name and press Enter. I then highlight Address 1 in the left box and click to move the Address 1 underneath the First Name Last Name. Then I move the cursor after the Address 1 and press Enter. I then highlight City in the left box, press to move City to the right box. I then move my cursor after City in the right box and add a comma and a space. Then I highlight State in the left box, click to move State to the right box. I then move the cursor to the right box after City, State and press the space bar twice. I then highlight the ZIP/Postal (Home) in the left box, click the to move the ZIP/Postal (Home) to the right box after City, State. Now I have the first and last name on the top line, the address in the middle line and the city, state and zipcode on the third line. This formatting is all done with the Text button checked in the upper Insert Data As: That format gives me the proper address labeling for letters, labels, etc. However, when I exit the Insert Database Columns popup, the formatting disappears in LibreOffice. However, in OpenOffice, that formatting would stay intact. Grant it, that formatting would have to be initialized for each address book database used. I hope that helps. Greg -- For 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] Base question - report exception on faultless query
Any time more than one table is used in a query or view, it is best to name fields with this format: table name.field name. Looking at the SQL of a query containing fields from two or more tables, this is the format used. However, when only one table is involved, the field name format is sufficient. I would still like to see the SQL for your query. Could you send it to me off list? --Dan On Thu, 2012-01-26 at 18:37 -0500, Jay Lozier wrote: On 01/26/2012 04:03 PM, Dan Lewis wrote: On Thu, 2012-01-26 at 20:30 +, Mark Stanton wrote: I'm trying to produce a report based on a query, trying to being the operative phrase. I have a query, it works just fine. I use the report wizard to produce a report based on the query (I haven't worked out how to do that manually yet). It presents me with the correct fields. I've arranged them the way I want them, at least in a very basic form 'cos I'm still testing. Running the report gives me four errors, SQL status S1000 An error occurred while creating the report, An exception of type com.sun.star.lang.WrappedTargetException was caught. (Alright, that was info, not strictly speaking an error I s'pose), and two errors that both say Syntax error in SQL expression. Check this link: https://issues.apache.org/ooo/show_bug.cgi?id=110535. Skimming the bug report the problem appeared to be not fully qualifying the field names in a JOIN. the field id exists in both tables and must be qualified by table1.id and table2.id. Why it would not throw an error earlier I do not know. What SQL expression would that be then? Since my query runs correctly? Mark Stanton One small step for mankind... Some details would be nice. For example, what is the SQL for your query? (You will find it if you right click the query and select Edi in SQL. What were your selections in the Report Wizard? There should be some clues in the answers to these questions. --Dan -- Jay Lozier jsloz...@gmail.com -- For 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] what is the alternative of countifs function in libreoffice?
no problem like that.downloaded and read it.and as i had mentioned already,missed the click data field and change function part previously.this time,doing this helped to solve my problem. now i am trying to include the row/column percentage into the data pilot result directly along with the absolute count.so far, no luck!! regards, On 26 January 2012 23:59, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) That link tries to download the Pdf version but this link lets you see all the chapters and doesn't try to download anything until after you have had a look around at what you might be downloading http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide I dunno why but some people get furious about links that force a download! The single chapter is pretty tiny file-size but i guess some people have very restricted limits and of course some people just enjoy getting angry about anything. Regards from Tom :) -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- For 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