[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//.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. M

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 wrote: > > 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 DB which acts as >

[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

[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 v

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). J

[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 determin

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//.config/libreoffice > > sometime between 3.x and 4.x development > > If you

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 wrote: > > 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? Calc on Ubuntu does t

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 rea

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, Er