Re: [libreoffice-users] Re: Base Report Builder
Hi Hank, I haven't been following this thread closely, but it seem like you are experiencing some of the same problems I had using Base HSQLDB. I eventually decided to move my Accounting Project to the H2 Database Engine, (see http://www.h2database.com/html/main.html). Some of the many advantages of H2 are - - Separate files for Data and Project - Can be run in single or multi-user mode - Users report successfully running very large databases - An active users forum I have found H2 to be very stable and have not regretted making the change. If you are interested at all, I can point you to a very good tutorial for replacing HSQLDB with H2. This may not be what you are looking for, but it's probably worth your while at least having a look at what H2 has to offer. Noel -- Noel Lodge lodg...@gmail.com On 27 January 2013 17:24, Hank Alper hankal...@gmail.com wrote: Hi Alex, Mark, Tom, You guys scare me ! I'm beginning to think I'd better start looking for a new back end. I've put a lot of work into this project. Tom, this is not a small database like an address book. After normalizing, my design has 16 tables.( with a few more coming as I've discovered as I feed more data into it.) If I connect to an external server is there any way I can save my forms and reports? Or shall I have to start anew ? My tables, queries and views were all produced using SQL and I have text copies of all of them to feed any server I might select. Transfer of data becomes a problem, of course. Hank On Mon, Jan 21, 2013 at 10:36 AM, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 21/01/13 16:01, Mark Stanton a écrit : Isn't hsqldb *still* a (relatively) good choice, as long as it is installed and used *external* to Base? That does of course mean it's still not the default setting. As I mentioned in my answer to Tom, if you use an external version of hsqldb, it can only be the same version number as the internal version provided with LO, else the old ODB files can no longer be opened. In other words, you can not install an external hsqldb jar and expect your old ODB(hsqldb) files to keep working, as this will throw an error. So yes, it still remains a possibility, but one that you may want to avoid if you still have old ODB files that use the internal hsqldb with an older revision number than the externa jar you plug into LO. Alex -- 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 -- 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 Report Builder
Thanks for answer After several trys to delete and reinstall libreOfficeImpress I looked for any file in the computer: sudo find / -name libreoffice* -print and deleted all of them and installed libreOfficeImpress new from ubuntuSoftwareCenter And ... its working :-) In one of these files must have been the wrong configuration, which happened through copy and paste the 2 minute long video to libreOfficeImpress. I have read, that the correct way to input a video I have to use the input-button. Yet I did not try the big video, but I can go on working with libreOffice, which makes me happy :-) If the problem will occure with the big video, I will try H2 Thanks for help On 2013-01-27 10:36, Marion Noel Lodge wrote: Hi Hank, I haven't been following this thread closely, but it seem like you are experiencing some of the same problems I had using Base HSQLDB. I eventually decided to move my Accounting Project to the H2 Database Engine, (see http://www.h2database.com/html/main.html). Some of the many advantages of H2 are - - Separate files for Data and Project - Can be run in single or multi-user mode - Users report successfully running very large databases - An active users forum I have found H2 to be very stable and have not regretted making the change. If you are interested at all, I can point you to a very good tutorial for replacing HSQLDB with H2. This may not be what you are looking for, but it's probably worth your while at least having a look at what H2 has to offer. Noel -- Noel Lodge lodg...@gmail.com On 27 January 2013 17:24, Hank Alperhankal...@gmail.com wrote: Hi Alex, Mark, Tom, You guys scare me ! I'm beginning to think I'd better start looking for a new back end. I've put a lot of work into this project. Tom, this is not a small database like an address book. After normalizing, my design has 16 tables.( with a few more coming as I've discovered as I feed more data into it.) If I connect to an external server is there any way I can save my forms and reports? Or shall I have to start anew ? My tables, queries and views were all produced using SQL and I have text copies of all of them to feed any server I might select. Transfer of data becomes a problem, of course. Hank On Mon, Jan 21, 2013 at 10:36 AM, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 21/01/13 16:01, Mark Stanton a écrit : Isn't hsqldb *still* a (relatively) good choice, as long as it is installed and used *external* to Base? That does of course mean it's still not the default setting. As I mentioned in my answer to Tom, if you use an external version of hsqldb, it can only be the same version number as the internal version provided with LO, else the old ODB files can no longer be opened. In other words, you can not install an external hsqldb jar and expect your old ODB(hsqldb) files to keep working, as this will throw an error. So yes, it still remains a possibility, but one that you may want to avoid if you still have old ODB files that use the internal hsqldb with an older revision number than the externa jar you plug into LO. Alex -- 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 -- 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] Installing 4.0 alongside 3.5
Den 26.01.2013 22:59, skreiv upscope: On Saturday, January 26, 2013 08:02:34 PM Johnny Rosenberg wrote: For some reasons I want to try the upcoming version 4.0. On the web page, they say ”You are not recommended to use LibreOffice pre-release builds for mission-critical purposes”. So obviously I need a stable version as well, like the 3.5.7.2 that I have installed right now. So I presume that I can use both versions at the same time, that they are ”isolated” from each other as long as 4.0 is a pre-release, right? But before I'm going to install it, I want to know rather than just assume… So, is it possible? If so, can I just install the debs (operating system=Ubuntu 12.04) and it will just work? Will I be able to run both versions at the same time safely? Johnny Rosenberg In the Linux enviroment I have 3.6.3 (openSUSE verssion), 3.6.4 and 4.0-dev (from libreoffice download page0 all installed and running together at times. install generated the icons and i Just select the one for the version I want. Will as long at each version has a different name. Not sure about the windows versions, I'll leave that to one of the Windows users. Russ No problem in Windows. As a translator I am running version 3.6.4.3 and version 4.0.0.0.beta2 (together with MS Excel) at the same time without any conflicts. Kolbjoern -- 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 Report Builder
And to allay your fears a little Hank, the job of moving your *data* to a new back end can be as easy as dragging and dropping tables. Setting up the new back end might introduce you to some new ideas so it might take a little to get your head around it, but once that's done it might not be hugely difficult. It's possible, of course, that there will be some little niggling problems that need to be resolved manually, but it's possible that the move can go relatively smoothly and easily. Regards Mark Stanton -- 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 Report Builder
Hi :) That is something that has been said by quite a fe people so i'm kinda happy to rely on it for migrating the database i'm vaguely working on. At the moment my main worry is getting a couple of the smaller tables into Base's internal back-end and if i manage that then i hope to just simply copy the rest of the tables out of Access and directly into something more sensible. There was an excellent post about doing that eons ago. Although i might have problems finding it, at least i know it's around. Regards from Tom :) From: Mark Stanton m...@vowleyfarm.co.uk To: users@global.libreoffice.org Sent: Sunday, 27 January 2013, 11:34 Subject: Re: [libreoffice-users] Base Report Builder And to allay your fears a little Hank, the job of moving your *data* to a new back end can be as easy as dragging and dropping tables. Setting up the new back end might introduce you to some new ideas so it might take a little to get your head around it, but once that's done it might not be hugely difficult. It's possible, of course, that there will be some little niggling problems that need to be resolved manually, but it's possible that the move can go relatively smoothly and easily. Regards Mark Stanton -- 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] Installing 4.0 alongside 3.5
Hi :) It should be fine in Ubuntu 12.04. I'm not sure why people are talking about Windows but this guide covers both anyway https://wiki.documentfoundation.org/Installing_in_parallel (to answer my own questions it's probably because there's been a lot of traffic on-list so people have to skim through quickly and most questions tend to be about Windows) Good luck and regards from Tom :) From: Kolbjørn Stuestøl kolbjo...@stuestoel.no To: users@global.libreoffice.org Sent: Sunday, 27 January 2013, 11:28 Subject: Re: [libreoffice-users] Installing 4.0 alongside 3.5 Den 26.01.2013 22:59, skreiv upscope: On Saturday, January 26, 2013 08:02:34 PM Johnny Rosenberg wrote: For some reasons I want to try the upcoming version 4.0. On the web page, they say ”You are not recommended to use LibreOffice pre-release builds for mission-critical purposes”. So obviously I need a stable version as well, like the 3.5.7.2 that I have installed right now. So I presume that I can use both versions at the same time, that they are ”isolated” from each other as long as 4.0 is a pre-release, right? But before I'm going to install it, I want to know rather than just assume… So, is it possible? If so, can I just install the debs (operating system=Ubuntu 12.04) and it will just work? Will I be able to run both versions at the same time safely? Johnny Rosenberg In the Linux enviroment I have 3.6.3 (openSUSE verssion), 3.6.4 and 4.0-dev (from libreoffice download page0 all installed and running together at times. install generated the icons and i Just select the one for the version I want. Will as long at each version has a different name. Not sure about the windows versions, I'll leave that to one of the Windows users. Russ No problem in Windows. As a translator I am running version 3.6.4.3 and version 4.0.0.0.beta2 (together with MS Excel) at the same time without any conflicts. Kolbjoern -- 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 Report Builder
Hi :) Preferably before trying the big video please go to Tools - Options - Memory and radically increase the various settings in there so that the program can cope with the video. Does the whole video really have to be embedded in the slide-show/file or could it just be linked to and then the 2 files carried around together? It might seems a little clunkier that way but it does increase flexibility for the longer-term or if the show needs to appear on lower-spec machines (such as netbooks or tablets or hand-helds). It's not always possible easily so don't worry too much about it. It's just a thought. Several assumptions there that 'need' to be demolished. 1. LibreOffice is one single program/application with several different parts to it. Those parts should really be called modules rather than apps but we tend to use the wrong word to minimise endless repetitions of explanations and discussions which are mostly irrelevant to whatever problems the original poster had. Obviously it back-fires sometimes as in this case. So, Writer, Draw, Impress, Calc and Math are all 'just' modules within the program and the 1 single program is LibreOffice. You dealt with that just fine in the end but sometimes it's a struggle to explain. 2. Reinstalling does not reset settings nor configurations. You fixed a much more serious issue with the reinstall. The program/package itself 'must' have been broken in some way. Perhaps a corrupted download or something. Generally if you have weird problems and want to get back to factory defaults just to see if it was somethign in the settings or perhaps some 3rd party Extension struggling then just rename the User Profile https://wiki.documentfoundation.org/Documentation/UserProfile Actually on Friday i was able to rapidly fix a broken Gimp session on a colleague's machine by following that familiar link rather than trying to find my way through Gimp's own documentation. Not that Gimp's is bad, just that i had under a minute to findfix. So, welcome in and regards from Tom :) From: Dr. Philipp Walderdorff ph.walderdo...@gmx.at To: users@global.libreoffice.org Sent: Sunday, 27 January 2013, 11:12 Subject: Re: [libreoffice-users] Re: Base Report Builder Thanks for answer After several trys to delete and reinstall LibreOfficeImpress I looked for any file in the computer: sudo find / -name libreoffice* -print and deleted all of them and installed LibreOfficeImpress new from Ubuntu Software Center And ... its working :-) In one of these files must have been the wrong configuration, which happened through copy and paste the 2 minute long video to LibreOfficeImpress. I have read, that the correct way to input a video I have to use the input-button. Yet I did not try the big video, but I can go on working with LibreOffice, which makes me happy :-) If the problem will occure with the big video, I will try H2 Thanks for help On 2013-01-27 10:36, Marion Noel Lodge wrote: Hi Hank, I haven't been following this thread closely, but it seem like you are experiencing some of the same problems I had using Base HSQLDB. I eventually decided to move my Accounting Project to the H2 Database Engine, (see http://www.h2database.com/html/main.html). Some of the many advantages of H2 are - - Separate files for Data and Project - Can be run in single or multi-user mode - Users report successfully running very large databases - An active users forum I have found H2 to be very stable and have not regretted making the change. If you are interested at all, I can point you to a very good tutorial for replacing HSQLDB with H2. This may not be what you are looking for, but it's probably worth your while at least having a look at what H2 has to offer. Noel -- Noel Lodge lodg...@gmail.com On 27 January 2013 17:24, Hank Alperhankal...@gmail.com wrote: Hi Alex, Mark, Tom, You guys scare me ! I'm beginning to think I'd better start looking for a new back end. I've put a lot of work into this project. Tom, this is not a small database like an address book. After normalizing, my design has 16 tables.( with a few more coming as I've discovered as I feed more data into it.) If I connect to an external server is there any way I can save my forms and reports? Or shall I have to start anew ? My tables, queries and views were all produced using SQL and I have text copies of all of them to feed any server I might select. Transfer of data becomes a problem, of course. Hank On Mon, Jan 21, 2013 at 10:36 AM, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 21/01/13 16:01, Mark Stanton a écrit : Isn't hsqldb *still* a (relatively) good choice, as long as it is installed and used *external* to Base? That does of course mean it's still not the default setting. As I mentioned in my answer to Tom, if you use an external version of hsqldb, it can only be the same version
Re: [libreoffice-users] Re: Base Report Builder
Many of these advantages also apply to HSQLDB if you know what you are doing. I refer to using Base to connect to the database rather than it be embedded. In this case, tables, queries, forms, and reports can be copied from the embedded database to the external one. This is done using HSQLDB 1.8 database engine in Base. Then you should be able to upgrade Base to using HSQLDB 2.8 which includes features not available in the 1.8 version. This does require having a version of LibreOffice dedicated for this purpose (for example, using 3.6.5.2 for HSQLDB 2.8, and 4.0.0 for embedded databases). The draft of chapter 3 of the Base contains discussion of this in the last section. --Dan On 01/27/2013 04:36 AM, Marion Noel Lodge wrote: Hi Hank, I haven't been following this thread closely, but it seem like you are experiencing some of the same problems I had using Base HSQLDB. I eventually decided to move my Accounting Project to the H2 Database Engine, (see http://www.h2database.com/html/main.html). Some of the many advantages of H2 are - - Separate files for Data and Project - Can be run in single or multi-user mode - Users report successfully running very large databases - An active users forum I have found H2 to be very stable and have not regretted making the change. If you are interested at all, I can point you to a very good tutorial for replacing HSQLDB with H2. This may not be what you are looking for, but it's probably worth your while at least having a look at what H2 has to offer. Noel -- Noel Lodge lodg...@gmail.com On 27 January 2013 17:24, Hank Alper hankal...@gmail.com wrote: Hi Alex, Mark, Tom, You guys scare me ! I'm beginning to think I'd better start looking for a new back end. I've put a lot of work into this project. Tom, this is not a small database like an address book. After normalizing, my design has 16 tables.( with a few more coming as I've discovered as I feed more data into it.) If I connect to an external server is there any way I can save my forms and reports? Or shall I have to start anew ? My tables, queries and views were all produced using SQL and I have text copies of all of them to feed any server I might select. Transfer of data becomes a problem, of course. Hank On Mon, Jan 21, 2013 at 10:36 AM, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 21/01/13 16:01, Mark Stanton a écrit : Isn't hsqldb *still* a (relatively) good choice, as long as it is installed and used *external* to Base? That does of course mean it's still not the default setting. As I mentioned in my answer to Tom, if you use an external version of hsqldb, it can only be the same version number as the internal version provided with LO, else the old ODB files can no longer be opened. In other words, you can not install an external hsqldb jar and expect your old ODB(hsqldb) files to keep working, as this will throw an error. So yes, it still remains a possibility, but one that you may want to avoid if you still have old ODB files that use the internal hsqldb with an older revision number than the externa jar you plug into LO. Alex -- 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 -- 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] Installing 4.0 alongside 3.5
2013/1/27 Tom Davies tomdavie...@yahoo.co.uk: Hi :) It should be fine in Ubuntu 12.04. I'm not sure why people are talking about Windows That felt strange to me too, since I mentioned my operating system in my original post. Even stranger is that I received that message at all, since I have a filter that is supposed move all messages that contains the word ”Windows” (or any of some other words) from my inbox so I never have to read them, but obviously this does not work, which doesn't have anything to do with LibreOffice anyway, so this is way off topic… but this guide covers both anyway https://wiki.documentfoundation.org/Installing_in_parallel Thanks. I'll take a look at it later. Johnny Rosenberg (to answer my own questions it's probably because there's been a lot of traffic on-list so people have to skim through quickly and most questions tend to be about Windows) Good luck and regards from Tom :) From: Kolbjørn Stuestøl kolbjo...@stuestoel.no To: users@global.libreoffice.org Sent: Sunday, 27 January 2013, 11:28 Subject: Re: [libreoffice-users] Installing 4.0 alongside 3.5 Den 26.01.2013 22:59, skreiv upscope: On Saturday, January 26, 2013 08:02:34 PM Johnny Rosenberg wrote: For some reasons I want to try the upcoming version 4.0. On the web page, they say ”You are not recommended to use LibreOffice pre-release builds for mission-critical purposes”. So obviously I need a stable version as well, like the 3.5.7.2 that I have installed right now. So I presume that I can use both versions at the same time, that they are ”isolated” from each other as long as 4.0 is a pre-release, right? But before I'm going to install it, I want to know rather than just assume… So, is it possible? If so, can I just install the debs (operating system=Ubuntu 12.04) and it will just work? Will I be able to run both versions at the same time safely? Johnny Rosenberg In the Linux enviroment I have 3.6.3 (openSUSE verssion), 3.6.4 and 4.0-dev (from libreoffice download page0 all installed and running together at times. install generated the icons and i Just select the one for the version I want. Will as long at each version has a different name. Not sure about the windows versions, I'll leave that to one of the Windows users. Russ No problem in Windows. As a translator I am running version 3.6.4.3 and version 4.0.0.0.beta2 (together with MS Excel) at the same time without any conflicts. Kolbjoern -- 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] Filtered or Conditionally Defined Data Ranges in Charts?
Hello, I'm having a lot of trouble doing something that I figure is actually pretty simple to do -- I hope folks can help me out! I have a simple dataset (this is from my duaghter's homework assignment actually!) which I've uploaded to a google doc just so you can see what it looks like: https://docs.google.com/spreadsheet/ccc?key=0Aqhzp2yOOf0zdGc1MHozTm1XblZTdWVLN2JkcE4ySUE I want to be able to make one simple scatter plot of one column (Time of Day) against another column (Response Time in Minutes). But I want to use the value of a third column (Company) to FILTER the results, and graph the filtered results against each other. So, in this case, we have two companies, Metro and Arrow. I want my graph to display the Arrow Datapoints in (say) Blue, and the Metro datapoints in (say) red. I feel like this ought to be easy to do, by defining a filter condition in the data range. This doesn't seem possible though. And if I try to do it through the graphical interface, using filters, say, then I can only ever graph one filter condition at a time. The only workaround I've found is to sort the data by company name, then define the data ranges of 2 data series based on that. But if I happen to resort my data, or add new rows, then the chart won't update dynamically in an appropriate way. Is there a good way to do what I'm trying to do? Thank you for your help! Matt -- 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] Reset the profile
Hello! Regarding this bug report: https://bugs.freedesktop.org/show_bug.cgi?id=59270 What steps should I follow to reset the profile? I have already done: rm -r ./.config/libreoffice/4 on Debian Linux. Any ideas? :) (Basically, I would like to confirm a bug but I do not know how to reset the profile except that rm command.) Are there other things I should do to confirm the bug? What are they? :) Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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] Left Justification in Stacked Scalable Braces
Writer → Insert → Object → Formula
At the Equation Editor at the bottom of the screen, type the following:
left lbrace alignc stack {-continuant # -nasal # +voiced } right rbrace
And the following will appear in the box in your document:
{- continuant}
{ - nasal}
{ * voice }
Regard the braces as continuous vertically.
The preceding appears:
- continuant
- nasal
+ voice
How can I make -continuant, -nasal, and +voice left-justified, as follows?
{- continuant}
{- nasal }
{+ voice }
Attachment:
Left Justification in Stacked Scalable Braces.odt (16K)
==
--
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] Reset the profile
On 27/01/2013 at 16:19, C. H. D. webofht-libreoffice...@yahoo.com.hk wrote: (Basically, I would like to confirm a bug but I do not know how to reset the profile except that rm command.) You can use this command: soffice -env:UserInstallation=file:///tmp/lo-userprof/ It will tell LO to start with /tmp/lo-userprof/ as profile. Since it does not exist, it will create it with default package settings. Of course you should change soffice part to path to soffice binary on your system (especially if you downloaded LO from website, then this binary probably isn't in your $PATH). (C. H. D.: sorry for sending this reply off-list, directly to you. This was due to stupid setting of this mailing list, that any replies are by default sent to poster, not to mailing list.) -- Best regards Mirosław Zalewski -- 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] Left Justification in Stacked Scalable Braces
At 11:16 27/01/2013 -0500, Taang Zomi wrote:
Writer Insert Object Formula
At the Equation Editor at the bottom of the screen, type the following:
left lbrace alignc stack {-continuant # -nasal # +voiced } right rbrace
And the following will appear in the box in your document:
{- continuant}
{ - nasal}
{ * voice }
Regard the braces as continuous vertically.
The preceding appears:
- continuant
- nasal
+ voice
How can I make -continuant, -nasal, and +voice left-justified, as follows?
{- continuant}
{- nasal }
{+ voice }
Easy: just change one letter. For alignc (align centre) read
alignl (align left).
Attachment: Left Justification in Stacked Scalable Braces.odt (16K)
Attachments are removed by the list processor before your message is
distributed, so no-one will have seen this.
I trust this helps.
Brian Barker
--
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: Left Justification in Stacked Scalable Braces
*Brian,
Thank you very, very much for your help. You saved my day.
Sincerely,
Taang Zomi*
-- Forwarded message --
From: Brian Barker b.m.bar...@btinternet.com
Date: Sun, Jan 27, 2013 at 11:48 AM
Subject: Re: [libreoffice-users] Left Justification in Stacked Scalable
Braces
To: users@global.libreoffice.org
At 11:16 27/01/2013 -0500, Taang Zomi wrote:
Writer Insert Object Formula
At the Equation Editor at the bottom of the screen, type the following:
left lbrace alignc stack {-continuant # -nasal # +voiced } right rbrace
And the following will appear in the box in your document:
{- continuant}
{ - nasal}
{ * voice }
Regard the braces as continuous vertically.
The preceding appears:
- continuant
- nasal
+ voice
How can I make -continuant, -nasal, and +voice left-justified, as follows?
{- continuant}
{- nasal }
{+ voice }
Easy: just change one letter. For alignc (align centre) read alignl
(align left).
Attachment: Left Justification in Stacked Scalable Braces.odt (16K)
Attachments are removed by the list processor before your message is
distributed, so no-one will have seen this.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to:
users+help@global.libreoffice.**orgusers%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/**Netiquettehttp://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
--
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 Report Builder
Hi Noel, Thank you for pointing me to H2. It appears to offer so many advantages over the embedded HSQLDB in LO Base that I shall certainly spend some time examining its possibilities. I'd definitely like to see the tutorial for replacing HSQLDB with H2. Hank On Sun, Jan 27, 2013 at 4:36 AM, Marion Noel Lodge lodg...@gmail.comwrote: Hi Hank, I haven't been following this thread closely, but it seem like you are experiencing some of the same problems I had using Base HSQLDB. I eventually decided to move my Accounting Project to the H2 Database Engine, (see http://www.h2database.com/html/main.html). Some of the many advantages of H2 are - - Separate files for Data and Project - Can be run in single or multi-user mode - Users report successfully running very large databases - An active users forum I have found H2 to be very stable and have not regretted making the change. If you are interested at all, I can point you to a very good tutorial for replacing HSQLDB with H2. This may not be what you are looking for, but it's probably worth your while at least having a look at what H2 has to offer. Noel -- Noel Lodge lodg...@gmail.com On 27 January 2013 17:24, Hank Alper hankal...@gmail.com wrote: Hi Alex, Mark, Tom, You guys scare me ! I'm beginning to think I'd better start looking for a new back end. I've put a lot of work into this project. Tom, this is not a small database like an address book. After normalizing, my design has 16 tables.( with a few more coming as I've discovered as I feed more data into it.) If I connect to an external server is there any way I can save my forms and reports? Or shall I have to start anew ? My tables, queries and views were all produced using SQL and I have text copies of all of them to feed any server I might select. Transfer of data becomes a problem, of course. Hank On Mon, Jan 21, 2013 at 10:36 AM, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 21/01/13 16:01, Mark Stanton a écrit : Isn't hsqldb *still* a (relatively) good choice, as long as it is installed and used *external* to Base? That does of course mean it's still not the default setting. As I mentioned in my answer to Tom, if you use an external version of hsqldb, it can only be the same version number as the internal version provided with LO, else the old ODB files can no longer be opened. In other words, you can not install an external hsqldb jar and expect your old ODB(hsqldb) files to keep working, as this will throw an error. So yes, it still remains a possibility, but one that you may want to avoid if you still have old ODB files that use the internal hsqldb with an older revision number than the externa jar you plug into LO. Alex -- 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 -- 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] Installing 4.0 alongside 3.5
Den 27.01.2013 15:33, skreiv Johnny Rosenberg: 2013/1/27 Tom Davies tomdavie...@yahoo.co.uk: Hi :) It should be fine in Ubuntu 12.04. I'm not sure why people are talking about Windows That felt strange to me too, since I mentioned my operating system in my original post. I thought this forum was for *all* users. I was answering the question because I thought there could be some peoples running another OS wondering whether running different versions of LibreOffice at the same time is possible. Kolbjoern Even stranger is that I received that message at all, since I have a filter that is supposed move all messages that contains the word ”Windows” (or any of some other words) from my inbox so I never have to read them, but obviously this does not work, which doesn't have anything to do with LibreOffice anyway, so this is way off topic… but this guide covers both anyway https://wiki.documentfoundation.org/Installing_in_parallel Thanks. I'll take a look at it later. Johnny Rosenberg (to answer my own questions it's probably because there's been a lot of traffic on-list so people have to skim through quickly and most questions tend to be about Windows) Good luck and regards from Tom :) From: Kolbjørn Stuestøl kolbjo...@stuestoel.no To: users@global.libreoffice.org Sent: Sunday, 27 January 2013, 11:28 Subject: Re: [libreoffice-users] Installing 4.0 alongside 3.5 Den 26.01.2013 22:59, skreiv upscope: On Saturday, January 26, 2013 08:02:34 PM Johnny Rosenberg wrote: For some reasons I want to try the upcoming version 4.0. On the web page, they say ”You are not recommended to use LibreOffice pre-release builds for mission-critical purposes”. So obviously I need a stable version as well, like the 3.5.7.2 that I have installed right now. So I presume that I can use both versions at the same time, that they are ”isolated” from each other as long as 4.0 is a pre-release, right? But before I'm going to install it, I want to know rather than just assume… So, is it possible? If so, can I just install the debs (operating system=Ubuntu 12.04) and it will just work? Will I be able to run both versions at the same time safely? Johnny Rosenberg In the Linux enviroment I have 3.6.3 (openSUSE verssion), 3.6.4 and 4.0-dev (from libreoffice download page0 all installed and running together at times. install generated the icons and i Just select the one for the version I want. Will as long at each version has a different name. Not sure about the windows versions, I'll leave that to one of the Windows users. Russ No problem in Windows. As a translator I am running version 3.6.4.3 and version 4.0.0.0.beta2 (together with MS Excel) at the same time without any conflicts. Kolbjoern -- 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] Drop Caps Character Style in Writer
I was working on understanding Character Styles in Writer, and it seems mostly straightforward. But I noticed that the Drop Caps style does not seem to do anything at all. Is that a bug or am I misunderstanding something here? Thanks, -- Kevin B. O'Brien zwil...@zwilnik.com http://google.me/+kevinobrien -- 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] Reset the profile
Hi :) This link is another way to reset the user profile https://wiki.documentfoundation.org/Documentation/UserProfile Regards from Tom :) From: C. H. D. webofht-libreoffice...@yahoo.com.hk To: LibreOffice User Support Mailing List users@global.libreoffice.org Sent: Sunday, 27 January 2013, 15:19 Subject: [libreoffice-users] Reset the profile Hello! Regarding this bug report: https://bugs.freedesktop.org/show_bug.cgi?id=59270 What steps should I follow to reset the profile? I have already done: rm -r ./.config/libreoffice/4 on Debian Linux. Any ideas? :) (Basically, I would like to confirm a bug but I do not know how to reset the profile except that rm command.) Are there other things I should do to confirm the bug? What are they? :) Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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] Drop Caps Character Style in Writer
On 01/27/2013 02:07 PM, Kevin O'Brien wrote: I was working on understanding Character Styles in Writer, and it seems mostly straightforward. But I noticed that the Drop Caps style does not seem to do anything at all. Is that a bug or am I misunderstanding something here? Thanks, What are you trying to do? subscript of a smaller sized character or do the same with a full size character? Uncheck the Automatic box next to the Raise/lower by box. The full size character will lower the given persentage with the Subscript option checked. -- 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] Drop Caps Character Style in Writer
On 01/27/2013 03:10 PM, webmaster-Kracked_P_P wrote: On 01/27/2013 02:07 PM, Kevin O'Brien wrote: I was working on understanding Character Styles in Writer, and it seems mostly straightforward. But I noticed that the Drop Caps style does not seem to do anything at all. Is that a bug or am I misunderstanding something here? Thanks, What are you trying to do? subscript of a smaller sized character or do the same with a full size character? Uncheck the Automatic box next to the Raise/lower by box. The full size character will lower the given persentage with the Subscript option checked Ah, thank you. All of that was turned off, but your directions showed me how to modify the style to do what I wanted. Regards, -- Kevin B. O'Brien zwil...@zwilnik.com http://google.me/+kevinobrien -- 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] Drop Caps Character Style in Writer
At 14:07 27/01/2013 -0500, Kevin O'Brien wrote: I was working on understanding Character Styles in Writer, and it seems mostly straightforward. But I noticed that the Drop Caps style does not seem to do anything at all. Is that a bug or am I misunderstanding something here? I'm guessing here, but I think I can see its usefulness. You set drop caps as a property of your paragraph or paragraph style, of course. You may not wish the dropped cap to have the same character style as the rest of the paragraph text. So the Drop Caps tab of the Paragraph or Paragraph Style dialogue gives you the opportunity to select a separate character style to be applied to the dropped caps themselves. I'm guessing that the Drop Caps character style is provided as a convenient style to use for this purpose: you can select it in the paragraph or paragraph style properties and then set the character properties that you want in the Drop Caps character style. You could alternatively create your own character style(s), of course. But that's true of all the predefined styles. I trust this helps. Brian Barker -- 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] Drop Caps Character Style in Writer
On 01/27/2013 03:35 PM, Brian Barker wrote: At 14:07 27/01/2013 -0500, Kevin O'Brien wrote: I was working on understanding Character Styles in Writer, and it seems mostly straightforward. But I noticed that the Drop Caps style does not seem to do anything at all. Is that a bug or am I misunderstanding something here? I'm guessing here, but I think I can see its usefulness. You set drop caps as a property of your paragraph or paragraph style, of course. You may not wish the dropped cap to have the same character style as the rest of the paragraph text. So the Drop Caps tab of the Paragraph or Paragraph Style dialogue gives you the opportunity to select a separate character style to be applied to the dropped caps themselves. I'm guessing that the Drop Caps character style is provided as a convenient style to use for this purpose: you can select it in the paragraph or paragraph style properties and then set the character properties that you want in the Drop Caps character style. You could alternatively create your own character style(s), of course. But that's true of all the predefined styles. I trust this helps. Brian Barker I have seen this done with books. the take the first character of the first paragraph of a chapter and use a larger or different font style of character. They have been doing this thing since the early days of printing. Some people call this type of thing illumination or something like that. Many times the that first character is in color or some really fancy font style [as we call it now]. There are some really interesting things that can be done with Writer and its font/text styling, but I know only a few of them. Sometimes it is easier for me to do it with graphic images or changing the font, but sometimes it is harder that way. -- 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] Numbering Equations
In LibreOffiice 3.3 Math Guide (0700MG33-MathGuide3.3.odt), on p. 14, the following is written: *Numbering equations* Equation numbering is one of LibreOffice Math’s best hidden features. The steps are simple, but obscure: 1. Start a new line. 2. Type *fn* and then press *F3*. The *fn* is replaced by a numbered formula: [[equation: E = mc2] (2) () Now you can double-click on the formula to edit it. For example, here is the Riemann Zeta function: [equation: [Rieman Zeta Function] (3) You can reference an equation (“as shown in Equation (2)”) with these steps: 1. Choose *Insert Cross-reference* from the menu bar. 2. On the *Cross-references* tab (Figure 17), under *Type*, select *Text*. 3. Under *Selection*, select the equation number. 4. Under *Format*, select *Reference*. == When I typed fn and pressed F3, nothing happened. In the document the fn I typed appeared, not the desired result. I do not know whether my F3 key did not work. Can somebody kindly explain in step-by-step detail how to number equations. == -- 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] Numbering Equations
It's possible to do what you're trying to do without the F3 key. Go to the Edit menu and select AutoText. You should see a list of categories. Expand the one called Standard. If you scroll down the resulting list, you should see the entry 'Formula Numbering'. Select it and then click on the Insert button. Your equation should appear. Does this work for you? On Sun, 27 Jan 2013, Taang Zomi wrote: In LibreOffiice 3.3 Math Guide (0700MG33-MathGuide3.3.odt), on p. 14, the following is written: *Numbering equations* Equation numbering is one of LibreOffice Math’s best hidden features. The steps are simple, but obscure: 1. Start a new line. 2. Type *fn* and then press *F3*. The *fn* is replaced by a numbered formula: [[equation: E = mc2] (2) () Now you can double-click on the formula to edit it. For example, here is the Riemann Zeta function: [equation: [Rieman Zeta Function] (3) You can reference an equation (“as shown in Equation (2)”) with these steps: 1. Choose *Insert Cross-reference* from the menu bar. 2. On the *Cross-references* tab (Figure 17), under *Type*, select *Text*. 3. Under *Selection*, select the equation number. 4. Under *Format*, select *Reference*. == When I typed fn and pressed F3, nothing happened. In the document the fn I typed appeared, not the desired result. I do not know whether my F3 key did not work. Can somebody kindly explain in step-by-step detail how to number equations. == -- 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 Report Builder
Hi Hank, The URL for the HSQLDB to H2 tutorial is - http://www.oooforum.org/forum/viewtopic.phtml?p=365296#365296 As you will see, I had asked a series of questions and dacm kindly came up with a very comprehensive set of answers. The steps he listed worked well for me. One point to watch when migrating each table. For Table name enter - Database name.PUBLIC.Table name e.g. ROSTERS.PUBLIC.Availability I think you can choose an alternative to PUBLIC, but I just went with the default. Regards, Noel -- Noel Lodge lodg...@gmail.com On 28 January 2013 04:15, Hank Alper hankal...@gmail.com wrote: Hi Noel, Thank you for pointing me to H2. It appears to offer so many advantages over the embedded HSQLDB in LO Base that I shall certainly spend some time examining its possibilities. I'd definitely like to see the tutorial for replacing HSQLDB with H2. Hank On Sun, Jan 27, 2013 at 4:36 AM, Marion Noel Lodge lodg...@gmail.comwrote: Hi Hank, I haven't been following this thread closely, but it seem like you are experiencing some of the same problems I had using Base HSQLDB. I eventually decided to move my Accounting Project to the H2 Database Engine, (see http://www.h2database.com/html/main.html). Some of the many advantages of H2 are - - Separate files for Data and Project - Can be run in single or multi-user mode - Users report successfully running very large databases - An active users forum I have found H2 to be very stable and have not regretted making the change. If you are interested at all, I can point you to a very good tutorial for replacing HSQLDB with H2. This may not be what you are looking for, but it's probably worth your while at least having a look at what H2 has to offer. Noel -- Noel Lodge lodg...@gmail.com On 27 January 2013 17:24, Hank Alper hankal...@gmail.com wrote: Hi Alex, Mark, Tom, You guys scare me ! I'm beginning to think I'd better start looking for a new back end. I've put a lot of work into this project. Tom, this is not a small database like an address book. After normalizing, my design has 16 tables.( with a few more coming as I've discovered as I feed more data into it.) If I connect to an external server is there any way I can save my forms and reports? Or shall I have to start anew ? My tables, queries and views were all produced using SQL and I have text copies of all of them to feed any server I might select. Transfer of data becomes a problem, of course. Hank On Mon, Jan 21, 2013 at 10:36 AM, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 21/01/13 16:01, Mark Stanton a écrit : Isn't hsqldb *still* a (relatively) good choice, as long as it is installed and used *external* to Base? That does of course mean it's still not the default setting. As I mentioned in my answer to Tom, if you use an external version of hsqldb, it can only be the same version number as the internal version provided with LO, else the old ODB files can no longer be opened. In other words, you can not install an external hsqldb jar and expect your old ODB(hsqldb) files to keep working, as this will throw an error. So yes, it still remains a possibility, but one that you may want to avoid if you still have old ODB files that use the internal hsqldb with an older revision number than the externa jar you plug into LO. Alex -- 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 -- 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
[libreoffice-users] Re: Installing 4.0 alongside 3.5
On 01/26/2013 11:02 AM, Johnny Rosenberg wrote: For some reasons I want to try the upcoming version 4.0. On the web page, they say ”You are not recommended to use LibreOffice pre-release builds for mission-critical purposes”. So obviously I need a stable version as well, like the 3.5.7.2 that I have installed right now. So I presume that I can use both versions at the same time, that they are ”isolated” from each other as long as 4.0 is a pre-release, right? But before I'm going to install it, I want to know rather than just assume… So, is it possible? If so, can I just install the debs (operating system=Ubuntu 12.04) and it will just work? Will I be able to run both versions at the same time safely? Luckily, LODev4 (linux only [1]) installs as a separate install: $ locate versionrc /opt/libreoffice/ure/bin/versionrc /opt/libreoffice3.4/basis3.4/program/versionrc /opt/libreoffice3.4/program/versionrc /opt/libreoffice3.4/ure/bin/versionrc /opt/libreoffice3.5/program/versionrc /opt/libreoffice3.6/program/versionrc /opt/libreoffice4.0/program/versionrc /opt/lodev4.0/program/versionrc /opt/openoffice.org/basis3.4/program/versionrc /opt/openoffice.org/ure/bin/versionrc /opt/openoffice.org3/program/versionrc /usr/lib/libreoffice/program/versionrc Install then create a new generic launcher to /opt/lodev4.0/program/soffice and you'll be fine. You can run at the same time as LO 3.x. [1] NHote to Windows users that are reading this, Please *read*: http://www.libreoffice.org/download/pre-releases/ NOTE: This build is in a release configuration and will replace your existing LibreOffice install on Windows! -- 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] Numbering Equations
At 18:04 27/01/2013 -0500, Taang Zomi wrote: In LibreOffice 3.3 Math Guide (0700MG33-MathGuide3.3.odt), on p. 14, the following is written: *Numbering equations* Equation numbering is one of LibreOffice Math's best hidden features. The steps are simple, but obscure: 1. Start a new line. 2. Type *fn* and then press *F3*. [...] When I typed fn and pressed F3, nothing happened. In the document the fn I typed appeared, not the desired result. I do not know whether my F3 key did not work. I think what you may be doing (understandably) is to try this in a Math document - and I cannot see how it works there. Instead, it works as described in a text (Writer) document. Indeed, I notice that the version of the Math Guide for LibreOffice version 3.5 has corrected Equation numbering is one of LibreOffice Math's best hidden features to read Equation numbering is one of Writer's best hidden features. In a text document, in a new paragraph or after a space, type fn and press F3. A table with a single row of two columns appears, containing a dummy equation and the required number (as a field). You need only to double-click the equation to open the Math window at the bottom of the window, where you can remove the dummy equation's definition and replace it with your own. I trust this helps. Brian Barker -- 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
