Re: [libreoffice-users] How to download?
Hi :) Have you made sure there is enough empty space in the folder you are downloading to? Which country are you in? Do you have a download limit/month and have you gone over that? Are you using a wireless connection or is there a network cable plugged into the machine? Have you tried rebooting your router? Are you using Adblock Plus or some parental thing and accidentally blocked things from this site? Regards from Tom :) --- On Fri, 13/4/12, Jay Lozier jsloz...@gmail.com wrote: From: Jay Lozier jsloz...@gmail.com Subject: Re: [libreoffice-users] How to download? To: users@global.libreoffice.org Date: Friday, 13 April, 2012, 5:37 On 04/12/2012 09:14 PM, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my connection speed. Its fast. thanks. What OS and browser are you using? -- 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] Recovery and Updates
El 13/04/12 2:17, rexrino escribió: On 04/12/2012 07:42 PM, Onyeibo Oku wrote: Hi everyone, I've switched to digest mode and, so far, it is just what I need. I started a thread earlier about an anomaly in Libreoffice 3.5.1. I have not seen any response to it neither have I spotted the initial mail in any digest I have received so far. I'll repeat again: 1. Libreoffice is trying to recover files that do not exist. This happens at every start-up. The files in question are not corrupt. They were deleted and are no longer needed. I'd like to stop this behaviour. Any clues? I suspect Libreoffice maintains a list/record of recently failed loading attempts and continues to try entries on that list at each start-up ... if this is true, where does LibO maintain such? 2. I have just downloaded 3.5.2. I did notice something strange on a page linked from the download page (release notes under 'Handy Resources'). The release info has the following statement: This is the third release from the 3.5 branch of Libreoffice. It contains many exciting new features, and is the recommended version for private users and small enterprises. This is not informative! What changed between 3.5.1 and 3.5.2? The idea of release notes is to inform users of changes ... or perhaps that is reserved for main releases in the order 3.3, 3.4, 3.5 ...etc. If so, there should be a change-log or report somewhere. We cant keep downloading things without knowing what to expect. Regards Onyeibo not sure if it will help but you might try writing a doc and checking the .libreoffice directory to see how it changes (config files, backup, etc). Did you check the settings in the Tools/Options section? I'm using slackware 13.37 without the kde lib's and it flies. I have the qt lib installed but nothing kde. I'm using the xfe GUI. John. And the changes between releases are here: http://wiki.documentfoundation.org/Releases Miguel ángel. -- 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] duplicate entire document writer
:O fantastic! thank you! 2012/4/13 Manfred J. Krause courrier.oou.fr@googlemail.com: Hi Pedro, On Thu, Apr 12, 2012 at 11:50 PM, Pedro wrote: grrr another one that doesn't works... this time the double ctrl+a doesn't works... :( http://www.sendspace.com/file/l041vo thank you (1) Set the cursor before '' (Table1:A1) (2) Press Alt+Enter (3) Ctrl+A Ctrl+C (4) Set the cursor below 'Aa...' (Table4:A2) [now: last line of page 2] (5) Ctrl+V ... (6) Remove the first (empty) page Sample: → https://www.dropbox.com/sh/lm5p9q9vq8qfzxa/noKlZ9rJzX/mapa_instala%C3%A7%C3%A3o_modelo_50.odt mjk 2012/4/12 Tom Davies: [...] --- On Wed, 11/4/12, Pedro wrote: [...] 2012/4/11 Tom Davies: [...] --- On Wed, 11/4/12, Pedro wrote: From: Pedro Date: Wednesday, 11 April, 2012, 14:25 hi, i need the 50 sheet in one document (tu use the pagination feature...) cntrl+a do not select all the entire sheet... just the first table thank you 2012/4/11 Tom Davies: [...] --- On Wed, 11/4/12, Pedro wrote: From: Pedro cartas.corr...@gmail.com Date: Wednesday, 11 April, 2012, 14:13 hello, i have a writer sheet with tables that i need to duplicate 50 times, i have the numbering function activated on the first one... i can't copy the entire sheet, can't select all tables at the same time... anyone can help me? thank you -- Street installations by Mark Jenkins http://xmarkjenkinsx.com/outside.html -- 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] How to download?
On Fri, 2012-04-13 at 08:20 +0100, Tom Davies wrote: Hi :) Have you made sure there is enough empty space in the folder you are downloading to? Yes. Which country are you in? US Do you have a download limit/month and have you gone over that? No Are you using a wireless connection or is there a network cable plugged into the machine? Wireless Have you tried rebooting your router? Yes Are you using Adblock Plus or some parental thing and accidentally blocked things from this site? No I will try a wget from a wired computer and see, but what should be a 8 minute download never happens. It gets to about 15MB/200MB or so and gets interrupted on the server side. I'm using Google Chrome. Regards from Tom :) --- On Fri, 13/4/12, Jay Lozier jsloz...@gmail.com wrote: From: Jay Lozier jsloz...@gmail.com Subject: Re: [libreoffice-users] How to download? To: users@global.libreoffice.org Date: Friday, 13 April, 2012, 5:37 On 04/12/2012 09:14 PM, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my connection speed. Its fast. thanks. What OS and browser are you using? -- 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] How to download?
Hi, On Fri, Apr 13, 2012 at 3:14 AM, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? [...] ...That will open up mirrors list. [luyu] → Ask LibreOffice Download line to ZA broken http://ask.libreoffice.org/question/1927/download-line-to-za-broken?answer=1928#answer-container-1928 mjk -- The Document Foundation announces LibreOffice 3.5.2 http://nabble.documentfoundation.org/The-Document-Foundation-announces-LibreOffice-3-5-2-tc3886925.html -- 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] How to download?
Hi :) Sounds like it 'should' be downloading fine. Do you already have a 2nd web-browser you can try? Not that it's likely to make any difference. I think trying the wired machine is smart and covers the issue of weird settings in your Chrome (which is unlikely anyway). Regards from Tom :) --- On Fri, 13/4/12, Darren Govoni dar...@ontrenet.com wrote: From: Darren Govoni dar...@ontrenet.com Subject: Re: [libreoffice-users] How to download? To: users@global.libreoffice.org Date: Friday, 13 April, 2012, 11:15 On Fri, 2012-04-13 at 08:20 +0100, Tom Davies wrote: Hi :) Have you made sure there is enough empty space in the folder you are downloading to? Yes. Which country are you in? US Do you have a download limit/month and have you gone over that? No Are you using a wireless connection or is there a network cable plugged into the machine? Wireless Have you tried rebooting your router? Yes Are you using Adblock Plus or some parental thing and accidentally blocked things from this site? No I will try a wget from a wired computer and see, but what should be a 8 minute download never happens. It gets to about 15MB/200MB or so and gets interrupted on the server side. I'm using Google Chrome. Regards from Tom :) --- On Fri, 13/4/12, Jay Lozier jsloz...@gmail.com wrote: From: Jay Lozier jsloz...@gmail.com Subject: Re: [libreoffice-users] How to download? To: users@global.libreoffice.org Date: Friday, 13 April, 2012, 5:37 On 04/12/2012 09:14 PM, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my connection speed. Its fast. thanks. What OS and browser are you using? -- 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 -- 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: How to download?
Am 13.04.2012 03:14, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my connection speed. Its fast. thanks. Where do you try to download from? Should be http://www.libreoffice.org/download/ and nothing else. The [Info] link leads to alternative locations (torrents and mirrors). -- 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] Connecting to HSQLDB with Base
I have hsqldb installed and running. But I don't find the information that I need to connect Base to it. I have read I can use either ODBC or JDBC to do this. JDBC requires: Data source URL jdbc:: and JDBC driver class. What belongs in these two boxes? If ODBC can be used, what goes in the Name of the ODBC data source on your system? (I don't even know what they are asking for.) --Dan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Connecting to HSQLDB with Base
On Fri, 2012-04-13 at 09:38 -0400, Dan Lewis wrote: I have hsqldb installed and running. But I don't find the information that I need to connect Base to it. I have read I can use either ODBC or JDBC to do this. JDBC requires: Data source URL jdbc:: and JDBC driver class. What belongs in these two boxes? If ODBC can be used, what goes in the Name of the ODBC data source on your system? (I don't even know what they are asking for.) --Dan Added question: What goes in /tools/options/LibreOfficeJavaDriver Class path? -- 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: Connecting to HSQLDB with Base
Am 13.04.2012 15:50, Dan Lewis wrote: On Fri, 2012-04-13 at 09:38 -0400, Dan Lewis wrote: I have hsqldb installed and running. But I don't find the information that I need to connect Base to it. I have read I can use either ODBC or JDBC to do this. JDBC requires: Data source URL jdbc:: and JDBC driver class. What belongs in these two boxes? If ODBC can be used, what goes in the Name of the ODBC data source on your system? (I don't even know what they are asking for.) --Dan Added question: What goes in /tools/options/LibreOfficeJavaDriver Class path? On my system that is: 1) /usr/local/lib/hsqldb/lib/hsqldb.jar 2a) hsqldb:hsql://192.168.0.2/chargen;default_schema=true 2b) hsqldb:file:/home/andreas/hsqldb_databases/Praxis/hsqldbdata/db0/chargen;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false 2a) connects to a HSQL server, where a configuration file controls which database directory is served under which alias name. 2b) connects to a local development version of the database (cached mode analog to the embedded thing). /home/andreas/hsqldb_databases/Praxis/hsqldbdata/db0/ contains the 3 database files chargen.script, chargen.data, chargen.properties. /usr/local/lib/hsqldb/index.html is the entry point to the excellent documentation (313 pages of PDF). -- 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: Connecting to HSQLDB with Base
On Fri, 2012-04-13 at 16:35 +0200, Andreas Säger wrote: Am 13.04.2012 15:50, Dan Lewis wrote: On Fri, 2012-04-13 at 09:38 -0400, Dan Lewis wrote: I have hsqldb installed and running. But I don't find the information that I need to connect Base to it. I have read I can use either ODBC or JDBC to do this. JDBC requires: Data source URL jdbc:: and JDBC driver class. What belongs in these two boxes? If ODBC can be used, what goes in the Name of the ODBC data source on your system? (I don't even know what they are asking for.) --Dan Added question: What goes in /tools/options/LibreOfficeJavaDriver Class path? On my system that is: 1) /usr/local/lib/hsqldb/lib/hsqldb.jar 2a) hsqldb:hsql://192.168.0.2/chargen;default_schema=true 2b) hsqldb:file:/home/andreas/hsqldb_databases/Praxis/hsqldbdata/db0/chargen;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false 2a) connects to a HSQL server, where a configuration file controls which database directory is served under which alias name. 2b) connects to a local development version of the database (cached mode analog to the embedded thing). /home/andreas/hsqldb_databases/Praxis/hsqldbdata/db0/ contains the 3 database files chargen.script, chargen.data, chargen.properties. /usr/local/lib/hsqldb/index.html is the entry point to the excellent documentation (313 pages of PDF). Right - and once the jar has been added into the system you can also connect to a HSQLdb server running in FILE mode - meaning that the server will not need to be started before the connection is established, instead in the connection string you designate the file directory to be used and as part of establishing the connection it starts an instance of the server in your process space and uses the directory listed to store the work files. //drew -- 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] How to format data entry in base table to UPPERCASE only
I am trying to find a way to format the text fields in my small data base to be uppercase only. Is there a way to do it at the table field level with the 'format', or can it only be done at the form level through a pattern field using 'X'? -- View this message in context: http://nabble.documentfoundation.org/How-to-format-data-entry-in-base-table-to-UPPERCASE-only-tp3908311p3908311.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: How to format data entry in base table to UPPERCASE only
Am 13.04.2012 17:42, leon244 wrote: I am trying to find a way to format the text fields in my small data base to be uppercase only. Is there a way to do it at the table field level with the 'format', or can it only be done at the form level through a pattern field using 'X'? -- View this message in context: http://nabble.documentfoundation.org/How-to-format-data-entry-in-base-table-to-UPPERCASE-only-tp3908311p3908311.html Sent from the Users mailing list archive at Nabble.com. Since 'x' and 'X' are different characters, this has nothing to do with formatting. Set the field type to VARCHAR_IGNORECASE so 'x' and 'X' are considered as equivalent. In queries you can use the UCASE or UPPER function in order to display the upper case version of the text. -- 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: Problems importing an OO database into LO
Hi :) There is no harm in using OpenOffice. It's a good product and not really a competitor anymore. It's more like we are 1 extended community with 2 legs and 2 products. Regards from Tom :) --- On Fri, 13/4/12, ptoye l...@ptoye.com wrote: From: ptoye l...@ptoye.com Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Friday, 13 April, 2012, 15:30 Manual refresh doesn't help. I'm afraid. And the workaround is even simpler - keep using Open Office! - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3908170.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: How to format data entry in base table to UPPERCASE only
On Fri, 2012-04-13 at 17:49 +0200, Andreas Säger wrote: Am 13.04.2012 17:42, leon244 wrote: I am trying to find a way to format the text fields in my small data base to be uppercase only. Is there a way to do it at the table field level with the 'format', or can it only be done at the form level through a pattern field using 'X'? -- View this message in context: http://nabble.documentfoundation.org/How-to-format-data-entry-in-base-table-to-UPPERCASE-only-tp3908311p3908311.html Sent from the Users mailing list archive at Nabble.com. Since 'x' and 'X' are different characters, this has nothing to do with formatting. Set the field type to VARCHAR_IGNORECASE so 'x' and 'X' are considered as equivalent. In queries you can use the UCASE or UPPER function in order to display the upper case version of the text. Howdy, Right - well the VARCHAR_IGNORECASE is fairly specific to HSQLdb, but it works well. You may also create an update trigger, using an SQL command via the SQL window, to cast all input to upper case before it is written into the data field - for any relational database engine used by Base, including the embedded HSQLdb engine, the syntax varies a bit from engine to engine however. //drew -- 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: How to format data entry in base table to UPPERCASE only
Thank you both. -- View this message in context: http://nabble.documentfoundation.org/How-to-format-data-entry-in-base-table-to-UPPERCASE-only-tp3908311p3908612.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] disappearing letter
I just modified a previous letter, which was a previously sent FAX, and went to save the modified version, which had a fair amount of work in it. When I said save I got a fast-disappearing message, something about java, and the whole document disappeared. I have since discovered that the document can be recovered, altho I didn't know it at the time, so I typed it over again using WordPerfect in Windows. I really don't like your program much, but it's almost the only game in town on Linux, and this behavior does not make me any fonder of it! (The other options are worse.) --doug -- Blessed are the peacekeepers...for they shall be shot at from both sides. --A.M. Greeley -- 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: Connecting to HSQLDB with Base
On Fri, 2012-04-13 at 16:35 +0200, Andreas Säger wrote: Trying again because nothing seems to make much sense to me. This time I need a reply that is made inline rather than a bottom post. Otherwise, what answer goes with what question becomes very unclear. I'm leaving some space between questions for the answers. Drag and drop the answers from below if they differ from what I have put in parentheses. Somewhere among all the words about HSQLDB there is instructions that are step by step. I already have the HSQLDB Guide in PDF format. I have searched through the index.html file, but could not find what I needed to know. Neither did LO Help explain what was needed (OOo Help was not better). The more I look at the documentation, the more confused I get. Setting the root and personal passwords for HSQLDB. (Nothing is clear about how to do this.) Connecting to HSQLDB using JDBC: Data source URL jdbc:: (Perhaps /usr/local/lib/hsqldb/lib/hsqldb.jar?) JDBC driver class Tools Options Java Class path Connecting to HSQLDB using JDBC: --Dan On my system that is: 1) /usr/local/lib/hsqldb/lib/hsqldb.jar 2a) hsqldb:hsql://192.168.0.2/chargen;default_schema=true 2b) hsqldb:file:/home/andreas/hsqldb_databases/Praxis/hsqldbdata/db0/chargen;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false 2a) connects to a HSQL server, where a configuration file controls which database directory is served under which alias name. 2b) connects to a local development version of the database (cached mode analog to the embedded thing). /home/andreas/hsqldb_databases/Praxis/hsqldbdata/db0/ contains the 3 database files chargen.script, chargen.data, chargen.properties. /usr/local/lib/hsqldb/index.html is the entry point to the excellent documentation (313 pages of PDF). -- 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] Can one export from Calc a spreadsheet raw into a MySql database table raw?
Hi, I made in Calc a spreadsheet and now I want to export some raws into a mysql database table's raws. I have created already the database using command mysql to log into mysql server and have already the table in database with corresponding fields in table. Can I export somehow these data from Calc into database or must I manually fill every field in the table's records? I can connect to this database from LibreOffice, but don't know how could I easily tranship datas from Calc into table's fields? -- Regards from Pal -- 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 one export from Calc a spreadsheet raw into a MySql database table raw?
On 2012-04-14 08:06, Csanyi Pal wrote: Hi, I made in Calc a spreadsheet and now I want to export some raws into a mysql database table's raws. I have created already the database using command mysql to log into mysql server and have already the table in database with corresponding fields in table. Can I export somehow these data from Calc into database or must I manually fill every field in the table's records? I can connect to this database from LibreOffice, but don't know how could I easily tranship datas from Calc into table's fields? I don't know if someone else can help with loading straight from calc, but you could save as a CSV file and use the LOAD DATA command to load into MySQL. Just check the result is as intended. http://dev.mysql.com/doc/refman/5.1/en/load-data.html Steve -- 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: Calc: cell protection + cut paste
-Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Thursday, April 12, 2012 11:15 To: 'users@global.libreoffice.org' Subject: RE: [libreoffice-users] Re: Calc: cell protection + cut paste I spoke too soon. Absolute references don't solve this problem, because even those are updated when moves happen, such as the cut and paste in the demonstration example. There actually needs to be a way to block cutting and other operations that relocate cells if formulas are to be protected from movement of their operands. It looks like a bigger issue might be whether it is possible to prevent editing operations (cut especially but also row-column insertions and deletions) in a sheet with protections turned on. All while still allowing data entry into unprotected cells. Yes, absolute references don't solve it. And I really do agree that there should be a way to control how these editing operations affect protected cells. One of the core fuctions of a speadsheet program (in my opinion) in that somebody skills can make a calculation sheet and other people can use it to fill needed data and do the calculations and get the needed data. In excel you build your own UI to enter data and with VB you can do a lot of things. But in my opinion that's just overkill for most of the cases. Somebody said that it's an expected (and maybe even wanted?) behaviour, but I just can't understand it. I wish I could do the coding needed, but unfortunately I'm not skilled enough. I think that with a small improvement LibreOffice could be a lot better tool without too complicated things (like Excels UI + VB) I hope somebody, who could do something about this, finds this interesting and needed. :) Mikko -- View this message in context: http://nabble.documentfoundation.org/Calc-cell-protection-cut-paste-tp3903414p3908930.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Calc: cell protection + cut paste
It is not trivial to add finer control on how protection of cells deals with formula-changing cut-paste and other move/insert/delete operations involving cells that protected formulas depend on. For starters, there needs to be a way to communicate the enhanced conditions on protected cells via the ODF format. There is no such provision at the moment. It is possible to handle this with configuration parameters carried in ODF. Unfortunately, that is intensely implementation-specific and frowned upon for something this deep into interpretation of the format. Either way, there remains the problem of having this work in interchange among enough other products that the feature is safe to rely on outside of a situation where all users can be required to use the same software. Interoperability with use of Excel is often a significant factor for many users, especially once Excel supports OpenFormula in its handling of .ods files (something expected eventually although I have no idea when). It might be worthwhile to review what the flavors of protection are in .xlsx and in Excel 2010. There might be an avenue there to something that could be done compatibly in ODF, digging into ISO OOXML for how it is done at the format level. I'm curious to know if the finer-grain options that are available there are helpful in your use case. Can you take a look? - Dennis PS: There is still a problem with the protection lock passwords not being portably-supported between Office formats and ODF formats, although there are ways to make that work better. Presently, the protection is simply turned off when transferring in either direction between formats. -Original Message- From: miakoiv [mailto:miak...@mbnet.fi] Sent: Friday, April 13, 2012 13:36 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Calc: cell protection + cut paste -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Thursday, April 12, 2012 11:15 To: 'users@global.libreoffice.org' Subject: RE: [libreoffice-users] Re: Calc: cell protection + cut paste I spoke too soon. Absolute references don't solve this problem, because even those are updated when moves happen, such as the cut and paste in the demonstration example. There actually needs to be a way to block cutting and other operations that relocate cells if formulas are to be protected from movement of their operands. It looks like a bigger issue might be whether it is possible to prevent editing operations (cut especially but also row-column insertions and deletions) in a sheet with protections turned on. All while still allowing data entry into unprotected cells. Yes, absolute references don't solve it. And I really do agree that there should be a way to control how these editing operations affect protected cells. One of the core fuctions of a speadsheet program (in my opinion) in that somebody skills can make a calculation sheet and other people can use it to fill needed data and do the calculations and get the needed data. In excel you build your own UI to enter data and with VB you can do a lot of things. But in my opinion that's just overkill for most of the cases. Somebody said that it's an expected (and maybe even wanted?) behaviour, but I just can't understand it. I wish I could do the coding needed, but unfortunately I'm not skilled enough. I think that with a small improvement LibreOffice could be a lot better tool without too complicated things (like Excels UI + VB) I hope somebody, who could do something about this, finds this interesting and needed. :) Mikko -- View this message in context: http://nabble.documentfoundation.org/Calc-cell-protection-cut-paste-tp3903414p3908930.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] duplicate entire document writer
Hi :) Nicely done! Thanks Manfred :) Regards from Tom :) --- On Fri, 13/4/12, Pedro cartas.corr...@gmail.com wrote: From: Pedro cartas.corr...@gmail.com Subject: Re: [libreoffice-users] duplicate entire document writer To: users@global.libreoffice.org Date: Friday, 13 April, 2012, 10:55 :O fantastic! thank you! 2012/4/13 Manfred J. Krause courrier.oou.fr@googlemail.com: Hi Pedro, On Thu, Apr 12, 2012 at 11:50 PM, Pedro wrote: grrr another one that doesn't works... this time the double ctrl+a doesn't works... :( http://www.sendspace.com/file/l041vo thank you (1) Set the cursor before '' (Table1:A1) (2) Press Alt+Enter (3) Ctrl+A Ctrl+C (4) Set the cursor below 'Aa...' (Table4:A2) [now: last line of page 2] (5) Ctrl+V ... (6) Remove the first (empty) page Sample: → https://www.dropbox.com/sh/lm5p9q9vq8qfzxa/noKlZ9rJzX/mapa_instala%C3%A7%C3%A3o_modelo_50.odt mjk 2012/4/12 Tom Davies: [...] --- On Wed, 11/4/12, Pedro wrote: [...] 2012/4/11 Tom Davies: [...] --- On Wed, 11/4/12, Pedro wrote: From: Pedro Date: Wednesday, 11 April, 2012, 14:25 hi, i need the 50 sheet in one document (tu use the pagination feature...) cntrl+a do not select all the entire sheet... just the first table thank you 2012/4/11 Tom Davies: [...] --- On Wed, 11/4/12, Pedro wrote: From: Pedro cartas.corr...@gmail.com Date: Wednesday, 11 April, 2012, 14:13 hello, i have a writer sheet with tables that i need to duplicate 50 times, i have the numbering function activated on the first one... i can't copy the entire sheet, can't select all tables at the same time... anyone can help me? thank you -- Street installations by Mark Jenkins http://xmarkjenkinsx.com/outside.html -- 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: How to download?
That's it. But the rate from that site is like 62k per second for me. I'm near Washington, DC. This is the speed coming from the server. Are there mirrors I can choose from, closer to me or not throttled? I couldn't find any download mirrors. On Fri, 2012-04-13 at 14:45 +0200, Andreas Säger wrote: Am 13.04.2012 03:14, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my connection speed. Its fast. thanks. Where do you try to download from? Should be http://www.libreoffice.org/download/ and nothing else. The [Info] link leads to alternative locations (torrents and mirrors). -- 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] Multiple language settings for spell check
On 04/12/2012 10:14 PM, Dan Lewis wrote: On Thu, 2012-04-12 at 20:15 -0400, Calvin Kim wrote: Is there a way to spell check multiple languages at once? If Western and Asian language are mixed, LibO seems to understand differences and use proper language dictionaries. But if I try to use two Western languages like English and Spanish, all Spanish words are filtered, because LibO only use English dictionary to spell check. I just found out, in Adobe Illustrator, you can highlight words and assign them to proper language setting, so that spell check will not pick them up as typo. It would be nice if LibO has a similar function. For an example, if there is an option in 'character style' setting to set languages. Then LibO will know exactly which words are in what language. How do you think? cK Yes there is. Chapter 7 of the Writer Guide contains a section on Paragraph styles. This will tell you how to assign a language for spelling to a selected paragraph. So, you can have one or more paragraphs in Spanish and some other paragraphs in English. By creating a paragraph style for English and another for Spanish and assigning them their respective paragraph styles, you can correctly spell check the entire document. If you want to mix words from different languages in a single paragraph, create the appropriate character styles for the desired language (done the same way as when creating paragraph styles for languages). By doing this, I can correctly spell check the following paragraph for three languages at once: No hablo Español. Aber Ich kann Deutch. Neat little trick, isn't it? Comment: I applied the Spanish character style to the first sentence and German to the second sentence. Since my chosen language is English (USA), the spell checker automatically checked spelling in English for anything that did not have a language character style applied to it. --Dan That's right. You can change the language in font tab. I just overlooked even though I use it everyday. Thanks. cK -- 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] [writer] Moving a frame with a table in
On 04/13/2012 01:30 AM, Jean-Francois Nifenecker wrote: Le 13/04/2012 07:21, Jean-Francois Nifenecker a écrit : Le 12/04/2012 21:43, Calvin Kim a écrit : Mmm, that's weird. I'm using LibO 3.4.4 in Ubuntu 11.10. To correct it, 1. Do not highlight the frame. 2. Move your cursor to outside of table, and inside of frame (to below the table perhaps) 3. Then [Alt]+direction key works fine. Ha ha! Yeah, right. Thanks. This works. IMO this is counter-intuitive: moving/acting against a frame/whatever is done by selecting the widget, isn't it? Drawback: doesn't work when there's nothing but the table within the frame. Mmm, that's weird, too. Because it works for me. I just opened up new document, insert new frame, insert a table in frame. No content whatsoever. How did you anchor your frame? Anchor as character will not work obviously. cK -- 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: Calc: cell protection + cut paste
El 13/04/12 22:36, miakoiv escribió:
-Original Message-
From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org]
Sent: Thursday, April 12, 2012 11:15
To: 'users@global.libreoffice.org'
Subject: RE: [libreoffice-users] Re: Calc: cell protection + cut paste
I spoke too soon. Absolute references don't solve this problem, because
even those are updated when moves happen, such as the cut and paste in the
demonstration example. There actually needs to be a way to block cutting
and other operations that relocate cells if formulas are to be protected
from movement of their operands.
It looks like a bigger issue might be whether it is possible to prevent
editing operations (cut especially but also row-column insertions and
deletions) in a sheet with protections turned on. All while still
allowing data entry into unprotected cells.
Yes, absolute references don't solve it.
And I really do agree that there should be a way to control how these
editing operations affect protected cells.
One of the core fuctions of a speadsheet program (in my opinion) in that
somebody skills can make a calculation sheet and other people can use it to
fill needed data and do the calculations and get the needed data.
In excel you build your own UI to enter data and with VB you can do a lot of
things. But in my opinion that's just overkill for most of the cases.
Somebody said that it's an expected (and maybe even wanted?) behaviour, but
I just can't understand it.
I wish I could do the coding needed, but unfortunately I'm not skilled
enough.
I think that with a small improvement LibreOffice could be a lot better tool
without too complicated things (like Excels UI + VB)
I hope somebody, who could do something about this, finds this interesting
and needed. :)
Mikko
--
View this message in context:
http://nabble.documentfoundation.org/Calc-cell-protection-cut-paste-tp3903414p3908930.html
Sent from the Users mailing list archive at Nabble.com.
A workaround is INDIRECT() function to avoid that cut/paste change the
references:
C1: =INDIRECT(A2)+INDIRECT(B1)
other options can be used like OFFSET() or INDEX(), and I don't know
how, maybe is easy to disable the cut option.
To avoid delete/insert rows/columns use an array formula:
An array formula in A1 like = {IV1:IV100} doesn't let delete/insert rows
in the range of the array formula, the same for columns with a column array.
Miguel Ángel
--
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 one export from Calc a spreadsheet raw into a MySql database table raw?
On 04/13/2012 04:06 PM, Csanyi Pal wrote: Hi, I made in Calc a spreadsheet and now I want to export some raws into a mysql database table's raws. I have created already the database using command mysql to log into mysql server and have already the table in database with corresponding fields in table. Can I export somehow these data from Calc into database or must I manually fill every field in the table's records? I can connect to this database from LibreOffice, but don't know how could I easily tranship datas from Calc into table's fields? You can import Open Document Spreadsheet directly from phpMyAdmin to MySQL. cK -- 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: How to download?
On Fri, 2012-04-13 at 18:05 -0400, Darren Govoni wrote: That's it. But the rate from that site is like 62k per second for me. I'm near Washington, DC. This is the speed coming from the server. Are there mirrors I can choose from, closer to me or not throttled? I couldn't find any download mirrors. WOW - me too- I'm in Maryland, the download usually takes is less the 5 minutes, now reporting 57 minutes...something isn't right. Sent this to the website ML also - where folks might be able to help. //drew On Fri, 2012-04-13 at 14:45 +0200, Andreas Säger wrote: Am 13.04.2012 03:14, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my connection speed. Its fast. thanks. Where do you try to download from? Should be http://www.libreoffice.org/download/ and nothing else. The [Info] link leads to alternative locations (torrents and mirrors). -- 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: Can one export from Calc a spreadsheet raw into a MySql database table raw?
Am 13.04.2012 22:06, Csanyi Pal wrote: Hi, I made in Calc a spreadsheet and now I want to export some raws into a mysql database table's raws. I have created already the database using command mysql to log into mysql server and have already the table in database with corresponding fields in table. Can I export somehow these data from Calc into database or must I manually fill every field in the table's records? I can connect to this database from LibreOffice, but don't know how could I easily tranship datas from Calc into table's fields? Copy the cell range with or without column headers. Select the table icon in the database window. Paste. Choose Append data and wether there are column headers. DragDrop works as well. You can also drag database table icons between database documents (which may also be connected to a Calc document) -- 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: Calc: cell protection + cut paste
Am 13.04.2012 22:36, miakoiv wrote: Yes, absolute references don't solve it. And I really do agree that there should be a way to control how these editing operations affect protected cells. One of the core fuctions of a speadsheet program (in my opinion) in that somebody skills can make a calculation sheet and other people can use it to fill needed data and do the calculations and get the needed data. There is no need to complicate things just because the simple rules of a spreadsheet don't fit your current requirements. Absolute/relative referencing has nothing to do with the protection state. The two features are completely independent from each other. There must not be any special meaning of absolute references for protected cells. As a matter of course, the spreadsheet program keeps track of the references when you move around referenced cells. There are ways to work-around this behaviour (INDIRECT, INDEX, OFFSET). What you may have in mind may be more like a database form. LibreOffice supports databases and database forms. -- 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: How to download?
Am 14.04.2012 00:05, Darren Govoni wrote: That's it. But the rate from that site is like 62k per second for me. I'm near Washington, DC. This is the speed coming from the server. Are there mirrors I can choose from, closer to me or not throttled? I couldn't find any download mirrors. On Fri, 2012-04-13 at 14:45 +0200, Andreas Säger wrote: Am 13.04.2012 03:14, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my connection speed. Its fast. thanks. Where do you try to download from? Should be http://www.libreoffice.org/download/ and nothing else. The [Info] link leads to alternative locations (torrents and mirrors). Again, click the [Info] link on the download page which takes you to http://download.documentfoundation.org/libreoffice/stable/3.5.2/deb/x86/LibO_3.5.2_Linux_x86_install-deb_en-US.tar.gz.mirrorlist -- 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: How to download?
On Fri, 2012-04-13 at 19:10 -0400, drew jensen wrote: On Fri, 2012-04-13 at 18:05 -0400, Darren Govoni wrote: That's it. But the rate from that site is like 62k per second for me. I'm near Washington, DC. This is the speed coming from the server. Are there mirrors I can choose from, closer to me or not throttled? I couldn't find any download mirrors. WOW - me too- I'm in Maryland, the download usually takes is less the 5 minutes, now reporting 57 minutes...something isn't right. Sent this to the website ML also - where folks might be able to help. Ok - it is a particular mirror which is being slow: http://ibiblio.org Pick any of the others in the US and the download speed goes right back to normal. //drew //drew On Fri, 2012-04-13 at 14:45 +0200, Andreas Säger wrote: Am 13.04.2012 03:14, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my connection speed. Its fast. thanks. Where do you try to download from? Should be http://www.libreoffice.org/download/ and nothing else. The [Info] link leads to alternative locations (torrents and mirrors). -- 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: How to download?
Hi, Question.? When I am in the download section of LibreOffice, http://www.libreoffice.org/download/ , how do I find the options of where to download it from. I'm missing something somewhere. Thank you. don On 04/13/2012 07:40 PM, drew jensen wrote: On Fri, 2012-04-13 at 19:10 -0400, drew jensen wrote: On Fri, 2012-04-13 at 18:05 -0400, Darren Govoni wrote: That's it. But the rate from that site is like 62k per second for me. I'm near Washington, DC. This is the speed coming from the server. Are there mirrors I can choose from, closer to me or not throttled? I couldn't find any download mirrors. WOW - me too- I'm in Maryland, the download usually takes is less the 5 minutes, now reporting 57 minutes...something isn't right. Sent this to the website ML also - where folks might be able to help. Ok - it is a particular mirror which is being slow: http://ibiblio.org Pick any of the others in the US and the download speed goes right back to normal. //drew //drew On Fri, 2012-04-13 at 14:45 +0200, Andreas Säger wrote: Am 13.04.2012 03:14, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my connection speed. Its fast. thanks. Where do you try to download from? Should be http://www.libreoffice.org/download/ and nothing else. The [Info] link leads to alternative locations (torrents and mirrors). -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Phone: 814-237-6543 Fax: 814-237-6502 Visit the Farm and Rural Property Division Website at www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_ _View Don's farm website: www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: How to download?
On Fri, 2012-04-13 at 20:00 -0400, Don Myers wrote: Hi, Question.? When I am in the download section of LibreOffice, http://www.libreoffice.org/download/ , how do I find the options of where to download it from. I'm missing something somewhere. What you don't know the secret handshake ;) On the download page, the green download button, click on the link, lower right hand, Info. This will give you a page with, amongst other items, direct links to the mirrors, those in your region listed first. //drew Thank you. don On 04/13/2012 07:40 PM, drew jensen wrote: On Fri, 2012-04-13 at 19:10 -0400, drew jensen wrote: On Fri, 2012-04-13 at 18:05 -0400, Darren Govoni wrote: That's it. But the rate from that site is like 62k per second for me. I'm near Washington, DC. This is the speed coming from the server. Are there mirrors I can choose from, closer to me or not throttled? I couldn't find any download mirrors. WOW - me too- I'm in Maryland, the download usually takes is less the 5 minutes, now reporting 57 minutes...something isn't right. Sent this to the website ML also - where folks might be able to help. Ok - it is a particular mirror which is being slow: http://ibiblio.org Pick any of the others in the US and the download speed goes right back to normal. //drew //drew On Fri, 2012-04-13 at 14:45 +0200, Andreas Säger wrote: Am 13.04.2012 03:14, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my connection speed. Its fast. thanks. Where do you try to download from? Should be http://www.libreoffice.org/download/ and nothing else. The [Info] link leads to alternative locations (torrents and mirrors). -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Phone: 814-237-6543 Fax: 814-237-6502 Visit the Farm and Rural Property Division Website at www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_ _View Don's farm website: www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: How to download?
Thank you so much Drew!!! I would have never found the secret handshake Don On 04/13/2012 08:08 PM, drew jensen wrote: On Fri, 2012-04-13 at 20:00 -0400, Don Myers wrote: Hi, Question.? When I am in the download section of LibreOffice, http://www.libreoffice.org/download/ , how do I find the options of where to download it from. I'm missing something somewhere. What you don't know the secret handshake ;) On the download page, the green download button, click on the link, lower right hand, Info. This will give you a page with, amongst other items, direct links to the mirrors, those in your region listed first. //drew Thank you. Don On 04/13/2012 07:40 PM, drew jensen wrote: On Fri, 2012-04-13 at 19:10 -0400, drew jensen wrote: On Fri, 2012-04-13 at 18:05 -0400, Darren Govoni wrote: That's it. But the rate from that site is like 62k per second for me. I'm near Washington, DC. This is the speed coming from the server. Are there mirrors I can choose from, closer to me or not throttled? I couldn't find any download mirrors. WOW - me too- I'm in Maryland, the download usually takes is less the 5 minutes, now reporting 57 minutes...something isn't right. Sent this to the website ML also - where folks might be able to help. Ok - it is a particular mirror which is being slow: http://ibiblio.org Pick any of the others in the US and the download speed goes right back to normal. //drew //drew On Fri, 2012-04-13 at 14:45 +0200, Andreas Säger wrote: Am 13.04.2012 03:14, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my connection speed. Its fast. thanks. Where do you try to download from? Should be http://www.libreoffice.org/download/ and nothing else. The [Info] link leads to alternative locations (torrents and mirrors). -- -- ** -- 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: LOo 3.5.1.2 upgrade in Ubuntu Natty does not 'see' old templates
On 04/11/2012 12:39 PM, Don C. Myers wrote: Hi Fabian, I've been using Ubuntu for 3+ years. A few years ago I had some issues with the Ubuntu OpenOffice packages. It might not have been their fault since I had non-repo versions installed when I did an upgrade. To fix that problem, I did a complete uninstall of the Ubuntu version and installed the official OpenOffice version. Ever since then I've used only the official OpenOffice version before LibreOffice came along, and the official LibreOffice version from http://www.libreoffice.org/. they aren't as pretty, but functionality has been very good. I've been running 3.5.2 on Ubuntu 11.10 and also 12.04 Beta 2 without any issues. And the recent documents function works perfectly fine in the LibreOffice version in Ubuntu 11.10 and 12.04 Beta 2. Here is how I do my install: (This is for the 64 bit version.) Download LibO_3.5.2_Linux_x86-64_install-deb_en-US.tar.gz to the desktop. Right click on it and extract it to the desktop. This will give you the folder LibO_3.5.2rc2_Linux_x86-64_install-deb_en-US Run the following terminal commands to install it: 1. sudo apt-get remove libreoffice*.* It is unnecessary to remove the Ubuntu/distro version of LO. That version *and* the standard LO version(s) reside nicely on the same machine, and can be run simultaneously. I currenly have open working, at the same time: LO 3.3.4, LO 3.4.6, LO 3.5.1.2, (U)LO 3.3.4, OOo 3.4.0, and OOo-Dev3: $ locate bootstraprc /opt/libreoffice/program/bootstraprc /opt/libreoffice3.4/program/bootstraprc /opt/libreoffice3.5/program/bootstraprc /opt/ooo-dev3/program/bootstraprc /opt/openoffice.org3/program/bootstraprc /usr/lib/libreoffice/program/bootstraprc The only bits you need to watch out for is where the user configuration files are placed. In order to not have one write over the other, I simply modify the bootsraprc file *before first run* so that each have their own user config/profile files. Example: For LO 3.3: $ gksu gedit /opt/libreoffice/program/bootstraprc and change UserInstallation=$SYSUSERCONFIG/.libreoffice/3 to UserInstallation=$SYSUSERCONFIG/.libreoffice3.3/3 For LO 3.4: $ gksu gedit /opt/libreoffice3.4/program/bootstraprc to UserInstallation=$SYSUSERCONFIG/.libreoffice3.4/3 For LO 3.5: $ gksu gedit /opt/libreoffice3.5/program/bootstraprc to UserInstallation=$SYSUSERCONFIG/libreoffice3.5/3 Create menu items to each (example: '/opt/libreoffice3.5/program/soffice'), and that's it. The Ubuntu/distro version will keep it's profile at ~/.libreoffice/3/user (or ~/.config/libreoffice/3/user in the case of the 3.5 versions), the others will name put the profile as you've intsructed in the bootstraprc file. ... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: How to download?
I just learned the secret handshake hidden in plain sight. And it works now. On Fri, 2012-04-13 at 20:17 -0400, Don Myers wrote: Thank you so much Drew!!! I would have never found the secret handshake Don On 04/13/2012 08:08 PM, drew jensen wrote: On Fri, 2012-04-13 at 20:00 -0400, Don Myers wrote: Hi, Question.? When I am in the download section of LibreOffice, http://www.libreoffice.org/download/ , how do I find the options of where to download it from. I'm missing something somewhere. What you don't know the secret handshake ;) On the download page, the green download button, click on the link, lower right hand, Info. This will give you a page with, amongst other items, direct links to the mirrors, those in your region listed first. //drew Thank you. Don On 04/13/2012 07:40 PM, drew jensen wrote: On Fri, 2012-04-13 at 19:10 -0400, drew jensen wrote: On Fri, 2012-04-13 at 18:05 -0400, Darren Govoni wrote: That's it. But the rate from that site is like 62k per second for me. I'm near Washington, DC. This is the speed coming from the server. Are there mirrors I can choose from, closer to me or not throttled? I couldn't find any download mirrors. WOW - me too- I'm in Maryland, the download usually takes is less the 5 minutes, now reporting 57 minutes...something isn't right. Sent this to the website ML also - where folks might be able to help. Ok - it is a particular mirror which is being slow: http://ibiblio.org Pick any of the others in the US and the download speed goes right back to normal. //drew //drew On Fri, 2012-04-13 at 14:45 +0200, Andreas Säger wrote: Am 13.04.2012 03:14, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my connection speed. Its fast. thanks. Where do you try to download from? Should be http://www.libreoffice.org/download/ and nothing else. The [Info] link leads to alternative locations (torrents and mirrors). -- -- ** -- 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: LOo 3.5.1.2 upgrade in Ubuntu Natty does not 'see' old templates
On 04/13/2012 08:37 PM, NoOp wrote: On 04/11/2012 12:39 PM, Don C. Myers wrote: Hi Fabian, I've been using Ubuntu for 3+ years. A few years ago I had some issues with the Ubuntu OpenOffice packages. It might not have been their fault since I had non-repo versions installed when I did an upgrade. To fix that problem, I did a complete uninstall of the Ubuntu version and installed the official OpenOffice version. Ever since then I've used only the official OpenOffice version before LibreOffice came along, and the official LibreOffice version from http://www.libreoffice.org/. they aren't as pretty, but functionality has been very good. I've been running 3.5.2 on Ubuntu 11.10 and also 12.04 Beta 2 without any issues. And the recent documents function works perfectly fine in the LibreOffice version in Ubuntu 11.10 and 12.04 Beta 2. Here is how I do my install: (This is for the 64 bit version.) Download LibO_3.5.2_Linux_x86-64_install-deb_en-US.tar.gz to the desktop. Right click on it and extract it to the desktop. This will give you the folder LibO_3.5.2rc2_Linux_x86-64_install-deb_en-US Run the following terminal commands to install it: 1. sudo apt-get remove libreoffice*.* It is unnecessary to remove the Ubuntu/distro version of LO. That version *and* the standard LO version(s) reside nicely on the same machine, and can be run simultaneously. I currenly have open working, at the same time: LO 3.3.4, LO 3.4.6, LO 3.5.1.2, (U)LO 3.3.4, OOo 3.4.0, and OOo-Dev3: $ locate bootstraprc /opt/libreoffice/program/bootstraprc /opt/libreoffice3.4/program/bootstraprc /opt/libreoffice3.5/program/bootstraprc /opt/ooo-dev3/program/bootstraprc /opt/openoffice.org3/program/bootstraprc /usr/lib/libreoffice/program/bootstraprc The only bits you need to watch out for is where the user configuration files are placed. In order to not have one write over the other, I simply modify the bootsraprc file *before first run* so that each have their own user config/profile files. Example: For LO 3.3: $ gksu gedit /opt/libreoffice/program/bootstraprc and change UserInstallation=$SYSUSERCONFIG/.libreoffice/3 to UserInstallation=$SYSUSERCONFIG/.libreoffice3.3/3 For LO 3.4: $ gksu gedit /opt/libreoffice3.4/program/bootstraprc to UserInstallation=$SYSUSERCONFIG/.libreoffice3.4/3 For LO 3.5: $ gksu gedit /opt/libreoffice3.5/program/bootstraprc to UserInstallation=$SYSUSERCONFIG/libreoffice3.5/3 Create menu items to each (example: '/opt/libreoffice3.5/program/soffice'), and that's it. The Ubuntu/distro version will keep it's profile at ~/.libreoffice/3/user (or ~/.config/libreoffice/3/user in the case of the 3.5 versions), the others will name put the profile as you've intsructed in the bootstraprc file. ... Thank you NoOp. I appreciate the information. The bad experience I had was about 2 years ago with OpenOffice. I had updated that to a new version. Several months later Ubuntu had an upgrade, and they had the same version of Open Office I had upgraded to. I didn't think anything about it. When I went to use Calc, I had some of the strangest behaviors. For any formula, it always gave the wrong answers, even for very obvious ones, such as 2+2, or 2*25. The only way I got things working properly again was to uninstall OpenOffice completely, then I reinstalled the application directly from OpenOffice. Don -- ** -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: LOo 3.5.1.2 upgrade in Ubuntu Natty does not 'see' old templates
On 04/13/2012 06:03 PM, Don Myers wrote: On 04/13/2012 08:37 PM, NoOp wrote: ... The only bits you need to watch out for is where the user configuration files are placed. In order to not have one write over the other, I simply modify the bootsraprc file *before first run* so that each have their own user config/profile files. Example: For LO 3.3: $ gksu gedit /opt/libreoffice/program/bootstraprc and change UserInstallation=$SYSUSERCONFIG/.libreoffice/3 to UserInstallation=$SYSUSERCONFIG/.libreoffice3.3/3 For LO 3.4: $ gksu gedit /opt/libreoffice3.4/program/bootstraprc to UserInstallation=$SYSUSERCONFIG/.libreoffice3.4/3 For LO 3.5: $ gksu gedit /opt/libreoffice3.5/program/bootstraprc to UserInstallation=$SYSUSERCONFIG/libreoffice3.5/3 Create menu items to each (example: '/opt/libreoffice3.5/program/soffice'), and that's it. The Ubuntu/distro version will keep it's profile at ~/.libreoffice/3/user (or ~/.config/libreoffice/3/user in the case of the 3.5 versions), the others will name put the profile as you've intsructed in the bootstraprc file. ... Thank you NoOp. I appreciate the information. The bad experience I had was about 2 years ago with OpenOffice. I had updated that to a new version. Several months later Ubuntu had an upgrade, and they had the same version of Open Office I had upgraded to. I didn't think anything about it. When I went to use Calc, I had some of the strangest behaviors. For any formula, it always gave the wrong answers, even for very obvious ones, such as 2+2, or 2*25. The only way I got things working properly again was to uninstall OpenOffice completely, then I reinstalled the application directly from OpenOffice. Don Ah. That is most likely of the two sharing the same profile (~/.openoffice.org/3/user). That is why I ensure that the standard install profiles are different from the distro version. For OOo 3.4 (standard) my bootstraprc file is modified to: UserInstallation=$SYSUSERCONFIG/.openoffice.org3.4/3 That kept it completely separate from the distro ~/.openoffice.org/3/. Note: the advantage of keeping (U)OOo installed (at the time) was that (U)OOo used the go-oo version, so it used gstreamer for multimedia. The standard versions of OOo did not so you had to install the ancient Java Media Format (JMF) that was a royal PITA. The advantage of keeping all of these installed on my system is that I can easily compare differences between versions, including putting windows of each side-by-side. -- 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: [Announce] HyperSQL 2.2.8 Released
Thank you for all of your replies, the information is very helpful, and I will continue to explore. Just one more question: Would migrating to other databases (like MySQL or PostgreSQL) be similar to how I would migrate from an *.odb file to a HSQL database? If not, are there instructions for transitioning to MySQL or PostgreSQL? Thanks! -- View this message in context: http://nabble.documentfoundation.org/Announce-HyperSQL-2-2-8-Released-tp3903059p3909460.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Bullets in .doc/.docx documents always become ^?
This is quite strange, indeed. I created another test document in Micro$oft Word with the Times New Roman font (see attached bullets_test_2.docx, and the bullets showed up correctly in LibreOffice 3.5.2. So at this point I was thinking it is just a font issue. However, I opened another document, a meeting agenda for teaching assistants, that someone sent me (sample_bullets.docx). This was also using the Times New Roman font, but the bullets appeared as ^s again!!! Can anyone confirm this? Is there anyway to see what is different between the bullets in these two documents? http://nabble.documentfoundation.org/file/n3909470/bullets_test_2.docx bullets_test_2.docx http://nabble.documentfoundation.org/file/n3909470/sample_bullets.docx sample_bullets.docx -- View this message in context: http://nabble.documentfoundation.org/Bullets-in-doc-docx-documents-always-become-tp3901697p3909470.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Make a form that allows user to drag and drop in an image
Hi Drew, The database is really looking polished now, and I think I have a great starting point from which to integrate into my own databases. If you do find out how to implement drag and drop, please let me know. I am really thankful for your help! My schedule is kind of crazy for the next couple of weeks, but if you can draft an explanation for how all this works, I would be more than willing to follow it along, and help with editing it. Please let me know! Thanks again! -- View this message in context: http://nabble.documentfoundation.org/Make-a-form-that-allows-user-to-drag-and-drop-in-an-image-tp3890657p3909475.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: LOo 3.5.1.2 upgrade in Ubuntu Natty does not 'see' old templates
On 04/13/2012 09:50 PM, NoOp wrote: On 04/13/2012 06:03 PM, Don Myers wrote: On 04/13/2012 08:37 PM, NoOp wrote: ... The only bits you need to watch out for is where the user configuration files are placed. In order to not have one write over the other, I simply modify the bootsraprc file *before first run* so that each have their own user config/profile files. Example: For LO 3.3: $ gksu gedit /opt/libreoffice/program/bootstraprc and change UserInstallation=$SYSUSERCONFIG/.libreoffice/3 to UserInstallation=$SYSUSERCONFIG/.libreoffice3.3/3 For LO 3.4: $ gksu gedit /opt/libreoffice3.4/program/bootstraprc to UserInstallation=$SYSUSERCONFIG/.libreoffice3.4/3 For LO 3.5: $ gksu gedit /opt/libreoffice3.5/program/bootstraprc to UserInstallation=$SYSUSERCONFIG/libreoffice3.5/3 Create menu items to each (example: '/opt/libreoffice3.5/program/soffice'), and that's it. The Ubuntu/distro version will keep it's profile at ~/.libreoffice/3/user (or ~/.config/libreoffice/3/user in the case of the 3.5 versions), the others will name put the profile as you've intsructed in the bootstraprc file. ... Thank you NoOp. I appreciate the information. The bad experience I had was about 2 years ago with OpenOffice. I had updated that to a new version. Several months later Ubuntu had an upgrade, and they had the same version of Open Office I had upgraded to. I didn't think anything about it. When I went to use Calc, I had some of the strangest behaviors. For any formula, it always gave the wrong answers, even for very obvious ones, such as 2+2, or 2*25. The only way I got things working properly again was to uninstall OpenOffice completely, then I reinstalled the application directly from OpenOffice. Don Ah. That is most likely of the two sharing the same profile (~/.openoffice.org/3/user). That is why I ensure that the standard install profiles are different from the distro version. For OOo 3.4 (standard) my bootstraprc file is modified to: UserInstallation=$SYSUSERCONFIG/.openoffice.org3.4/3 That kept it completely separate from the distro ~/.openoffice.org/3/. Note: the advantage of keeping (U)OOo installed (at the time) was that (U)OOo used the go-oo version, so it used gstreamer for multimedia. The standard versions of OOo did not so you had to install the ancient Java Media Format (JMF) that was a royal PITA. The advantage of keeping all of these installed on my system is that I can easily compare differences between versions, including putting windows of each side-by-side. Thank you again. I'm sure you are correct. When I did the Ubuntu upgrade back then I didn't know enough to know there might be a conflict or anything like that. It was really, really strange to see the results I was getting with simple formulas. None of them gave the correct answer. -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Phone: 814-237-6543 Fax: 814-237-6502 Visit the Farm and Rural Property Division Website at www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_ _View Don's farm website: www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Micro Move graphic
If I select a graphic, say a bullet, that is already on the page, and want to move it 1/10 diameter, I can TRY to move the mouse that short distance, but it is not easy. I have tried using the arrow keys, but they move the graphic about an inch. I have tried key combinations (ctrl-key, etc) but they don't seem to work any better than the arrow key alone. -- View this message in context: http://nabble.documentfoundation.org/Micro-Move-graphic-tp3908914p3908914.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Removing Themes box
I don't know how I opened the themes box, but now I can't get rid of it. The damn thing takes about 3 inches off the top of my desktop/page. As I am writing a letter, the page is already short enough. -- View this message in context: http://nabble.documentfoundation.org/Removing-Themes-box-tp3908902p3908902.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] Can one export from Calc a spreadsheet raw into a MySql database table raw?
On 04/13/2012 04:29 PM, Steve Edmonds wrote: On 2012-04-14 08:06, Csanyi Pal wrote: Hi, I made in Calc a spreadsheet and now I want to export some raws into a mysql database table's raws. I have created already the database using command mysql to log into mysql server and have already the table in database with corresponding fields in table. Can I export somehow these data from Calc into database or must I manually fill every field in the table's records? I can connect to this database from LibreOffice, but don't know how could I easily tranship datas from Calc into table's fields? I don't know if someone else can help with loading straight from calc, but you could save as a CSV file and use the LOAD DATA command to load into MySQL. Just check the result is as intended. http://dev.mysql.com/doc/refman/5.1/en/load-data.html Steve An alternate athttp://dev.mysql.com/doc/refman/5.5/en/load-data.html -- 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
Re: [libreoffice-users] Removing Themes box
On Fri, 2012-04-13 at 13:22 -0700, 20rdj04 wrote: I don't know how I opened the themes box, but now I can't get rid of it. The damn thing takes about 3 inches off the top of my desktop/page. As I am writing a letter, the page is already short enough. hmm - I believe you are referring to the Gallery. The menu item: ToolsGallery Toggles the feature on and off. HTH //drew -- View this message in context: http://nabble.documentfoundation.org/Removing-Themes-box-tp3908902p3908902.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [Announce] HyperSQL 2.2.8 Released
Hi, On 04/13/2012 10:22 PM, avamk wrote: Thank you for all of your replies, the information is very helpful, and I will continue to explore. Just one more question: Would migrating to other databases (like MySQL or PostgreSQL) be similar to how I would migrate from an *.odb file to a HSQL database? If not, are there instructions for transitioning to MySQL or PostgreSQL? Thanks! -- View this message in context: http://nabble.documentfoundation.org/Announce-HyperSQL-2-2-8-Released-tp3903059p3909460.html Sent from the Users mailing list archive at Nabble.com. MySQL and PostgreSQL migration requires using the appropriate connector. They are found as extensions to Base. Depending on the connector you may need to enter more or less connection information. -- 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
[libreoffice-users] Re: Bullets in .doc/.docx documents always become ^?
Thanks to Brian Barker, using a replacement table to replace the Symbol font with the OpenSymbol font worked to make the bullet points correctly. I don't mean to be too inquisitive, but does someone know why and how this is the solution, and could OpenSymbol be made the default so that compatibility with Word documents will be improved? Thanks! -- View this message in context: http://nabble.documentfoundation.org/Bullets-in-doc-docx-documents-always-become-tp3901697p3909585.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Bullets in .doc/.docx documents always become ^?
At 21:19 13/04/2012 -0700, Advrk Aplmrkt wrote: Thanks to Brian Barker, using a replacement table to replace the Symbol font with the OpenSymbol font worked to make the bullet points correctly. Since this worked, it may be helpful to others to have it articulated: o Go to Tools | Options... | LibreOffice | Fonts. o Tick Apply replacement table. o Enter Symbol and OpenSymbol. I don't mean to be too inquisitive, but does someone know why and how this is the solution, ... I'm guessing, but is it possible that the Symbol font in the generating system (wherever it comes from) has the bullets in a different place from where they are in the version of Symbol you have - but that OpenSymbol has them in the same place? Is it a Unicode issue? Remember that word processor documents (generally) carry font names, not the fonts themselves. ... and could OpenSymbol be made the default so that compatibility with Word documents will be improved? I cannot know whether that would generally be an improvement. But it's what you have arranged by this setting, of course. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to format data entry in base table to UPPERCASE only
Which is also to say that the input filters you're expecting don't exist in Base. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Micro Move graphic
Le 13/04/2012 22:30, 20rdj04 a écrit : If I select a graphic, say a bullet, that is already on the page, and want to move it 1/10 diameter, I can TRY to move the mouse that short distance, but it is not easy. I have tried using the arrow keys, but they move the graphic about an inch. I have tried key combinations (ctrl-key, etc) but they don't seem to work any better than the arrow key alone. [Alt]+[arrow] should do. Alternatively -- and yet better -- use the Size and Position dialog (right-click, then Size and Position). There you can set the position to an *exact* value. Note: the reaction to the [arrow] (and combination) highly depends upon the graphics anchoring. Depending upon your needs, Character and As character are likely to be the best choices. -- 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
