Re: [libreoffice-users] BasIe - connecting through JDBC
Heinrich, diid you trie the native aOO connector made by Ariel C.H. it seems it works fine on LO 3.6 nut alos no longer on 4.0 Ariel told me his extension can been recompilid using the SDK (without the whole code base) but i simply do not know how to this. My compagny is willing to pay for this services, any Volunteer ? Greetz Fernand 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 -- 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
Dan , Any interest to build a Windows Version ? My compagny is willing to provide the hardware an pay for your time ? Greetz Fernand 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
Re: [libreoffice-users] Moving list items and re-numbering
Le 03/03/2013 00:54, Kevin O'Brien a écrit : 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? Xubuntu 12.04 TDF LibO Version 4.0.1.1 (Build ID: 2c0c17a6e4bee0ee28131ea4bdc47edc700d659) I can't reproduce. Can you be more specific, please? -- OS and LibO version? -- the steps you're following to reproduce? -- are you creating your own numbering style or using the Numbered list toolbutton? -- 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
Re: [libreoffice-users] new version of LO gives gibberish for excel file.
Hi :) So it's beginning to sound like there might be a problem with the install of LibreOffice rather than with the file. David, can you re-download a fresh new version of LibreOffice? Either the stable branch, 3.6.5, http://www.libreoffice.org/download/?type=win-x86lang=en-USversion=3.6.5 or the branch with newer features and greater compatibility, the 4.0.0 http://www.libreoffice.org/download/ or the 4.0.1 when that comes out in a few days. https://wiki.documentfoundation.org/ReleasePlan While waiting for the download, or before starting on that, perhaps just try renaming your User Profile https://wiki.documentfoundation.org/Documentation/UserProfile Renaming the user profile resets all settings and configurations back to factory defaults so that usually fixes any weird problems and it's quite quick to try. Regards from Tom :) From: Steve Edmonds steve.edmo...@ptglobal.com To: David B Teague sr davidbtea...@comporium.net Cc: users@global.libreoffice.org Sent: Sunday, 3 March 2013, 7:11 Subject: 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 -- 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
Hi :) Is it possible to have a table or a list of the different connectors that are known to work with different versions of LibreOffice and on different platforms? Either on the Extensions site or as a wiki-page? Regards from Tom :) From: Dan Lewis elderdanle...@gmail.com To: users@global.libreoffice.org Sent: Saturday, 2 March 2013, 23:19 Subject: 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 -- 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] definition of flat/relational database
Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat databases* A flat database contains one or more tables, each containing one or more fields. Each table is completely independent of all the other tables in the database. For example, I have an address database with seven tables in it. One has my family's contacts, another has my business contacts, and another has my wife's family contacts. While some contacts are contained in more than one table, different tables may not have the same information about the same person. dBase is a flat database program. LibreOffice and several database programs can also create flat databases. *Relational databases* Relational databases contain one or more tables with one or more relationships; each relaltionship is defined by a pair of fields. One field of each pair belongs to one table and the second field belongs to the same or a different table. Where relationships exist between fields in the same or different tables, a flat database could still be used, but it provides no mechanism for defining the relationship. Instead the same data must be entered in both fields, making data entry errors more likely. A well designed relational database requires the data to be entered only once, reducing possible errors. dbase is a relational database per the above definition. I link 2 tables with 1 field so I can refer to data in the second database so data does not have to bbe entered multiple times. In our alarm monitoring station, when a police dept. changes its phone number, we change 1 field in 1 database. Hundreds of subscriber records refer to that field to populate the data screen. It seems that LO ptb either have a problem with dbase/xbase, or they are (were) uninformed of the facts. John Sowden (been programming in dBase II (under cp/m), Foxbase, Foxpro (under DOS) since 1981) -- 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] definition of flat/relational database
On 03/03/2013 10:09 AM, John R. Sowden wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat databases* A flat database contains one or more tables, each containing one or more fields. Each table is completely independent of all the other tables in the database. For example, I have an address database with seven tables in it. One has my family's contacts, another has my business contacts, and another has my wife's family contacts. While some contacts are contained in more than one table, different tables may not have the same information about the same person. dBase is a flat database program. LibreOffice and several database programs can also create flat databases. *Relational databases* Relational databases contain one or more tables with one or more relationships; each relaltionship is defined by a pair of fields. One field of each pair belongs to one table and the second field belongs to the same or a different table. Where relationships exist between fields in the same or different tables, a flat database could still be used, but it provides no mechanism for defining the relationship. Instead the same data must be entered in both fields, making data entry errors more likely. A well designed relational database requires the data to be entered only once, reducing possible errors. dbase is a relational database per the above definition. I link 2 tables with 1 field so I can refer to data in the second database so data does not have to bbe entered multiple times. In our alarm monitoring station, when a police dept. changes its phone number, we change 1 field in 1 database. Hundreds of subscriber records refer to that field to populate the data screen. It seems that LO ptb either have a problem with dbase/xbase, or they are (were) uninformed of the facts. John Sowden (been programming in dBase II (under cp/m), Foxbase, Foxpro (under DOS) since 1981) Good, someone who can provide some information! How far back has dBase been able to create and use relational databases? I ask because until OOo 1.1.15, Base created databases in dBase format. With the switch to using HSQLDB and embedded databases, Base could work with relational databases. Base could also work with dBase but only as a flat database. So, how would you suggest this section you quote be written to make it accurate? What are some good examples of flat databases? --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
Re: [libreoffice-users] Moving list items and re-numbering
2013/3/3 Kevin O'Brien zwil...@zwilnik.com 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 Running Writer on LO 4.0.03 on 64-bit Ubuntu 12.04, I have no difficulty using the arrows on the numbered-list toolbar to move, e g, the third item in a numbered list to the first or second postion, at which time it receives the appropriate numeral 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] Change Y axis labels in Calc chart
On 25/02/13 17:48, PeterTheBike wrote: In this chart I want to use the names in the legend to be labels in the Y axis instead of the numeric values. Is there a way this can be done please? Sample_position_chart.ods http://nabble.documentfoundation.org/file/n4039977/Sample_position_chart.ods Have you received assistance with this issue yet? Regards Hylton -- 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: Change Y axis labels in Calc chart
No, afraid not. Peter -- View this message in context: http://nabble.documentfoundation.org/Change-Y-axis-labels-in-Calc-chart-tp4039977p4041285.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] About.com Readers' Choice Awards 2013 for Office Software
FYI, the About.com Readers' Choice Awards 2013 for Office Software started on Feb. 19 and will end on March 19. You may vote every 24hrs. Let's make our LibreOffice suite the office suite of choice and it would be nice if we won out on all categories where we appear! To vote, you can log in with your Facebook or About.com accounts or you can enter your email address in a field on the page. Here are the details: = = The Readers' Choice Awards 2013 for Office Software categories webpage can be found here: http://office.about.com/od/ReaderResponse/tp/About-Com-Readers-Choice-Awards-2013-For-Office-Software-Nominations.htm = = As of today, March 3 2013, LibreOffice ranking in the various Office Software Suites categories is: = Favorite Office Suite for Android: LIBREOFFICE does not have an official implementation of an Android version. Favorite Office Suite for Android: Google Docs/Apps 80% -- Quickoffice Pro HD 20% = Favorite Office Software Suite or App for iOS: LIBREOFFICE does not have an official implementation of an iOS version. Favorite Office Software Suite or App for iOS: Google Apps 60% -- iWork 20% -- Documents Free 20% = Favorite Office Software for Mac: LibreOffice 75% -- iWork and MSO both 12% = Favorite Office Software for Windows: LibreOffice 75% -- MSO 14% -- AOO 10% = Favorite Office Software for BlackBerry: LibreOffice 100% = Favorite Office Software for Business: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO IS AWARE OF THIS. Favorite Office Software for Business: MSO 33% -- Google Docs/Apps 33% -- AOO 33% ??? -- IMO strange as LibreOffice is most likely used in Business = Favorite Academic Software Suite: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO IS AWARE OF THIS. Favorite Academic Software Suite: MSO Home and Student 50% -- Google Apps for Education 50% -- IMO, strange as LibreOffice is most likely used in education extensively!!! = Favorite Site for Office Software Templates: LibreOffice templates 80% -- MSO templates 20% = Favorite Cloud Office Suite: LIBREOFFICE, at present, does not have an official Cloud implementation, but is working on it. Favorite Cloud Office Suite: Google docs 100% = Favorite Office Software Company or Organization Based on Social Responsibility: TheDocumentFoundation 60% -- TheApacheFoundation 20% -- Microsoft 20% = Congrats to all who are voting every 24hrs. If you are not voting yet, feel free to join in. It will make a difference to our brand and show that we are a very committed community. Cheers, Marc -- Marc Paré m...@marcpare.com http://www.parEntreprise.com parEntreprise.com Supports OpenDocument Formats (ODF) parEntreprise.com Supports http://www.LibreOffice.org -- 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] Moving list items and re-numbering
On 2013-03-04 05:49, M Henri Day wrote: 2013/3/3 Kevin O'Brien zwil...@zwilnik.com 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 Running Writer on LO 4.0.03 on 64-bit Ubuntu 12.04, I have no difficulty using the arrows on the numbered-list toolbar to move, e g, the third item in a numbered list to the first or second postion, at which time it receives the appropriate numeral Henri I also have no problem on Version 3.6:build-304. I can also move a section of numbered items by cut and paste and the items are renumbered. 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
Re: [libreoffice-users] About.com Readers' Choice Awards 2013 for Office Software
LO is not listed in office suits for business, but AOO is. I think this is important for business acceptance and not showing makes it look like its not suitable. Steve On 2013-03-04 05:54, Marc Paré wrote: FYI, the About.com Readers' Choice Awards 2013 for Office Software started on Feb. 19 and will end on March 19. You may vote every 24hrs. Let's make our LibreOffice suite the office suite of choice and it would be nice if we won out on all categories where we appear! To vote, you can log in with your Facebook or About.com accounts or you can enter your email address in a field on the page. Here are the details: = = The Readers' Choice Awards 2013 for Office Software categories webpage can be found here: http://office.about.com/od/ReaderResponse/tp/About-Com-Readers-Choice-Awards-2013-For-Office-Software-Nominations.htm = = As of today, March 3 2013, LibreOffice ranking in the various Office Software Suites categories is: = Favorite Office Suite for Android: LIBREOFFICE does not have an official implementation of an Android version. Favorite Office Suite for Android: Google Docs/Apps 80% -- Quickoffice Pro HD 20% = Favorite Office Software Suite or App for iOS: LIBREOFFICE does not have an official implementation of an iOS version. Favorite Office Software Suite or App for iOS: Google Apps 60% -- iWork 20% -- Documents Free 20% = Favorite Office Software for Mac: LibreOffice 75% -- iWork and MSO both 12% = Favorite Office Software for Windows: LibreOffice 75% -- MSO 14% -- AOO 10% = Favorite Office Software for BlackBerry: LibreOffice 100% = Favorite Office Software for Business: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO IS AWARE OF THIS. Favorite Office Software for Business: MSO 33% -- Google Docs/Apps 33% -- AOO 33% ??? -- IMO strange as LibreOffice is most likely used in Business = Favorite Academic Software Suite: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO IS AWARE OF THIS. Favorite Academic Software Suite: MSO Home and Student 50% -- Google Apps for Education 50% -- IMO, strange as LibreOffice is most likely used in education extensively!!! = Favorite Site for Office Software Templates: LibreOffice templates 80% -- MSO templates 20% = Favorite Cloud Office Suite: LIBREOFFICE, at present, does not have an official Cloud implementation, but is working on it. Favorite Cloud Office Suite: Google docs 100% = Favorite Office Software Company or Organization Based on Social Responsibility: TheDocumentFoundation 60% -- TheApacheFoundation 20% -- Microsoft 20% = Congrats to all who are voting every 24hrs. If you are not voting yet, feel free to join in. It will make a difference to our brand and show that we are a very committed community. Cheers, Marc -- 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] definition of flat/relational database
Hi John, John R. Sowden schrieb: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: Do you have a direct link? *Flat databases* A flat database contains one or more tables, each containing one or more fields. Each table is completely independent of all the other tables in the database. For example, I have an address database with seven tables in it. One has my family's contacts, another has my business contacts, and another has my wife's family contacts. While some contacts are contained in more than one table, different tables may not have the same information about the same person. dBase is a flat database program. LibreOffice and several database programs can also create flat databases. *Relational databases* Relational databases contain one or more tables with one or more relationships; each relaltionship is defined by a pair of fields. One field of each pair belongs to one table and the second field belongs to the same or a different table. Where relationships exist between fields in the same or different tables, a flat database could still be used, but it provides no mechanism for defining the relationship. Instead the same data must be entered in both fields, making data entry errors more likely. A well designed relational database requires the data to be entered only once, reducing possible errors. I think, it is a wrong definition of the term 'relational database'. The word 'relation' in 'relational database' means the mathematical definition of 'relation', which is connected to 'tupel', a organization of data in rows and columns. It is not about a 'relationship'. Another database model is a hierarchical model for example, which is tree-like. http://en.wikipedia.org/wiki/Relational_database. http://en.wikipedia.org/wiki/Database_model http://de.wikipedia.org/wiki/Datenbankmodell It seems, that 'Flat database' is used for a database with one single table. But such a database would still be a relational database. My German text book does not have any term which would correspond to 'Flat database'. And the German Wikipedia article has no database model 'Flat database'. dbase is a relational database per the above definition. I link 2 tables with 1 field so I can refer to data in the second database so data does not have to bbe entered multiple times. In our alarm monitoring station, when a police dept. changes its phone number, we change 1 field in 1 database. Hundreds of subscriber records refer to that field to populate the data screen. It seems that LO ptb either have a problem with dbase/xbase, or they are (were) uninformed of the facts. dBase is a relational database application because the data is organized in tables. I think, there is no need to introduce the term 'flat database' at all. The distinction is in the management system. For files in dBase-format and for spreadsheets, LibreOffice itself is the database management system. For all other database connections, it uses an external database management system. Kind regards Regina -- 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] Moving list items and re-numbering
On 03/03/2013 05:42 AM, Jean-Francois Nifenecker wrote: Le 03/03/2013 00:54, Kevin O'Brien a écrit : 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? Xubuntu 12.04 TDF LibO Version 4.0.1.1 (Build ID: 2c0c17a6e4bee0ee28131ea4bdc47edc700d659) I can't reproduce. Can you be more specific, please? -- OS and LibO version? -- the steps you're following to reproduce? -- are you creating your own numbering style or using the Numbered list toolbutton? I am using Kubuntu 12.10, and LO version 3.6.2.2, I did create my own list style. But I just opened it up again and now it works the way it should. I guess I had some kind transient issue, or there is some factor I have not been able to identify. Thanks for the help. I ma trying to get a deep understanding of this stuff, and what I often encounter are problems where step 1 is to figure out if the program is misbehaving, if I am doing something wrong, or if I am just thinking about it the wrong way.. Regards, -- 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] definition of flat/relational database
I think the (incorrect) definition that is being used is whether LO manipulates files directly or talks to a database engine. I don't think there is a dBase or FoxBase engine. I'm pretty sure there is a Visual FoxPro engine (John doesn't mention VFP, whyzatt then? ;) ), however it'll be a Windoze only thing I expect. So, to answer the original question, LO is calling dBase files flat because it can't access a database engine for them and it won't do any engine work itself. A flat database? Errr, can't think of one, although I know there have been such things. You only had to ask ;) Regards Mark Stanton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] definition of flat/relational database
On 03/03/2013 07:27 AM, Dan Lewis wrote:
On 03/03/2013 10:09 AM, John R. Sowden wrote:
Why do the Libreoffice powers that be define dbase/xbase as a flat
file database, not a relational database. The below definitions from
the Base Intro documentation demonstrate what I am saying:
*Flat databases*
A flat database contains one or more tables, each containing one or
more fields. Each table is completely independent of all the other
tables in the database. For example, I have an address database with
seven tables in it. One has my family's contacts, another has my
business contacts, and another has my wife's family contacts. While
some contacts are contained in more than one table, different tables
may not have the same information about the same person.
dBase is a flat database program. LibreOffice and several database
programs can also create flat databases.
*Relational databases*
Relational databases contain one or more tables with one or more
relationships; each relaltionship is defined by a pair of fields. One
field of each pair belongs to one table and the second field belongs
to the same or a different table. Where relationships exist between
fields in the same or different tables, a flat database could still
be used, but it provides no mechanism for defining the relationship.
Instead the same data must be entered in both fields, making data
entry errors more likely. A well designed relational database
requires the data to be entered only once, reducing possible errors.
dbase is a relational database per the above definition. I link 2
tables with 1 field so I can refer to data in the second database so
data does not have to bbe entered multiple times. In our alarm
monitoring station, when a police dept. changes its phone number, we
change 1 field in 1 database. Hundreds of subscriber records refer
to that field to populate the data screen. It seems that LO ptb
either have a problem with dbase/xbase, or they are (were) uninformed
of the facts.
John Sowden
(been programming in dBase II (under cp/m), Foxbase, Foxpro (under
DOS) since 1981)
Good, someone who can provide some information! How far back has
dBase been able to create and use relational databases? I ask because
until OOo 1.1.15, Base created databases in dBase format. With the
switch to using HSQLDB and embedded databases, Base could work with
relational databases. Base could also work with dBase but only as a
flat database.
So, how would you suggest this section you quote be written to
make it accurate? What are some good examples of flat databases?
--Dan
dBase II (there was never a dbase I. The closest was Vulcan which was
written with our tax dollars at the Jet Propulsion Laboratory.) was
originally a relational database. The original 3 ring binder manual
said Assembly Language Relational Database on the cover. It only
supported 2 open databases (now called tables). dBase calls its
elements fields and records. An example of a 'flat database is a name
and address file. It's not linked to anything, so if you had a city
field, and had 25 addresses in Cupertino, and the city got 10 million
from Apple to change the name to Apple City, you would have to change
the city field in 25 records. If it were a relational database, and you
set up a link between the citycode field in the main database and the
citycode field in a cities database, then all of the addresses in
Cupertino would have a code in the city field ('14') and the cities
database would have 2 fields, one citycode and one cityname. All of the
addresses in Cupertino would have a '14' in the city field and all of
them would link to the one record in the cities database, so to make the
change, all you would have to do is go to the cities database and change
the cityname from 'Cupertino' to 'Apple City'.
It sounds like OO 1.1.15 treated the dbf files as unlinked individual
databases. Therefore the flat database concept was a deficiency in
the code of OO, not in the structure of the dbf format. Maybe no one
wanted to acknowledge this, so they made the dBase format the scapegoat.
Re: your last comment, I would not mention dBase as a flat file. If it
were necessary to have an example of a flat fire, I would look for a
well known database that actually is a flat file, or define it as a list
of data broken into sections, like a comma delimited list.
Another comment was made in another message re: the definition of
relation. Actually the 2 databases cited above are related. I the
commonness (is that a word?) of them is the citycode field, and the
connection is via the software. In dBase they must be indexed on the
linking field. The command used to relate them is set relation to.
Runnin' out of wind,
John
--
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:
Re: [libreoffice-users] definition of flat/relational database
On 03/03/2013 09:30 AM, Regina Henschel wrote: Hi John, John R. Sowden schrieb: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: Do you have a direct link? *Flat databases* A flat database contains one or more tables, each containing one or more fields. Each table is completely independent of all the other tables in the database. For example, I have an address database with seven tables in it. One has my family's contacts, another has my business contacts, and another has my wife's family contacts. While some contacts are contained in more than one table, different tables may not have the same information about the same person. dBase is a flat database program. LibreOffice and several database programs can also create flat databases. *Relational databases* Relational databases contain one or more tables with one or more relationships; each relaltionship is defined by a pair of fields. One field of each pair belongs to one table and the second field belongs to the same or a different table. Where relationships exist between fields in the same or different tables, a flat database could still be used, but it provides no mechanism for defining the relationship. Instead the same data must be entered in both fields, making data entry errors more likely. A well designed relational database requires the data to be entered only once, reducing possible errors. I think, it is a wrong definition of the term 'relational database'. The word 'relation' in 'relational database' means the mathematical definition of 'relation', which is connected to 'tupel', a organization of data in rows and columns. It is not about a 'relationship'. Another database model is a hierarchical model for example, which is tree-like. http://en.wikipedia.org/wiki/Relational_database. http://en.wikipedia.org/wiki/Database_model http://de.wikipedia.org/wiki/Datenbankmodell It seems, that 'Flat database' is used for a database with one single table. But such a database would still be a relational database. My German text book does not have any term which would correspond to 'Flat database'. And the German Wikipedia article has no database model 'Flat database'. dbase is a relational database per the above definition. I link 2 tables with 1 field so I can refer to data in the second database so data does not have to bbe entered multiple times. In our alarm monitoring station, when a police dept. changes its phone number, we change 1 field in 1 database. Hundreds of subscriber records refer to that field to populate the data screen. It seems that LO ptb either have a problem with dbase/xbase, or they are (were) uninformed of the facts. dBase is a relational database application because the data is organized in tables. I think, there is no need to introduce the term 'flat database' at all. The distinction is in the management system. For files in dBase-format and for spreadsheets, LibreOffice itself is the database management system. For all other database connections, it uses an external database management system. Kind regards Regina Direct Link: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide A spreadsheet is organized as a table. That does not make it a relational database. John -- 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] definition of flat/relational database
On 03/03/2013 10:28 AM, Jay Lozier wrote: On 03/03/2013 12:39 PM, Mark Stanton wrote: I think the (incorrect) definition that is being used is whether LO manipulates files directly or talks to a database engine. I don't think there is a dBase or FoxBase engine. I'm pretty sure there is a Visual FoxPro engine (John doesn't mention VFP, whyzatt then? ;) ), however it'll be a Windoze only thing I expect. So, to answer the original question, LO is calling dBase files flat because it can't access a database engine for them and it won't do any engine work itself. A flat database? Errr, can't think of one, although I know there have been such things. Probably the closet to a flat database would be using a spreadsheet as a database for most people. Depending on the backend for Base and how well they communicate Base is can be the front end to a true relational database or to flat database. You only had to ask ;) Regards Mark Stanton exactly. -- 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] definition of flat/relational database
On 03/03/2013 10:50 AM, Wolfgang Keller wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The main issue for me would be whether the database management system (some call it engine or whatever) actually enforces relational integrity (foreign key constraints) between tables. In case of directly writing to DBF files from LO Base, I would guess there's no enforcement. Sincerely, Wolfgang Foxpro and dBase do not support referential integrity. They do not have data dictionaries (possible VFP does, I don't know). I don't allow my users to write directly to any dbf. They must go through an application that I wrote (gigo, etc.). John -- 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] definition of flat/relational database
On 03/03/2013 10:09 AM, John R. Sowden wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat databases* A flat database contains one or more tables, each containing one or more fields. Each table is completely independent of all the other tables in the database. For example, I have an address database with seven tables in it. One has my family's contacts, another has my business contacts, and another has my wife's family contacts. While some contacts are contained in more than one table, different tables may not have the same information about the same person. dBase is a flat database program. LibreOffice and several database programs can also create flat databases. *Relational databases* Relational databases contain one or more tables with one or more relationships; each relaltionship is defined by a pair of fields. One field of each pair belongs to one table and the second field belongs to the same or a different table. Where relationships exist between fields in the same or different tables, a flat database could still be used, but it provides no mechanism for defining the relationship. Instead the same data must be entered in both fields, making data entry errors more likely. A well designed relational database requires the data to be entered only once, reducing possible errors. dbase is a relational database per the above definition. I link 2 tables with 1 field so I can refer to data in the second database so data does not have to bbe entered multiple times. In our alarm monitoring station, when a police dept. changes its phone number, we change 1 field in 1 database. Hundreds of subscriber records refer to that field to populate the data screen. It seems that LO ptb either have a problem with dbase/xbase, or they are (were) uninformed of the facts. John Sowden (been programming in dBase II (under cp/m), Foxbase, Foxpro (under DOS) since 1981) See the string Link Base to External Spreadsheet -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- 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] Readers' Choice Awards 2013 Finalist
Hi :) Another poll that might pique your interest. I must admit i had expected Mac Users to vote somewhat differently . With the GnuLinux poll i thought the results were quite predictable. The Mac poll seems to have found some really odd choices that i have never heard of but also includes MS Office (which couldn't appear on the GnuLinux poll). Regards from Tom :) From: Italo Vignoli italo.vign...@gmail.com To: market...@global.libreoffice.org Sent: Saturday, 2 March 2013, 20:54 Subject: [libreoffice-marketing] Fwd: Readers' Choice Awards 2013 Finalist LibreOffice is the only free office suite chosen by About.Com readers in the category of Best Mac WOrd Processor. To learn more about the awards program visit http://macs.about.com/od/RCA2013/ss/Readers-Choice-Awards-2013-Vote-For-Your-Favorite-Mac-related-Items.htm. To learn more about the overall awards program visit awards.about.com. If you would like to participate in the voting phase of the awards, you can use any of the links below: http://macs.about.com/od/RCA2013/ss/Readers-Choice-Awards-2013-Vote-For-Your-Favorite-Mac-related-Items.htm http://macs.about.com/od/RCA2013/ss/Readers-Choice-Awards-2013-Vote-For-Your-Favorite-Mac-related-Items_6.htm http://macs.about.com/b/2013/02/19/readers-choice-awards-2013-voting-booth-best-word-processor.htm You can use the following code on your web site to display the finalist badge: img src=http://clk.about.com/?zi=1/1tU; alt=About.com http://about.com/ 2013 Readers' Choice Awards / -- Unsubscribe instructions: E-mail to marketing+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/marketing/ 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: About.com Readers' Choice Awards 2013 for Office Software
On 2013-03-03 10:54 AM Marc Paré wrote: Favorite Office Software for Mac: LibreOffice 75% -- iWork and MSO both 12% = AOO is not on the list for Macs, so the 74% figure is meaningless. You point out when LibreOffice is not listed but do not point out when AOO is not listed. Phui. = Favorite Office Software for Business: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO IS AWARE OF THIS. Favorite Office Software for Business: MSO 33% -- Google Docs/Apps 33% -- AOO 33% ??? -- IMO strange as LibreOffice is most likely used in Business = Favorite Academic Software Suite: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO IS AWARE OF THIS. Favorite Academic Software Suite: MSO Home and Student 50% -- Google Apps for Education 50% -- IMO, strange as LibreOffice is most likely used in education extensively!!! -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- 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: Readers' Choice Awards 2013 Finalist
On 2013-03-03 3:04 PM Tom Davies wrote: Another poll that might pique your interest. I must admit i had expected Mac Users to vote somewhat differently . With the GnuLinux poll i thought the results were quite predictable. The Mac poll seems to have found some really odd choices that i have never heard of but also includes MS Office (which couldn't appear on the GnuLinux poll). Not a very good poll. It omits Apache OpenOffice. It also omits the two best Mac word processors, Nissus Writer Pro, and Scrivener. -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- 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: Vector Graphics in PDF
Berengar Lehr wrote: Hy, I'm asking if anyone could provide me with a list of vector graphics formats that can be used in ODT _and_ that will be exported as vector graphic. SVG e.g. is not a valid example: while it can be used in ODT, SVG will be rasterized during conversion to PDF. ODG on the other hand works for both. WMF/EMF work for both but I could not find *nix libs for these microsoft formats. Any other ideas? In the ideal case the source would be svg and I would import that into Draw. Currently this conversions does not goes 100% perfect (like closed shapes become open and because of that don't fill). At this time importing pdf goes pretty good in most cases. If needed I do some touch ups in Draw and then paste the whole thing into Writer (as a Draw object, so you need to 'paste as'). This procedure seems to work well even for complex stuff like Autocad drawings (dxf), and PCB layouts (gerber files) Thank you, waiting patiently, Ber -- 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: About.com Readers' Choice Awards 2013 for Office Software
On 03/03/2013 at 22:05, Larry Gusaas larry.gus...@gmail.com wrote: AOO is not on the list for Macs, so the 74% figure is meaningless. You point out when LibreOffice is not listed but do not point out when AOO is not listed. Phui. As far as I believe that AOO and LO should not compete against each other, but try to take some users away from Microsoft Office instead, I also understand Marc -- this is *LibreOffice* mailing list. It is natural that he points out absence of LibreOffice, while absence of Apache OpenOffice is irrelevant at the moment. -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: About.com Readers' Choice Awards 2013 for Office Software
On 2013-03-03 4:36 PM Mirosław Zalewski wrote: On 03/03/2013 at 22:05, Larry Gusaas larry.gus...@gmail.com wrote: AOO is not on the list for Macs, so the 74% figure is meaningless. You point out when LibreOffice is not listed but do not point out when AOO is not listed. Phui. As far as I believe that AOO and LO should not compete against each other, but try to take some users away from Microsoft Office instead, I also understand Marc -- this is *LibreOffice* mailing list. It is natural that he points out absence of LibreOffice, while absence of Apache OpenOffice is irrelevant at the moment. The absence of Apache OpenOffice is not irrelevant. It make the poll meaningless. LibreOffice is not actually used by 74% of the Mac users taking the survey when you have left out Apache OpenOffice from the survey, as well as Nissus, Scrivener, and others. It is like conducting a survey about the favourite cola drink and leaving Coca-Cola off the list. -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- 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] Impress remote under windows
Hi, I'm using LibreOffice RC 4.0.1.2 for windows and Impress Remote 1.0.4, but when I tried using impress remote on Android, it can't connect to my laptop. The problem is impress not listen on TCP 1599, but still listen on UDP 1598. Anyone has a suggestion to resolve it? -- 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: Impress remote under windows
Solved. Just enable experimental feature in Options. Sorry about my carelessness. On Sun, Mar 3, 2013 at 4:30 PM, Boyi Chen fts...@gmail.com wrote: Hi, I'm using LibreOffice RC 4.0.1.2 for windows and Impress Remote 1.0.4, but when I tried using impress remote on Android, it can't connect to my laptop. The problem is impress not listen on TCP 1599, but still listen on UDP 1598. Anyone has a suggestion to resolve it? -- 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: Impress remote under windows
Sometimes it is needed to know if things are needing the experimental features option checked to get it to work. I was told to do that to get the solution to an issue, once, but the solution was not part of those features. So, it is nice you found the issue, but it would be nice to know what is needing that option to work. On 03/03/2013 07:12 PM, Boyi Chen wrote: Solved. Just enable experimental feature in Options. Sorry about my carelessness. On Sun, Mar 3, 2013 at 4:30 PM, Boyi Chen fts...@gmail.com wrote: Hi, I'm using LibreOffice RC 4.0.1.2 for windows and Impress Remote 1.0.4, but when I tried using impress remote on Android, it can't connect to my laptop. The problem is impress not listen on TCP 1599, but still listen on UDP 1598. Anyone has a suggestion to resolve it? -- 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: About.com Readers' Choice Awards 2013 for Office Software
Hi :) My guess is that people wanting to vote for AOO or OOo just vote for LO because they are about the same really. However, the reason AOO is missing is that Mac users didn't propose it or register it for the poll. Perhaps they see AOO as being too old now or unfashionable or perhaps they just decided that LibreOffice was close enough. Regards from Tom :) From: Larry Gusaas larry.gus...@gmail.com To: users@global.libreoffice.org Sent: Sunday, 3 March 2013, 23:19 Subject: [libreoffice-users] Re: About.com Readers' Choice Awards 2013 for Office Software On 2013-03-03 4:36 PM Mirosław Zalewski wrote: On 03/03/2013 at 22:05, Larry Gusaas larry.gus...@gmail.com wrote: AOO is not on the list for Macs, so the 74% figure is meaningless. You point out when LibreOffice is not listed but do not point out when AOO is not listed. Phui. As far as I believe that AOO and LO should not compete against each other, but try to take some users away from Microsoft Office instead, I also understand Marc -- this is *LibreOffice* mailing list. It is natural that he points out absence of LibreOffice, while absence of Apache OpenOffice is irrelevant at the moment. The absence of Apache OpenOffice is not irrelevant. It make the poll meaningless. LibreOffice is not actually used by 74% of the Mac users taking the survey when you have left out Apache OpenOffice from the survey, as well as Nissus, Scrivener, and others. It is like conducting a survey about the favourite cola drink and leaving Coca-Cola off the list. -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- 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] Moving list items and re-numbering
Hi :) It might be good to work through some of the published guides. The full book of the Getting Started Guide is now finally ready https://wiki.documentfoundation.org/Documentation/Publications and is on the official LibreOffice website and available for purchase through the Lulu on-line book-store. Any proof-reading suggestions are still being welcomed although some may not make it in until the next release of the guides. Regards from Tom :) From: Kevin O'Brien zwil...@zwilnik.com To: users@global.libreoffice.org Sent: Sunday, 3 March 2013, 17:49 Subject: Re: [libreoffice-users] Moving list items and re-numbering On 03/03/2013 05:42 AM, Jean-Francois Nifenecker wrote: Le 03/03/2013 00:54, Kevin O'Brien a écrit : 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? Xubuntu 12.04 TDF LibO Version 4.0.1.1 (Build ID: 2c0c17a6e4bee0ee28131ea4bdc47edc700d659) I can't reproduce. Can you be more specific, please? -- OS and LibO version? -- the steps you're following to reproduce? -- are you creating your own numbering style or using the Numbered list toolbutton? I am using Kubuntu 12.10, and LO version 3.6.2.2, I did create my own list style. But I just opened it up again and now it works the way it should. I guess I had some kind transient issue, or there is some factor I have not been able to identify. Thanks for the help. I ma trying to get a deep understanding of this stuff, and what I often encounter are problems where step 1 is to figure out if the program is misbehaving, if I am doing something wrong, or if I am just thinking about it the wrong way.. Regards, -- 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 -- 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: Vector Graphics in PDF
Op 03/03/2013 23:09, Ferry Toth schreef: Berengar Lehr wrote: Hy, I'm asking if anyone could provide me with a list of vector graphics formats that can be used in ODT _and_ that will be exported as vector graphic. SVG e.g. is not a valid example: while it can be used in ODT, SVG will be rasterized during conversion to PDF. ODG on the other hand works for both. WMF/EMF work for both but I could not find *nix libs for these microsoft formats. Any other ideas? In the ideal case the source would be svg and I would import that into Draw. Currently this conversions does not goes 100% perfect sinds 4.0 most problems are solved and no need to uses Draw, place the SVG directly in writer (like closed shapes become open and because of that don't fill). At this time importing pdf goes pretty good in most cases. If needed I do some touch ups in Draw and then paste the whole thing into Writer (as a Draw object, so you need to 'paste as'). This procedure seems to work well even for complex stuff like Autocad drawings (dxf), and PCB layouts (gerber files) Thank you, waiting patiently, Ber -- 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] macro compatibility between LO and AOO?
(sorry if this comes in twice, my email server had problems earlier today)Reply-To: M. Fioretti mfiore...@nexaima.net Greetings, the subject says it all. I have already searched online, and am looking at the manual but apparently (maybe I used the wrong terms) it is not easy to find CURRENT information on macro compatibility between LO 4 and AOO 3.4.1: will all macros created in one tool also work in the other? If not, why and when? What are the reasons/cases when a macro is not portable? are there any guidelines/best practices to write portable macros? Thanks in advance for any pointer! Marco http://mfioretti.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: definition of flat/relational database
Le 03/03/2013 19:50, Wolfgang Keller a écrit : Hi all, Neither OOo, AOO, or LO have ever supported multitable referential integrity, multitable write or multitable query operations with regard to the dBase file format. It was requested by users several times in various ways over the years with the OpenOffice.org project (myself included), but it never happened. Comparisons were made with VFP or Lotus Approach as ways of providing an application layer over the underlying database structure, but they were no doubt deemed too much effort for too little perceived added value. Personally, I loved the Lotus Approach wrapper for its GUI, access to Smartscript, etc (yes, it was so 80's, but then so were a lot of things at the time ;-)). I only ever used (V)FP sporadically, so find it harder to make comparisons. Of course, for someone so inclined, there would be nothing standing in the way of coding improved support for dBase in LO and more complete user interface options ;-)) Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
