Re: [libreoffice-users] BasIe - connecting through JDBC
On 03/02/2013 08:10 AM, Heinrich Stoellinger wrote: Hello, Seeing as the Native MySQL-connector seems to be a difficult birth - I tried both ODBC and JDBC lately. Unfortunately both seem to be unusable! JDBC: I cannot get it to accept German special characters (even though I specify codepage ISO-8859-15/EURO). Also, when inserting you rows into the database, both with JDBC and ODBC, string default values are shown with apostrophies at the beginning and end. If one then re-selects the row, the fields are shown correctly (i.e. without the apostrophies). This might be kind of o.k. for me as I have around 30 years of IT-experience behind me, but certainly NOT o.k. for the average uninitiated user... ODBC: default values as specified within a table creation show kind of random values in columns of inserted tuples. When refreshing the display or re-selecting the tuplethe values are displayed correctly. I yearn for the native connector but unfortunately really DON't have the time to build it myself... Regards Heinr What OS are you using? I have built a mysql-connector-ooo.oxt (1.0.2) on Ubuntu 12.04. With it I have connected to a MySQL server 5.5 both locally and remotely. I did this using LO 4.0.0.3, LO 4.0.1.1, and 4.1.0.0+alpha (the build created with the connector. Today I plan to install Mandriva to see whether it will work with it. It is alpha until sufficient testing is done. --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: new version of LO gives gibberish for excel file.
Opens fine in 3.6.5.2 on Windows 7 64 bit... The only difference between your machine and mine is mine has 8Gb of ram. -- View this message in context: http://nabble.documentfoundation.org/new-version-of-LO-gives-gibberish-for-excel-file-tp4040924p4041117.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] new version of LO gives gibberish for excel file.
2013/3/1 David B Teague sr davidbtea...@comporium.net Hi I just downloaded an excel file from http://www.taxpolicycenter.**org/taxfacts/displayafact.cfm?**Docid=205http://www.taxpolicycenter.org/taxfacts/displayafact.cfm?Docid=205 The file is the excel version of Historical Source of Revenue as Share of GDP. The newest, recommended version of LO opens the file as gibberish: LibreOffice Version 3.6.5.2 (Build ID: 5b93205) My system runs Windows 7, 64 bit, AMD quad core, 4 GB RAM. Can anyone explain or help me fix this? A workaround is to fetch MS' Excel Viewer, then copy from that to a table in Writer for my document, but I would prefer to use LO for as nearly everything as possible. Warmest Regards David Teague -- nil significat nisi oscillat do wop, do wop, do wop! -- Duke Ellington ​Just a line to confirm that the hist_receipt_source_GDP.xls file opens without any difficulty in LO 4.0.0.3 on my main box running 64-bit Ubuntu 12.04 Henri -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] BasIe - connecting through JDBC
On Sat, 02 Mar 2013 14:46:45 +0100, Dan Lewis elderdanle...@gmail.com wrote: On 03/02/2013 08:10 AM, Heinrich Stoellinger wrote: Hello, Seeing as the Native MySQL-connector seems to be a difficult birth - I tried both ODBC and JDBC lately. Unfortunately both seem to be unusable! JDBC: I cannot get it to accept German special characters (even though I specify codepage ISO-8859-15/EURO). Also, when inserting you rows into the database, both with JDBC and ODBC, string default values are shown with apostrophies at the beginning and end. If one then re-selects the row, the fields are shown correctly (i.e. without the apostrophies). This might be kind of o.k. for me as I have around 30 years of IT-experience behind me, but certainly NOT o.k. for the average uninitiated user... ODBC: default values as specified within a table creation show kind of random values in columns of inserted tuples. When refreshing the display or re-selecting the tuplethe values are displayed correctly. I yearn for the native connector but unfortunately really DON't have the time to build it myself... Regards Heinr What OS are you using? I have built a mysql-connector-ooo.oxt (1.0.2) on Ubuntu 12.04. With it I have connected to a MySQL server 5.5 both locally and remotely. I did this using LO 4.0.0.3, LO 4.0.1.1, and 4.1.0.0+alpha (the build created with the connector. Today I plan to install Mandriva to see whether it will work with it. It is alpha until sufficient testing is done. --Dan Hi Dan, I use LO 4.0.0.3 on Debian-Wheezy. On this system the Native Connector works just fine (locally with MySQL 5.5 and remotely with MySQL 5.1 (Debian Squeeze))! I also just installed LO 4.0.1.2 on Mint Nadia. The connector does NOT work on that system. If you could let me have the one you built for LO 4.0.1.1 on Ubuntu 12.04 I would be much obliged to you. I might try to build one myself if I find the time. Could you provide some hints on how to go about that? Thanks a lot H. S. -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Writer: Nested Bullet Lists with different bullets?
I finally figured out what my problem was. I was using the Indent button instead of the Demote button. Once I got my buttons straight everything worked fine. On 02/23/2013 06:50 PM, Dan Lewis wrote: You are right: Edit your Default template. Then edit the List style you want to use. Make these changes in the Option tab. Make any other changes that you want to use and click OK to close it. Save your Default template. One thing that was not mentioned explicitly. Step 1 needs to be done for each level of bullets you want to use. (I think from your original email that you understand this, but I wanted to make sure.) --Dan On 02/23/2013 06:01 PM, Kevin O'Brien wrote: Does this mean it cannot be done with a Style? The reason I ask is that this window seems very similar to the Style window, but I assume it will only let me do something in the current document. Presumably if I could create a style and save it in my Default template I would have it available to me for all future documents. Thanks, On 02/23/2013 04:38 PM, Kieran Peckett wrote: My suggestion is to go to Format Bullets and Numbering Options Then... 1. Select the level from the left 2. Change the Numbering drop-down to Bullet 3. Then choose Bullets from the only other drop-down left 4. Then use the button labelled ... to choose the bullet you want. On Saturday, 23 February 2013, Kevin O'Brien wrote: Is it possible to create nested bullet lists where each level has a different bullet type? Somehow I am failing to do it, even when I see what looks like possibilities. For example, if you open the Numbering Style window, go to the Outline tab, and look at the bottom right selection it looks like what I want to do, but selecting it does not create this type of nested list. And when I go to the Options tab it lets me select different characters for each level, but it won't let me apply them. I'm thinking I may be missing some basic part of this that makes everything work. Can anyone shed light on this? Thank you, -- Kevin B. O'Brien zwil...@zwilnik.com http://google.me/+kevinobrien -- Kevin B. O'Brien zwil...@zwilnik.com http://google.me/+kevinobrien -- 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] BasIe - connecting through JDBC
On 03/02/2013 01:47 PM, Heinrich Stoellinger wrote: On Sat, 02 Mar 2013 14:46:45 +0100, Dan Lewis elderdanle...@gmail.com wrote: On 03/02/2013 08:10 AM, Heinrich Stoellinger wrote: Hello, Seeing as the Native MySQL-connector seems to be a difficult birth - I tried both ODBC and JDBC lately. Unfortunately both seem to be unusable! JDBC: I cannot get it to accept German special characters (even though I specify codepage ISO-8859-15/EURO). Also, when inserting you rows into the database, both with JDBC and ODBC, string default values are shown with apostrophies at the beginning and end. If one then re-selects the row, the fields are shown correctly (i.e. without the apostrophies). This might be kind of o.k. for me as I have around 30 years of IT-experience behind me, but certainly NOT o.k. for the average uninitiated user... ODBC: default values as specified within a table creation show kind of random values in columns of inserted tuples. When refreshing the display or re-selecting the tuplethe values are displayed correctly. I yearn for the native connector but unfortunately really DON't have the time to build it myself... Regards Heinr What OS are you using? I have built a mysql-connector-ooo.oxt (1.0.2) on Ubuntu 12.04. With it I have connected to a MySQL server 5.5 both locally and remotely. I did this using LO 4.0.0.3, LO 4.0.1.1, and 4.1.0.0+alpha (the build created with the connector. Today I plan to install Mandriva to see whether it will work with it. It is alpha until sufficient testing is done. --Dan Hi Dan, I use LO 4.0.0.3 on Debian-Wheezy. On this system the Native Connector works just fine (locally with MySQL 5.5 and remotely with MySQL 5.1 (Debian Squeeze))! I also just installed LO 4.0.1.2 on Mint Nadia. The connector does NOT work on that system. If you could let me have the one you built for LO 4.0.1.1 on Ubuntu 12.04 I would be much obliged to you. I might try to build one myself if I find the time. Could you provide some hints on how to go about that? Thanks a lot H. S. Here is the mysql connector that I built. This afternoon I installed Ubuntu 12.10 and LO 4.0.1.2. It worked on this OS as well. Remember that my computer is 32 bit, and this connector only works with 32 bit OS's. (You probably already know this.) Hope this is what you need. I do not know why the native connector will work with LO 4.0.0.3 unless that is a 64 bit OS. My tower also uses Ubuntu 12.04 64 bit. The 64 bit native connector works well with both the 3.x and 4.x versions of LO. It is the 32 bit connector that has been the problem. I need to take some time thinking through what I did and writing it down. I know that there are several steps with some of them seemingly repetive. The last step (make dev-install) takes about 4-6 hours to run. So, I will have to get back to you on this sometime closer to the end of next week. --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] Moving list items and re-numbering
I have another question regarding lists. If I create a Numbered list, I have items numbered 1, 2, 3, 4, etc. On the Bullets and Numbering toolbar there are buttons for moving list items, which would let do something like move item #2 to the top of the list. But when I do so it is still #2. Is there a way to do this that would change the numbers so that the former #2 becomes #1, and the former #1 becomes #2? Thanks, -- Kevin B. O'Brien zwil...@zwilnik.com http://google.me/+kevinobrien -- 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] new version of LO gives gibberish for excel file.
Opens fine in my Opensuse Version 3.6:build-304 (Build ID: 360m1(Build:304)) steve On 2013-03-02 03:18, David B Teague sr wrote: Hi I just downloaded an excel file from http://www.taxpolicycenter.org/taxfacts/displayafact.cfm?Docid=205 The file is the excel version of Historical Source of Revenue as Share of GDP. The newest, recommended version of LO opens the file as gibberish: LibreOffice Version 3.6.5.2 (Build ID: 5b93205) My system runs Windows 7, 64 bit, AMD quad core, 4 GB RAM. Can anyone explain or help me fix this? A workaround is to fetch MS' Excel Viewer, then copy from that to a table in Writer for my document, but I would prefer to use LO for as nearly everything as possible. Warmest Regards David Teague -- 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] new version of LO gives gibberish for excel file.
On 03/02/2013 11:11 PM, Steve Edmonds wrote: Opens fine in my Opensuse Version 3.6:build-304 (Build ID: 360m1(Build:304)) steve On 2013-03-02 03:18, David B Teague sr wrote: Hi I just downloaded an excel file from http://www.taxpolicycenter.org/taxfacts/displayafact.cfm?Docid=205 The file is the excel version of Historical Source of Revenue as Share of GDP. The newest, recommended version of LO opens the file as gibberish: LibreOffice Version 3.6.5.2 (Build ID: 5b93205) My system runs Windows 7, 64 bit, AMD quad core, 4 GB RAM. Can anyone explain or help me fix this? A workaround is to fetch MS' Excel Viewer, then copy from that to a table in Writer for my document, but I would prefer to use LO for as nearly everything as possible. Warmest Regards David Teague It opens fine, Ubuntu, *Version 3.6.2.2 (Build ID: 360m1(Build:2)) Joe Conner, Poulsbo, WA USA * -- 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