[libreoffice-users] Re: Can't open .xls files in LibreOffice 4.4 calc
Thanks everyone. I suspected it might be something specific to 4.4 I'll try find my way to raising a bug and I'll download a previous release to open the files. Thanks again. -- View this message in context: http://nabble.documentfoundation.org/Can-t-open-xls-files-in-LibreOffice-4-4-calc-tp4142025p4142051.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Can't open .xls files in LibreOffice 4.4 calc
The datasheet contains open links to other datasheets which are hosted somewhere in Australia, and is trying to update the numbers when it opens. LibreOffice hangs during this operation. Unfortunately, I do not have a workaround for this problem, but maybe someone other has some ideas. On 03/03/15 02:16, infinityplusb wrote: Hi allI'm trying to open an .xls file (actually a number of xls files) I downloaded from the Australia Statistics agency website and want to check if other people can open it before I raise it as an issue with ... someone.The file is attached 3303_1_underlying_causes_of_death_(australia).xls http://nabble.documentfoundation.org/file/n4142025/3303_1_underlying_causes_of_death_%28australia%29.xls The versions I'm using are:LibreOffice Version: 4.4.0.3Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645dI'm using Ubuntu 14.10Can someone try and open up the file attached in LibreOffice please?Also if someone could let me know what I need to do to trouble shoot that would be great.PS I can open some .xls files, just not this (or a few others) so it might be something *in* the file. A workaround rather than solution would also suffice for my purposes. -- Italo Vignoli - The Document Foundation mob IT +39.348.5653829 - mob EU +39.392.7481795 email it...@libreoffice.org - skype italovignoli email / hangout italo.vign...@gmail.com GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Where is Base?
Much of the e-mails on Base have focussed on negative aspects. It is worth remembering that for moderate size data bases (a few thousand records, a dozen tables) it is perfectly adequate. I have now converted all of my data ase applications for MS Access to run on Base with its internal data base. All of them perform better than they did using MS Access. I would not regard either Base or Access as suitable for a large multiuser data base application. The only linux based large data base I have developed I used MySQL with a web based front end using php to interface to the data base. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Where is Base?
Hi :) I don't see this thread as having been entirely negative at all! Base is pretty fantastic despite having so few devs and being the most unpopular module/program to work on out of the whole suite. The devs who are working on it are fantastic and heroic imo. The only real problems are when people try to use Base in the way they would use Access. Access does quite a lot of very dodgy things that most database programs steer well away from. For a start having the front-end and the back-end as 1 file is just asking for trouble for reasons which i am not quite clear on but has been described in previous threads. My pet hate is that normal users are presented with the unfamiliar interface. So even if they just want to browse through records they kinda need training and that training usually involves just how to design, create and build a new database rather just how to flick through records. Even with training it is all to easy for normal users to accidentally (or otherwise) make a hideous mess of things. The contacts database at my work-place was such a hideous mess that even printing address labels was practically impossible. I didn't have time to go through all the hundreds of badly named Queries to make any sense of them so i was never sure which could be deleted and which were crucial. So i had to make yet another new one in order to avoid getting bogged down for days in a fairly simple task. When i got back to the database a week later someone had renamed my Query and the Report so i had to do a bit of detective work to find them again. Nowadays no-one uses that database at all. The company has lost track of tons of contacts who may or may not have been useful. Nowadays we use a simple csv to track only the email addresses and we no longer do mail-outs at all. Base neatly avoid ALL that can be neatly avoided by using Writer or Calc to create Reports or Forms so that people who are not into building and designing databases are safely in familiar programs/modules. So normal users can still do simple edits, such as correcting spellings or changing the company letterhead and such-like but they do so in a familiar environment without having to learn tons of stuff they will probably never need. They can even create new documents based on the existing ones. At no point would they accidentally find themselves in Desgn views or accidentally creating Queries. So for me Base, Kexi and pretty much everything non-Microsoft has huge time-saving advantages! Regards from Tom :) On 3 March 2015 at 15:06, Peter Goggin petergog...@bigpond.com wrote: Much of the e-mails on Base have focussed on negative aspects. It is worth remembering that for moderate size data bases (a few thousand records, a dozen tables) it is perfectly adequate. I have now converted all of my data ase applications for MS Access to run on Base with its internal data base. All of them perform better than they did using MS Access. I would not regard either Base or Access as suitable for a large multiuser data base application. The only linux based large data base I have developed I used MySQL with a web based front end using php to interface to the data base. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Where is Base?
Hi :) Oops!! Sorry for the rant! Also the tpyos in the 5th paragraph! (4th from the end!). I should have deleted some of it (or the whole email tbh) down to; Base neatly avoids ALL that nightmare by allowing database-designers to use Writer or Calc to create Reports or Forms so that people who are not into building and designing databases are safely in familiar programs/modules. Apols and regards from Tom :) On 3 March 2015 at 16:01, Tom Davies tomc...@gmail.com wrote: Hi :) I don't see this thread as having been entirely negative at all! Base is pretty fantastic despite having so few devs and being the most unpopular module/program to work on out of the whole suite. The devs who are working on it are fantastic and heroic imo. The only real problems are when people try to use Base in the way they would use Access. Access does quite a lot of very dodgy things that most database programs steer well away from. For a start having the front-end and the back-end as 1 file is just asking for trouble for reasons which i am not quite clear on but has been described in previous threads. My pet hate is that normal users are presented with the unfamiliar interface. So even if they just want to browse through records they kinda need training and that training usually involves just how to design, create and build a new database rather just how to flick through records. Even with training it is all to easy for normal users to accidentally (or otherwise) make a hideous mess of things. The contacts database at my work-place was such a hideous mess that even printing address labels was practically impossible. I didn't have time to go through all the hundreds of badly named Queries to make any sense of them so i was never sure which could be deleted and which were crucial. So i had to make yet another new one in order to avoid getting bogged down for days in a fairly simple task. When i got back to the database a week later someone had renamed my Query and the Report so i had to do a bit of detective work to find them again. Nowadays no-one uses that database at all. The company has lost track of tons of contacts who may or may not have been useful. Nowadays we use a simple csv to track only the email addresses and we no longer do mail-outs at all. Base neatly avoid ALL that can be neatly avoided by using Writer or Calc to create Reports or Forms so that people who are not into building and designing databases are safely in familiar programs/modules. So normal users can still do simple edits, such as correcting spellings or changing the company letterhead and such-like but they do so in a familiar environment without having to learn tons of stuff they will probably never need. They can even create new documents based on the existing ones. At no point would they accidentally find themselves in Desgn views or accidentally creating Queries. So for me Base, Kexi and pretty much everything non-Microsoft has huge time-saving advantages! Regards from Tom :) On 3 March 2015 at 15:06, Peter Goggin petergog...@bigpond.com wrote: Much of the e-mails on Base have focussed on negative aspects. It is worth remembering that for moderate size data bases (a few thousand records, a dozen tables) it is perfectly adequate. I have now converted all of my data ase applications for MS Access to run on Base with its internal data base. All of them perform better than they did using MS Access. I would not regard either Base or Access as suitable for a large multiuser data base application. The only linux based large data base I have developed I used MySQL with a web based front end using php to interface to the data base. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Where is Base?
Hi :) I am not quite sure what level of co-operation you are asking for. There is always a potential for more, of course. At the moment, and hopefully on into the future, they are independent of each other and each has their own advantages and peculiar quirks. They gain the advantages of competition while being able to co-operate too. Both have far too few devs imo but the devs in both are pretty heroic. More devs in either or both might make things interesting. :) At the moment both can connect to a wide range of back-ends. Also both could be front-ends for the same back-end. Creating 2 different front-ends might be annoying but it seems to be very possible. Regards from Tom :) On 3 March 2015 at 14:14, Jaroslaw Staniek stan...@kde.org wrote: Hi Tom, Interesting. Given similar, huge challenges, would you see areas of cooperation with Kexi? On 3 March 2015 at 14:33, Tom Davies tomc...@gmail.com wrote: Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we now effectively have a choice of 2 internal back-ends neither of which work entirely as hoped for yet. With Firebird it feels like it is on the way though. Regards from Tom :) On 2 March 2015 at 21:09, Andreas Säger ville...@t-online.de wrote: Am 02.03.2015 um 21:23 schrieb Tom Davies: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. This is not a matter of partisanship, fanboyism nor objective evidence of the better product. The important thing is that you are able to connect to whatever you already have. The database of your online shop, your business software, your accounting software, some dBase directory, spreadsheets or csv files. The connectivity feature lets you use tabular data without troublesome export/import. If all you have is an embedded HSQLDB, you can convert this to HSQL 2 within minutes. Conversion into Postrgre/MySQL/whatever would require careful editing of SQL scripts, testing and possibly adjustment of queries, forms, reports. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/
Re: [libreoffice-users] Re: Where is Base?
Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we now effectively have a choice of 2 internal back-ends neither of which work entirely as hoped for yet. With Firebird it feels like it is on the way though. Regards from Tom :) On 2 March 2015 at 21:09, Andreas Säger ville...@t-online.de wrote: Am 02.03.2015 um 21:23 schrieb Tom Davies: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. This is not a matter of partisanship, fanboyism nor objective evidence of the better product. The important thing is that you are able to connect to whatever you already have. The database of your online shop, your business software, your accounting software, some dBase directory, spreadsheets or csv files. The connectivity feature lets you use tabular data without troublesome export/import. If all you have is an embedded HSQLDB, you can convert this to HSQL 2 within minutes. Conversion into Postrgre/MySQL/whatever would require careful editing of SQL scripts, testing and possibly adjustment of queries, forms, reports. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Where is Base?
Hello, I am an old DB-User in the real sense of the word (I am over 70!). In the 90ies I got into DB2 as a systems engineer at IBM. Then, around the turn of the millenium, I set up a database for the administration of a 50-piece wind band, using Lotus-Approach (DBase...). It was fine but I wanted to go Open Software and - when stumbling onto StarOffice/OpenOffice and Base - it was clear to me to go for that scene. Since then I have been using MySQL as external back-end and must say I am more than happy with it. My DB consists of some 80 interconnected tables/views with record numbers up to around 40.000. This is handled perfectly fine by MySQL (maybe MariaDB in the near future!). Of course - as an old DB-guy I have no qualms about using the command-line mysql client directly for doing things like defining DBs, tables, views, foreign keys etc. Therefore, if there are any limitations in the LO-front end, it is o.k. for me. I do feel strongly though, that if we ever want LO to become a REALLY important player (especially within the business world!), a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) will have to be implemented. Internal, integrated backends are o.k. for playing around but NOT for mission-critical, large-scale operations. Regards Heinz Tom Davies schrieb: Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we now effectively have a choice of 2 internal back-ends neither of which work entirely as hoped for yet. With Firebird it feels like it is on the way though. Regards from Tom :) On 2 March 2015 at 21:09, Andreas Säger ville...@t-online.de wrote: Am 02.03.2015 um 21:23 schrieb Tom Davies: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. This is not a matter of partisanship, fanboyism nor objective evidence of the better product. The important thing is that you are able to connect to whatever you already have. The database of your online shop, your business software, your accounting software, some dBase directory, spreadsheets or csv files. The connectivity feature lets you use tabular data without troublesome export/import. If all you have is an embedded HSQLDB, you can convert this to HSQL 2 within minutes. Conversion into Postrgre/MySQL/whatever would require careful editing of SQL scripts, testing and possibly adjustment of queries, forms, reports. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to:
Re: [libreoffice-users] first step forward
Hi Tom, would you mind sending me the link to this book in german or is it only available in hardcopy? Thanks Ralf -- Laboratório de Biodiversidade Genética Instituto de Ciências Biológicas Universidade Federal do Rio Grande - FURG Av. Itália, s/n, Carreiros 96201-900, Rio Grande, RS - Brasil Tel.:+.55.53.3293.5128 +.55.53.3233.6742/6538 e-mail:dmbralfatfurg.br msn:r_kersanachathotmail.com skype: ralfkersanach On Tuesday 03 March 2015 17:29:26 Tom Davies wrote: Hi :) You might find this website more useful; http://pl.libreoffice.org/ Also the Polish language mailing list might be easier as you can use Polish; https://wiki.documentfoundation.org/Local_Mailing_Lists#Polish or if your main language is something else then there is probably a different mailing list for that too. I think most people use spreadsheets (ie Calc or Excel) to create an array of numbers. However if this for bookkeeping then you might find it better to use a specialist tool such as GnuCash (also Libre and free OpenSource program). It really depends on what you are trying to do. If you think a database might be better then using Base as a front-end with an external back-end such as MySql/MariaDb, Postgresql or something else is probably a good idea. Some people have a go with a spreadsheet first as part of the planning process before designing a database. There is a book about how to use Base but it is primarily only available in German. The English one is quite outdated now (already! Time flies!) and the translator teams are often even smaller and mostly have only just begun to think about translating the Published Guides. Of course they do have the built-in help but it sounds like you really need something a bit more hefty to get a good overview. If you can find it in an appropriate language then you might like the Getting Started Guide Regards from Tom :) On 2 March 2015 at 23:22, an...@neostrada.pl wrote: Hello, Just few days've gone, I had opportunity to discover your LibreOffice 4.4.1.2. I've got really impressed. Unfortunatly, there is not enough time, till now, to answer the question: Is the LO abbly, for example, to proceed efficiently a specific arrey of numbers (a kind of compilation)? I'm pretty sure, but to get forward I've attached simple sample as below. Is the spreadsheet, or rather is the database the proper tool? Could you proceed the sample, please? Best regards, Andrew Anddos -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: 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: Where is Base?
Am 03.03.2015 um 16:06 schrieb Peter Goggin: Much of the e-mails on Base have focussed on negative aspects. It is worth remembering that for moderate size data bases (a few thousand records, a dozen tables) it is perfectly adequate. I have now converted all of my data ase applications for MS Access to run on Base with its internal data base. All of them perform better than they did using MS Access. I would not regard either Base or Access as suitable for a large multiuser data base application. The only linux based large data base I have developed I used MySQL with a web based front end using php to interface to the data base. Regards Peter Goggin My first medium complex project with input forms to collect daily job data used the embedded DB as well. It worked flawlessly. But the most important preconditions is that you really do your backup every time after closing the connection. Nevertheless, there are far too many reports about complete data loss. Meanwhile it is very easy to split a self-contained Base document into a frontend and a stable backend which can be distributed and installed on multiple machines with a tiny little bit of extra effort. Apart from keeping your data safe and warm, HSQL 2.3 provides a lot more features than HSQL 1.8. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Where is Base?
Hi Heinrich, I've been reluctant to join this discussion, but you comment about the need to have ... a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) ..., has prompted me to say that I believe one such database already exists - it is called H2. See - http://www.h2database.com/html/main.html. Some will perhaps reject it out of hand, because it is Java based. However it has a vibrant user base and from comments on the user group, some are using H2 for very large databases. A year or so ago one user was complaining that H2 was slowing down after his application passed the 1 billion record mark! In reply, he received several suggestions as to how he might over come his problem. I have migrated 6 databases from HSQL 1.8, (the largest having nearly 35,000 records - which I realise, is still quite small), but I have found that H2 works well for me. There was a bit of work involved with the migration, but H2 tables can be designed in LibreOffice and the process went pretty smoothly. Perhaps the only drawback is that once tables have been designed, they can be altered only using SQL commands. But I guess most users who want an industrial strength database, would already be literate in SQL. My 2c worth, Noel -- Noel Lodge lodg...@gmail.com On 4 March 2015 at 05:56, Heinrich Stöllinger hc.stoellin...@aon.at wrote: Hello, I am an old DB-User in the real sense of the word (I am over 70!). In the 90ies I got into DB2 as a systems engineer at IBM. Then, around the turn of the millenium, I set up a database for the administration of a 50-piece wind band, using Lotus-Approach (DBase...). It was fine but I wanted to go Open Software and - when stumbling onto StarOffice/OpenOffice and Base - it was clear to me to go for that scene. Since then I have been using MySQL as external back-end and must say I am more than happy with it. My DB consists of some 80 interconnected tables/views with record numbers up to around 40.000. This is handled perfectly fine by MySQL (maybe MariaDB in the near future!). Of course - as an old DB-guy I have no qualms about using the command-line mysql client directly for doing things like defining DBs, tables, views, foreign keys etc. Therefore, if there are any limitations in the LO-front end, it is o.k. for me. I do feel strongly though, that if we ever want LO to become a REALLY important player (especially within the business world!), a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) will have to be implemented. Internal, integrated backends are o.k. for playing around but NOT for mission-critical, large-scale operations. Regards Heinz Tom Davies schrieb: Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we now effectively have a choice of 2 internal back-ends neither of which work entirely as hoped for yet. With Firebird it feels like it is on the way though.
Re: [libreoffice-users] first step forward
Hi Tom, many thanks for the links. Ralf -- On Tuesday 03 March 2015 23:32:21 Tom Davies wrote: Hi :) The link to the English translation is; https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_B ase_Handbook The original in German is; https://wiki.documentfoundation.org/Documentation/de#Handbuch_f.C3.BCr_Base_ .28Datenbank-Programm.29 Regards from Tom :) On 3 March 2015 at 18:40, Ralf Kersanach dmbr...@furg.br wrote: Hi Tom, would you mind sending me the link to this book in german or is it only available in hardcopy? Thanks Ralf -- Laboratório de Biodiversidade Genética Instituto de Ciências Biológicas Universidade Federal do Rio Grande - FURG Av. Itália, s/n, Carreiros 96201-900, Rio Grande, RS - Brasil Tel.:+.55.53.3293.5128 +.55.53.3233.6742/6538 e-mail:dmbralfatfurg.br msn:r_kersanachathotmail.com skype: ralfkersanach On Tuesday 03 March 2015 17:29:26 Tom Davies wrote: Hi :) You might find this website more useful; http://pl.libreoffice.org/ Also the Polish language mailing list might be easier as you can use Polish; https://wiki.documentfoundation.org/Local_Mailing_Lists#Polish or if your main language is something else then there is probably a different mailing list for that too. I think most people use spreadsheets (ie Calc or Excel) to create an array of numbers. However if this for bookkeeping then you might find it better to use a specialist tool such as GnuCash (also Libre and free OpenSource program). It really depends on what you are trying to do. If you think a database might be better then using Base as a front-end with an external back-end such as MySql/MariaDb, Postgresql or something else is probably a good idea. Some people have a go with a spreadsheet first as part of the planning process before designing a database. There is a book about how to use Base but it is primarily only available in German. The English one is quite outdated now (already! Time flies!) and the translator teams are often even smaller and mostly have only just begun to think about translating the Published Guides. Of course they do have the built-in help but it sounds like you really need something a bit more hefty to get a good overview. If you can find it in an appropriate language then you might like the Getting Started Guide Regards from Tom :) On 2 March 2015 at 23:22, an...@neostrada.pl wrote: Hello, Just few days've gone, I had opportunity to discover your LibreOffice 4.4.1.2. I've got really impressed. Unfortunatly, there is not enough time, till now, to answer the question: Is the LO abbly, for example, to proceed efficiently a specific arrey of numbers (a kind of compilation)? I'm pretty sure, but to get forward I've attached simple sample as below. Is the spreadsheet, or rather is the database the proper tool? Could you proceed the sample, please? Best regards, Andrew Anddos -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: 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] first step forward
On Tue, Mar 3, 2015 at 8:24 AM, an...@neostrada.pl wrote: Thank you, Allan for the prompt reply, ... The sample is simply enough, I belive, so the point is how to proceed it to get output in several seperate SS or database tables, preserving the sequention in row position. Unfortunately I don't understand your spreadsheet. I've added the mail list address back to the message. Please reply to mail list. That way more (and better) brains than mine can then give their feedback too. I did edit your spreadsheet and put a copy here. https://docs.google.com/spreadsheets/d/1xusCFUw5wy62IOcRJTTTfCQxtAcnyccXJuMHUilZ9T8/edit?usp=sharing In my copy I've highlighted all the number/value pairs and have some questions based on that. First, some numbers aren't paired with anything. What do they belong with? Second, you refer to the values as an array but, given the organization of the spreadsheet I don't see any arrays. What arrays are you referring to? Cell addresses would be helpful to understand. Regarding your question about numbers of rows and columns I believe the max number of rows is 1,000,000 and max columns is 1024. Your example for A target shows the one positive value for A in one column and the negative values for A in a different column. In the target the order of values by row is the same as in the source. Which gets me back to I still don't understand what you need to accomplish. Answers to a few questions may help me: - is the goal to rearrange the Raw Alphanumerical so it is organized like the target? - is there a specific repeatable method for why data is where it is in the Raw Alphanumerical and if there is what are the rules? Knowing the rules would go a long way to planning how to rearrange Raw into Target -Alan -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Check (tick) box.
Hi. Is there a way to add a check box (click it and a tick or x appears, click it again and it becomes empty) to a writer document. This does not need to be a form. Word has these and they work in LO when I open the word doc but I can't copy paste one to a writer document. Form controls are not easy to use keep crashing my LO 4.3 when I change the anchor method so I don't know how robust that option is. Cheers, Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] first step forward
Hi :) You might find this website more useful; http://pl.libreoffice.org/ Also the Polish language mailing list might be easier as you can use Polish; https://wiki.documentfoundation.org/Local_Mailing_Lists#Polish or if your main language is something else then there is probably a different mailing list for that too. I think most people use spreadsheets (ie Calc or Excel) to create an array of numbers. However if this for bookkeeping then you might find it better to use a specialist tool such as GnuCash (also Libre and free OpenSource program). It really depends on what you are trying to do. If you think a database might be better then using Base as a front-end with an external back-end such as MySql/MariaDb, Postgresql or something else is probably a good idea. Some people have a go with a spreadsheet first as part of the planning process before designing a database. There is a book about how to use Base but it is primarily only available in German. The English one is quite outdated now (already! Time flies!) and the translator teams are often even smaller and mostly have only just begun to think about translating the Published Guides. Of course they do have the built-in help but it sounds like you really need something a bit more hefty to get a good overview. If you can find it in an appropriate language then you might like the Getting Started Guide Regards from Tom :) On 2 March 2015 at 23:22, an...@neostrada.pl wrote: Hello, Just few days've gone, I had opportunity to discover your LibreOffice 4.4.1.2. I've got really impressed. Unfortunatly, there is not enough time, till now, to answer the question: Is the LO abbly, for example, to proceed efficiently a specific arrey of numbers (a kind of compilation)? I'm pretty sure, but to get forward I've attached simple sample as below. Is the spreadsheet, or rather is the database the proper tool? Could you proceed the sample, please? Best regards, Andrew Anddos -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Where is Base?
Hi Tom, Interesting. Given similar, huge challenges, would you see areas of cooperation with Kexi? On 3 March 2015 at 14:33, Tom Davies tomc...@gmail.com wrote: Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we now effectively have a choice of 2 internal back-ends neither of which work entirely as hoped for yet. With Firebird it feels like it is on the way though. Regards from Tom :) On 2 March 2015 at 21:09, Andreas Säger ville...@t-online.de wrote: Am 02.03.2015 um 21:23 schrieb Tom Davies: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. This is not a matter of partisanship, fanboyism nor objective evidence of the better product. The important thing is that you are able to connect to whatever you already have. The database of your online shop, your business software, your accounting software, some dBase directory, spreadsheets or csv files. The connectivity feature lets you use tabular data without troublesome export/import. If all you have is an embedded HSQLDB, you can convert this to HSQL 2 within minutes. Conversion into Postrgre/MySQL/whatever would require careful editing of SQL scripts, testing and possibly adjustment of queries, forms, reports. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: 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 -- regards, Jaroslaw Staniek KDE: : A world-wide network of software engineers, artists, writers, translators : and facilitators committed to Free Software development - http://kde.org Calligra Suite: : A graphic art and office suite - http://calligra.org Kexi: : A visual database apps builder - http://calligra.org/kexi Qt Certified Specialist: : http://www.linkedin.com/in/jstaniek -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Can't open .xls files in LibreOffice 4.4 calc
On 2015-03-02 20:16, infinityplusb wrote: Hi allI'm trying to open an .xls file (actually a number of xls files) I downloaded from the Australia Statistics agency website and want to check if other people can open it before I raise it as an issue with ... someone.The file is attached 3303_1_underlying_causes_of_death_(australia).xls http://nabble.documentfoundation.org/file/n4142025/3303_1_underlying_causes_of_death_%28australia%29.xls The versions I'm using are:LibreOffice Version: 4.4.0.3Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645dI'm using Ubuntu 14.10Can someone try and open up the file attached in LibreOffice please?Also if someone could let me know what I need to do to trouble shoot that would be great.PS I can open some .xls files, just not this (or a few others) so it might be something *in* the file. A workaround rather than solution would also suffice for my purposes. -- View this message in context: http://nabble.documentfoundation.org/Can-t-open-xls-files-in-LibreOffice-4-4-calc-tp4142025.html Sent from the Users mailing list archive at Nabble.com. If the file is opened in an earlier version, then saved(keeping the xls format), the file will open in 4.4.0. TomW -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Can't open .xls files in LibreOffice 4.4 calc
Hi :) Nice one TomW! :) Good to know LibreOffice can fix the file :) This has been reported as a good way of helping MS Office users share documents that they initially have trouble with in MS Office. The LibreOffice user acts as a stepping stone to solve incompatibility issues between differeing versions of MS Office. I guess next step might be if someone can find the time to do that and then upload the new file to Nabble or somewhere so that the o.p. can download it easily? Of course one trouble-shooting tactic that is only possible with documents in ODF format is to; 1. create a copy of the document (basic rule of data-recovery is to work on a copy rather than the original) 2. rename the file-ending from .ods to .zip 3. now the 'file' opens as a normal compressed set of foldersfiles. Most of the text of the document is in the content.xml file. I'm not quite sure how that plays out for spreadsheets. Also this tactic doesn't work for the older MS formats. It is still better to use them rather than any of the newer MS formats though because the older format can be read by a much wider range of software so it's better for sharing documents. XlsX often needs people to be using the exact same version of MS Office as each other! The ODF format is becoming more widely used, especially since MS Office 2013 can (allegedly!) finally read the same version of ODF as everyone else. Regards from Tom :) On 3 March 2015 at 10:53, TomW tomw...@fairpoint.net wrote: On 2015-03-02 20:16, infinityplusb wrote: Hi allI'm trying to open an .xls file (actually a number of xls files) I downloaded from the Australia Statistics agency website and want to check if other people can open it before I raise it as an issue with ... someone.The file is attached 3303_1_underlying_causes_of_death_(australia).xls http://nabble.documentfoundation.org/file/n4142025/3303_1_underlying_ causes_of_death_%28australia%29.xls The versions I'm using are:LibreOffice Version: 4.4.0.3Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645dI'm using Ubuntu 14.10Can someone try and open up the file attached in LibreOffice please?Also if someone could let me know what I need to do to trouble shoot that would be great.PS I can open some .xls files, just not this (or a few others) so it might be something *in* the file. A workaround rather than solution would also suffice for my purposes. -- View this message in context: http://nabble.documentfoundation.org/Can-t- open-xls-files-in-LibreOffice-4-4-calc-tp4142025.html Sent from the Users mailing list archive at Nabble.com. If the file is opened in an earlier version, then saved(keeping the xls format), the file will open in 4.4.0. TomW -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: 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't open .xls files in LibreOffice 4.4 calc
The file is not corrupted. It open correctly in MS Office 2010. However it will not open in LibreOffice 4.4.1 under Windows 7 x64 but it will open in 4.3.6 Therefore this seems to be a regression in the 4.4 branch The workaround is to use a release from the previous branch. Under Windows there are two portable versions you could use without installing just to convert the files. Hope this helps. -- View this message in context: http://nabble.documentfoundation.org/Can-t-open-xls-files-in-LibreOffice-4-4-calc-tp4142025p4142049.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Can't open .xls files in LibreOffice 4.4 calc
Hi, before you raise a bug (if you could). It would be helpful to log a few things: * last version it actually worked with * if you save with the working version, can you open with 4.4 Cheers On 03/03/15 19:48, infinityplusb wrote: Thanks everyone. I suspected it might be something specific to 4.4 I'll try find my way to raising a bug and I'll download a previous release to open the files. Thanks again. -- View this message in context: http://nabble.documentfoundation.org/Can-t-open-xls-files-in-LibreOffice-4-4-calc-tp4142025p4142051.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
