[libreoffice-users] Re: LO Base Error: DB Created By Newer Version

2014-03-11 Thread Alex Thurgood
Le 11/03/2014 02:00, Mark LaPierre a écrit : Hi Mark, Do you know where LO keeps it's settings? AFAIK the user profile directory was moved to /home/user/.config/libreoffice sometime between 3.x and 4.x development If you have that folder, you will probably find a 4 and a 3 in there.

Re: [libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-11 Thread jomali
On Mon, Mar 10, 2014 at 9:23 PM, Mark LaPierre marklap...@aol.com wrote: snip Hey Alex, So what you are saying is that I can create a LO Base DB that references tables stored in the standalone HSQLDB database with the JDBC connector, and use that .odb file as a back end to another LO Base

[libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-11 Thread Alex Thurgood
On 11/03/2014 13:23, jomali wrote: Hi John, I think your confusion lies in equating an .odb file with an Access database. The .odb file never contains the data. It is a sort of registry that points to wherever the data is. Thus, Base is the front end, a real database is the back end, and the

[libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-11 Thread Alex Thurgood
On 11/03/2014 02:23, Mark LaPierre wrote: Hi Mark, So what you are saying is that I can create a LO Base DB that references tables stored in the standalone HSQLDB database with the JDBC connector, and use that .odb file as a back end to another LO Base DB which acts as a front end? I've

Re: [libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-11 Thread Tom Davies
Hi :) Yes, quite. So 2 different front-ends (such as Base on different machines or for different purposes) could use the same back-end. Daisy chaining one to another seems like a really bad plan. Fairy lights on Xmas trees used to be daisy-chained which meant that if 1 bulb went out then they

[libreoffice-users] cross references in footnotes

2014-03-11 Thread Erik Jan
I made a document in Libreoffice 4.2.1 Mageia 3 with a few cross references to other footnotes in the document. When I exported the document to pdf some of these references had changed. After saving the document and reopening it the references were still wrong. I tried to correct them, but in

Re: [libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-11 Thread jomali
Thanks, Alex, for the clarification. Since I have never used the internal hsqldb database, I was unaware that it kept its data in the .odb file. The last internal database I used was Adabas D in Staroffice. I quickly went to JDBC or ODBC connectors to other external datbase engines (e.g., MySQL).

[libreoffice-users] Calc worksheet stalls when opening

2014-03-11 Thread William Drago
All, I have a spreadsheet that stalls when I try to open it and when I try to save it. It does eventually open after a very long time. I don't know how long, I just walk away from the computer, eat breakfast, and then come back. Are there any log files that I can look at to try and

Re: [libreoffice-users] Re: LO Base Error: DB Created By Newer Version

2014-03-11 Thread Mark LaPierre
On 03/11/14 04:57, Alex Thurgood wrote: Le 11/03/2014 02:00, Mark LaPierre a écrit : Hi Mark, Do you know where LO keeps it's settings? AFAIK the user profile directory was moved to /home/user/.config/libreoffice sometime between 3.x and 4.x development If you have that

Re: [libreoffice-users] Calc worksheet stalls when opening

2014-03-11 Thread Alan B
On Tue, Mar 11, 2014 at 9:21 PM, William Drago wdr...@suffolk.lib.ny.uswrote: I have a spreadsheet that stalls when I try to open it and when I try to save it. It does eventually open after a very long time. I Just looking for confirmation the issue is with only one particular spreadsheet?

Re: [libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-11 Thread Tom Davies
Hi :) I think it's worth avoiding using the internal back-end. Until very recently the internal one was an ancient and heavily tweaked version of Hsqldb. I think the devs have been working at replacing it with a more straight-forward Firebird and hopefully that will be updated in some sort of

Re: [libreoffice-users] cross references in footnotes

2014-03-11 Thread Tom Davies
Hi :) Apparently there is a 3rd party tool that handles this sort of thing MUCH better than Writer or Word and works well with either or both. Have a look around for Zotero and see if that looks like it might be better at handling the cross-references Regards from Tom :) On 11 March 2014 22:31,