Re: [libreoffice-users] Mail Merge and Labels
I have just done my labels too - only using Avery 8165 (I just happened to have some in the drawer) It worked find, but I too found the printing started right on the edge - and I couldn't see any way to change this other than adding spaces manually. I had to add a blank line at the top for the same reason. Or is there a way that I have missed? On 5 December 2013 23:37, Jeff Hahn hahn...@outlook.com wrote: I use LO 4.1.3 and Windows 7. I should repeat that in my case the first 2 columns print properly (although the print starts right at the edge of the label). It is only the third (right) column that is off. Jeff Hahn From: cuyfa...@hotmail.com To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels Date: Thu, 5 Dec 2013 12:31:46 -0500 I just noticed this thread, and I have to chime in that, the last time I tried to create labels, I too noticed that the LO Avery 5160 template alignment was off. I had to adjust the contents of every cell. At that time, I was still using LO 3.5.x. I have not yet tried since upgrading to the 4.x.x range. At the time, I just installed Apache OO, as its template worked properly. If I recall correctly, I think there may have been other label templates online as extensions that worked better than LO's label template. Virgil -Original Message- From: Niklas Johansson Sent: Thursday, December 05, 2013 12:20 PM To: Jeff Hahn ; users@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels So I looked at the configuration in LibreOffice 4.0.6 and LibreOffice 4.2 beta-version and the configuration seems to be correct. I even compared it to the result that I get in Word 2013 for the same label (sorry for not thinking about doing that earlier). So before I put anymore time into this it would be good to know what version of LibreOffice you used when you created the labels? Niklas Johansson Jeff Hahn skrev 2013-12-05 17:22: I think the configuration in the wizard may be wrong. The Avery 5160 has 30 labels on a 8.5 x 11 sheet each measuring 1 x 2 5/8. It is probably one of the most common labels used so I am surprised the issue hasn't previously been raised. As I indicated in my email, I didn't have any problem when I switched to Word so I am reasonably confident the issue is not related to my printer. Jeff Hahn Date: Thu, 5 Dec 2013 17:04:24 +0100 From: sleeping.pil...@gmail.com To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels Hi Jeff Is the issue that you used lable sheets of the type Avery 5160 and that the preconfiguration for these lables were wrong? I think that I remember reading some issues with the label functionality (File - New - Label) in an earlier version of LibreOffice that might or might not be fixed in newer versions. What version of LibreOffice did you use? Do you have any specifications for the measurements of these specific labels so I can do a quick review if there seems to be any issues there? Note also that you can tweak the measurements under the Format tab of the Labels-dialog. Not that you should need to if you use labels that has a preset configuration. Kind regards, Niklas Johansson Jeff Hahn wrote 2013-12-04 16:41: I tried to do my labels for Christmas cards using LO's mail merge. I was able to create the data base and print without difficulty. Unfortunately, the entire third column was not properly spaced and printed outside of the label, a couple of spaces to the left. The first two columns were they were supposed to be. I was using standard configuration for Avery 5160. I finally gave up created the labels with Excel and Word. I am not sure where to send an email to suggest that the matter be looked into so I am sending this information to this list with the hope the matter will be picked for investigation. Also, although I suspect it has been suggested before, it would be nice to be able to do a mail merge directly from the spreadsheet without creating a database file. Jeff Hahn -- 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:
Re: [libreoffice-users] Change key
Try Tools Customise Keyboard from within Writer. Watch for the radio buttons top right that change the scope between just Writer and all of LO. John On 14 January 2013 08:37, Jaap Bosman j...@xs4all.nl wrote: I need to change keys because function keys do not work on my keyboard. Want ctrl F to be the key to open Navigator. Did change this in ExtraChangeKeyboard, but this does not work. Question: How to change keys in Writer? (OSX 10.7.5, Libreoffice Versie 3.6.4.3 (Bouw-id: 2ef5aff) thanks Jaap -- / -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Is it possible to show cell value with text
This was a thread from 5th November which I answered to the group. He thanked me but got fooled by the stupid group reply settings. On 11 November 2012 16:24, Dan Lewis elderdanle...@gmail.com wrote: On 11/11/2012 11:03 AM, dave_ wrote: Thanks for the solution. -- View this message in context: http://nabble.** documentfoundation.org/Is-it-**possible-to-show-cell-value-** with-text-tp4016842p4018036.**htmlhttp://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842p4018036.html Sent from the Users mailing list archive at Nabble.com. How can we give you a solution when you have not yet given us the problem? It appears that you are using Calc. But what to you mean by show cell value? Where is the text located? Are you referring to a cell containing twenty-seven rather than 27 for example? Or perhaps ten november two thousand twelve instead of 10 Nov 2012 or Nov 10, 2012? Please be more specific. --Dan -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Is it possible to show cell value with text
The concatenates text strings whereas + tries to add them and fails! On 12 November 2012 04:28, Viral Orpe viral.o...@yahoo.com wrote: Hi John, Checked your reply on list-archives :) Somehow must have missed on 6th Nov when it first appeared. Please, what is the stand for? Dave_ had asked the question with a + So, I guess this is some standard way of doing things(name?) with slightly diff syntax. I have never known it can be done that way - text and formula together in a cell. I have always used adjacent cells - one with the text part and another with the formula. Any pointers would be great. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS: Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- -- *From:* John Clegg john.cl...@nailsea.net *To:* Dan Lewis elderdanle...@gmail.com *Cc:* users@global.libreoffice.org users@global.libreoffice.org *Sent:* Sunday, November 11, 2012 9:59 PM *Subject:* Re: [libreoffice-users] Re: Is it possible to show cell value with text This was a thread from 5th November which I answered to the group. He thanked me but got fooled by the stupid group reply settings. On 11 November 2012 16:24, Dan Lewis elderdanle...@gmail.com wrote: On 11/11/2012 11:03 AM, dave_ wrote: Thanks for the solution. -- View this message in context: http://nabble.** documentfoundation.org/Is-it-**possible-to-show-cell-value-** with-text-tp4016842p4018036.**html http://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842p4018036.html Sent from the Users mailing list archive at Nabble.comhttp://nabble.com/ . How can we give you a solution when you have not yet given us the problem? It appears that you are using Calc. But what to you mean by show cell value? Where is the text located? Are you referring to a cell containing twenty-seven rather than 27 for example? Or perhaps ten november two thousand twelve instead of 10 Nov 2012 or Nov 10, 2012? Please be more specific. --Dan -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/ http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/ http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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] Connecting LO Base to an SQL DB [SOLVED]
The way I extracted my data was to right-click on each table and copy, and then open a new spreadsheet and paste. Once in the spreadsheet you can then save as CSV for easy importing into MYSQL. On 6 November 2012 10:10, Ian Whitfield whitfi...@telkomsa.net wrote: On 11/06/2012 11:34 AM, Pertti Rönnberg wrote: Hello LibO experts, and congratulations IanW! It has been very interesting to follow this discussion getting Base working with MySQL. Unfortunately -- if I got it right - is Ian's OS a Linux (Ubuntu?) Would it be possible to get the same proceeding described as a step-by-step instruction for Windows7 (64bit)? in plain english (no IT-jargong) starting from the very beginning defining the different programs (versions) and components (ODBC, JDBC, JRE, etc when needed, included) to be installed Hi Pertti Noted on your comments!! Unfortunately I'm running PCLinuxOS here and NOT Windows!! (I'm sure you will be told to move by someone!!). So I don't think it's any use me sending you the steps I went through. I did however have the same situation here and over the past 8 months or so this was the fourth attempt at getting it working. In the past I gave up after several days of thrashing about and went back to Base/HSQL until it crashed on me again and so on and so on This time I decided to hold out and work it through to the very end!! There were many things to learn and lots of Hoops to jump through but we got there in the end thanks to the aforementioned Members of the Forum (thanks again Guys!!) I'm sure somebody WILL pop up and try and help you out - just stay with it, one step at a time, and you'll get there in the end. VERY early days here but so far it looks good and I have a good feeling about Base/MySQL. I'm stuck at the moment though trying to extract my data from the old DB!!! Whatever I try it just crashes on me. (Grrr). The saga continues and I will be VERY glad to be shot of Base/HSQL!!! All the best IanW Pretoria RSA. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Is it possible to show cell value with text
Nice easy one that! You were nearly there: =Number of errors are(SUM(A1:A3) .) On 5 November 2012 06:06, dave_ dave.wagne...@gmail.com wrote: Is it possble to do the following: Lets say a1 =5, a2=3 and a3=7, now in cell c1 I would like a message to say Number of errors are + (=sum(a1:a3) +. Number of errors are 15. Is this even possible? Thanks ahead for any suggestions. -- View this message in context: http://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base - need to re-point a form
OK, all fixed at last - by a clunky method, but hey - it worked! I had the data in a CSV so I loaded that into an ODS sheet, then pasted from there into a new table via Base, creating a new primary index in the process. That worked! On 19 October 2012 16:52, V Stuart Foote vstuart.fo...@utsa.edu wrote: Perhaps a Windows environment issue? See this thread (and similar) at StackOverflow on the SE: http://stackoverflow.com/questions/2259718/mysql-environment-variable-on-windows Stuart From: John Clegg [mailto:john.cl...@nailsea.net] Sent: Fri 10/19/2012 10:04 AM To: jomali Cc: Alexander Thurgood; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Base - need to re-point a form Really? Mine doesn't On 19 October 2012 15:55, jomali jomali3...@gmail.com wrote: What are you talking about? Of course there is a command line interface to MySQL in Windows. I use it all the time. Just go to Run and type mysql in the Open: box. You'll get a Command prompt with mysql command line ready to go. John On Fri, Oct 19, 2012 at 9:23 AM, John Clegg john.cl...@nailsea.net wrote: Hm It isn't quite that simple in Windows (no command line mysql client) but I tried HeidiSQL and I can connect and amend data with no problems -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base - need to re-point a form
No, the ODB is on a local NTFS volume The problem with the ODBC version is that Base can't download the table structure from the server for some reason. The JDBC version can but can't r/w. Which all suggests to me some dodgy MySQL connectors To check that I set up another MySQL server elsewhere and had exactly the same problem with the JDBC connector. I suppose I could set up a local MySQL server but I don't want it local! And I suspect I might hit the same problem anyway. Very frustrating! On 19 October 2012 09:46, Alex Thurgood alex.thurg...@gmail.com wrote: On 10/18/2012 03:49 PM, John Clegg wrote: Hi John, Update - I have now tried connecting with ODBC (MySQL 3.5.1, Win7) rather than JDBC. The table now becomes editable, but when I make a change I can't save because I get a message that nothing has changed! Shot in the dark - the ODB file isn't on a SMB/CIFS or NFS server or network storage ? Unfortunately, I can't reproduce your problem from a general point of view - yesterday I managed to set up a JDBC ConnectorJ connection to a locally hosted mysql db on WIndows XP and LO 3.6.1 and can edit the data and have it saved no problem. So, it must be something specific to your setup, or the ODB file itself. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Suitability of Lo in Small organisations
I am a small organisation using 3.6.2 and I find it pretty well bug free in the bits we use! On 19 October 2012 10:17, Mirosław Zalewski mini...@poczta.onet.pl wrote: On 19/10/2012 at 10:30, Tom Davies tomdavie...@yahoo.co.uk wrote: Luckily you can't really go wrong now that the 3.6.3 is out. 3.6.3 has not been released yet. It's only rc1 that is available. LO website clearly state that this version is not meant for production use. -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base - need to re-point a form
OK, thanks for that. Using LO 3.6.2 on Windows 7SP1 (also linux, but let's get it working here first!). Connecting to a database on xeround.com (actually hosted on Amazon EC2 servers, using port 18993. JDBC driver class com.mysql.jdbc.Driver using mysql-connector-java-5.1.22-bin.jar John On 19 October 2012 13:16, Alexander Thurgood alex.thurg...@gmail.comwrote: Hi John, Le 19/10/12 11:09, John Clegg a écrit : The problem with the ODBC version is that Base can't download the table structure from the server for some reason. The JDBC version can but can't r/w. Which all suggests to me some dodgy MySQL connectors There are some known issues with ODBC connectors, some of which cause crashes, or data access problems, depending on which version of LO you are using and which version of the MySQL ODBC Connector. Remember, LO is 32bit, even on Windows 64bit OS, so it requires a 32bit ODBC connector. This is also a major problem on OSX, where : - current versions of the OS are 64bit only as are the included mysql servers ; - LO is only 32bit ; - OSX can't manage a 32bit and 64bit mysql connector at the same time (or at least if it can, I've found no way to get it to behave properly), so users are stuffed when it comes to MyODBC on Mac OSX unless they are using a 32bit OS, i.e. Leopard or older..., or Snow Leopard in 32bit kernel mode... On Linux, the ODBC connector and LO are available in 32 and 64 bit incarnations, so it is possible to get something up and running. All versions of LO have had problems accessing remote database instances via ODBC, especially if your db server is on the internet. To check that I set up another MySQL server elsewhere and had exactly the same problem with the JDBC connector. I suppose I could set up a local MySQL server but I don't want it local! And I suspect I might hit the same problem anyway. No, I suspect that your problem is precisely because your mysql server is not local, or at least, not on the local lan (if I have understood your implied setup correctly). I don't have any problem accessing a LAN hosted mysql server instance over the mysql JDBC connector. Trying that over the internet is a whole other ballgame though. You need to have remote user access to your mysql server instance other than through port 80, which is not always (rarely, other than by SSH) provided for by hosting services. On top of that, DNS resolution issues can cause timeouts. It might be helpful if you gave us the exact setup you are trying to put into place, with version numbers for the different components. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base - need to re-point a form
Hm It isn't quite that simple in Windows (no command line mysql client) but I tried HeidiSQL and I can connect and amend data with no problems On 19 October 2012 13:44, Alexander Thurgood alex.thurg...@gmail.comwrote: Hi John, Le 19/10/12 14:25, John Clegg a écrit : OK, thanks for that. Using LO 3.6.2 on Windows 7SP1 (also linux, but let's get it working here first!). Connecting to a database on xeround.com (actually hosted on Amazon EC2 servers, using port 18993. JDBC driver class com.mysql.jdbc.Driver using mysql-connector-java-5.1.22-bin.jar Can you connect to that instance via the mysql client program from the command line interface and edit data in your tables on the remote instance ? mysql -h myhost -P myport -d mydb -u myuser -p mypassword Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base - need to re-point a form
Really? Mine doesn't On 19 October 2012 15:55, jomali jomali3...@gmail.com wrote: What are you talking about? Of course there is a command line interface to MySQL in Windows. I use it all the time. Just go to Run and type mysql in the Open: box. You'll get a Command prompt with mysql command line ready to go. John On Fri, Oct 19, 2012 at 9:23 AM, John Clegg john.cl...@nailsea.netwrote: Hm It isn't quite that simple in Windows (no command line mysql client) but I tried HeidiSQL and I can connect and amend data with no problems On 19 October 2012 13:44, Alexander Thurgood alex.thurg...@gmail.com wrote: Hi John, Le 19/10/12 14:25, John Clegg a écrit : OK, thanks for that. Using LO 3.6.2 on Windows 7SP1 (also linux, but let's get it working here first!). Connecting to a database on xeround.com (actually hosted on Amazon EC2 servers, using port 18993. JDBC driver class com.mysql.jdbc.Driver using mysql-connector-java-5.1.22-bin.jar Can you connect to that instance via the mysql client program from the command line interface and edit data in your tables on the remote instance ? mysql -h myhost -P myport -d mydb -u myuser -p mypassword Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base - need to re-point a form
OK, a supplementary if I may! I am accessing the remote MySQL database using com.mysql.jdbc.Driver. When I access the data by opening the table or using the form it is read-only. Any ideas again? John On 17 October 2012 20:25, John Clegg john.cl...@nailsea.net wrote: I have a base file attached to a MySQL database on a remote server. I have a form that I use to view and edit the data in one table. Others also access the database, and I need to experiment with the data in that table without molesting the master copy. One solution would be to make a complete copy of the database, but as I want to make copies of the main table many times a day that would be a laborious solution It is easy to make a duplicate of the main table within the database, and also easy to make a copy of the form in the base file, but what I need to do now is point the copy of the form at the copy of the table. I thought it might be possible to open the odb file as a zip file and find the form data containing the table name somewhere in it, and edit it to the copy table name, but I haven't succeeded yet. Does anybody know if this is possible - or even if there is a much easier way? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base - need to re-point a form
That's pretty comprehensive, thanks! I will work through those. Regards john On 18 October 2012 08:22, Alex Thurgood alex.thurg...@gmail.com wrote: On 10/18/2012 08:02 AM, John Clegg wrote: Hi John, I am accessing the remote MySQL database using com.mysql.jdbc.Driver. When I access the data by opening the table or using the form it is read-only. Any ideas again? Several possible reasons : - no primary key field defined in your table, but I guess you would have noticed that before, with your previous attempts to edit the data from within LO Base ; - a field in your table that LO can not parse - unfortunately, some data types, whilst in theory recognised by the driver in other circumstances, i.e. with other software, are not recognised by LO's data type parser, for the lack of them being defined in the handling code. One such example are certain binary objects. At present CLOB support is limited to images in LO ; - a corrupt or misconfigured ODB file : it may be that changing your table source has confused LO's database registration code and caused it mark the table as read only, or alternatively, if it points to a separated database, then the ODB configuration needs to be reset to correspond to the new database in addition to the new table (this is just speculation on my part) ; - a bug in the version of LO you are using. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base - need to re-point a form
Thanks. This is a fairly new connection, so I can't be sure it has ever had read/write. I know it's read-only because if I open the table and click Edit everything is greyed out except Copy. And if I access data via the form I can't change anything. I can access the data via phpMyAdmin and make changes. I have added a primary key this way, but I'm not sure that Base is seeing that - there is no sign of it if I edit the table structure in Base. On 18 October 2012 08:53, Mark Stanton m...@vowleyfarm.co.uk wrote: Is this after you've switched to using a different copy? It sounds like you have had read/write access in the past, is that right? If so, what changed? How do you know it's read only? If your form won't let you change the data it's a local issue, if you can save but it makes no difference presumably thems who are administering the MySQL have set something. Often the reason for having read only access through Base is that the table in question doesn't have a primary key defined, but if you've had write access before and nothing else has changed that would be unlikely. Regards Mark Stanton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base - need to re-point a form
It's a single field, integer and unique. And having been out and in again base can see the index now, but I still can't edit. On 18 October 2012 13:47, Alexander Thurgood alex.thurg...@gmail.comwrote: Le 18/10/12 11:46, John Clegg a écrit : Hi John, I can access the data via phpMyAdmin and make changes. I have added a primary key this way, but I'm not sure that Base is seeing that - there is no sign of it if I edit the table structure in Base. How is your primary key defined ? - single or multiple field ? Additionally, you might have to quit LO completely, and then reload the ODB file. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base - need to re-point a form
No, same user! On 18 October 2012 14:18, Alexander Thurgood alex.thurg...@gmail.comwrote: Le 18/10/12 15:10, John Clegg a écrit : It's a single field, integer and unique. And having been out and in again base can see the index now, but I still can't edit. Dumb question perhaps, but : user privileges ? Any difference between Base user and phpmyadmin user ? Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base - need to re-point a form
The structure is very simple - one integer field, indexed unique and 33 fields text(varchar) of varying lengths all unindexed. On 18 October 2012 14:22, Alexander Thurgood alex.thurg...@gmail.comwrote: Le 18/10/12 15:10, John Clegg a écrit : It's a single field, integer and unique. And having been out and in again base can see the index now, but I still can't edit. Can you post the table structure ? Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base - need to re-point a form
Update - I have now tried connecting with ODBC (MySQL 3.5.1, Win7) rather than JDBC. The table now becomes editable, but when I make a change I can't save because I get a message that nothing has changed! Am I jinxed?? On 18 October 2012 14:28, John Clegg john.cl...@nailsea.net wrote: The structure is very simple - one integer field, indexed unique and 33 fields text(varchar) of varying lengths all unindexed. On 18 October 2012 14:22, Alexander Thurgood alex.thurg...@gmail.comwrote: Le 18/10/12 15:10, John Clegg a écrit : It's a single field, integer and unique. And having been out and in again base can see the index now, but I still can't edit. Can you post the table structure ? Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Base - need to re-point a form
I have a base file attached to a MySQL database on a remote server. I have a form that I use to view and edit the data in one table. Others also access the database, and I need to experiment with the data in that table without molesting the master copy. One solution would be to make a complete copy of the database, but as I want to make copies of the main table many times a day that would be a laborious solution It is easy to make a duplicate of the main table within the database, and also easy to make a copy of the form in the base file, but what I need to do now is point the copy of the form at the copy of the table. I thought it might be possible to open the odb file as a zip file and find the form data containing the table name somewhere in it, and edit it to the copy table name, but I haven't succeeded yet. Does anybody know if this is possible - or even if there is a much easier way? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base - need to re-point a form
That's exactly what I wanted and couldn't find anywhere! I'm very grateful John On 17 October 2012 21:14, Girvin R. Herr girvin.h...@sbcglobal.net wrote: John Clegg wrote: I have a base file attached to a MySQL database on a remote server. I have a form that I use to view and edit the data in one table. Others also access the database, and I need to experiment with the data in that table without molesting the master copy. One solution would be to make a complete copy of the database, but as I want to make copies of the main table many times a day that would be a laborious solution It is easy to make a duplicate of the main table within the database, and also easy to make a copy of the form in the base file, but what I need to do now is point the copy of the form at the copy of the table. I thought it might be possible to open the odb file as a zip file and find the form data containing the table name somewhere in it, and edit it to the copy table name, but I haven't succeeded yet. Does anybody know if this is possible - or even if there is a much easier way? John, I am assuming you need to change the table that your form points to. You can do this by: 1. Bring up your form in edit mode (right click on form name and select Edit.) 2. Select the Form Properties window (this is the icon that looks like a window with 2 buttons with an arrow pointing to it, and with a help balloon that says Form. 3. In the popup window, select the Data tab. 4. Change the Content box to the table you want to use from the list. If the new table's column (control) names are different, you will have to change those too in the form editor. You do that by Ctrl-left-clicking on the form's control box and selecting its Data tab and selecting the new name from the list derived from your new table. Do that for each control that has a different name from your old table. Hope this helps. Girvin Herr -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Integer part of a number
Indeed. Which is why your last answer is also wrong! On 15 October 2012 15:08, Andreas Säger ville...@t-online.de wrote: Am 15.10.2012 10:45, Brian Barker wrote: At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote: On 14.10.2012 12:20, Gilles SICHE wrote: could anyone tell me which formula I should use for the integer part of a cell to be shown in another cell, ... The answer could be: =IF(C31;0;INT(C3)) You are overthinking the problem: if C3 is positive, that's no different from =INT(C3) Brian Barker Reportedly, negative numbers do exist. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] pcl overlay
+1 to that. And I believe he may be referring to a watermark - but I have no idea how to do it! On 10 October 2012 09:08, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) I often grumble so this time i wanted to draw attention to some excellent behaviour on the users list. Most times, in most projects, a question written in anything other than English on an 'International' list illicits a lot of telling-off from various people. I think this time the response was unusually excellent. 1. There is a direct link so the person can copypaste their question to the right list easily 2. That message is translated so the list understands the action taken 3. There is a neat translation of the question so the list can understand. So, now if someone does know the answer to the question they can answer in English (or French) and we can take it from there. This raises the bar significant;y. It makes our list look like an extremely professional customer support list. Regards from Tom :) --- On Wed, 10/10/12, Jean-Francois Nifenecker jean-francois.nifenec...@laposte.net wrote: From: Jean-Francois Nifenecker jean-francois.nifenec...@laposte.net Subject: Re: [libreoffice-users] pcl overlay To: users@global.libreoffice.org Date: Wednesday, 10 October, 2012, 8:53 Hello Hervé, [EN version follows] Le 10/10/2012 09:24, hs...@villeneuvedascq.fr a écrit : je souhaite avoir un fond de page en overlay avec word on peut utiliser un champ imprimer et y mettre une sequence PCL comment faire avec LibreOffice cette liste est anglophone. Les questions doivent donc y être posées en anglais. Il existe également une liste francophone : us...@fr.libreoffice.org [EN] This list is english-speaking, thus you should ask questions here in English. There exists a francophone list: us...@fr.libreoffice.org Here's a translation of Hervé's question (which I don't understand ;) 8 - I wish to get an overlaid page background. With Word one may use a print field and set a PCL sequence there. How can I do this using LibO? - 8 Best regards, -- Jean-Francois Nifenecker, Bordeaux -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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: MS raised prices so people will now start renting their office products instead
Forgive me, but I thought one of the aims of LO was improvements to usability. I open emails mailed to me dozens of times a day. Doing Save-As, or clicking the edit button takes little time I agree, but why is it so wrong to desire that as the default to save me time? On 9 October 2012 10:18, Andreas Säger ville...@t-online.de wrote: Am 09.10.2012 09:14, Marcello Romani wrote: Il 08/10/2012 14:13, John Clegg ha scritto: OK, if I accept everything that has been said, then why wouldn't opening an in-memory r/w copy be the sensible default action? So that when the user would try to save it a Save As dialog would appear ? Sounds good to me. Again, it is not the office program which creates read-only files. In most cases some other application calls the office to *view* some document. In most cases the office is called by a browser, mail client or cloud application to view online content or mail attachments. There are many reasons why this application has a viewing mode. It must not open some document in unsaved template mode just because the file is read-only. That would be extremely annoying for many users. Most of our ODF documents (documentations, print-outs, database forms, reports) are strictly read-only because only one person (me, the file owner) is supposed to modify these. The co-workers can work with the contained material (read, print, mail as PDF, edit databases through forms). All you've got to do is hitting the edit button in order to get an editable new and unsaved document. All you've got to do is saving the same document in your own file system in order to get your own editable copy of the document. Some Microsoft feature carries over the read-only flag when an application saves a document under another name. I'd call this a bug. No other file system behaves that silly. You need to turn it off in the file properties (right-click file in Win ExplorerProperties...). There is also an internal read-only mode implemented in the office program (FileSave As... save with password, open read-only with password). But that is another story. The internal flag within the document does not protect the file from being manipulated by other applications and the read-only status is carried with every copy of the file. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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: MS raised prices so people will now start renting their office products instead
OK, if I accept everything that has been said, then why wouldn't opening an in-memory r/w copy be the sensible default action? On 8 October 2012 13:08, Marcello Romani mrom...@ottotecnica.com wrote: Il 05/10/2012 17:18, Marcello Romani ha scritto: Il 05/10/2012 16:31, webmaster-Kracked_P_P ha scritto: On 10/05/2012 10:10 AM, Marcello Romani wrote: Il 05/10/2012 11:07, John Clegg ha scritto: One feature I miss isn't actually a feature in MSO as such, but LO behaves differently. If I open a spreadsheet from an email or the web it places a copy in the download folder/directory and Calc always opens it read-only whereas Excel opens it as read-write. I would like at least an option to get Calc to open it as read-write. To do so I have to save a copy before I start, and as I do this around 100 times a day it becomes quite an irritant. It's just a modify document button click away. But I guess it's more a problem of the web browser or e-mail client rather than OOo/LibO as such. The browser / e-mail client puts a read-only file in the user temp folder, then passes its full path to OOo/LibO for reading. OOo/LibO will just notice it's a readonly file and will behave accordingly. Hopefully someone with more technicall indsight into this can confirm or correct me ? This open as a read only is a security feature from before LO came out. I remembering it doing the same with OpenOffice.org and MSO-2003. The file, at least with Thunderbird, that come in an email attachment is stored in a TEMP folder. Those files are, by nature, read-only till they get saved outside the TEMP [/tmp for Linux] folder. I know it is a hassle for people but I really do not want to have any email attachments placed in a normal data folder without me saving it there. That way I control what gets saved from the email and then all the other stuff is removed with the deletion cycle of the email client's TEMP folder content. We must think safety first and deal with the hassles like this, or could suffer a email that places their attachment file anywhere it wants to be and may be overwrite a working file with the same name or worse a system file. If those files weren't read only there would be other, more serious complaints from users (I had one). The user would doubleclick on an attachment and have it open r/w in OOo/LibO/MSO. He would start modifying it right away (no hassle!), then save it. Then close the word processor and forget about it. Then after a little while go to the IT guy asking where the hell is that document that he just saved. Being readonly, instead, forces the user to click on that damned icon, so the program produces an in-memory r/w copy of the document that will trigger a save as procedure when the user would click save. There was a missing bit in my description: if the attachment would be opened R/W, the file would be saved in the user's temp folder. So it would be lost at best, or in worst case scenario deleted as temp folders gets cleaned. -- Marcello Romani -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
Whilst a condom is always wise I still prefer to put it on for myself On 6 October 2012 18:13, Jay Lozier jsloz...@gmail.com wrote: On 10/06/2012 11:37 AM, Spencer Graves wrote: On 10/6/2012 6:13 AM, Andreas Säger wrote: Am 05.10.2012 14:09, John Clegg wrote: I thought LO was emulating MSO 97?? Read-only is the only sensible way to open other people's files (web downloads, mail attachments). Why? What if I want to edit it? Are you outlawing collaborative work? I'm confused. Spencer Spencer Usually Save As 'will allow you to create an editable version. The issue is security and balancing usefulness and safety. If you are only allowed to open with limited privileges (no macro execution or editing) the possibility of infecting your computer unintentionally with malware is lessened considerably. This gives the users a chance to verify before granting full privileges on their computers. Having cleaned serious malware infections on friends and coworkers computers; the inconvenience is worth the protection. It is not perfect but puts another step in the way of disaster. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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: MS raised prices so people will now start renting their office products instead
One feature I miss isn't actually a feature in MSO as such, but LO behaves differently. If I open a spreadsheet from an email or the web it places a copy in the download folder/directory and Calc always opens it read-only whereas Excel opens it as read-write. I would like at least an option to get Calc to open it as read-write. To do so I have to save a copy before I start, and as I do this around 100 times a day it becomes quite an irritant. On 5 October 2012 10:00, Mirosław Zalewski mini...@poczta.onet.pl wrote: On 04/10/2012 at 12:54, rost52 bugquestcon...@online.de wrote: I am missing (compared to MSO) a few features in IMPRESS badly Could you tell which features do you mean, exactly? I am always interested in such comparisons. People all over the web say LO is missing some features, but such statements tend to not be supported by descriptions of features in question. -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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: MS raised prices so people will now start renting their office products instead
I thought LO was emulating MSO 97?? On 5 October 2012 13:00, Gordon Burgess-Parker gbpli...@gmail.com wrote: On 05/10/12 10:07, John Clegg wrote: whereas Excel opens it as read-write. That behaviour has changed in MS Office 2010 - email attachments are opened as read-only by default.. -- Registered Linux User no 240308 GBP's alternative computing:http://gbplinuxfoss.**blogspot.com/http://gbplinuxfoss.blogspot.com/ Say No to OOXMLhttp:// www.linuxjournal.**com/article/9594#mpart8http://www.linuxjournal.com/article/9594#mpart8 I only accept odf or pdf documents by email -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] documentation for LO base
I am going to stick my head above the parapet and say it should have an embedded database functionality that is secure and reliable. That is an essential requirement for entry-level users that have only ever used Access. On 5 October 2012 13:34, Pertti Rönnberg p...@elisanet.fi wrote: Hi everybody, I agree with Mark. The question itself is interesting but an answer does not explain anything relevant. Let us turn the question around:how many people should use LO-Base if there was a LibO-version available that is ready to use, reliable, and free of problems (bugs). If its installing instructions should be complete, consequent, and placed in one easy to find place the program's every single detail should work -- functions, features, processes at a level (e.g.) similar to MSAccess (2003) --the ability to build decent reports included (and the embedded db-engine and its guides up-dated and supported) the guiding documentation ( help) should be logic, understandable and in every detail correlating with the program With the exception of heavy industrial systems the need and possibilities of up to medium complex databases in everyday life at home are unlimited -- only limited by the decision to start creating. There are really nothing difficult in creating such home databases-- no need to be an Einstein, if only good guidings are available. Creating database applications is also a very interesting form of brain training -- and the feeling when succeeding is a yippee. If you know how to use Writer/Word and Calc/Excel (esp. as databases) you are almost half way. What you still has to do is to study and learn some few basic theories about and how to create the tables and the queries(experiment manually, not with wizards, if you want to learn and understand);creating the forms and the reports is just a matter of following instructions. If you want LibO to be a popular competitor to MSO ( MSAccess), then the rest is only a question of marketing. As far as I have experienced LibO-Base (v. 3.4.5), there are only a few details left to fixed before LibO should be almost perfect. About contributing A basic rule in quality systems (ISO9000) is that if you want improvement you must first identify the problems (faults, weaknesses) -- and then follow up by a plan and an improving activity. LibO might be a very fine and usable suit -- especially if also its Base module (docs included) should work properly, at least as promised in introductions. Mr Dan Lewis is doing a good and valuable work when updating and completing the Base's documentation and it is obvious that without any help his project will take a long time. Last winter I started to read and follow up experimenting Dan's docs with the intension to send my comments as points of views. And hadquite a lot already done. At this list I several times also mentioned some quite basic problems/faults both in Base's docs and especially in the modules's features. I never got any kind of response, I don' t know if my proposals were noticed, nor do I know if the mentioned things have been fixed. So I skipped working any further on experimenting LibO-Base and its docs. (I am now back to OO and tries to learn MySQL) You may take this as some sort of a contribution too. Best regards Pertti Rönnberg On 4.10.2012 18:04, Mark Stanton wrote: Question: How many people do you know use Base, or have tried to use Base? Whilst there is some quite valid criticism of Base, I don't think answering this question says as much about Base as it does about the general usage of databases. They are less familiar than word processors, spreadsheets or drawing packages. Mark -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Update SQL does nothing using Run SQL directly button
That button, according to the help file, toggles whether the SQL is passed directly to the database engine or handled by Base first. I'm not quite sure what that means in effect! On 5 October 2012 18:12, David S. Crampton david_cramp...@ie2b.com wrote: John and the others who responded, It took me a while to realize that the useful SQL menu is available only on the main / opening window of the db. The SQL button in the Query Design view still appears to do nothing. I'm finally getting some traction. I acknowledge and appreciate the stylistic suggestions. This year and month data is very unlikely to change once the transaction record is accurately entered. Thank you, all, David - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/Update-SQL-does-nothing-using-Run-SQL-directly-button-tp4010902p4011374.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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] Opening hybrid pdf in LO 3.6.0.2 results in gibberish
I did exactly what it says - ie downloaded it, then ran LO and did File Open and selected the downloaded file. It opened in Draw and was all there and legible. LO 3.6.1 on Win7 On 4 October 2012 15:02, Gordon Burgess-Parker gbpli...@gmail.com wrote: I downloaded the hybrid pdf from here http://blog.** documentfoundation.org/2012/**07/17/libreoffice-**infographics/http://blog.documentfoundation.org/2012/07/17/libreoffice-infographics/and tried to open in LO as it said at the bottom of the page. All I get is a load of gibberish. The hybrid pdf opens OK in a PDF reader -- Registered Linux User no 240308 GBP's alternative computing:http://gbplinuxfoss.**blogspot.com/http://gbplinuxfoss.blogspot.com/ Say No to OOXMLhttp:// www.linuxjournal.**com/article/9594#mpart8http://www.linuxjournal.com/article/9594#mpart8 I only accept odf or pdf documents by email -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] PROPER function in Calc
I have just discovered that applying the PROPER function to st george's in Calc gives St George'S Now would that be considered to be a bug, or just a rather annoying feature?? LO3.6.1 on Windows 7 and 3.5.4.2 on Ubuntu 12.04 -- 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] PROPER function in Calc
Sorry, I should have checked. It is 53146 On 3 October 2012 16:19, Joel Madero jmadero@gmail.com wrote: That would be a bug, and I've confirmed it. Might already be on bugzilla. bugs.freedesktop.org If it's not there, go ahead and report it, definitely a relatively easy thing to fix. Regards, Joel On Wed, Oct 3, 2012 at 8:16 AM, John Clegg john.cl...@nailsea.net wrote: I have just discovered that applying the PROPER function to st george's in Calc gives St George'S Now would that be considered to be a bug, or just a rather annoying feature?? LO3.6.1 on Windows 7 and 3.5.4.2 on Ubuntu 12.04 -- 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 -- *Joel Madero* LibO QA Volunteer jmadero@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Update SQL does nothing using Run SQL directly button
Base will only run SELECT statements that way. If you want to use other than SELECT the only way IIRC is to use Tools-SQL which opens Execute SQL statement but can only handle typed stuff, not stored queries. It is useful for one-off tasks such as merging two tables into one or doing a field update as you describe. On 4 October 2012 00:27, David S. Crampton david_cramp...@ie2b.com wrote: Register1a is a table with field Trans-Date of type TIMESTAMP. Field Trans-Date-Year is either TIMESTAMP or INTERGER. I have tried with both. Update Register1a Set Register1a.Trans-Date-Year = YEAR(Register1a.Trans-Date); Looks like is should be a very simple SQL statement. It does absolutely nothing. The statement won't run with the F5 key (the run button). It gives The given command is not a SELECT statement. I'm trying to apply SQL learned elsewhere, mostly in MicroBloat Access, and I'm getting nowhere. Help will be appreciated. David - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/Update-SQL-does-nothing-using-Run-SQL-directly-button-tp4010902.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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] Can Calc read/import data from Google Docs?
But it's so easy! In Google Docs open the spreadsheet and select File, Download as, ODS. That's it! John On 27 September 2012 20:57, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Ok, this is probably not what you are looking for but just to clear the idea out of the way ... Can you just open the google-docs spreadsheet and save it onto your computer? Then just double-clicking on it should open it in Calc. Google-docs uses the same native format as LO but both can save as .xls or .xlsX (MS formats) and Google-docs might do that by default. If Google-docs does that instead of saving in native .odS then you can probably choose OpenDocument Format from Google-doc's Save As ... menu. Double-clicking on the .ods almost definitely opens the file in Calc. Alternatively if it has saved as .xls or .xlsX then right-click the file and choose Open With and then try to find Calc or LibreOffice in that menu. This approach is slightly different in different OSes but is roughly the same in all except Apples. A similar alternative is to open Calc (or just LibreOffice) and then dragdrop the file onto it. This approach will definitely work whatever format it's in unless something really weird is going on in which case tells us and we might be able to figure it out. However i have a feeling that you don't want to download the file at all and just want LO to dynamically read the Google-docs spreadsheet while other people are editing the google-docs spreadsheet. If so then i think there is a far better answer but it involves using Base at your end and having a proper database on a server somewhere. So, the question is do you want to do this with static data (as in my first 4 paragraphs), or dynamically changing data? Regards from Tom :) From: Michael Reich reich.mi...@gmail.com To: users@global.libreoffice.org Sent: Thursday, 27 September 2012, 18:24 Subject: [libreoffice-users] Can Calc read/import data from Google Docs? I'm trying to figure out if I can have a Calc (OpenOffice or LibreOffice) spreadsheet import data from a Google Docs spreadsheet. The online assistance via google search is very confusing and seems mostly oriented toward importing data to Google Docs. What I want is a local sheet that can pull several cells of info (like names and addresses) from a Google Docs spreadsheet, but I can't figure out what function and syntax, if any, can do this in OO or LO. Is this possible to do? If so, I apparently need the idiot's instructions. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: python reading calc
Andreas - why are you always so grumpy?? Chill ! On 24 September 2012 08:16, Andreas Säger ville...@t-online.de wrote: Instead of running tests, how about debugging your program and reading some documentation? -- View this message in context: http://nabble.documentfoundation.org/python-reading-calc-tp4008804p4008939.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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: MS raised prices so people will now start renting their office products instead
I think this is a very fair point. Versions of Ubuntu have an LTS version without stopping the development chain progress. It would be really useful to have a really mature and settled LTS version of LO that businesses could use with confidence. On 20 September 2012 12:06, Pertti Rönnberg p...@elisanet.fi wrote: Dear mr Webmaster, I agree with you about the risks with Microsoft's possible actions in the future -- let us hope we are wrong. I am afraid you got me wrong -- my fault. What I meant by the break in developing LibO, was that the LibO's developers for a while should stop proceeding. They must take one specific version of LibO (especially for Windows as the main OS) and make it absolutely free of bugs and failures -- and plus that make the documentations complete and understandable (and thus usable) for ordinary non-expert computer users. And then - after that - continue again. Why? Because I have been a Windows user since early -80 and installed OpenO decades ago. Last January this year I downloaded LibO (3.4.5) with the main intention to use Base -- but experienced that much problems - first with the installing JRE and then with many basic functions and especially with the embedded HDBSQL and especially with the quite horrible unlogical documentations -- that I have given up. I am quite sure that I am not alone! Since January I have followed the discussions on this list and am getting even more convinced that LibO is not really meant for ordinary people as an alternative to MSO. It seems mainly to be a playground for a group of open-source enthusiasts with a language of their own. Whom are the new features and finesses meant for, when there is no general info about them and no guiding documentation until 3-4 version generations later? Meanwhile they have only caused problems. When I download a what-ever program for my needs, I want it to work and to work stable and smoothly. I have no need nor time to struggle with different problems, to investigate and test different workarounds -- nor asking for help and waiting perhaps days for an answer that might help if I only happen to understand the advice. Frustration can easily be limited by paying to Microsoft. Best regards Pertti Rönnberg On 19.9.2012 21:48, webmaster-Kracked_P_P wrote: I have not bought any MSO past MSO-2003. I moved to OpenOffice.org [as soon as it read/saved .doc files] till LO 3.3.0 came out. Then I moved to LO for all my systems, Windows and Linux. Now I create/update the NA-DVD [http://libreoffice-na.us/** English-3.5-installs/index.**htmlhttp://libreoffice-na.us/English-3.5-installs/index.html] project and a 773,000 American Spelling Dictionary for LO. On 09/19/2012 01:11 PM, John Clegg wrote: Which is why I started migrating 3 months ago! I haven't had to go back once. On Sep 19, 2012 4:57 PM, webmaster-Kracked_P_P webmas...@krackedpress.com mailto:webmaster@**krackedpress.comwebmas...@krackedpress.com wrote: No, it is not a good idea to take a break. But it is time to tell those people who do use MSO that they are changing their pricing policy and almost forcing their users to rent their products in the near future. It is time that the users start thinking about their long term use of MS's Office and other business software. You no longer will be able to buy their products in any reasonable price, for MS that is, and not know if you rent it for X dollars for the first year, it will not go up to 150% of X dollars in year two. You will then have to pay their ransom or you loose the ability to use the software on your computer. Then there is the multi-license discount - or should it be the end of the multi-license discount. Businesses with 50 or 100 computers will be required to but a single user license for every computer at $150+ per license. The rental agreement plan is not that much better of an option. So now you can say that every computer they own can have a copy of LO for free. Every updated or new version of LO will be free, unlike MSO's policy. No need to rent or buy anything office suite package anymore. FREE now and FREE in the future. MSO just wants to force a user to pay them over and over for the same software, for as long as you live. Then when you die, you heirs will be forced to pay MS's blood money for the rest of their lives. This maybe a good plan as a revenue generation, but not for the users. On 09/19/2012 11:22 AM, Pertti Rönnberg wrote: Hi LiBO folks and especially LibO developers Microsoft's desicion to start renting their software puts ordinary people (and companies) in a fortune with very uncertain costs ahead. Should it not be now - if ever! - the perfect time for the LibO devs to take a break in developing new features
Re: [libreoffice-users] Help with Scoring Bi-nominal Responses
How about: T2 = 4 * (F2 AND (L2=3)) On 21 September 2012 06:34, Paul Anderson panders...@gmail.com wrote: Thanks to all for the previous help, Also, sorry if you have addressed this already, Brian. But, I know only basic functions within the spreadsheet and will request a more explanatory example. The file was delivered in xlsx format. I would like to maintain the format (using LibreOffice!), but I may have to look to other software. Here is an example of my first two rows of data, cells F23 through S23, with F1-S1 containing variable names *F* *G* *H* *I* *J* *K* *L* *M* *N* *O* *P* *Q* *R* *S* 0 1 0 1 0 0 1 0 0 0 0 0 0 0 1 0 1 1 0 0 1 0 0 0 1 0 0 0 Using a simple example with only two cells (F2L2), I want T2 to equal a 'score' based on a weighted index, like this: IF F2=0 then T2=0; else T2=T2+1; (Where F2 can only take on a value of 0 or 1) AND IF L2=0 OR L2=1 OR L2=2 then T2=T2+0; else T2=T2+3 (Where L2 can take on a value of 0,1,2,or 3) So that: T2 = 0 (if F2=0 and L2=0,1,or 2) OR T2 = 4 (if F2=1 and L2=3) I haven't been able to create the proper syntax for this simple two cell scoring. How can I not only score an individual cell but also link it with another cell in the same row? A simple demonstration will be adequate so that I can create my specific and more complicated function. I hope I have stated my needs in a clearer fashion this time around, and thanks to everyone for the previous help. Regards, -Paul On 9/19/2012 11:58 AM, Jean-Francois Nifenecker wrote: Le 19/09/2012 07:03, Paul Anderson a écrit : Hello all, I have a simple question for which I cannot find the answer. I have a LibreCalc spreadsheet containing binomial data for which I would like to create a final summed score (in Column T) based upon a manually specified score index. Columns F, G, H, J, K, M, N, O, P, O, and R contain pure binomial information (0 or 1) Columns I, L, and S contain multiple numbered responses: I = 0,1,3 L = 0,1,2,3 S = 0,1,2 I want to create a final score (Column T) based upon numerical responses (in Columns F-S) All this makes me think of binary data, hence to have columns F..R (except I, L S) set to hold either 0 or a power of 2. F would hold 0 or 1 G0 or 2 H0 or 4 J0 or 8 and so forth. Then, adding any group of columns would then give a unique meaningful value: -- if you add F+G+H and get 3, you know that only F and G are set -- if you AND F+G+H with, say, 2, you may check if G (value 2) is set : if G AND 2 = 2 then G is set (in Calc use the BITAND function) As I don't know exactly what you're looking to achieve, perhaps my idea is useless. Anyway, just my two euro-cents, -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Can't send document as e-mail attachment to Opera Mail
There is a great little programme in Windows called Affixa. Just need something similar for Linux really... On 17 September 2012 17:07, anne-ology lagin...@gmail.com wrote: yes, I agree - that is a great idea. The only way, I know, is to allow LO to open whatever, then save the attachment, then add this attachment to the correct e-mail. On Sun, Sep 16, 2012 at 6:15 AM, M Henri Day mhenri...@gmail.com wrote: 2012/9/16 Anthony Easthope antiso...@myopera.com Thats a tricky one. I don't exactly have a solution to the opera problem but it might be best to associate the email client (Thunderbird maybe?) as the default. From the best of my knowledge the opera browser can not become associated with the *.eml format which Thunderbird Evolution use? -- As an aside what is the reason your using the M2 Client? from my own experience it has loads of issues and is not as half as good as thunderbird or evolution for that matter I almost feel like I am talking through a hole in my head. On Sun, 16 Sep 2012, at 12:10 AM, wpost wrote: I use LibreOffice 3.4.5, and Opera 12.02 as a mail client, running Linux Mint Debian Edition 201204. LibreOffice has a send document as email command. Searching the web, I see it works fine with some other mail clients (Thunderbird, etc.) on Linux. But when I try it, I get the error message: LibreOffice was unable to find a working e-mail configuration. Please save this document locally instead and attach it from within your e-mail client. The relevant configuration appears to be found at Tools - Options - Internet - Email. I've tried opera, /usr/bin/opera, and /usr/bin/opera --remote 'openComposer(new-window)' (all without the double quotes). All of the above work from the terminal, and the latter (taken from Opera's documentation) opens a new message composition window, but none make LibreOffice's error go away. Searching the web, this list, and LibreOffice's Get Help references turns up nothing relevant. I'm out of ideas. Does anyone know how to make LibreOffice and Opera Mail play together? A feature I should greatly like to see in LibreOffice is one allowing a user to choose a webmail service, e g, Gmail, as the default, rather than an email client like Thunderbird or Evolution. This is easily done on, say, Ubuntu, by installing the Gnome Gmail package ; it would be wonderful if one of the LibreOffice developers could modify this package or create a different one which would resolve this problem for LibreOffice users Henri -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Where to store a simple database?
Thank you, that's very useful. However it has confirmed to me that I shouldn't use MySQL in this instance! All that packing and unpacking looks rather like your description of Embedded HSQL. I have made some progress with SQLite3, and I think this is the answer for me. On 15 September 2012 11:31, Andreas Säger ville...@t-online.de wrote: Someone found his way to share a database on Dropbox: http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=41238 http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=54988 http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=44131 -- View this message in context: http://nabble.documentfoundation.org/Where-to-store-a-simple-database-tp4007504p4007661.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Where to store a simple database?
I am using LO 3.5.6 on Windows 7 and also recently on Ubuntu 12.04 I have been eagerly migrating all my usage from Microsoft Office to LO, and I would appreciate some advice on converting from Access. I have one project which consists of a fairly modest flat file (896 records of 33 fields), but I have a number of well established queries that I use with it and once a year I link the data to an imported direct debit accounts table and export a CSV file which I convert to XML (using a python script) for sending to the direct debit company. So SQL access to the data is vital. The data is stored in Dropbox so it can be accessed from Windows or Ubuntu easily - but never simultaneously. I do have access to a MySQL server as part of my web hosting but I would rather not bother with setting one up locally for just this application. My original approach was to just use embedded HSQL, but I have got the message that this is a BAD IDEA, although it does work well with storing the data in Dropbox. I tried storing the data as an ods file (in Dropbox) and attaching my Base file to that, but the SQL functionality is too restricted. So, where should I store the data? Can I use SQLite to store the data in Dropbox? Or should I bite the bullet and store it in the SQL server where I wouldn't be able to get at it without Internet access? (Dropbox of course keeps local copies which it synchronises). Or is this one use use where embedded HSQL really is the right answer?? All views appreciated! -- 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: Where to store a simple database?
Whilst your answer is no doubt rigorous it lacks a little in the helpfulness class! You have explained many times before that base is not a database and embedded hsql is evil. You haven't really explained why in either case, but then I am much the same in declaiming Apple as the evil empire. You focussed on cloud as if I had my head in it, I don't. Let me state it again in less inflammatory ways - I want the database held in a single file with no need for an engine - hence SQLite seemed ideal. So that is the way I am pursuing but I am hitting snags (like ODBCConfig resolutely refusing to install) so I was rather hoping somebody might come up with an alternative or some help. In the meantime, unless somebody can really convince me that embedded HSQL is a disastrous approach I shall have to stick with that. Incidentally stand alone HSQL seems to rely on java, and most of the cognoscenti suggest avoiding java, so I shall! On 14 September 2012 16:27, Andreas Säger ville...@t-online.de wrote: Am 14.09.2012 16:41, John Clegg wrote: where I wouldn't be able to get at it without Internet access? (Dropbox of course keeps local copies which it synchronises). Or is this one use use where embedded HSQL really is the right answer?? All views appreciated! Of course you can not access cloud content without internet access. This office suite is a most conservative *desktop* application and Base is NOT a database program. Just like MS Access it lets you connect to various types of databases so you can access your data in this office suite. The whole thing does not know anything about a so called cloud. No, the *embedded* HSQLDB is not an option. It is even much worse than the JET database embedded in MS Access. A stand-alone HSQLDB server may be a very good database solution if it fits your needs. You can run the same tiny Java program on all platforms as server, as client and in cached mode. But again, all this has nothing to do with any cloud computing. It just works with client-server connections or with plain single-user file access. If you are able to backup your files, the medium should not matter. If you need to access the same database from various places, it is about nothing but database servers. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing
Could you just not exclude this directory from the backup? On 13 September 2012 15:29, Enda enda...@yahoo.com wrote: When I backup all the files, I like to see which files are being backed up, if the folder has changed (by having a file created and deleted) I see this folder I when I backup. I would rather not see folders that have not really changed. (I am not trying to open the file more than once.) - Enda - Original Message - From: Dan Lewis elderdanle...@gmail.com To: users@global.libreoffice.org Cc: Sent: Thursday, September 13, 2012 3:11 PM Subject: Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing What does it prevent you from doing? Are you trying to open this file more than once? You see, I'm confused why you need to override this function of LO. Since the dot files are hidden anyway, I don't see what difference the existence of these files make. The answer to my questions might enlighten me. --Dan On 09/13/2012 10:00 AM, Enda wrote: I am the only user on the system. When I view a file, a dot file (like .~lock.file.doc#) is created. How can I override (stop) this in LibreOffice? - Enda - Original Message - From: Jay Lozier jsloz...@gmail.com To: users@global.libreoffice.org Cc: Sent: Wednesday, September 12, 2012 3:33 PM Subject: Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing On 09/12/2012 09:23 AM, Enda wrote: OS: Ubuntu Calligra does not create a dot file when viewing files, is there an option to turn this off in LibreOffice? - Enda Do you want multiple users to be able to edit the file at the same time? I think this is causing confusion on the list. Often a program will create a lock file to prevent other users from modifying a file while someone is editing the file. This is a fairly common procedure and in some programs can be over ridden. A dot file can also refer to the MSO XP Word template with *.dot extension. - Original Message - From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Cc: Sent: Tuesday, September 11, 2012 8:41 PM Subject: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing Am 11.09.2012 18:01, Enda Noname wrote: Can Libreoffice not create a dot file in same folder as document when opening it for viewing? .~lock.file.doc# Is it really that difficult to tell us exactly about the situation? We don't even know the operating system. Is it really that difficult to copy some documents into a test directory, display hidden files and open them read-only? 4 tests on Linux: 1) libreoffice -view blah.odt [no lock file] 2) chmod -w blah.odt libreoffice blah.odt [no lock file] 3) menu:FileOpen... [X] Read Only [no lock file] 4) menu:Save As... [X]Password blah2.odt with a read-only password close, re-open blah2.odt [creates a lock file] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted