Re: [libreoffice-users] Page Numbers in TOC
Sorry - My mistake. Thanks Piet!! On 08/26/2017 09:27 AM, Piet van Oostrum wrote: Ian Whitfield <whitfi...@blinkmail.co.za> writes: Hi All I have been watching this thread and hoping a problem I have with this might be mentioned!! I produce a monthly "Journal" and also make use of the TOC to list the contents. It works fairly well (with a bit of editing) but the one problem I have is as follows. The first two pages of the SLA document are the Front Cover and the Inside of the Front Cover so my actual content starts on the third Page. However Scribus' TOC works on the actual Page Count so all the listed pages are two pages out and I need to edit each line of the TOC to correct this. Is there any way for the TOC to be set to do this automatically? Are you talking about Scribus or LibreOffice (LO)? This list is about LO. If you mean LO, then you should use a different page style for the first two pages and reset the page count on the third one. -- To unsubscribe e-mail to: users+unsubscr...@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] Page Numbers in TOC
Hi All I have been watching this thread and hoping a problem I have with this might be mentioned!! I produce a monthly "Journal" and also make use of the TOC to list the contents. It works fairly well (with a bit of editing) but the one problem I have is as follows. The first two pages of the SLA document are the Front Cover and the Inside of the Front Cover so my actual content starts on the third Page. However Scribus' TOC works on the actual Page Count so all the listed pages are two pages out and I need to edit each line of the TOC to correct this. Is there any way for the TOC to be set to do this automatically? Thanks for any and all suggestions. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Pop Up Notifications
If you use Thunderbird for your eMail add the extension "ReminderFox" - It does this kind of thing perfectly!! On 04/24/2017 07:13 PM, charles meyer wrote: My esteemed listmates, I’m wondering if in Libre Writer or Calc a user can set up a sound or pop-up notification of an approaching deadline which sounds or pop-sup when you power on the PC or while Windows is open even though Word or Excel is *not* open? Ex. Due date for auto tire rotation – You don’t have Libre Writer or Calc open but Windows 7 is open. A sound (e.g. .mp3) launches or a box pops-up alerting you that in one week you need to rotate your tires. This is just an example so please don’t explore the issue of rotating tires! :) I was reading/watching these Excel suggestions (below) but they don’t seem to answer my questions about alerting sounds or pops-ups if the program is not open. https://excel.tips.net/T003179_Alerts_About_Approaching_Due_Dates.html https://www.youtube.com/watch?v=BiDfI4-kngw Has anyone set these kinds of notification? Thanks so much. Charles. -- -- To unsubscribe e-mail to: users+unsubscr...@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] Setting Defaults [SOLVED]
*Thanks Cley* That did it for me - It was not the 'Local' or the 'User Profile' that was out - but thanks to others for the suggestions!! It was just the convoluted (IMHO) way that LO works to achieve this. I my World I would suggest that a better way to do this is to have a "Default" set of settings, (that you change in Preferences), and these are how the Program _always_ starts up. Then if you need special Templates you select this after the Program is started and they over ride the Default. Just my Penny/Cent's worth!! But at least I've solved this problem that has bugged me for a long time!! So thanks to all IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Setting Defaults
Hi All I have a MAJOR problem setting some defaults in LibreOffice!! The first one is the Default Font - I have battled with this for some time now and discussed it on the Forum and tried ALL the suggestions but can not get rid of 'Liberation Serif' as the default!! This should be a quick change in the 'Tools > Options' Menu but it is not!! Why is this so difficult and how do you do it??!! Second in the last few days on a new fresh install of LibreOffice' on another machine I find the Page Size is set to 'Letter" an American standard not used by the rest of the World!! How do you change this to 'A4"?? Again it should be a basic change in the same 'Options' Menu like most other Programs have. In both cases I'm working with LO ver 5.3.0.3 both running PClinuxOS 64-bit. Any help would be appreciated. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Default font in LO calc
*Thank you, Thank you Piet and Brian* That did it - Magic!! Just what I wanted. You have made my frequent use of Calc so much better!! I still think it is a convoluted way of doing things but I'm very happy to have the answer at last. With much appreciation!! Ian Pretoria RSA On 02/21/2017 10:08 AM, Piet van Oostrum wrote: That's not enough. You also have to designate it as the default template. The name doesn't do that. Go to File > Template > Manage Templates, select the template and set it as the default template. See my posting. -- To unsubscribe e-mail to: users+unsubscr...@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] Default font in LO calc
*Thanks Everyone* I seem to have stirred-up a real Hornets Nest here - but to me it just shows how badly this part of LO is!!! It's a GREAT program except for this problem and of course the orphan child Base!! Anyway - still no luck here - I tried the Side-Bar method first of all but my version has no such option as Cell Styles - so no joy there!! Next I tried starting a new Spreadsheet, changing to the Font and size I want, (which is what I've been doing for a couple of years or so), and then saving this as a Template with the name 'Default'. I then close down the program and re-start it and it comes up with Liberation Sans 10 still *GRR!!!* This should be one change in the Options Menu - "Set Default Font and Size". Why all these hoops to jump through! It's no wonder some people leave LO for other programs!! But thank you all for trying - appreciated. (back to the repetitive manual method I guess!) IanW Pretoria RSA. -- To unsubscribe e-mail to: users+unsubscr...@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] Default font in LO calc
Thanks All But still no joy!! Why does this have to be so difficult!!?? None of the ideas about using the Side-Bar do anything that makes any sense. So I thought I would try Paul's idea and try and edit the Default Template but I can find no reference in the Drop-Down options in the Menu Bar for Templates or Edit Templates. So where do you find this and edit it?? This should be as easy to do as it is in Scribus!!! Why make things so difficult?? Thanks all On 02/20/2017 06:27 PM, Piet van Oostrum wrote: Ian Whitfield wrote: > *Thanks Bruce* > > BUT that does not work!! > > Top Right Icon is 'Properties' not 'Styles and Formatting' and it is > showing the Font and Size I want. > > But when I select 'New Spreadsheet' the "default" Liberation Sans 10 > still comes up!! > > I don't want or need a Template I just want the Font and size that I > selected to be the Default for all new Spreadsheets!! > If you want to change the default font, and setting the default template is the way to do it, why would you not want that? -- -- To unsubscribe e-mail to: users+unsubscr...@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] Default font in LO calc
*Thanks Bruce* BUT that does not work!! Top Right Icon is 'Properties' not 'Styles and Formatting' and it is showing the Font and Size I want. But when I select 'New Spreadsheet' the "default" Liberation Sans 10 still comes up!! I don't want or need a Template I just want the Font and size that I selected to be the Default for all new Spreadsheets!! IanW Pretoria RSA On 02/20/2017 03:22 PM, Bruce Hohl wrote: View > Sidebar Use top right icon to switch to "Styles and Formatting Right click "Default" and select "Modify" Under the Font tab select your desired font. You might want to save this as a template and use as your default template. On Mon, Feb 20, 2017 at 7:52 AM, Ian Whitfield <whitfi...@telkomsa.net> wrote: *Hi All* _PLEASE_ can someone tell me how to change the *&%$# Default Font in Calc!! I have tried many times to do this, Googled lots of suggestions but NOTHING WORKS!! And there are many different sets of instruction on how to do this. It is one of the most frustrating things in LO Calc and there has to be a basic simple way to do this - all I need is for someone to teach me how!! I'm currently using LO ver 5.3.0.3 on PClinusOS 64-bit. Thanks a lot IanW Pretoris RSA -- -- To unsubscribe e-mail to: users+unsubscr...@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] Default font in LO calc
*Hi All* _PLEASE_ can someone tell me how to change the *&%$# Default Font in Calc!! I have tried many times to do this, Googled lots of suggestions but NOTHING WORKS!! And there are many different sets of instruction on how to do this. It is one of the most frustrating things in LO Calc and there has to be a basic simple way to do this - all I need is for someone to teach me how!! I'm currently using LO ver 5.3.0.3 on PClinusOS 64-bit. Thanks a lot IanW Pretoris RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Help with LO Forms
Thanks Guys - Appreciated!! But I'm confused. The Handbook says Calc can be used as the datasource for a Form in Writer. But even Alexander's method still gives me no option to select the Registered Spreadsheet (The options box remains empty)!! The other replies tell me Calc can _NOT_ do this (But the Handbook says it can!!??) Everyone else wants me to use Base but I'm NOT interested in this at all as I battled with it for 7 years and could never get a stable set-up. It crashed frequently and usually took all the data with it or 'gabbled' the data - so you spend more time with back ups and patching damaged data records. I can not let the end user have such an unstable program to work with. I hoped the Calc/Writer Form would prove more reliable. So if this can not work I'll have to move to Kexi which is rock solid, With best regards IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Help with LO Forms
*Hi All* I need some help with Forms for LO. I have a Spreadsheet of Data and I have prepared a Form in Writer to display and edit this information. As per "Getting Started with LO", Chapter 15 I select - New - Database, Connect to existing DB, select the Spreadsheet and Register it I then go to the Form in Writer and select Properties of the Fields, select Data and pull down the Data Source options BUT it is empty with nothing to select!! What am I missing or doing wrong.?? I also need to know how to move between records and how to save any new Records added in the Form and how to save them. I can't find any info on this. My OpSys is PClinuxOS 64-bit and my LO is ver 5.3.0.3 Thanks for any help IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: Compatibility of LO Base with Access databases
*Hi all* *Re: The LO Base discussion* - just my "Penny's Worth"!!! After a 5+ years effort to use LO Base I have given up completely!! It is *NOT* usable at all in it's "out of the box" set-up, ie with the HSQL engine. It is totally unstable, crashes frequently AND - *MORE IMPORTANT* - trashes all you data when it goes down!!! This seems to be something to do with the compressing that the program does as you exit the program. The only way I got any (sort of results) was by using MySQL as the backend but it took a couple of months to get it working and after a few months even that crashed on me. I recently had to re-build my computer after a hardware failure and my OpSys upgraded to 64bit and since then I can not even get the MySQL linking in LO Base to even start!! So if you are happy to keep lots and lots of backups, and spend lots and lots of time re-building everything at almost monthly intervals - and by re-building I mean the Database Tables, redesign all your Forms and set-up all your Queries and Reports from scratch - then go with it, otherwise give it a miss. I have searched for a suitable replacement. I run Linux here, and have looked at many programs. In desperation I was keeping things going using LO Calc and this is not easy. The rest of LO is fine and I use it a lot but base is the (VERY) weak link in the chain. This not only my opinion - if you dig around you will find many reports of this. Early this month I gave *Kexi* a second try and I'm finding it very workable. It is still a bit "young" but does everything I want for my Database and I'm very comfortable with it. It is "All-in-one" using SQLite as the engine and the only major problem I have come across is the program crashing during Form design but frequent (say every 5min saves) seems to get round this. Doing actual work with the finished set-up has so far proved Rock Solid. It's worth a look at and stay with it long enough to learn its rather different layout and way of doing thins!! Have fun - I am and very happy to be away from LO Base. All the best IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base - Dropdown boxes
Hi all I'm trying to use LO Base - linked to a Spreadsheet and so far all is going well. However I don't seem to be able to get Dropdown Boxes to work. On my 'User Form' they are greyed out and do not react when clicked. I have set them to be Dropdown, entered the list of options and set the display line number. Any ideas please?? They worked with HSQLDB but I've had too many crashes and lost data with that system so am trying a Spreadsheet source instead. Do they work with this system?? My OpSys is PClinuxOS and LO is version 5.1.4.2. Thanks a lot IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: Calc as a Flat File Database
Hi Alexander On 03/17/2016 05:59 PM, Alexander Thurgood wrote: So Alexander has told me how to save my Form (that helps a lot) and I >decided to get back into Base as it seems to be the only way to go for >me. But MySQL is giving me up-hill. It does not seem to want to save an >empty Table for me to import my CSV into and gives me this error ... Again, I don't understand why you are attempting to use LO and a CSV file to import your data into your mysql database. I have managed - after a 2 day battle - to get all my CSV data back into MySQL as a Table. I needed to do this as that was the only source of my original data. I have also successfully linked Base to this Table. And can view it all in Base. But I now have the problem of bringing in the Form you told me how to save. I have it as an ODT file but can not find a way of coping it into Base!! Can you assist me with this please?? Thanks a lot. -- To unsubscribe e-mail to: users+unsubscr...@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: Calc as a Flat File Database
Hi Alex On 03/10/2016 01:11 PM, Alex Thurgood wrote: Why not separate out your forms from the ODB file if you are concerned about the stability of the ODB file itself ? It is perfectly possible, you can still link to a mysql db and you won't have the issues of screwing up your ODB just because the power goes off, or your network goes down, or some other life-event that seems to befall computer users on a daily basis. I wrote to you directly but it seems you don't like direct contact this way - sorry about that. I have sort off given-up on trying to find an alternative to Base. Kexi is too "young" and still has many problems, Glom is not available on my OpSys, (and seems very difficult to get working on Linux in any case), there seems to be no GUI Front-end to MySQL that does what I need so I'm now looking at your idea as mentioned above. However I need some help with this please. I've looked inside an ODB file and it seems very complicated so wonder if you can assist with details of which files to save and move to preserve my Forms, (and Queries??). I would greatly appreciate any assistance with this - thanks IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc as a Flat File Database
Thanks Dan and Alan I know about the Base > Calc link but I have been using Base since about 2010 and had many, many crashes where in most cases the crash takes out the data as well and you need to spend hours and hours re-building the Database and re-designing your Forms etc. This has happened repeatedly with the embedded engine and also with the MySQL engine. As far as I'm concerned there is basic unstability in Base itself which makes it unusable on a day-to-day basis!! This was why I was wanting to try another route. I tried Kexi but it is still to early in its development to be reliable. I wanted to try Glom but it is unavailable on my OpSys (PClinuxOS). So I was hoping to try a simpler option of Calc plus a Form. Thanks for pointing out to me the 'Form' option under Data - I had not noticed that. Unfortunately it is not very useable for me which is a great pity as this would be the perfect answer if it was. Thanks for the pointers - my search continues.. Any suggestions of a reliable Flat File Database would be of interest to me. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc as a Flat File Database
Hi All I was thinking the other day about using Calc as a Flat File Database - ie with no relationships. Many users make use of a Spreadsheet as a kind of Database but the problem is viewing the data. So I was wondering if there is and Add-On or Extension available to give you a "Form" to overlay the Spreadsheet so that you can view the data one row at a time?? Or if not would it be possible to achieve this using Macros?? I would be most interested in any suggestions or input. Thanks IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LibreOffice Base and MySQL
Hi All I have been trying to import a CSV file from Calc into MySQL to run with Base for over a week now and can not believe this is so difficult to do so I'm hoping some other Base users might have cracked this one!! My OpSys is PClinuxOS - 32-bit and MySQL is ver 5.1.73. Everything is running on localhost. My CSV file is in Calc and has 2600 rows and 78 cols. I save it as a CSV file which is 717.8Kb in size. Field Names are in row 1. I have tried many times with phpMyAdmin with no luck and today I installed MySQL Workbench - also no luck. In all cases I get the error ... MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(10), `NULL` varchar(10), `NULL` varchar(10), `NULL` varchar(21), `NULL` ' at line 1 MyAdmin seems to stop after only 38 fields and the error does not show the field names in the error. Also it is not MY SQL syntax it is MyAdmin's syntax!! Workbench says - ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RecordID,Status,StatusGraphic,Title,PrefFirstName,FirstName,LastName,Maiden/Form' at line 1 Operation failed with exitcode 1. Can anyone help me out please. I'm NOT a Database expert just a user and must get this DB up and running again ASAP!! Many, many thanks IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Linking a Form to another table
Hi All I take from the lack of any replies to my post of a few days back that either anyone who can help out is still on Christmas Holidays or this just can not be done ?? Ianw Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Linking a Form to another table
Hi All I have another table of data that I would like to link to an existing Form. The Form was originally linked to Table "ABC" but I now want to link it to table "Name/DEF". Is this possible and how would I do this please?? Thanks for any help (I'm using PClinuxOS and LibreOffice 5.0.0.2 to a MySQL Database) Ianw Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: Lost connection to Database.
Thanks Alex Sorry have been away from the computer for some days due to work and other personal reasons!! I seem to be getting somewhere but I sit with the problem that the DB will not accept the old username and/or Password. Is there a way to reset this at all?? -- To unsubscribe e-mail to: users+unsubscr...@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: Lost connection to Database.
Up-date I have been busy with other things and just got back to this problem. I found that the link to the Class file was not working so corrected that and the whole set-up now works fine. But when I try to open the Database it opens the input Form and pops up an error - "The data content could not be loaded Can't find file: ./FS/Members.frm (errno:13)" But the Members form IS opening all right, and its actual path is root/var/lib/mysql/FS/Members.frm. But it is not being populate. Any thoughts?? IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: Lost connection to Database.
On 10/22/2015 03:31 PM, Alexander Thurgood wrote: Is the mysql server actually running ? mysqld is running, (start on boot) in Services. Is your JDK recognized by LO (Tools - Options - Advanced) ? YES- /usr/lib/jvm/java-1.8.0-sun-1.8.0.60/jre -- To unsubscribe e-mail to: users+unsubscr...@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: Lost connection to Database.
Thanks Alex and Dan. I had forgotten to do that - so have downloaded 5.1.37 and set it up in LO but I still get the same error. I notice also that when checking Services I have no htppd available to switch on!!?? Any other ideas please? Thanks a lot. -- To unsubscribe e-mail to: users+unsubscr...@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] Lost connection to Database.
Hi All Due to problems with Kernel updates I have rebuilt my system using the last ISO disk I had, (2014-12). I re-installed the ISO formatting the complete drive, updated the system via Synaptic to bring it up to date and restored all my backed-up data to /home. I then restored the MySQL folder under /var/lib that contains my Database. I then updated LO to the latest version = 5.0.2.2 But now when trying to connect to my database I get the error "The JDBC driver could not be loaded" mysqld is set in Services to run on Boot, Skip networking is commented out in /etc/my.cnf. Current driver in Base Options is set to - com.sun.star.comp.sdbc.JDBCDriver (with pooling enabled). Any suggestions please?? PCLOS 32-bit. KDE, Thanks IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: [OT] Operating Environment Survey
/On 26/07/2015 14:50, Erik Jan wrote:// / /To tell you the truth: I still use my slide rule, very easy and useful for calculations that need only to be about 95% accurate with the correct order of magnitude. I even once corrected errors in an Excel spreadsheet with the help of my log tables in 7 decimals from the year 1867. The author promised a Louis d'Or for each error in the tables! / In my life at work, (from 60s to early 70s), in Laboratories I used Slide Rules all the time!! I had the 'Standard' type as well as a Circular one but eventually got a Tubular Slide Rule. It was aprox 3 to 4 cm in Diameter and closed up was about 10cm Tall (long), but because of its spiral design was the equivalent to a Standard 55 Slide Rule so very much more accurate. In fact I still have two of these - the Standard one and the Tubular one!! (The Circular one has gone missing over the years.) In one job I had in Bulawayo, (Rhodesia), in the late 60s I had to go down to the factory floor in the late afternoon to look after the production so used to keep all my calculation work for this period. The Production Manager's Desk was elevated over the Production Floor and the African Workers thought that it was a kind of Calculating Microphone I was using that I spoke the calculations into and it gave me the answers!! The floor was very noisy so that could only see me working the Slide Rule and then writing down the answers!!! Only later on did we get the first 'Facit, hand operated Calculating Machine' - you had to work out the position of the decimal point yourself, it just gave you a string of numbers!! Later we got electric ones!!! I believe the mechanics of the original Facit Calculators was developed somewhere in Scandinavia and working it all out drove the Inventor crazy. Having opened one up at one time I can understand why!! Great times!!! I also remember later desperately trying to buy a Four Function Hand Calculator in Sanction Plagued Rhodesia for a ridicules price!! But later got a friend in America to get the first of several 'Texas Instruments' Calculators, (could never get the hang of Reverse Polish Notation as used by HP!!), and sending it to me!!! Hard now to believe all these steps in development isn't it And let's not forget about Visi Calc!! IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] [OT] Operating Environment Survey
_**_ *Hi All *After 25+ years in the Computer business I retired in the early 2000s. I had been involved with CP/M, DOS and Windows during this period and even did a Xenix Course at one time which I found interesting, (Unix was a propitiatory name in those days!!). I also played with Coral Linux, (who remembers that?? Rumored to actually MS Linux given to Coral to Test the Waters!!!) The first thing I did after I retired was get rid of Windows!! I started with Ubuntu but hated Gnome - so I tried Kubuntu. Better but I was still not happy so moved to Mint. Better still but something still missing. Then found PClinuxOS - tried it and have stayed there ever since. Magic flavour of Linux - can not recommend it enough!! I run a Desktop and an old Laptop both PCLOS. Converted my Partner a few years ago as well when her Windows crashed for the umpteenth time and she loves it too. We both run Specialist Groups on the Internet, produce publications etc etc and we are a totally Microsoft-Free Zone (except for Skype - which MS bought anyway!!) I have also helped a few others to convert and do so whenever the chance comes up. With the exception of a lot of games and specialist programs written only for Windows you can do everything the average person needs to do with Linux and it's better priced, more secure, faster etc etc and the Support Forums are awesome. I still have an HP/Compaq Tablet - TC 1100 - a great machine for its time and would love to get Linux on that but have had no luck. Would love a Linux Tablet!! Will NOT look at any Apple products and there is nothing worth doing on small Android screens except SMSs so I don't look there either. Linux is the way to go IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Linux alternative
I couldn't find a good OCR solution for linux either. Project for someone? Cheers Harvey I also battled to find a good OCR program for a couple of years on my Linux System (PClinuxOS)!! Then about two years or eighteen months back I came across the combination of YAGF with Tesseract. This combination works fantastically with basically just clean-up to do on almost any scanned document. I can recommend this to anyone who needs, or uses, OCR as a regular job, (as I do). IanW Pretoria RSA. -- To unsubscribe e-mail to: users+unsubscr...@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: Libre Office Base
I posted this 2 days back but don't see it coming up on the Form - Let's try again . Hi Gabriele On 16/07/2015 10:45, Gabriele Ponzo wrote: /It is, more or less, in the GUI: You just have to open the Form's properties dialog box and correct the already present query (or insert, not sure) with the suggested one. Just a row to write in a property. / Where is the Form's Properties Dialog Box?? Can't seem to find anything with this name! /Re-sizing Check Boxes/ /In this case You have to open the form in edit mode (just like for the previous point), click on the CheckBox and resize it./ This does not work - You can enlarge the box but this only creates a larger gray area round two sides of the Check Box which keeps it's original size!!?? Thanks for the help IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Libre Office Base
Hi All I'm running two copies of LO Base here - and old one using HSQL embedded and a new one using MySQL. Firstly I notice is that if I sort the DB the sort only holds for the duration of the session. Is it possible to make a sort order stick. ie - I sort into Lastname then First Name and would like that to remain fixed. Second on the new MySQL version the Tick Boxes come out very small. Is it possible to enlarge these at all? My version of LO is 4.4.0.3 on PClinuxOS. Thanks for any help. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: Where is Base?
Ditto!!! +1 It has cemented the decision I took last year to move to Base+MySQL - which works very well indeed!! IanW Pretoria RSA On 03/05/2015 04:08 PM, HBarr wrote: Just want to say this thread has been so helpful and enlightening, I have learned a lot about base, mysql and databases. Tom, thanks for all your input! Howard On 5 Mar 2015 21:29, Tom Davies tomc...@gmail.com wrote: Hi :) I have been told, off-list, that i am quite wrong about what i have been saying about Base. I'm not clear exactly which bits of what i have said are wrong. Almost all of what i said was things i had picked-up from experts on this mailing list or discussions elsewhere, rather than from my own direct experience or knowledge of the issues. It would be nice to know where i am wrong to help me be less wrong in the future! Also it would be good for such corrections to be in this thread if possible because it has been a really good thread with a lot of good feedback about different people's knowledge and experience. Finally if i have given people a wrong impression about Base then it would be nice to be able to fix that. Regards from Tom :) On 4 March 2015 at 16:40, Tom Davies tomc...@gmail.com wrote: Hi :) Yeh, in attempting to clarify i did add an extra confusion! Sorry! The HsqlDb version 1.8 is only a problem when using the internal version in Base. However Base doesn't give you much choice about what to use as the internal back-end. Just the heavily tweaked and broken version of 1.8. Regards from Tom :) On 4 March 2015 at 10:58, Andreas Säger ville...@t-online.de wrote: Am 04.03.2015 um 11:03 schrieb Tom Davies: Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the version used as the internal back-end in Base. The problem is _not_ a particular version of a particular database. If HSQL 1.8 works for you, even that version works as a rock stable, fast and reliable backend to your Base document. Heinrich demanded an _interface_ to handle the big irons. He was not talking about a particular version of some particular big iron. He did not tell us what is wrong with the current interface. From the view point of database developers, there are several missing features. From the view point of someone who wants to build a serial letter from his spreadsheet, Base is the big and dark mystery to be avoided entirely and the serial letter wizard does not mention that one of its products is a Base document together with the serial letter. -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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 -- -- To unsubscribe e-mail to: users+unsubscr...@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: Where is Base?
Hi Peter Noted on your comments and others I can confirm that using the embedded DB in Base is a disaster - I battled with it for a couple of years until I found out about using an external engine - I use MySQL and have had _NO_ problems, (except my own finger problems!!) since then. Regarding images in the Database I have about 2600 records with a maximum of 7 images per record. I had no problems with this under Base/MySQL except that the DB file gets very large as a copy of each image is included in the DB. I just recently came across a tutorial on 'Linking Images' rather than including them and this works like a charm and the DB stays much smaller and therefore faster. The tutotial can be found here -/_www.youtube.com/watch?v=IsHqqvn2zYg_/ https://www.youtube.com/watch?v=IsHqqvn2zYg Another nice plus is that if you control your image file names you can be sure that your DB always shows the latest image - works for me!! Hope this helps IanW Pretoria RSA. -- To unsubscribe e-mail to: users+unsubscr...@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: LO Base Problem [SOLVED]
Thanks Alex and Paul!!! We have cured the problem!! Alex - your correction still gave me the SQL Error as before. Paul - your correction was on the nail!! Worked like a charm and my RecordID now Auto-Increments!! I appreciate GREATLY all this help guys!! As I mentioned I'm not - and don't want to be a DB Admin - I just need to be a DB user, as I have been for the past year or so. Yes I do my own set-up etc as best I can but am rather lost when the wheels fall off. Thanks again Guys - Greetings from South Africa IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: LO Base Problem
On 02/22/2015 03:20 PM, Alex Thurgood wrote: You could try using : ALTER TABLE Members CHANGE RecordID1 INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY; Thanks Alex I gave this a try in MyAdmin and got ... Error *SQL query:* || |ALTER TABLE Members CHANGE RecordID1 INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY | *MySQL said: *Documentation http://localhost/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.1%2Fen%2Ferror-messages-server.htmltoken=8d06c7c288ebb2e01f21b98220996b09 |#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY' at line 1 | My SQL is Ver 5.1.73 and MyAdmin 4.2.10.1 IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: LO Base Problem
Thanks Alex But I fear this is getting nowhere. As per your suggestion I built a new ODB file and it showed the same problem. i have run the MySQLcheck program and it confirms the DB is OK. Maybe it is a funny in Base itself??? And it may come right with the next release?? In itself the problem does not make my DB unusable and I must press on with it so I guess the best is to just put the RecordID number in by hand and keep a paper record of the last used number. Seems ridicules but I guess it's what we all call a Workround. I really do appreciate your help and assistance nonetheless. With best wishes IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: LO Base Problem
Hi Alex I really appreciate your help here!! But still no luck - My replies are below. A quick, alternative possibility : Create a new ODB file that connects to your database. Save it under a new name. Open the newly named (and currently empty, at least with regard to forms, queries, etc) ODB file. I tried this and the ID field comes through as 'No increment' and still will NOT change!! Did you read Fernand's comment ? Yes - There is only ONE field on my Form that calls this field. The one I'm trying to change. your old RecordID was just an INT that you filled in yourself - No - it was empty, like all my fields), and I imported my old data from a CSV file and then started to work. That,s when I discovered I had not set it to Auto Increment. so now that you have converted it to INT AUTO_INCREMENT, did you regenerate the values, or have you just carried on from the previous lastinsert_id() of the RecordID field ? I can not change it so have not regenerate it. All I can do at the moment is enter the next number by hand. Ways around this : - reindex your table using the appropriate mysql command ; - run mysqlcheck from the command line I'm NOT a DB Admin at all I just need this DB to keep all the details of my Group. The DB is just a very important tool to me!! I tried to run the 'mysqlcheck' command and I don't know what the output is but this is what I got ... Variables (--variable-name=value) and boolean options {FALSE|TRUE} Value (after reading options) - - all-databases FALSE all-in-1 FALSE auto-repair FALSE character-sets-dir(No default value) compress FALSE databases FALSE debug-check FALSE debug-infoFALSE default-character-set (No default value) fast FALSE fix-db-names FALSE fix-table-names FALSE force FALSE extended FALSE host (No default value) write-binlog TRUE port 0 quick FALSE silentFALSE socket(No default value) ssl FALSE ssl-ca(No default value) ssl-capath(No default value) ssl-cert (No default value) ssl-cipher(No default value) ssl-key (No default value) ssl-verify-server-certFALSE use-frm FALSE user (No default value) Thanks again IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: LO Base Problem
On 02/20/2015 04:47 PM, Alexander Thurgood wrote: Try mysqlcheck -A -p Thanks for the explanation Alex. This is what I get . FedSaints.Members OK mysql.columns_priv OK mysql.db OK mysql.eventOK mysql.func OK mysql.general_log Error: You can't use locks with log tables. status : OK mysql.help_categoryOK mysql.help_keyword OK mysql.help_relationOK mysql.help_topic OK mysql.host OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.servers OK mysql.slow_log Error: You can't use locks with log tables. status : OK mysql.tables_priv OK mysql.time_zoneOK mysql.time_zone_leap_secondOK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_typeOK mysql.user OK IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: LO Base Problem
Hi All I've spent today trying to cure this problem. I have only ONE table in my Database and needed to make the RecordID field Auto-incrementing. (I forgot when I set it up) Using the Base Front End it will *NOT* change the setting - as soon as you save it reverts to 'No' Using MyAdmin I ran - ALTER TABLE `Members` MODIFY `RecordID` INT AUTO_INCREMENT PRIMARY KEY; and got a positive return from that SQL statement. This is the only Primary Key and there are no other Auto-Incrementing fields. But when I go back into my Database with the Base Front End the RecordID is still marked as 'No Auto-Increment' and still will not change!! What am I doing wrong and how do I urgently fix this?? Thanks for any pointers. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: LO Base Problem
On 02/18/2015 05:35 PM, Alexander Thurgood wrote: Le 18/02/2015 15:23, Ian Whitfield a écrit : Yesterday I found I had not set my Keyfield (RecordID) to Auto Increment so I set a new field with phpMyAdmin called 'id'. And this is now working fine and Auto incrementing. I deleted the old RecordID field. Why did you do that ? Why not just alter the existing Keyfield (RecordID) to autoincrement ? I tried several times and the Auto Increment just reverted to 'NO' every time I saved it. When you talk about the Keyfield, do you mean that this was a PRIMARY KEY or was it a reference for other tables (FOREIGN KEY)? Yes I mean the Primary Key - I have no Foreign Keys Did you attribute PRIMARY KEY status to the new field that you created? Did you recreate any references (FOREIGN KEYS) to other tables ? I deleted the old Primary key and marked the new field as Primary If you didn't, then by deleting your original RecordID field, you probably deleted the primary key and/or any references as well, and in all likelihood that is the reason why the forms that relied on that key to be set no longer work. In which case should I rather export my data out and start again?? My feeling is this might be the best and quickest way to go. Thanks for the help. -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base Problem
*Hi All* I have been rebuilding/revamping my Database over the past few weeks and everything has been going great. I'm using LO 4.3.5.2 and MySQL 5.1.73 on PClinuxOS (latest). Yesterday I found I had not set my Keyfield (RecordID) to Auto Increment so I set a new field with phpMyAdmin called 'id'. And this is now working fine and Auto incrementing. I deleted the old RecordID field. Now many of my fields are greyed out in the Form and will not accept input and all my drop-down boxes are inactive. I created a new temporary Form (using the Wizard) and it works fine and displays all fields. But as soon as I replace a field with a drop-down or Combo Box box that box becomes inactive again and is greyed out and will not display the options. I've looked everywhere in the field properties but can find no obvious cause. Anyone have any ideas please?? Thanks. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] MySQL - LO Base question.
Hi All I have been running a MySQL Database with LO Base as a front-end for some time now - and VERY successfully indeed compared to the built-in engine in LO Base!! (My OpSys is PClinuxOS 32-bit) For a variety of reasons I decided to rebuild my system last week. I have a back-up of my Database as a CSV file and have completely wiped the hard drive and reinstalled the OpSys and all relevant programs and copied all my data into /home. I now need to set-up my Database again but have a question. (My Database has only one table with about 2500 records and each record has 80 fields.) Which is the correct procedure?? 1) Set-up the Database in MySQL and create an empty table to import the CSV into. Then link Base to it. 2) Set-up the Database in MySQL then use LO Base to create the table and do the import 3) Set-up the Database using LO Base and then import the data. Thanks for any pointers. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] File-Send-Document As doesn't!
I had to add the /usr/bin/thunderbird and then it worked fine. But I agree this should be automated some how. My OpSys is PClinuxOS IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Problem Installing/Updating LO
*Hi All* Since I upgraded to LO 4.3.4 I have a problem with LO Manager!! Whenever I start it it shows the error - /Please close your package manager 'synaptic' // // and then run LibreOffice Manager again.// // // Exiting../. Synaptic is _*NOT*_ running - So am unable to update the package. * I tried re-installing LO Manager - still get the error. * Then I 'Completely Removed' all LO files with Synaptic and re-installing LO with but still get the same error. * I then removed the hidden .config/libreoffice files and reinstalled the Manager but still get the same error. I'm now stuck with no LO on my system at all!! My system runs PClinuxOS (latest) 32-bit. Any suggestions please?? IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Problem Installing/Updating LO
*Thanks Paul - answers below ...* On 12/08/2014 05:18 PM, Paul D. Mirowsky wrote: This sounds like LO Manager is calling to synaptic twice. Did you confirm synaptic is not running by process status command ps that includes all processes before starting LO Manager? /*- YES NOT RUNNING*/ Try lomanager --no-updatetest from http://www.pclinuxos.com/forum/index.php?topic=125725.0 *This is what I get ...* [root@localhost ianw]# lomanager --no-updatetest ** (zenity:19120): WARNING **: Couldn't connect to accessibility bus: Failed to connect to socket /tmp/dbus-hWMDwz5vcY: Connection refused Also suggested is... Close Synaptic, then reboot. Log in, then open Synaptic and do a full upgrade... *Reload -- Mark All Upgrades -- Apply* then *Apply* again, from the confirmation window. When the upgrade has finished, close Synaptic. Then run the *updated version* of LbreOffice Manager. from http://www.pclinuxos.com/forum/index.php?topic=108906.0 Synaptic only gives option to install LO Manager In linux it is possible to have someone else login and start synaptic and leave it open. Is this a possible scenario? NO - I'm single user on single machine!! -- To unsubscribe e-mail to: users+unsubscr...@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] Using LO Writer to edit HTML
Hi Regina On 11/13/2014 09:13 PM, Regina Henschel wrote: Hi Ian, try this: 1. menu File New HTML Document. Now you should have an HTML-source-icon between ABC-icon and Print-Preview-icon. If it is not there, see below. 2. menu Insert Document. 3. Click on the HTML-source-icon. You have to save the file, otherwise HTML-source view is not possible. 4. Click the icon again to switch back to Web-Layout. Thanks VERY much for the above instructions!! *THIS DOES WORK*!! I would suggest that these steps are put into the Wiki page on HTML and into the Help screen that is under F1 in the program!! I have now been able to try LO Writer out in this mode and I must say it's not bad at all!! No colour coding and a few other things missing but - as I said - not bad. I think it could be tweaked into something useful!! Going in the other direction I tried out Komodo but gave that up as it has a VERY annoying default in that it changes things you code the way *it* thinks it should be and I hate this!! I like to lay things out MY WAY and want it to stay that way. So I have been using Bluefish for the past few days and find it also rather good. I notice one responder mentioned he used to use Quanta - I did too and it's a great pity it was dropped. It was the best HTML Editor I ever came across!! But thanks Regina, and as mentioned try and get your steps into the documentation!! Also thanks to all who responded to my original question. Very much appreciated!! Best regards IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Using LO Writer to edit HTML
Hi All Can I get some help on this please?? I have read about, and looked-up, the possibility of editing HTML documents in Writer but can not get it to work!! No matter what I do I can not fine 'HTML Mode' or 'View HTML' as talked about ion the help files. I can load my document but can not get at the HTML code. What am I missing or doing wrong?? I'm using LO 4.3 on PClinuxOS (latest) Thanks for any help. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Using LO Writer to edit HTML
Hi Kolbjoern Thanks for the reply. The document already exists - so I'm selecting 'File Open', I change the File Type to 'HTML Document (Writer)' and select my file. It then opens in view mode - So how do I get to the code to edit it?? On 11/13/2014 01:18 PM, Kolbjørn Stuestøl wrote: When saving your document, select HTML Document (Writer) (.html) in the File type: drop down list in the Save dialog. Kolbjoern Den 13.11.2014 11:18, skreiv Ian Whitfield: Hi All Can I get some help on this please?? I have read about, and looked-up, the possibility of editing HTML documents in Writer but can not get it to work!! No matter what I do I can not fine 'HTML Mode' or 'View HTML' as talked about ion the help files. I can load my document but can not get at the HTML code. What am I missing or doing wrong?? I'm using LO 4.3 on PClinuxOS (latest) Thanks for any help. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Using LO Writer to edit HTML
Thanks all. Well it looks as if the PClinuxOS version of LO has omitted or taken out this function. No matter which way I open the file I get _NO_ option in 'View' that has anything to do with HTML!! I even tried a 'Save as selecting HTML and still no luck. (Although doing this changed the names of my images in the code to long miscellaneous number and letter strings!!??!!) So I'm having to look around I know I can use a plain Text Editor but I was hoping for something a little better to help with the editing - like colour coding and selectable Tags etc. I can live without WISIWYG. I'm currently evaluating Komodo!! *Steve* - I was looking at (amongst others) - https://help.libreoffice.org/Common/HTML_Source; https://help.libreoffice.org/Common/Opening_documents_saved_in_other_formats; https://doc.opensuse.org/documentation/html/openSUSE_121/opensuse-startup/art.oofficequick.html; (Section 4.5.4) And the LO Help Window. Thanks all IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Using LO Writer to edit HTML
On 11/13/2014 05:28 PM, Brian Barker wrote: At 17:03 13/11/2014 +0200, Ian Whitfield wrote: Well it looks as if the PClinuxOS version of LO has omitted or taken out this function. No matter which way I open the file I get _NO_ option in 'View' that has anything to do with HTML!! In that operating system, do you have something like right-click | Open With | LibreOffice Writer? Does that produce the desired effect? YES Brian we do have that in PCLOS - but still the same result... NO option under 'View'. Thanks though!! -- To unsubscribe e-mail to: users+unsubscr...@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] nabble issue
On 11/03/2014 11:44 AM, Tom Davies wrote: Can other people try on other systems? Mint and other Debian family probably have the same result as me. Someone in the thread already tried with Fedora. So ideally if you are using something else it might help more. Windows anyone? ;) Loads fine on my system - PClinuxOS - KDE, Firefox 33. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: Recommended version of Java?
On 10/30/2014 11:02 PM, Virgil Arrington wrote: On 10/30/2014 04:12 PM, Paul wrote: On Thu, 30 Oct 2014 12:53:09 -0700 (PDT) Andreas Säger ville...@t-online.de wrote: And Tom is a phony idiot who knows nothing. I hope that you personally know Tom very well, and know that he is ok with you calling him such, otherwise I think you should consider your words more carefully. This list is a user-oriented place meant to be friendly and encouraging to new and old users alike, and Tom has done a lot of good on this list; I don't feel he deserves that sort of slander, even if he happens to be misguided in this instance (which I am not yet convinced he is). Paul +1 In my experience on this list, Tom has been extremely helpful and, just as important, courteous. Virgil No +100. Tom is a great help to many (including me) and should not be slandered for this!! -- To unsubscribe e-mail to: users+unsubscr...@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] bug segnaled in 4.3
On 09/28/2014 11:53 AM, Paolo Debortoli wrote: a debian user has written on a mailing list that differently from version 4.2, in the last 4.3.2.1 version the ordering function (right click - sort) in calc is not working yet (I haven't verified it by myself at the moment actually). It works fine in 4.3.2.2 on PClinuxOS. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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 questions
On 08/04/2014 04:15 PM, dave boland wrote: On Mon, Aug 4, 2014, at 09:10 AM, Jean-Francois Nifenecker wrote: Le 04/08/2014 14:51, dave boland a écrit : How does switching to Firebird solve the issue of an embedded, all in memory database? I would be happy if LO offered an option (when creating a db) to use embedded model or the split model. Any embedded DB engine (HSQL or Firebird or any other) won't solve the Base [R]DBMS embedding problems. Only external DB engines can be reliable. Using an external DBMS is up to you. Base/LibO can be setup accordingly. -- Jean-Francois Nifenecker, Bordeaux That is my point. That is why Base needs to make setting up an external db easy - like when the db is being created. Check one box for the embedded model, another for the split/external model. Appropriate Help infornation will be needed. While they are at it, how about an option to do mariadb or mysql external db instead of just HSQL or Firebird? Dave, BIG +1 (or rather +100) I think this is a MUST!! It took me a couple of years to puzzle out what was wrong, (Embedded vs External), and then a few weeks to get it all to work - very little info available - all I could do was step-by-step with the Forum. But once you get it all working the difference is amazing. One year down the line and not one crash or one piece of data lost!!! IanW Pretoria RSA -- -- To unsubscribe e-mail to: users+unsubscr...@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] Text in an IF function
Hi All I'm using a lot of IF functions in my Spreadsheets to limit DIV and NAME errors with rows that don't have values in them yet. I came across a situation today where I need to test text - ie I need to test for a month's name. I tried =IF(Cell Ref=AUG,do calculation.) But this gives NAME error. Is it possible to test text in this way? Can't find anything with a Google on this. PClinuxOS KDE 32-bit (latest); LO 4.1.3.2 Thanks IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Text in an IF function
On 07/29/2014 10:45 PM, Brian Barker wrote: The only thing wrong with your example is the dot separating the second and third arguments - which presumably should be a comma. There is nothing in the basic structure you are illustrating here that would stimulate a #NAME? error, so the problem must be in your cell reference or the do calculation - the parts you've not shown. Thanks Brian!! The dot separating the arguments was finger trouble when I wrote the eMail!! I think I've tracked down the problem but not the answer My full statement is - =IF(H44=AUG,Paid.D21,) Paid.D21 is the value I want to insert if the month is correct. H44 contains the month, ie AUG - and this seems to be the problem. It is a pull-down list of months. If I enter the month by hand the IF statement works but with it being a pull-down list it does not work. Is there a way round this?? -- To unsubscribe e-mail to: users+unsubscr...@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] Adding fields to existing Base table
On 07/11/2014 04:21 PM, dave boland wrote: Thank you Noel. I will check this out. My head is spinning right now with all of the choices. I need to get something together for next Fri., so I'm going with LO Base for now. Seems like a decent choice because I will be the only user for most of the rest of the year. Later this year there may be two other users. So the convenience of LO Base makes sense, and the data size for the rest of the year is not likely to excede 200 MB. The biggest limitation with LO Base is the report spftware - doesn't seem to support embedding charts in the report. Hopefully this problem gets fixed in 4.3. Alternatively, I'll use a stand-alone report software product. Hey, did I mention that this was SUPPOSED to be a quick simple project? Aren't they all?? My hope is that I can use LO Base as the front end for a more robust RDMS later this year. I have been looking at MariaDB because it seems to have a lot of buz, but may not be the best chioce. One of the things that really needs to happen is that I have to get my arms around this project in terms of potential size, number of users, on the web or not, ect. My guess is that I won't have that done until very late this year. Dave, On Fri, Jul 11, 2014, at 09:07 AM, Marion Noel Lodge wrote: Hi Dave My penny's worth - I battled with plain Base for about 3 years. Horrendous crashes and freezes and the amount of data I lost and had to re-enter was unbelievable!!! (I'm a single user, single machine running with Linux as my OpSys). Every time Base goes down it takes the entire Database with it! So the only way round it is to make copies every time you add data so that when it crashes you can rename the copy and get going again. You WILL lose data I promise you!! I did everything I could but no luck. It then became obvious to me that the problem was the embedded DB so I took the plunge and moved to MySQL last year. I've had NO crashes or lost data since then. It's as solid as a rock!! My recommendation would be to START right now with MySQL (or other backend). Base as a front end is great as long as the backend is solid!! Just my opinion for what it's worth but I speak from hard experience!!! Best wishes IanW Pretoria RSA. -- To unsubscribe e-mail to: users+unsubscr...@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] LO Calc - Only display results on active row?
Hi All I have several of Spreadsheets that work with monthly figures. They also have columns with calculations of these figures. (ie Totals, averages etc). At the moment I get a lot of 'DIV by Zero' results and the current total repeating BELOW the current month. Is there a way to only show calculated results on active (ie current) month rows?? Maybe the equivalent of the old 'If - Then' Basic function. (If there is a figure 0 in column B then calculate column C. Would be interested to know - thanks. OpSys PClinuxOS, LO 4.1.3.2. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Calc - Only display results on active row?
On 07/09/2014 11:28 AM, Brian Barker wrote: Yes: there is the IF() function: is that a close enough equivalent? Just put =IF(condition;expression-for-true;expression-for-false) . Your expression for false may well be consecutive double-quote marks, representing the null string. Thanks Brian I have managed to get rid of the 'DIV 0' problem but still have a problem with a decreasing total. My DEC TOTAL formula is 'Current Cell minus the Cell above' and this echos the last result down the whole Spreadsheet. Is there a way round this as well?' IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Calc - Only display results on active row? [SOLVED]
On 07/09/2014 12:23 PM, Brian Barker wrote: Yes - but you don't say what the controlling factor might be. There must be some aspect of the list that indicates the point at which you want the totals to stop. Instead of using =X100-X99 you need something like =IF(condition;X100-X99;) with condition being something like A1000 or A100 - referring to whichever column shows how far you want your values to be calculated. Thanks a lot Brian - that did it!!! My formula is now 'IF(First column cell0,subtract the two cells,)' And that has fixed it 100% - I appreciate the help!! IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Need help with Base
+100 Wolfgang!!! I fell in the same hole!!! PostgreSQL or MySQL is the ONLY way to go. IanW On 05/05/2014 05:44 PM, Wolfgang Keller wrote: I'm new user of LO Base, we are transitioning from MS Access, and I need to redesign our db from it. One word of advice based on experience: Avoid use of the built in database. Use a proper client-server RDBMS. Preferrably PostgreSQL, as it's reliable and the driver comes with LO. Otherwise you *will* regret it the day your data has gone to Nirvana. Sincerely, Wolfgang -- -- To unsubscribe e-mail to: users+unsubscr...@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: Neat Writer Feature -- Relative Font Sizes
On 02/13/2014 08:04 PM, Tom Davies wrote: Hi :) I think some people here do read the manuals https://wiki.documentfoundation.org/Documentation/Publications But i agree that it might be good for certain people (mostly thinking about me tbh) to dip in and read-up even on just 1 feature per week or month or however long. Actually part of the reason i joined this list was because i hoped to learn how to solve issues that people find problematic in the herenow and maybe learn a few tricks or quirks. Kinda a cheats way of learning without trying. However i really need to knuckle down to some proper reading at some point. Perhaps we could have a quick little weekly gem (or find) maybe from a different person each time (ish)? but i think some of the various blogs are trying to do that already. Would it be duplication to do something similar on this list or would it be just a good thing to try out for a bit because we handle things differently here? Advice of the week Tom RTFM LOL!! IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] MySQL/LO Base problem
Hi All I'm looking for someone to help me out with a serious and URGENT mySQL/LO Base problem please. I prefer to do it Off-List but am happy to post the end result on the Forum later. I did write to Alex Thurgood directly but got no reply - maybe he's busy of away?? My direct eMail is _whitfield(at)telkomsa.net_ or post here on the Forum. Thanks a lot IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base/MySQL questions
Hi All I've been using the Base/MySQL combination since mid-last year now and it is fantastic!! It is much faster, never crashes or freezes and just works the way it is supposed to. I can definitely recommend it to anyone!! (In my opinion this should be the standard and HSQL should be dropped) Now I have a couple of questions... 1) Where does MySQL store the Database? (I think it's in the root somewhere) 2) Is it easy to move it into the /home directory? 3) Where do I find the LO front-end form? 4) If I copy these two files to another machine will I be able to get the Database running on this second machine? Side question I have a couple of graphics/photos in each record - Is it possible to 'Link' these instead of embedding them so that if you up-date a photo it will automatically update in the Database? If this is possible will it effect Base at all? (faster, slower etc) Thanks for any help IanW Pretoria RSA. -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base/MySQL questions
Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 A MySQL 'expert' was telling me recently that HSQL is only meant to be a prototyping utility and should *NEVER* be used for any proper work - - interesting!!?? I can confirm that when it crashes it takes everything with it so you have to backup every time you make change. This is what forced me to MySQL. Thanks again -- To unsubscribe e-mail to: users+unsubscr...@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: Pasting plain text into Calc changes row height and undo doesn't revert
On 04/12/13 16:48, whatever wrote: Tom Davies wrote You can double-click on the line between the row headers to make it auto-adjust the height of the row. THANKS TOM!! I've been wanting this function for a long time and could not find it. BTW - I think you mean auto-adjust the WIDTH of the Column. If not it works just fine for me. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Using the TOC/Index function.
Thanks for the comments Tom You are right - I was meant to send it to the Scribus Forum but I selected the wrong eMail address!! My Bad as they say these days!! Regarding your comments - what you say makes a lot of sense. All the best -- To unsubscribe e-mail to: users+unsubscr...@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] Using the TOC/Index function.
Hi all I've been looking for a way to index my monthly Journal I edit in Scribus. I have managed to get the Scribus function working, (after a battle), but two problems remain. 1) In all my Paragraph Styles the 'Fill Character' is greyed-out!! How do I activate this? 2) The created Index is in page order and not Alphabetical order. Can this be changed? [My Scribus version is 1.4.3 on PClinuxOS 2013.08] Thanks for any help. IanW Pretoria RSA -- -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base Sub Forms
Hi All I've had some success at last!! Using Shane Piper's Tutorial at http://www.youtube.com/watch?v=TcudVETPePY I have got my sub-Forms working fine. My last problem was with Opening a Form with a Button and again Shane has a Tutorial on this at http://www.youtube.com/watch?v=9Zmd-zidIvg But I have been unable to get it to work on LO 4.1.1.2. Today I started my old machine running LO 3.6.5.2 and it works fine on that machine!!! (Both machines running PClinuxOS) The Macro is ... REM * BASIC * Sub OpenStoryForm const sNewDocumentName = Database Name.Form Name oNewFormDocument = ThisDatabaseDocument.FormDocuments.getbyname(sNewDocumentName).open End Sub We have tried with and without the Database Name and with and without the '.' between the two - but no difference. Nothing happens at all when you click on the Button. Has anyone seen this or knows of a reason for this? I'm thinking of dropping back to LO 4.0 and see if it works on that. Thanks for any info IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base Sub Forms
On 15/10/13 22:41, Andrew Douglas Pitonyak wrote: If I remember correctly (and I have not looked at this in a while), I think that you need to link the master and slave fields. So, if you open your form in edit mode, load the form navigator, right click on your sub-form and choose properties, navigate to the Data tab, do the values in the Link master fields and Link slave fields look right to you? Thanks Andrew You got the memory cells working again!! This morning I read-up on Sub Forms in the new LO 4.0 Base Handbook and I'm sure you are right. BTW - Great book but no 'How To' details (??). That got me remembering a video on You Tube about Sub Forms - www.youtube.com/watch?v=TcudVETPePY - so I went and found that again. However my Form Navigator will NOT show me the content of my Form!! All it gives me is a list of types - Headings, Tables, Text Frames, Graphics, OLE Objects, Bookmarks, Sections, Hyperlinks, Indexes, References, Comments and Draw Objects. (all with a count of '0'). And none of the options at the top of the Navigator make any difference. How do I get the Navigator to display the content of my Form?? Thanks IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base Sub Forms
Hi All I'm still stuck with LO Base Sub Forms!! I've been at this for some time, off and on, but over the past few months I have been very busy converting, editing and checking/updating my DB to now run on MySQL. I must say it is a GREAT improvement!! OK - My OpSys is PClinuxOS 2012-10. LO 4.1.1.2, MySQL 5.1.55 I have three tables in my DB - 'Members', 'Story', 'eMails'. I have one Main Form Members (that references the 'Members Table) AND contains a Sub Form eMail (that references the 'eMail' Table). Also on the Main Form is a Button that should pop-up, over the Main Form, a Story Form that references the Story table). All the individual Tables and Forms work well on their own - BUT ... The eMail Sub Form does not link to the individual Members record and cycle with each record so I can not add info to this Sub Form that will be linked with the correct record. The Button does not work at all!! I have worked on this so many times off and on that I'm now rather confused on how to go about it or what I did before. My 'eMails' Table contains the fields - MessageID, Date, In/Out, Title, Message. ID (My Foreign Key) My 'Story' Table contains the fields - StoryID, Story, ID (My Foreign Key) If I remember correctly I created the eMail Sub Form at the time I laid out the new Data Base and under the Button properties I currently have When pressed - Standard.Story.OpenForm (document, Basic) Can someone help me out of this mess??? Thanks for ANY help. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Label Printing in LO Writer {SOLVED]
Thanks to all for the input - appreciated!! Pedro contacted me directly and has put me right and I now have it working 100%. He picked up my error and said The trick is that the 'Pitch' means the label width PLUS any following space whereas I was putting in only the gap between the labels, (which was zero). As I said once you get this right it works perfectly!! I still think the Titles of the fields could be improved as could the help file - which could also use a better graphic to illustrate the values. I agree that Scribus is an overkill but it was - at the time - my only other option. I tried using tables in LO but getting everything lined-up correctly was a nightmare!! In the end though it would work. Thanks to all - The Forum never ceases to amaze me!!! IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base - Pushbutton on Form not working.
Hi All After some time working on other aspects of my Database I'm back to trying to get a Pushbutton working to open a SubForm. PClinuxOS 2013.08; LO Base 4.1.1.2; MySQL 5.1.55 My Database - FSNew Tables - Members Story Forms - FSNew.Members FSNew.Story The Pushbutton on the Members Form has the event - Mouse Button Pressed - Standard.Story.OpenForm . On Clicking on the Button in the Members Form I get the error - A Scripting Framework error occurred while running the Basic script vnd.sun.star.script:Standard.Story.OpenForm?language=Basiclocation=document. Message: The following Basic script could not be found: library: 'Standard' module: 'Story' method: 'OpenForm' location: 'document' Can someone decipher this for me please?? Thanks!! IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base - Check boxes not working after upgrade?? [WORKROUND]
Thanks to Andrew and Mark for their input I thought about this over the past few days and did not want to wind back to the earlier version of LO and have the problem of getting the link to my SQL Database working again. So yesterday afternoon I came up with a Workround!! I converted all the Tick Boxes to Combo Boxes. It now takes two clicks to set them now but you do get more options if you need them. All is working fine now. Just an idea that worked for me, in case anyone else is in the same boat. Regards to all IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base - Check boxes not working after upgrade??
Hi Andrew On 05/09/13 23:09, Andrew Douglas Pitonyak wrote: Is it possible that the form is in edit mode? As in, you are editing the control? It is a long shot guess... On 09/05/2013 04:47 AM, Ian Whitfield wrote: Hi All I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just upgraded my LO Office to 4.1.2. Everything seems to be fine EXCEPT The Check Boxes in my LO Form no longer work - you can not edit them or add to them. If you click on one a tick appears in the box but as you select Save the tick disappears and it is *NOT* saved. I have even tried and created a new Tick Box and it behaves just as above, Has anyone seen this effect or got any idea how to fix it please?? Thanks or any help. IanW Pretoria RSA No Andrew this is NOT the case as all other fields are working correctly - only Tick Boxes can not be saved!! IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: LO Base - Check boxes not working after upgrade??
On 06/09/13 10:58, Alexander Thurgood wrote: Le 05/09/13 10:47, Ian Whitfield a écrit : Hi Ian, Has anyone seen this effect or got any idea how to fix it please?? This has also been reported on the French users mailing list. Sounds like a bug to me. So how do we, or can we, report it or has it been reported by the French Group. Would really like to get my Tick Boxes back!! Thanks for the input. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base - Check boxes not working after upgrade??
Hi All I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just upgraded my LO Office to 4.1.2. Everything seems to be fine EXCEPT The Check Boxes in my LO Form no longer work - you can not edit them or add to them. If you click on one a tick appears in the box but as you select Save the tick disappears and it is *NOT* saved. I have even tried and created a new Tick Box and it behaves just as above, Has anyone seen this effect or got any idea how to fix it please?? Thanks or any help. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base - Check boxes not working after upgrade??
FIRST POST DID NOT SEEM TO GET THROUGH - RE-SENDING ... Hi All I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just upgraded my LO Office to 4.1.2. Everything seems to be fine EXCEPT The Check Boxes in my LO Form no longer work - you can not edit them or add to them. If you click on one a tick appears in the box but as you select Save the tick disappears and it is *NOT* saved. I have even tried and created a new Tick Box and it behaves just as above, Has anyone seen this effect or got any idea how to fix it please?? Thanks or any help. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Sorting a MySQL Database
Hi Noel On 29/08/13 06:12, Marion Noel Lodge wrote: Hi Ian, With a Form, I have found the following is the way to lock in the Form's sort order - 1. Open the Form in Edit mode 2. Right click on the form and from the dropdown choose Form... 3. Click on the Data Tab 4. The contents field should be pointing to your Table 5. Click on the box to the right of the Sort field 6. Then you can choose your sort fields, (LastName and FirstName) 7. Click OK 8. Close Form Properties 9. Save the Form This works with my H2 database. Hopefully it is the same for your MySQL. Thanks for your reply - This is exactly what I was looking for!! BUT I open the Form in Edit Mode and Right-Click on it and there is NO Form in the options that come up!! My LO is version 3.6.5.2 (Build ID: 5b93205) and MySQL is 5.1 thanks anyway IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Sorting a MySQL Database
Hi Noel On 29/08/13 06:12, Marion Noel Lodge wrote: Hi Ian, With a Form, I have found the following is the way to lock in the Form's sort order - 1. Open the Form in Edit mode 2. Right click on the form and from the dropdown choose Form... 3. Click on the Data Tab 4. The contents field should be pointing to your Table 5. Click on the box to the right of the Sort field 6. Then you can choose your sort fields, (LastName and FirstName) 7. Click OK 8. Close Form Properties 9. Save the Form This works with my H2 database. Hopefully it is the same for your MySQL. Just checked on my OLD Base / HSQL Database and there is NO Form option there either - so I guess this is an option only with your H2 engine (??) IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Sorting a MySQL Database
Thanks Jay On 26/08/13 15:54, Jay Lozier wrote: Ian, Is there an id key field? If there is the default sorting is by the id key (usually numerical order). In SQL you can add the line: ORDER BY Last-Name, First-Name The default order is ascending (ASC) if descending is needed ORDER BY Last-Name DESC, First-Name DESC Yes - I do have an ID Field (Record_No). I found the correct SQL 5.1 syntax for me was - Select * from {Table Name} ORDER BY LastName, FirstName; This worked fine and does the same as the 'Sort' button BUT it is still not fixed or remembered!! You have to run this each time you start. Is there no way to make this automatic when you start the Database?? With thanks IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Sorting a MySQL Database
Hi All I now have my new MySQL/LO Base Database up, running and fully edited from the old one. And what a pleasure it is to work with!! This IS the way to go, One question - It seems to have a strange way of sorting the Data as displayed in the Form I designed and I have to select 'Sort' in the bottom Bar and then pick 'Last Name', Ascending and 'First Name' Ascending to get it the way I want it. Unfortunately it does not seem to keep this Sort!! Is there a way to lock' this sort or to make it automatically do it when you start the program?? PClinuxOS 2013 LO Version 3.6.5.2 (Build ID: 5b93205) Thanks for any help. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Variables in Libre Office
Hi All Very interesting article on using variables in LO that I just came across. Worth a read http://www.techrepublic.com/blog/opensource/three-great-ways-to-use-variables-in-libreoffice-and-openoffice/4446?tag=nl.e101s_cid=e101ttag=e101ftag= IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Calv - Vertical Split
Thanks to everyone who has helped me out in the last week or so - appreciated!! It's fantastic to have a Forum like this, (as is the Scribus Forum that I also use). A week or so back I asked about 'Searching in a Column' so thanks to Suo, Tom and Luuk for that help - Not exactly how I would like it but a suitable workround. With my latest problem with 'Splits' and then vanishing Tab thanks to Regina, Brian and Oogie for their help!! I found my Tabs again - during me playing with Splits it seems that the entire Tab system had been compressed totally to the left and was all but invisible except for a small un-noticed Bar. Only by picking-up on this Bar could I drag the Tabs back on to the screen. strange!!(??) Again thanks to all and the Forum in general IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Calv - Vertical Split
Hi All I have LO 3.6.5.2 on PCLOS 2013 Is it possible to do the following in Calc?? I have two list of names (and other data) side-by-side in a Spreadsheet and I want to Split the Spreadsheet vertically to show the LH part on the left and the RH part on the right. This I can do but the two parts don't scroll vertically independently, there is only ONE Scroll Bar. So they remain in sync!! (What I need to do is scroll the RH part, without the LH part moving to find a match in the two lists) The Horizontal Split works like this with two Scroll Bars for each part. Is there a way of doing this Vertically?? Thanks for any help IanW Pretoria RSA -- -- To unsubscribe e-mail to: users+unsubscr...@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] LO Calv - Vertical Split
On 17/06/13 13:20, Regina Henschel wrote: Do not use split or freeze options, but from the menu 'Window' the item 'New Window'. You get a new UI, but on the very same document. So the content changes in one Window will be in the other window too. That are not two documents but only one document with two views. Thanks Regina That DOES in fact work and will do for me - but I still don't understand why the Horizontal and Vertical Splits don't work the same??? It would be much easier to work this way as there is no separate window sizing and lining-up to do!! ANOTHER PROBLEM - Don't know if this is to do with me experimenting with Splits but my Tabs have vanished from the bottom of my Spreadsheet!!! I've looked and can find no way to get them back??? (If I open a NEW Spreadsheet they are still there), so it must be just on my current SS that they have vanished. Any idea??? Thanks for the help - appreciated!! IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Calc - Find in a column
Hi All Is it possible to get Calc to search/Find in a specific column?? I have a three column list of names, (A=First, B-Surname, C=Former Name), with about 3000 entries and want to get the Search function (CTRL-F) to look in just the specific column related to the Search. I have tried to pre-select the column, (right-click), but the Search function still looks at all the columns. PCLOS 2013 and LO 3.6.5.2 Thanks for any help. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: LO Calc - Find in a column (SOLVED - sort of!!)
Thanks to everyone on this!! Appreciated!! On 07/06/13 11:52, Luuk wrote: On 07-06-2013 11:35, Suo Kunlong wrote: 06/07/2013 05:07 PM, Ian Whitfield : Hi All Is it possible to get Calc to search/Find in a specific column?? I have a three column list of names, (A=First, B-Surname, C=Former Name), with about 3000 entries and want to get the Search function (CTRL-F) to look in just the specific column related to the Search. I have tried to pre-select the column, (right-click), but the Search function still looks at all the columns. PCLOS 2013 and LO 3.6.5.2 Thanks for any help. IanW Pretoria RSA Select a column, then Find Replace (CTRL+H), and make sure the Current Selection Only option is selected within More Options. You may also use regular expressions if you wish. But after the first 'find', the selection is cleared, therefore it will not be possible to find second occurance in that selection. LO 4.0.3.3 / Win7 All of the above seems to be correct!! The best 'Work around' I've come-up with is to select 'Find and Replace' but pick 'Find all' and it then Marks all the finds in the right column!! That works for me. Thanks a lot. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base/MySQL Backup??
Hi All I'm now using the MySQL back-end (5.1.55) with LO Base (3.6.5.2) as my front-end - all on PCLOS 2013. I've been messing around since late last year getting this all right, (with lots of GREAT help from the Forum!!) My question now is - Where does MySQL store the Database and how do I track it down to make a backup?? Because of all my messing around I have several different files in the system that may be the right one but I'm not sure which is which. I lost my whole Database at the beginning of the year when I re-installed my OpSys so DON'T want that to happen again and need a reliable backup method. Any suggestions would be most welcome. Thanks a lot IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base - Question about Query
Hi All I have a Database with about 3000 addresses in it and need - from time-to-time - to check how many different Countries are listed in it. I have a Query that extracts this for me but naturally it pulls out EVERY entry for EVERY Country. Is there a way for a Query to do this BUT only list each Country Once?? (PCLOS 2013, MySQL 5.1.55, LO 3.6.5.2) Thanks for any help IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] LO Base - Question about Query [SOLVED]
Thanks Noel !!! On 25/05/13 11:58, Marion Noel Lodge wrote: Assuming your field is 'Country', try this - SELECT Country, Count(Country) AS 'Count' FROM your Table name GROUP BY Country ORDER BY Country I had a problem, at first - as I always seem to do - with 'Syntax Error'!! So I created it with the Wizard and edited it in SQL view. This resulted in ... SELECT `Members`.`Country` AS `Country` FROM `FedSaintsNew`.`Members` `Members` GROUP BY `Members`.`Country` ORDER BY `Members`.`Country` This worked 100%!! So thanks very much. It does bring up two 'Blank' results, (which I guess must have a space in them or something). I don't know how to track these down but it's not too important. Appreciate the help. IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: Italics and bold in BASE.
On 14/05/13 10:52, acanela wrote: What´s the problem? What sould I do? I have the feeling that the solution is easy, but I can't find it. I mean for italics and bold in BASE. Set-up your requirements in your Form .. Select Form (Right-Click) Edit Control-Click on any Field Then Double-Click on the highlighted Field to display Properties Select Font Style as required. Save Form Open in normal mode and whatever you enter in the field will have the Italics and/or Bold that you selected above. Hope this helps IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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: help with database
Hi All I'm sure Alex is right - so thanks for pointing out the 'bits' that don't work from Base!! As a plain ordinary - everyday Front-End I have so far found Base to be adequate... so far (??) But I note the comments made. Must say I've been busy with other things for some days and have not been able to press-on with my development. I wonder what Front-End _YOU_ use Alex?? Would be interested to know. (m NOT on a Mac but on Linux (PCLOS 2012). IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] help with database
On 12/05/13 13:30, Tom Davies wrote: Hi :) That is a good question. Ultimately the Tables 'should' be in MySql (or whichever back-end you are using). One thing i don't know is if you can use the nice GUI front-end in Base to create the Tables and find the Tables are automatically in the external back-end. If it does work that way then it greatly reduces complexity by hiding the complexity away from the Database Designer. Ian, Alex, Dan, anyone any idea? Regards from Tom :) I have sent my procedure to Rounak off-list and replied to a couple of his questions. AFAIK once you have got ONE Table in MySQL and Linked to it you control everything with Base and any new tables created are in MySQL. At least that's what I see here!!* *IanW Pretoria RSA* * -- To unsubscribe e-mail to: users+unsubscr...@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 data-loss and other problems
Hi All Tom says ... I'm fairly sure that quite a few people have had troubles with the internal back-end that were solved by 'just' moving to an external back-end. I vaguely remember someone even suffering data-loss using the embedded/internal back-end. Was there a bug-report? Should people be encouraged to stick with the internal/embedded back-end or warned off from it? And Hank replied ... My experience with the embedded database in Base has convinced me to move to an external back-end. I have had several instances of data loss particularly during sessions of heavy data input. While I'm in the process of moving my database to an external H2 database, I still use the embedded database carefully, however. I backup the embedded database before adding data, sparingly or working with the Report Writer. Both of these activitie have resulted in data loss in the past. I still like Base as a front end, however. I have to agree with you 200% Tom - and if some people don't like it - too bad!! IT'S TRUE!! - The 'Embedded engine/Base Front End' combination is a disaster!! I have been using Base for about 7 years now and had nothing but problems. It's slow, crashes all the time, freezes etc etc and FREQUENTLY takes the data file with it when it crashes. The only recourse is to back-up all the time, (several times each session), so that you can get back at your data and be prepared to enter stuff more than once during a busy session. Because of this I HAVE LOST and/or had to re-enter data time and time again!! This is supported by Hank above I see, (and I'm sure many others)!! Late last year I converted to MySQL as the Backend and Base as the Front End. WHAT A DIFFERENCE As I said to people it's like getting out of your old broken-down, unreliable Beetle and driving around in the latest Rolls Royce!! Solid, fast, never crashes and is just fantastic!! I'm currently running BOTH set-ups, on two different machines side-by-side, for cross checking purposes and the difference is startling when you do this. The one is slow and plodding, (and still crashes), and the other just works - and fast!! IMHO the current engine in Base should be dropped, (or fixed), and a change made to make stand-alone Base of any serious use. I saw recently a mention of wanting to do this and change top Firebird!! (??) For now I'm VERY happy with my 'MySQL/Base combination!! Best wishes IanW Pretoria RSA -- To unsubscribe e-mail to: users+unsubscr...@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] Check Box size in LO Base
Hi All Question regarding LO Base, (being used as a Front End to a MySQL Database). (PCLOS, LO 3.6.5.2) I have eight 'Check Boxes' on my Form that work just fine but I find them a little small and can find no way to make them larger. I tried pulling them out and changing the Font size but neither of these work!! Is there a way of adjusting the size at all? Thanks for any help. IanW Pretoria RSA -- 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] Check Box size in LO Base
On 30/04/2013 12:43, Ian Whitfield wrote: Is there a way of adjusting the Check Box size at all? On 30/04/13 14:54, Fernand Vanrie wrote: The model must have a Height and Width property ? Changing this only seems to enlarge the background colour. The Check Box itself DOES NOT change in size!! Maybe Dan is right and there is no way to do this in which case it should be put on a 'Wish List' somewhere!!?? Thanks IanW Pretoria RSA -- 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: Using a Button to activate Subform. Relationships
Thank you Dan and Alex!!! This is the kind of help I was needing to understand the problem. I knew one of you DB Boffins would point me in the right direction. Dan I will try your method but first I must investigate what Alex says about MyISAM and InnoDB. So - That leaves me now with two questions ... 1) Dan - can you give me an address/link for the Base Tutorial by Mariano Casanova you mention?? 2) Alex - I have checked my DB with MyAdmin and I'm on MySQL 5.1.55 and the default Style is listed as MyISAM. So can I just change this with MyAdmin or is it a more deep seated problem?? VERY many thanks for the help IanW Pretoria RSA -- 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: Using a Button to activate Subform. Relationships
Thank you both (Dan and Alex) I will follow these routes. Appreciate the help!! IanW Pretoria RSA -- 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] Using a Button to activate Subform. Relationships
Hi All I posted the question below on the 13th but have seen no comments or replies. Surely someone has an idea or a thought on this?? Thanks a lot. On 13/04/13 17:29, Ian Whitfield wrote: Hi All You will have seen my question to Noel about Relationships and his reply. I just tried again as he suggested ... Open Relationship Window. Add my two Tables Click on 'New Relationship' (There are no fields listed) Select id in Main Table Select id in Second Table Press Close (Window does NOT close so press 'X' to close it) (There are NO lines or any other change to the Tables display in the Relations Window) Press Save Close Window Press Save again Open Main Form But I'm afraid the sub-Form does _NOT_ work still!! Can anyone see the error I can't see?? Thanks a lot. IanW Pretoria RSA -- 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