Re: [libreoffice-users] Connecting LO Base to an SQL DB
Thanks once again Girvin On 11/03/2012 11:30 PM, Girvin R. Herr wrote: 1. Look at /etc/my.cfg, the mysqld configuration file. I have searched my whole drive and can not find a file with this name (??) [even after running mysql_install_db as mentioned below - No such file on my system!!] 2. ping localhost [root@localhost ~]# ping localhost PING localhost.localdomain (127.0.0.1) 56(84) bytes of data. 64 bytes from localhost.localdomain (127.0.0.1): icmp_req=1 ttl=64 time=0.024 ms I highly recommend reading the Section Post-Installation Setup and Testing in the MySQL Reference Manual. This document is a good source for configuring and testing MySQL. http://dev.mysql.com/doc/ Will go and look at this. Started Base and selected my old DB to get to the Edit screen - BUT when I go there Connection Type is grayed out!! Tried again selecting the new SQL DB but again the Connection Type is grayed out!! I don't understand what you mean by new SQL DB? Did you try creating a new Base database connection with the wizard? NO - I created my new SQL Database in MyAdmin and then imported all the fields from the previous time I did this. But somehow the 'Connection Type' is now available to me BUT still gives me communication error Host name should be localhost. - *IT IS* Port number should be 3306 - *IT IS* MySQL JDBC driver class should be com.mysql.jdbc.Driver if you are using JDBC. - *IT IS* For reference, I am using mysql-connector-java-5.0.7 with MySQL 5.0.67 and LO 3.5.3 . Not the latest, but it works. Under edit - database - Properties - Advanced Properties, you can set up the database name and authentication: I'm using mysql-connector-java-5.1.22, with MySQL 5.1.55, and LO 3.6.2.2 (Build ID: da8c1e6), and phpMyAdmin 3.5.2. Name of the MySQL database is the name of the database you used in the CREATE DATABASE mysql statement. *YES* User name is the user name you used in the GRANT statement - *IT IS* Password required should be checked if you set up a password in the GRANT statement. - *IT IS* But 'Test Connection' still gives me the Communication Failure!! This sounds like Base still can't talk to the server through localhost. The var/lib/mysql Folder is there but is EMPTY(??)! (and has no permissions) and I can not delete it. Are you looking at /var/lib/mysql as root? - *NO I WAS NOT!!* Tried as 'root' and I can now see it - thanks for that!! Oops! I don't think I told you about mysql_install_db? If not, that's my bad. I am sorry I left it out. That needs to be run before anything else, including the mysqld server. Here is the correct sequence of configuration: (set up my.cfg) mysql_install_db --user=mysql #creates the databsae structures. mysqld_safe --user=mysql#script to run the mysqld server. NOTE: sometimes called safe_mysqld mysql_secure_installation #removes insecure files/structures. mysql --user=root -p mysql #Allows you to create your databases, user names, permissions, etc. No - you did not tell me about this!! So I followed the instructions and got positive response all the way!! (set up Base) Went back to Base - BUT still get the dammed Communication Link Failure! I'll go off and read the Post Installation Guide you mentioned and see if I can spot anything. This is REALLY getting to be a total PITA - This is the 4th time I've tried to get this to work in the past 8 months or so. I really DON'T understand why it has to be such an involved and impossible way to do something!!!?? But I DO thank you Girvin (and others) who have been trying to help me. Installing MySQL and getting Base working with it is not trivial, as you have seen. As far as I know, there is no one document to describe the process. Now add in all the other database server systems out there that Base can connect to and it really expands. That is why I keep notes on what my process is for the time I upgrade my Linux and have to do it all over again. I also started a Linux Set-up Document when I started with the OpSys. I think the first one was one or one and half pages. 4 years on it is now over 20 pages of notes, methods, tips and tricks!! And *IF* I get this to work that will add a few more pages!!! Thanks again and all the best IanW Pretoria RSA. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Win64: Scribus too... :-)
Hi :) Are Cpu cycles to do with multi-core/multi-cpu? If so it's presumably possible for 32bit apps to take advantage. I think it's just a fluke that most of us think that 64bit machines tend to have more than 1 cpu/core and 32bit ones don't. Both technologies became well known around the same time. Apparently the 4Gb Ram limit is a limit of the OS, not the apps. If the OS can read/write to more ram then i don't think the apps would be restricted. Apparently OSes that are 32bit could read more Ram with a different kernel module. With GnuLinux it's possible to swap-in the different module and i kept being told that it's really easy. Something like the pae-something module. Ram is used more efficiently by OpenSource programs, especially when using quite a few at the same time. My whole system is OpenSource apart from a few fonts and a couple of codecs and i seldom need even 1Gb. Movies and even fairly hefty games seem quite happy. I figure that if bits of my ram detiorate over time then i could always swap the sticks around to use the ones that aren't getting used at the moment. If it feels like LO/OO are bumping into ram issues then it's more likely to be the limits you set (or the default ones) in Tools - Options - Memory If you imagine wires or cables as lanes on a motorway then double the number of lanes can carry double the number of cars. It's just that you don't always need to have that many cars on a section of motorway. Regards from Tom :) From: Mas tier3supp...@gmail.com To: Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, 4 November 2012, 5:03 Subject: Re: [libreoffice-users] Win64: Scribus too... :-) On Sat, Nov 3, 2012 at 6:24 PM, Jay Lozier jsloz...@gmail.com wrote: On 11/03/2012 05:14 PM, VA wrote: Okay, I'll betray my ignorance. What would be the difference or advantage of running a 64 bit LibO vs. a 32 bit LibO? Virgil IMHO, the practical difference is nil for a typical office use. Some large databases will require 64 bit because 32 bit is limited to 4 GB. -Original Message- From: James Knott Sent: Saturday, November 03, 2012 4:53 PM To: LibreOffice Subject: Re: [libreoffice-users] Win64: Scribus too... :-) rost52 wrote: How many LibO user are having wn64 machines? Or better what is the percentage of win64 users in the LibO community? I'm a Linux user, 64 bits of course, but I have one, 1, count 'em, one computer that has 64 bit Windows 7 on it. Then again, there have been 64 bit versions of Linux going back 17 - 18 years and I was running 64 bit Linux for over 5 years, before I had 64 bit Windows. -- Jay Lozier jsloz...@gmail.com Since Libreoffice is a Office product . I don't believe you will see a big differential in performance as a user . From a programmer view , you can take advantage of the cpu cycles and memory usage with a 64bit system. -- -- Masekela Walls Web Security Analyst | Senior Server Administrator Powserve.com / Gemini ISP Networks -- 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] Win64: Scribus too... :-)
On Sun, Nov 4, 2012 at 5:25 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Are Cpu cycles to do with multi-core/multi-cpu? If so it's presumably possible for 32bit apps to take advantage. I think it's just a fluke that most of us think that 64bit machines tend to have more than 1 cpu/core and 32bit ones don't. Both technologies became well known around the same time. Apparently the 4Gb Ram limit is a limit of the OS, not the apps. If the OS can read/write to more ram then i don't think the apps would be restricted. Apparently OSes that are 32bit could read more Ram with a different kernel module. With GnuLinux it's possible to swap-in the different module and i kept being told that it's really easy. Something like the pae-something module. Ram is used more efficiently by OpenSource programs, especially when using quite a few at the same time. My whole system is OpenSource apart from a few fonts and a couple of codecs and i seldom need even 1Gb. Movies and even fairly hefty games seem quite happy. I figure that if bits of my ram detiorate over time then i could always swap the sticks around to use the ones that aren't getting used at the moment. If it feels like LO/OO are bumping into ram issues then it's more likely to be the limits you set (or the default ones) in Tools - Options - Memory If you imagine wires or cables as lanes on a motorway then double the number of lanes can carry double the number of cars. It's just that you don't always need to have that many cars on a section of motorway. Regards from Tom :) CPU Cycles is the process the processor takes to complete a command. Multiple cores came about due to the current CPU overheating above 4GHZ . So they started adding more cores to the existing processors to give you more cpu threads to process commands. So in theory you can have a 3GHZ CPU with dual cores (2 central processing units) to get the result of a 6ghz processor. You are correct, the 4GB limit was imposed by the operating system . 64bit has been around for years, I believe someone else mention this on the thread, its not new and unix/linux has been using it. If you imagine wires or cables as lanes on a motorway then double the number of lanes can carry double the number of cars. It's just that you don't always need to have that many cars on a section of motorway. I like that , -- -- Masekela Walls Web Security Analyst | Senior Server Administrator Powserve.com / Gemini ISP Networks -- 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
Ian, The file is called my.cnf (NOT my.cfg!) on my system. Regards H On Sun, 04 Nov 2012 10:59:04 +0100, Ian Whitfield whitfi...@telkomsa.net wrote: Thanks once again Girvin On 11/03/2012 11:30 PM, Girvin R. Herr wrote: 1. Look at /etc/my.cfg, the mysqld configuration file. I have searched my whole drive and can not find a file with this name (??) [even after running mysql_install_db as mentioned below - No such file on my system!!] 2. ping localhost [root@localhost ~]# ping localhost PING localhost.localdomain (127.0.0.1) 56(84) bytes of data. 64 bytes from localhost.localdomain (127.0.0.1): icmp_req=1 ttl=64 time=0.024 ms I highly recommend reading the Section Post-Installation Setup and Testing in the MySQL Reference Manual. This document is a good source for configuring and testing MySQL. http://dev.mysql.com/doc/ Will go and look at this. Started Base and selected my old DB to get to the Edit screen - BUT when I go there Connection Type is grayed out!! Tried again selecting the new SQL DB but again the Connection Type is grayed out!! I don't understand what you mean by new SQL DB? Did you try creating a new Base database connection with the wizard? NO - I created my new SQL Database in MyAdmin and then imported all the fields from the previous time I did this. But somehow the 'Connection Type' is now available to me BUT still gives me communication error Host name should be localhost. - *IT IS* Port number should be 3306 - *IT IS* MySQL JDBC driver class should be com.mysql.jdbc.Driver if you are using JDBC. - *IT IS* For reference, I am using mysql-connector-java-5.0.7 with MySQL 5.0.67 and LO 3.5.3 . Not the latest, but it works. Under edit - database - Properties - Advanced Properties, you can set up the database name and authentication: I'm using mysql-connector-java-5.1.22, with MySQL 5.1.55, and LO 3.6.2.2 (Build ID: da8c1e6), and phpMyAdmin 3.5.2. Name of the MySQL database is the name of the database you used in the CREATE DATABASE mysql statement. *YES* User name is the user name you used in the GRANT statement - *IT IS* Password required should be checked if you set up a password in the GRANT statement. - *IT IS* But 'Test Connection' still gives me the Communication Failure!! This sounds like Base still can't talk to the server through localhost. The var/lib/mysql Folder is there but is EMPTY(??)! (and has no permissions) and I can not delete it. Are you looking at /var/lib/mysql as root? - *NO I WAS NOT!!* Tried as 'root' and I can now see it - thanks for that!! Oops! I don't think I told you about mysql_install_db? If not, that's my bad. I am sorry I left it out. That needs to be run before anything else, including the mysqld server. Here is the correct sequence of configuration: (set up my.cfg) mysql_install_db --user=mysql #creates the databsae structures. mysqld_safe --user=mysql#script to run the mysqld server. NOTE: sometimes called safe_mysqld mysql_secure_installation #removes insecure files/structures. mysql --user=root -p mysql #Allows you to create your databases, user names, permissions, etc. No - you did not tell me about this!! So I followed the instructions and got positive response all the way!! (set up Base) Went back to Base - BUT still get the dammed Communication Link Failure! I'll go off and read the Post Installation Guide you mentioned and see if I can spot anything. This is REALLY getting to be a total PITA - This is the 4th time I've tried to get this to work in the past 8 months or so. I really DON'T understand why it has to be such an involved and impossible way to do something!!!?? But I DO thank you Girvin (and others) who have been trying to help me. Installing MySQL and getting Base working with it is not trivial, as you have seen. As far as I know, there is no one document to describe the process. Now add in all the other database server systems out there that Base can connect to and it really expands. That is why I keep notes on what my process is for the time I upgrade my Linux and have to do it all over again. I also started a Linux Set-up Document when I started with the OpSys. I think the first one was one or one and half pages. 4 years on it is now over 20 pages of notes, methods, tips and tricks!! And *IF* I get this to work that will add a few more pages!!! Thanks again and all the best IanW Pretoria RSA. -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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] Win64: Scribus too... :-)
Tom Davies wrote: Apparently the 4Gb Ram limit is a limit of the OS, not the apps. If the OS can read/write to more ram then i don't think the apps would be restricted. Apparently OSes that are 32bit could read more Ram with a different kernel module. With GnuLinux it's possible to swap-in the different module and i kept being told that it's really easy. Something like the pae-something module. With PAE, the 32 bit CPU can access more that 4 GB, but Microsoft still limits Windows to 4 GB. With Linux, no there is no such artificial limitation. IIRC, applications are still limited to 4 GB, as they don't know how to access more, but the OS can use the greater space and make it available to the apps. With Linux, recently used stuff is retained in memory, so that accessing it again is quick. It will eventually be moved to swap, if not recently used. So, with Linux, the more memory available, including beyond 4 GB, the faster the system in general runs. https://en.wikipedia.org/wiki/Physical_Address_Extension -- 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] Win64: Scribus too... :-)
Mas wrote: I believe someone else mention this on the thread, its not new and unix/linux has been using it. Yes, there was a 64 bit version of Linux running on the DEC Alpha, followed shortly by the IBM PowerPC around 1994 - 1995. -- 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] Installation of Help Pack For LibreOffice 3.6.2
Tiziano Bianchi wrote: I am using Linux Slackware 13.37, 32-bit. I am fairly novice with Linux. I have installed LibreOffice 3.6.2 using the SlackBuilds.com script (I modified the line which starts with VERSION). Now I would like to also install the corresponding Help Pack, available here: http://www.libreoffice.org/download/?type=rpm-x86lang=en-USversion=3.6.2 Does anyone know how to do it? There is no SlackBuilds.com script that I could find and Google did not turn up anything helpful in this respect... I will post the same question on LinuxQuestions.org (Slackware forum). Tiziano, Have you resolved this problem? I have created a SlackBuild script to repackage both LO and the helppack into a single Slackware installation package. However, I was reluctant to send it to you because it is not tested with Slack 13+. I am using Slack 12.2. I can tweek it for 13+ for you, but I still can't test it, so it may still need a bit of work to get it to work on your system. If you want to try it, let me know and I can tarball it and the other files I use to repackage LO for Slack and send it to you. Note: My SlackBuild script does a lot more than the usual SlackBuild scripts, but it is commented fairly well. Girvin Herr -- 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] Win64: Scribus too... :-)
On 04-11-12 13:21, James Knott wrote: Mas wrote: I believe someone else mention this on the thread, its not new and unix/linux has been using it. Yes, there was a 64 bit version of Linux running on the DEC Alpha, followed shortly by the IBM PowerPC around 1994 - 1995. The 64-bit R4000 by MIPS technologies came out in 1992 and was first used in Silicon Graphics machines, running IRIX the SGI flavour of UNIX. This processor was 64-bit internally but 32-bit externally so only a 32-bit wide memory-path could be used.Later versions, notably the R8000 (1994) and the R1000 (1996) were 64-bit internally and externally. In 1994 SGI licensed the memory architecture, developed by Cray (which it bought a few years later) and licensed it, I thought in 2002 to AMD for its 64-bit processors. This NUMA architecture is much faster than the standard architecture used in other processors and is much more suitable for multiprocessor systems. Joep -- 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] Installation of Help Pack For LibreOffice 3.6.2
Tiziano, Good. I am glad you got it working. Yes, the help is out-dated. But it comes in handy now and then. Girvin Tiziano Bianchi wrote: Thanks for the offer, Girvin. I was able to successfully install the Help Pack using the command rpm2txz, so everything is ok. (However, Tom is right in saying that the Help Pack is quite outdated...) -- tb *From:* Girvin R. Herr girvin.h...@sbcglobal.net *To:* Tiziano Bianchi tb75...@yahoo.com *Cc:* users@global.libreoffice.org users@global.libreoffice.org *Sent:* Sunday, November 4, 2012 2:48 PM *Subject:* Re: [libreoffice-users] Installation of Help Pack For LibreOffice 3.6.2 Tiziano Bianchi wrote: I am using Linux Slackware 13.37, 32-bit. I am fairly novice with Linux. I have installed LibreOffice 3.6.2 using the SlackBuilds.com http://slackbuilds.com/ script (I modified the line which starts with VERSION). Now I would like to also install the corresponding Help Pack, available here: http://www.libreoffice.org/download/?type=rpm-x86lang=en-USversion=3.6.2 Does anyone know how to do it? There is no SlackBuilds.com script that I could find and Google did not turn up anything helpful in this respect... I will post the same question on LinuxQuestions.org (Slackware forum). Tiziano, Have you resolved this problem? I have created a SlackBuild script to repackage both LO and the helppack into a single Slackware installation package. However, I was reluctant to send it to you because it is not tested with Slack 13+. I am using Slack 12.2. I can tweek it for 13+ for you, but I still can't test it, so it may still need a bit of work to get it to work on your system. If you want to try it, let me know and I can tarball it and the other files I use to repackage LO for Slack and send it to you. Note: My SlackBuild script does a lot more than the usual SlackBuild scripts, but it is commented fairly well. Girvin Herr -- 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] Installation of Help Pack For LibreOffice 3.6.2
Hi :) +1 to all that. It is handy to have quick help so easily available even if it is a little dated. Nice work both of you! I hope there is somewhere good to keep the script. Congrats and regards from Tom :) From: Girvin R. Herr girvin.h...@sbcglobal.net To: Tiziano Bianchi tb75...@yahoo.com Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, 4 November 2012, 23:12 Subject: Re: [libreoffice-users] Installation of Help Pack For LibreOffice 3.6.2 Tiziano, Good. I am glad you got it working. Yes, the help is out-dated. But it comes in handy now and then. Girvin Tiziano Bianchi wrote: Thanks for the offer, Girvin. I was able to successfully install the Help Pack using the command rpm2txz, so everything is ok. (However, Tom is right in saying that the Help Pack is quite outdated...) -- tb *From:* Girvin R. Herr girvin.h...@sbcglobal.net *To:* Tiziano Bianchi tb75...@yahoo.com *Cc:* users@global.libreoffice.org users@global.libreoffice.org *Sent:* Sunday, November 4, 2012 2:48 PM *Subject:* Re: [libreoffice-users] Installation of Help Pack For LibreOffice 3.6.2 Tiziano Bianchi wrote: I am using Linux Slackware 13.37, 32-bit. I am fairly novice with Linux. I have installed LibreOffice 3.6.2 using the SlackBuilds.com http://slackbuilds.com/ script (I modified the line which starts with VERSION). Now I would like to also install the corresponding Help Pack, available here: http://www.libreoffice.org/download/?type=rpm-x86lang=en-USversion=3.6.2 Does anyone know how to do it? There is no SlackBuilds.com script that I could find and Google did not turn up anything helpful in this respect... I will post the same question on LinuxQuestions.org (Slackware forum). Tiziano, Have you resolved this problem? I have created a SlackBuild script to repackage both LO and the helppack into a single Slackware installation package. However, I was reluctant to send it to you because it is not tested with Slack 13+. I am using Slack 12.2. I can tweek it for 13+ for you, but I still can't test it, so it may still need a bit of work to get it to work on your system. If you want to try it, let me know and I can tarball it and the other files I use to repackage LO for Slack and send it to you. Note: My SlackBuild script does a lot more than the usual SlackBuild scripts, but it is commented fairly well. Girvin Herr -- 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] Cannot save data ranges in spreadsheet other than with .ods files
I'm using LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) on Ubuntu 11.04 When I create a data range and save that range in the ods format, everything works as expected. If I save the file as a MS files (xls or xlsx), the range is not saved (i,e if I save and close, the range has disappeared if I open the file) Thanks -- 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] Cannot save data ranges in spreadsheet other than with .ods files
Seems to be a bug. I made a test using XP/SP3 and 3.5.7 Data Range names get lost. If other it could be confirmed in 3.6 version, a bug report appears to be the we can do. On 2012-11-05 09:56, Subscriptions wrote: I'm using LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) on Ubuntu 11.04 When I create a data range and save that range in the ods format, everything works as expected. If I save the file as a MS files (xls or xlsx), the range is not saved (i,e if I save and close, the range has disappeared if I open the file) Thanks -- 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] bug or missing functionality in Impress/Chart ?
I wanted to create a chart in Impress Inserted a chart Opened the chart data table So far all fine and as expected When I wanted to copy data array (2 rows, 5 columns) from Calc into the table, the data of the array selected on copied into the clipboard all get pasted into the cell I selected (top left corner) Even adjusting the chart data table to exactly the size as the original data array resulted in all data in the selected cell in the chart data table. Is this a bug or a missing functionality in Impress? The ability to copy and array of data from Calc into the chart data table would increase productivity. XP/SP3 LibO 3..5.7 -- 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] Is it possible to show cell value with text
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
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