Re: [libreoffice-users] Re: Urgent Base problem (stability in long term use)
Interesting to know! For my part, by precaution, all my data are kept in separate dbf tables, linked to an odb file. Why do I use dbf? Standard format making it portable to all softs, notably GIS softwares. Old archives can also be read even if you changed your soft. There is not much information on long term use of databases, let's say more than 10 years (e.g.: keeping adresses or bibliographic data). The file can get corrupt. But worser, some data inside the file can get corrupt, without changing the structure of the dbf file,and you just notice it when you query these data. I heard once that MS-access is not stable enough in long term use. And, sometimes, odb file can get problems (for ex. shutdown of windows while some forms are open in the odb file). But, when the tables are kept in separate files, recovery is easy, using a backup copy of the odb file. Using LibreOffice 3.3.2 on windows Vista. NB: I came to openoffice several years ago mainly because of its good integration with databases (standalone use). I wonder if my way of using Base is optimal, trying to find the way among the many possibilities offered by Base and Calc. Many thanks to the developers, Paul Le 17/03/2012 11:58, Andreas Säger a écrit : Am 17.03.2012 11:41, Ian Whitfield wrote: What filter must I selct or what must I do to get my Database going again?? You need to restore your database from a backup. It is lost. This would not have happened with a true database connection. The database wrapped in a single document (embedded HSQLDB) is just fine for drafts and demo purposes. If you really want to work with this bastard you should save a backup copy whenever you take a break. Close the file, wait a moment and make copy of it before you reopen the 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] Urgent Base problem
I think the point Mark was making was to switch away from using the embedded back-end to pretty much any external one. Which is what you often suggest too. Yes indeed. Can HSQLDB be used as an external engine? I thought not, which is why I didn't include it. 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: lack of recent documents
On 17 March 2012 11:48, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 17/03/12 03:52, Sharon Kimble a écrit : Hi Sharon, I've just installed LibreOffice 3.5.1 and autospellcheck is working well, but I have no documents appearing in the 'Recent documents' box. Does anyone know how to get it working please? 1) Shut down LO completely (including any quickstarter if your are on Windows). 2) Rename your LO user configuration profile directory to something else, then restart LO to see if that solves the problem. Alex I tried this and it made no difference, still no 'recent documents' :( Take care Sharon. -- A taste of linux = http://www.sharons.org.uk/taste/index.html efever = http://www.efever.blogspot.com/ efever = http://sharon04.livejournal.com/ Debian 6,0.4, Gnome 1:2.30+7, LibreOffice 3.5.1 Registered Linux user 334501 -- 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] [Feature request] Allow typing when saving file
Hi, Don: I do belive a newer computer would minimize the saving time, but I have no money to buy a new one. I think allow typing while saving files would be a good feature for many old computer users. Such feature will save our working time when using Libreoffice on old machines, we don't need to buy new computers for the long file saving time. Thank you :) 2012/3/18 Don Myers donmy...@myersfarm.com Hi, I think that Tom was thinking he made a double post, not you. Do you know anyone who has a newer computer with a faster processor and more memory that you could run your files on to see if there is any difference between theirs and yours? Then we would know if it is a hardware issue with the computer, or a LibreOffice issue. Don -- 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] Urgent Base problem
Hi :) Yes, apparently HSqlDb is a really decent light and fast back-end http://hsqldb.org/ It's just the tweaks in the embedded version that make it go wonky. Of course it is written in Java so it might be worth avoiding on that basis. Regards from Tom :) --- On Sun, 18/3/12, Mark Stanton m...@vowleyfarm.co.uk wrote: From: Mark Stanton m...@vowleyfarm.co.uk Subject: Re: [libreoffice-users] Urgent Base problem To: users@global.libreoffice.org Date: Sunday, 18 March, 2012, 7:56 I think the point Mark was making was to switch away from using the embedded back-end to pretty much any external one. Which is what you often suggest too. Yes indeed. Can HSQLDB be used as an external engine? I thought not, which is why I didn't include it. 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 -- 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] Urgent Base problem (stability in long term use)
The problem with using dbf files is that you no longer have a relational database. Because Base is then dealing with files not a database engine it will only use one file at a time and will not relate them. 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] More mailmerge woes
Herr Säger, you may have hit the nail on the head, thank you. Yes, even though my query was correctly displayed as the driving data for the document (of course, since I'm using mailmerge, this is a Writer document that has the problem), when I went through the Change datasource dialogue/wizard, it showed a different database as the source, weird! And that is a *fabulous* feature in Writer, just dragging the column onto the page, fabulous. However, there was still one problem remaining which I have fixed by changing the field name Company to Co. Whether I allowed MySQL to produce the fieldname or explicitly speciifed it with an alias, Base would insert the field as company (lowercase first letter), and it would therefore display the fieldname not the field contents, because the query wasn't producing a field with that name! Company is a reserved word somehow? Surely not! Many thanx 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
[libreoffice-users] Re: Urgent Base problem
Am 18.03.2012 08:56, Mark Stanton wrote: I think the point Mark was making was to switch away from using the embedded back-end to pretty much any external one. Which is what you often suggest too. Yes indeed. Can HSQLDB be used as an external engine? I thought not, which is why I didn't include it. Mark Stanton One small step for mankind... http://hsqldb.org Download the latest version. Put it somewhere in your libraries (no installation required). Point your office Java to the extracted hsqldb.jar. Extract ./database/ from your embedded database somewhere to your files. Rename your database files with a common dbname. prefix. Connect a new Base document using JDBC with an URL like this one (refer to the downloaded documentation in your libs): jdbc: hsqldb:file:/home/andreas/hsqldb-2.2.5/databases/Praxis/hsqldbdata/db0/chargen;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false Copy over the queries, forms and reports from your embedded thing. You get the latest version of a full featured HSQLDB without restrictions, many more functions, the access control and safety you would expect from a database application. You can write a configuration file to run a server for concurrent access. Drawbacks: - Embedded HSQL requires another Java config. I use OOo for embedded and LibO 3.3.4 for normal access. - Base can not handle user defined row filters with HSQLDB2. I use my own power filters anyway. -- 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] [Feature request] Allow typing when saving file
Hi :) No, i had already posted an answer to this thread. Then i read another post which made me think of something else and then a little while later i thought of another thing. So i made a real mess of posting too many times. I have my cache set at 20Mb but i have also raised the Memory per object higher than any of the pictures or graphics in my documents. I sometimes use Gimp to reduce the byte-wise size without losing too much quality. Often photos from a camera are such a high resolution that they would look good on a roadside bill-board. Scaling them down to about twice the size they are going to be in the document means they still look good http://www.gimp.org/tutorials/Lite_Quickies/ http://kerryshamblin.com/index.php?page=tutorial-web-images-gimp http://www.ahotw.com/2008/08/09/gimp-image-cropping-for-web/ This link does a lot more than i normally have time to http://www.geekazine.com/guests/basic-gimp-preparing-pictures-for-the-web I only usually get photos down to a couple of hundred kilobytes but logos and stuff are usually fairly easy to get down to maybe 20Kb. Images occasionally vanish from documents so it's a good idea to keep a back-up of them outside the document. If you save in Odt format then you can find all the images by opening the document as an archive. (Create a copy of the file. Rename the file-ending from .odt to .zip and then double-click on the file's icon). So it's easy to get a folder full of the images you use before they run into trouble. It's not clear what operating system you are using. Xp or a GnuLinux such as Ubuntu? Regards from Tom :) --- On Sun, 18/3/12, minhsien0330 minhsien0...@gmail.com wrote: From: minhsien0330 minhsien0...@gmail.com Subject: Re: [libreoffice-users] [Feature request] Allow typing when saving file To: users@global.libreoffice.org Date: Sunday, 18 March, 2012, 0:45 Hi~Tom and Daniel: I set the cache to 256MB (Tools - Options - Memory), but the saving time did not change, and Writer still did not accepting any keyboard input during saving the file. Maybe my machine is really too old? (CPU type : Genuine Intel(R) CPU T2300 @ 1.66GHz with 2G DDR2-ram) I am ready to post a feature request. But Tom said: Ouch, sorry for the double-post! Does Tom mean I have already posted the request? Thank you~ :) 2012/3/18 Tom Davies tomdavie...@yahoo.co.uk Hi :) Ouch, sorry for the double-post! -- 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] SOLVED- lack of recent documents
I renamed the /libreoffice folder as already suggested, which made no difference except when I restarted libreoffice all my setup was still the same. But when checking my paths I noticed that several items had config files under /.config, so I looked in there and found a ./config/libreoffice folder. So I renamed that too and restarted libreoffice, and then had to setup my paths again, and on checking, my 'recent documents' menu entry works. Brilliant! Thanks to all those who responded, both my showstoppers have now been sorted out, lovely jubbly! Sharon. -- A taste of linux = http://www.sharons.org.uk/taste/index.html efever = http://www.efever.blogspot.com/ efever = http://sharon04.livejournal.com/ Debian 6,0.4, Gnome 1:2.30+7, LibreOffice 3.5.0 Registered Linux user 334501 -- 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] [Feature request] Allow typing when saving file
Hi, You are most welcome. I am a farmer among other things. A 50 horsepower tractor will take twice as long to do the same amount of work as a 100 horsepower tractor. A computer processor only has so many cycles in a given time frame. If another processor had twice as many cycles, things should go twice as fast in theory. It would be interesting to know how your file would work on a newer machine. Don Hi, Don: I do belive a newer computer would minimize the saving time, but I have no money to buy a new one. I think allow typing while saving files would be a good feature for many old computer users. Such feature will save our working time when using Libreoffice on old machines, we don't need to buy new computers for the long file saving time. Thank you :) 2012/3/18 Don Myersdonmy...@myersfarm.com Hi, I think that Tom was thinking he made a double post, not you. Do you know anyone who has a newer computer with a faster processor and more memory that you could run your files on to see if there is any difference between theirs and yours? Then we would know if it is a hardware issue with the computer, or a LibreOffice issue. Don -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Phone: 814-237-6543 Fax: 814-237-6502 Visit the Farm and Rural Property Division Website at www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_ _View Don's farm website: www.myersfarm.com http://www.myersfarm.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
[libreoffice-users] Re: Urgent Base problem
Some additions for anybody who wants to follow my receipt: Am 18.03.2012 10:25, Andreas Säger wrote: Extract ./database/ from your embedded database somewhere to your files. Rename your database files with a common dbname. prefix. The dbname in the below URL is chargen so I renamed the files data, properties and script to chargen.data, chargen.properties and chargen.script Connect a new Base document using JDBC with an URL like this one (refer to the downloaded documentation in your libs): jdbc: hsqldb:file:/home/andreas/hsqldb-2.2.5/databases/Praxis/hsqldbdata/db0/chargen;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false where chargen is the database name and the semicolon separated options improve the look and interoperability in Base. -- 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 and HSQLDB 2
Am 18.03.2012 01:35, RustyRiley wrote: thanks, after reading the commentr about the bastard thought I'd go ahead aand install HSQLDB, especially after reading it was small, fast and siuitable for thr home user, but even this tutorial is too advanced for me -- like how do I install it? not familiar with Java program installation, so where do I read about that? thanks again, Russell J. Wilson Dunedin, New Zealand Read today's postings of mine in reply to Marc Stanton (Re: Urgent Base problem) -- 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] fyi Fw: [MariaDB Announce] MariaDB 5.5.21 beta now available
On Sat, Mar 17, 2012 at 5:27 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) MariaDb is to MySql as LibreOffice is to OpenOffice except that MySql is still owned by Oracle. Regards from Tom :) Not quite. LibreOffice is going in the direction of being completely independent of OpenOffice, while MariaDb remains parasitic on MySQL, as shown by the recent incorporation of MySQL 5.5 into MariaDb. Also, MariaDb is available on a much more limited spectrum of target servers (e.g., no OS-X binaries). snip -- 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: AutoFilter Change
Tom wrote Hi :) I don't think LO's Calc is aiming to look exactly like Excel but it does aim to remain fairly similar so that people find it easy to migrate to LO. I think it's a lot more configurable than Excel especially with the Add-ons/Extensions. Regards from Tom :) You may never used Excel. So you don't know about the thousands of Excel add-ons made by professional programmers. That's OK. But sometimes _I think_ you don't use LibreOffice neither. LibreOffice added some dysfunctional bullshit that makes Calc look like MS Excel. The marching ants border around a copied cell selection together with the related behaviour of the Enter key is the most prominent example why I prefer OOo Calc over LibO Calc. The switched meaning of Backspace and Delete is the second example, third example is cell back colour that superimpose some visual aid (view grid) but not the other visual aid (snap points). -- View this message in context: http://nabble.documentfoundation.org/AutoFilter-Change-tp3832199p3836745.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] fyi Fw: [MariaDB Announce] MariaDB 5.5.21 beta now available
Not quite. LibreOffice is going in the direction of being completely independent of OpenOffice, while MariaDb remains parasitic on MySQL, Really? Maria is a fork of MySQL, and I thought the 5.5-alike was their first real release, and they've had a second since then. No? Regards 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] fyi Fw: [MariaDB Announce] MariaDB 5.5.21 beta now available
Hi :) It seems that MariaDb are carefully remaining a drop-in replacement for MySql. Obviously there are some heated feelings in the 2 communities. Regards from Tom :) --- On Sun, 18/3/12, Mark Stanton m...@vowleyfarm.co.uk wrote: From: Mark Stanton m...@vowleyfarm.co.uk Subject: Re: [libreoffice-users] fyi Fw: [MariaDB Announce] MariaDB 5.5.21 beta now available To: users@global.libreoffice.org Date: Sunday, 18 March, 2012, 16:58 Not quite. LibreOffice is going in the direction of being completely independent of OpenOffice, while MariaDb remains parasitic on MySQL, Really? Maria is a fork of MySQL, and I thought the 5.5-alike was their first real release, and they've had a second since then. No? Regards 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 -- 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] Print range not always loading
Hi :) I am sorry that no-one seems to be able to help you with the print range issue. It might not help but Chapter 11 of the Getting Started guide covers some aspects of printing https://wiki.documentfoundation.org/Documentation/Publications#Getting_Started_with_LibreOffice I was wondering if you set the print range and then don't save before closing down. It might not flag up as a change so the save symbol might stay greyed-out. Regards from Tom :) --- On Thu, 15/3/12, Ron Gregor rgre...@wcnjcd.com wrote: From: Ron Gregor rgre...@wcnjcd.com Subject: Re: [libreoffice-users] Print range not always loading To: users@global.libreoffice.org Date: Thursday, 15 March, 2012, 17:12 I just tried to type one of our spreadsheets into a new ods file. I entered the formulas and text exactly as the original and did cell borders. I didn't change font settings (size, bold...). I enter hard values for the 3 cells we use for external links. I set the print range and then closed an opened the file a few times and the print range loaded every time. Once I added one of the links that pull a number from another ods file save and close. When opened the print range is gone. I created a new ods file and put the same 3 links in it and typed random text. This file so far loads the print range every time. It seems I have some special combination that blocks the print range from loading sometimes. Thanks, Ron Gregor -- 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: Indexing a text by concordance file failes
Hi :) As far as java goes LibreOffice 3.5.x prefers java 1.7 which hasn't been released yet. So you might need to upgrade your version of java from http://www.java.com Your English is fine but there might be a list that does use your preferred language. Here's the page for de lists http://de.libreoffice.org/hilfe-kontakt/mailing-listen/ Regards from Tom :) --- On Sun, 18/3/12, u-ri ur...@arcor.de wrote: From: u-ri ur...@arcor.de Subject: [libreoffice-users] Re: Indexing a text by concordance file failes To: users@global.libreoffice.org Date: Sunday, 18 March, 2012, 0:41 Hi Tom, thank you very much for the fast response and the hints. Using the concordance file was necessary, because the index is quite big and has to be changed several times (prepress, for publishing etc., 300p text and two indexes for persons and items). Worked with little errors in OO 3.1., so I hoped that it would work even better in LO, which I use (since fork) in my daily work. But now I can't index by concordance file at all. Even a simple test-text and a few entries results in a headline and that's it. Until now I thought indexing by external file would be a standard procedure (as a part of the online-help). New installation of LO didn't change anything. Maybe use of concordance-file relies on some feature, I don't know (a special java-environment e.g.?) Best regards u-ri (Sorry about my poor english. I'm not a native speaker at all...) Win7 64Bit LibreOffice 3.5.1.2 /Writer -- View this message in context: http://nabble.documentfoundation.org/Indexing-a-text-by-concordance-file-failes-tp3833634p3835571.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
[libreoffice-users] Re: Address Books
On 03/16/2012 03:00 AM, Nino Novak wrote: On Thursday 15 March 2012, 21:39:51 Stephanie Dutcher wrote: I was basically just looking for something I could have on my computer and export it as an excel file or pdf when I needed to share it, but having something that was online or able to be shaared through a network isn't a bad idea. Everything I've seen that is more like an address book app is compatible with Mac and not with Windows. Do you have any suggestions of what to use, or is that not really your thing? File|New Database|Use Wizard to Create Table|Personal|Addresses| select the fields you wish to include. Also look at the other table templates provided (in both Buiness and Personal); maybe 'Business|Contacts' There must be some address book apps also in Windows (did you try your mail client's address book? E.g. Thunderbird-Mail includes a nice address book - but sorry, I'm not a Windows user). ... -- 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] fyi Fw: [MariaDB Announce] MariaDB 5.5.21 beta now available
Obviously there are some heated feelings in the 2 communities. Obviously because of Jomali's message, or is there something else you're aware of? 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
[libreoffice-users] Conditions
For my mailmerge I want to set up a conditional paragraph conditional on more than one thing. I've got a database field Country, and if this is blank or contains Scotland I want the paragraph hidden. I *think* the condition ought to be NOT Country OR Country EQ 'Scotland' but it doesn't work. I thought blanks at the end of the country field might cause a problem so I tried NOT Country OR 'Scotland' EQ Country but that didn't work either. The help states that the fields ought to be written as database.table.field but that doesn't make any difference either and the single condition NOT Country does work, although it's insufficient for my needs. Have I got my logic entirely wrong, or can the condition expression not have more than one part? 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
[libreoffice-users] Re: Indexing a text by concordance file failes
[Solved] Using Concordance for Indexing http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=47581hilit=concordance -- View this message in context: http://nabble.documentfoundation.org/Indexing-a-text-by-concordance-file-failes-tp3833634p3837173.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] Conditions
Le 18/03/2012 20:53, Mark Stanton a écrit : For my mailmerge I want to set up a conditional paragraph conditional on more than one thing. I've got a database field Country, and if this is blank or contains Scotland I want the paragraph hidden. I *think* the condition ought to be NOT Country OR Country EQ 'Scotland' but it doesn't work. I thought blanks at the end of the country field might cause a problem so I tried NOT Country OR 'Scotland' EQ Country but that didn't work either. The help states that the fields ought to be written as database.table.field but that doesn't make any difference either and the single condition NOT Country does work, although it's insufficient for my needs. Have I got my logic entirely wrong, or can the condition expression not have more than one part? You need double quotes and I guess parenthesis can help as weel, that is: (NOT Country==) OR (Country==Scotland) equivalent to (Country) AND (CountryScotland) -- Jean-Francois Nifenecker, Bordeaux -- 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] Conditions
--On Sunday, March 18, 2012 22:11 +0100 Jean-Francois Nifenecker jean-francois.nifenec...@laposte.net wrote: You need double quotes and I guess parenthesis can help as weel, that is: (NOT Country==) OR (Country==Scotland) equivalent to (Country) AND (CountryScotland) These two are not logically equivalent. I think the second one is what the op wanted. -- Jim -- 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] Conditions
Le 18/03/2012 21:17, James E. Lang a écrit : These two are not logically equivalent. I think the second one is what the op wanted. ooops... you're right. I started with the op proposition without any further thought. My bad. -- Jean-Francois Nifenecker, Bordeaux -- 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] Conditions
On Sun, 2012-03-18 at 19:53 +, Mark Stanton wrote: For my mailmerge I want to set up a conditional paragraph conditional on more than one thing. I've got a database field Country, and if this is blank or contains Scotland I want the paragraph hidden. I *think* the condition ought to be NOT Country OR Country EQ 'Scotland' but it doesn't work. I thought blanks at the end of the country field might cause a problem so I tried NOT Country OR 'Scotland' EQ Country but that didn't work either. The help states that the fields ought to be written as database.table.field but that doesn't make any difference either and the single condition NOT Country does work, although it's insufficient for my needs. Have I got my logic entirely wrong, or can the condition expression not have more than one part? Mark Stanton One small step for mankind... Might be in the logic. You wrote if this is blank or contains Scotland I want the paragraph hidden. I would write this as If (db.table.Country IS NULL) OR (db.table.Country='Scotland') then the paragraph is hidden. Then again in LO queries, this is written as (db.table.Country IS EMPTY) OR (db.table.Country='Scotland') See if either of these work. --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] fyi Fw: [MariaDB Announce] MariaDB 5.5.21 beta now available
Hi :) I guess i just can't imagine a split being completely amicable. Even within a community things are seldom completely amicable. When a murder happens who do the police question after family, loved ones and close friends? Regards from Tom :) --- On Sun, 18/3/12, Mark Stanton m...@vowleyfarm.co.uk wrote: From: Mark Stanton m...@vowleyfarm.co.uk Subject: Re: [libreoffice-users] fyi Fw: [MariaDB Announce] MariaDB 5.5.21 beta now available To: users@global.libreoffice.org Date: Sunday, 18 March, 2012, 19:53 Obviously there are some heated feelings in the 2 communities. Obviously because of Jomali's message, or is there something else you're aware of? 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 -- 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: Indexing a text by concordance file failes
Hi Tom, hi Andreas, I'm really thankful for your efforts and for being so lenient. But unfortunately the given solution doesn't match my problem. The solution-thread is about OpenOffice and the guy in the OO-forum has successfully got (!) an index using a concordance file and wants to modify it using a 2nd different file. (In fact I found this OO-Forum-Thread before I decided to start this LO-Thread.) Maybe I couldn't make my point clear enough: In LO (!) I can't insert an index by concordance file at all. All I get is a headline. It doesn't work in my environment and in LO 3.5.x. using the newest documentation (Thank you, Tom!). I have no problem building an index by concordance file in my old OO 3.x. Of course I can (and I do) open the LO-text after finishing as a workaround in OO and insert the index afterwards, but I'm quite sure that's not the way it's intended me to do. Please, did anybody succeed to use this feature in LO 3.5.1.2 running Win7 64Bit? Or should I consider submitting a (potential-) bugreport? Sorry for the inconveniences and best regards u-ri -- View this message in context: http://nabble.documentfoundation.org/Indexing-a-text-by-concordance-file-failes-tp3833634p3837915.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] Re: Urgent Base problem
THANKS for that, I must admit I've gotten spoilt by lots of years on Windows now, expect one install file to set up a program, and never having to use a command line -- even for Windows the program HSQLDB still encourages people to use command lines for some things Mind you, I don't mind learning again, if one is learning to do things more reliably and or powerfully Rusty in more ways than one I'm rusty ;-) - Original Message - From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Cc: Sent: Sunday, 18 March 2012 10:25 PM Subject: [libreoffice-users] Re: Urgent Base problem Am 18.03.2012 08:56, Mark Stanton wrote: I think the point Mark was making was to switch away from using the embedded back-end to pretty much any external one. Which is what you often suggest too. Yes indeed. Can HSQLDB be used as an external engine? I thought not, which is why I didn't include it. Mark Stanton One small step for mankind... http://hsqldb.org Download the latest version. Put it somewhere in your libraries (no installation required). Point your office Java to the extracted hsqldb.jar. Extract ./database/ from your embedded database somewhere to your files. Rename your database files with a common dbname. prefix. Connect a new Base document using JDBC with an URL like this one (refer to the downloaded documentation in your libs): jdbc: hsqldb:file:/home/andreas/hsqldb-2.2.5/databases/Praxis/hsqldbdata/db0/chargen;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false Copy over the queries, forms and reports from your embedded thing. You get the latest version of a full featured HSQLDB without restrictions, many more functions, the access control and safety you would expect from a database application. You can write a configuration file to run a server for concurrent access. Drawbacks: - Embedded HSQL requires another Java config. I use OOo for embedded and LibO 3.3.4 for normal access. - Base can not handle user defined row filters with HSQLDB2. I use my own power filters anyway. -- 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