Re: [libreoffice-users] Calc and Base problems.
Thanks Tom On 30/09/2011 13:11, Tom Davies wrote: 1. Is your java version higher than _21? if so it would be best to install the _21 just for LibreOffice& OpenOffice. The more recent ones cause problems. Find out which version by Tools - Options - LibreOffice/OpenOffice/General - Java Machine 1 has Java _21 Machine 2 has Java _20 2. Do you really need a spreadsheet? A query or even a report can be made to look like a spreadsheet? Would be interested to hear about this. I need a printable document that up-dates automatically from the DB to transfer to my WebSite. Thanks Ian Whitfield -- 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] Calc and Base problems.
Hi :) I don't know much about this but 1. Is your java version higher than _21? if so it would be best to install the _21 just for LibreOffice& OpenOffice. The more recent ones cause problems. Find out which version by Tools - Options - LibreOffice/OpenOffice/General - Java 2. Do you really need a spreadsheet? A query or even a report can be made to look like a spreadsheet? Regards from Tom :) --- On Fri, 30/9/11, Ian Whitfield wrote: From: Ian Whitfield Subject: [libreoffice-users] Calc and Base problems. To: users@global.libreoffice.org Date: Friday, 30 September, 2011, 8:24 Hi All I have a couple of problems I need to solve urgently!! I have two computers here - 1) Running Mint 10 KDE and Open Office 3.2.1 2) Running Mint 9 KDE and Libre-Office 3.3.2.2 I have developed and am running a Membership Database on a daily basis on machine 1and it works perfectly!! I would like to create a Spreadsheet that links to the Database. The DB is "Registered" on the system but if I do a 'Insert>Link to external data', then browse to and select the Database file - nothing happens and the 'link box' remains empty. If I do a 'View>Data Sources' the whole Open-Office Suite just "crashes' totally!! (I use Calc on a regular basis also and it works fine). On my second machine I have a separate copy of the Database file from machine 1 which is also "Registered" on that machine. If I try to run the database - 'LO Base>Open existing file>Select file>Open' The Base window opens and shows all my Tables, forms etc. But when I select any of these I get the following error... "Connection to 'My DB' couldn't be established. GENERAL ERROR: org.hsqldb.lib.FileSystem RunTime Error: Java.IO Exception: /home/tinderbox/ooobuild/build/libre-3.3.2.2/package/source/xstor/xstorage.cxx: :3323;" Also if I try to run my Database on this machine I get the exact same error. I can select it and the Base window comes up showing all my tables, forms etc but if I select anything the error comes up. This is very distressing as it means I can not move to Libre-Office if I can't run my Database which works fine in OO!!! Any thoughts or suggestions on these problems?? Thanks in advance Ian Whitfield. -- 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] Calc and Base problems.
Hi All I have a couple of problems I need to solve urgently!! I have two computers here - 1) Running Mint 10 KDE and Open Office 3.2.1 2) Running Mint 9 KDE and Libre-Office 3.3.2.2 I have developed and am running a Membership Database on a daily basis on machine 1and it works perfectly!! I would like to create a Spreadsheet that links to the Database. The DB is "Registered" on the system but if I do a 'Insert>Link to external data', then browse to and select the Database file - nothing happens and the 'link box' remains empty. If I do a 'View>Data Sources' the whole Open-Office Suite just "crashes' totally!! (I use Calc on a regular basis also and it works fine). On my second machine I have a separate copy of the Database file from machine 1 which is also "Registered" on that machine. If I try to run the database - 'LO Base>Open existing file>Select file>Open' The Base window opens and shows all my Tables, forms etc. But when I select any of these I get the following error... "Connection to 'My DB' couldn't be established. GENERAL ERROR: org.hsqldb.lib.FileSystem RunTime Error: Java.IO Exception: /home/tinderbox/ooobuild/build/libre-3.3.2.2/package/source/xstor/xstorage.cxx: :3323;" Also if I try to run my Database on this machine I get the exact same error. I can select it and the Base window comes up showing all my tables, forms etc but if I select anything the error comes up. This is very distressing as it means I can not move to Libre-Office if I can't run my Database which works fine in OO!!! Any thoughts or suggestions on these problems?? Thanks in advance Ian Whitfield. -- 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