Re: [libreoffice-users] Calc suddenly very slow on loading
Hi all: I think it would be because you have low memory asigned for your big spreadsheet. I suggest this: 1) Menu 2) Tools 3) Memory There you find some topics where you can increase the memory that Libre Office use for the program. If you increase them your Libre Office able to manage more data and information in each spreasheet. I hope this help you Regards, Jorge Rodríguez El mié, 04-03-2015 a las 11:01 +0100, Milos Sramek escribió: Hi, I have an ods file with about 1800 lines and 25 columns. In each line there are about 50 hyperlinks (they are links to web or local files - I have two versions of the document). Until recently (two weeks ago), LO was able to open it in a second or two, and I was able to work with it normally (adding columns, sorting etc). Suddenly everything has changed - loading takes about 10 minutes and then no work is possible, since the response is horribly slow. I have several versions of LO installed and I am sure that the 4.3 an 4.4.0 versions were OK. Recently, I have upgraded 4.4.0 to 4.4.1 and installed 4.5 alpha. What surprises me is that also 4.3 is slow now and removing of 4.4.1 and 4.5 does not change the situation. I am using Ubuntu 14.10. I suspect that the problem is somewhere outside LO. A version of the document without the hyperlink loads instantly, so the problem resides in them Do you have any idea? Thank in advance Milos -- email jabber: sramek.mi...@gmail.com -- Atentamente, Jorge Rodríguez -- 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 :) Yeh, in attempting to clarify i did add an extra confusion! Sorry! The HsqlDb version 1.8 is only a problem when using the internal version in Base. However Base doesn't give you much choice about what to use as the internal back-end. Just the heavily tweaked and broken version of 1.8. Regards from Tom :) On 4 March 2015 at 10:58, Andreas Säger ville...@t-online.de wrote: Am 04.03.2015 um 11:03 schrieb Tom Davies: Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the version used as the internal back-end in Base. The problem is _not_ a particular version of a particular database. If HSQL 1.8 works for you, even that version works as a rock stable, fast and reliable backend to your Base document. Heinrich demanded an _interface_ to handle the big irons. He was not talking about a particular version of some particular big iron. He did not tell us what is wrong with the current interface. From the view point of database developers, there are several missing features. From the view point of someone who wants to build a serial letter from his spreadsheet, Base is the big and dark mystery to be avoided entirely and the serial letter wizard does not mention that one of its products is a Base document together with the serial letter. -- 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] database2spreadsheet
Hi, how would I create a spreadsheet from a table in a database? I know I can copy and paste, and I want to avoid that. Basically, users should be able to click an icon in LO (or on their desktop) and be presented with a spreadsheet which displays an export from a table I have in a mysql database. Fields in the spreadsheet must be in a different order than in the database and be formatted to a pre-defined width. In a future step, I would like to integrate graphics into the spreadsheet which could be created by a perl script with gnuplot from data in the database; the images could reside in a directory and rows in the database would have a field referring to the file name of the image. Is there any functionality in LO to achieve something like this, or is the database part as incompatible to other parts of LO, like spreadsheets, as it seems to be? -- 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] Calc suddenly very slow on loading
Hi, I have an ods file with about 1800 lines and 25 columns. In each line there are about 50 hyperlinks (they are links to web or local files - I have two versions of the document). Until recently (two weeks ago), LO was able to open it in a second or two, and I was able to work with it normally (adding columns, sorting etc). Suddenly everything has changed - loading takes about 10 minutes and then no work is possible, since the response is horribly slow. I have several versions of LO installed and I am sure that the 4.3 an 4.4.0 versions were OK. Recently, I have upgraded 4.4.0 to 4.4.1 and installed 4.5 alpha. What surprises me is that also 4.3 is slow now and removing of 4.4.1 and 4.5 does not change the situation. I am using Ubuntu 14.10. I suspect that the problem is somewhere outside LO. A version of the document without the hyperlink loads instantly, so the problem resides in them Do you have any idea? Thank in advance Milos -- email jabber: sramek.mi...@gmail.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: Where is Base?
Hello Noel, Interesting! I will have a look at H2. The only issue for me at the moment is that my provider has not got it installed and therefore I cannot use it. Regards from Salzburg Heinz Marion Noel Lodge schrieb: 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
Re: [libreoffice-users] Re: Where is Base?
Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the version used as the internal back-end in Base. People using HsqlDb as an external back-end would have been pushed into upgrading many times in the last decade or so. Not upgrading would have been a lot like sticking with Win98. So i believe it was the move to a more modern version of a database program that gave Noel the fantastic improvements he experienced. Java-based back-ends do have a reputation for being much faster for the relatively small databases that most of us probably use. The one with 1 billion records might well find that moving to something heftier such as Postgresql or MySql/MariaDb does the trick. Although there might be some performance advantages to moving from the heftier back-ends to the smallerfaster ones there are several disadvantages around doing the move. Internet facing Servers using LAMP or WAMP and web-hosting companies tend to already have MySql/MariaDb (hence the M i think) so it'd be a bit like installing a different Office Suite for each document rather than trying to stick with just 1 or 2. Regards from Tom :) On 4 March 2015 at 08:53, Heinrich Stöllinger hc.stoellin...@aon.at wrote: Hello Noel, Interesting! I will have a look at H2. The only issue for me at the moment is that my provider has not got it installed and therefore I cannot use it. Regards from Salzburg Heinz Marion Noel Lodge schrieb: 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
Re: [libreoffice-users] Re: Where is Base?
Hi :) One point that may have become muddled in translation is that it is only the front-end that needs to be copied, or re-created on multiple machines. The stable back-end could be on a server so that everyone is using the same data. As one person adds data everyone else would be able to see that data on their various machines. So Base is a LOT more scalable much more easily than Access. On a single machine you probably keep the back-end on the same machine as the front-end. If other machines get added then they just share that same back-end. As the company grows and eventually needs it's own internal server that back-end might get moved to that server but all the front-ends on all the different machines still keep using that same back-end even though it's been moved. Hopefully Base can even connect to back-ends hosted on WANs rather than just LANs and even on remotely hosted websites and Clouds. Regards from Tom :) On 3 March 2015 at 18:28, Andreas Säger ville...@t-online.de wrote: 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 -- 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 Tom... Maybe I misunderstand your remark below, but... My database has for years been on a WAN-accessed MySQL server. This is only an issue resolved through DNS or the hosts file . I haven't experienced any difficulties/problems either in defining the database, loading or backing up data to my local machine (either through phpMyAdmin or the native command-line client). The only issue I have at this time is that scrolling through tables/views under LO tends to be slow. I'll have to look at that... Regards Heinz Tom Davies schrieb: Hopefully Base can even connect to back-ends hosted on WANs rather than just LANs and even on remotely hosted websites and Clouds. -- 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?
On 4 March 2015 at 11:25, Tom Davies tomc...@gmail.com wrote: Hi :) One point that may have become muddled in translation is that it is only the front-end that needs to be copied, or re-created on multiple machines. The stable back-end could be on a server so that everyone is using the same data. As one person adds data everyone else would be able to see that data on their various machines. Everyone can have the same frontend too (so it's keep updated) if its definition resides on the server side. Not necessarily in the same db instance or even db type. That's the way of Kexi even if only local SQLite instances are used. All combinations possible: local data + shared frontend, shared data + local frontend, everything shared, nothing shared. This is an entry point to the cloud infra. Without this, splited database with local frontend sounds still very Access way no matter how we criticize it. Also and idea, for a higher level operation is based on 3-tier architecture where users have access to business logic and not to physical database instances. Reasons being: reliability, maintainability and security. -- 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
[libreoffice-users] Re: database2spreadsheet
Am 04.03.2015 um 10:59 schrieb hw: Hi, how would I create a spreadsheet from a table in a database? [Tutorial] Using registered datasources in Calc https://forum.openoffice.org/en/forum/viewtopic.php?f=75t=18511 -- 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 04.03.2015 um 11:03 schrieb Tom Davies: Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the version used as the internal back-end in Base. The problem is _not_ a particular version of a particular database. If HSQL 1.8 works for you, even that version works as a rock stable, fast and reliable backend to your Base document. Heinrich demanded an _interface_ to handle the big irons. He was not talking about a particular version of some particular big iron. He did not tell us what is wrong with the current interface. From the view point of database developers, there are several missing features. From the view point of someone who wants to build a serial letter from his spreadsheet, Base is the big and dark mystery to be avoided entirely and the serial letter wizard does not mention that one of its products is a Base document together with the serial letter. -- 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] database2spreadsheet
On Wed, Mar 4, 2015 at 4:59 AM, hw h...@gartencenter-vaehning.de wrote: how would I create a spreadsheet from a table in a database? I know I can copy and paste, and I want to avoid that. Basically, users should be able to click an icon in LO (or on their desktop) and be presented with a spreadsheet which displays an export from a table I have in a mysql database. Fields in the spreadsheet must be in a different order than in the database and be formatted to a pre-defined width. Hello hw, there was recently conversation on the topic of data export. The thread is here... https://listarchives.libreoffice.org/global/users/msg43335.html There is no icon or menu selection providing access to that feature however, yes, the export and reordering of columns can be done. It is done via the SQL command window. The command, using HSQL syntax, is... SELECT * INTO TEXT exportTable1 FROM Table1 Syntax would need to be modified to mysql equivalent to support the same action with a mysql source. -- 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] Syntax highlighting
body p { margin-bottom: 0cm; margin-top: 0pt; }Dear All,I need to export my articles as EPUB, My context of my odt, contais of code , so i need to syntax highlighting, How can i enable syntax highlighting in odt ?--Regards,Mohsen -- 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] Syntax highlighting
On 03/04/2015 07:48 AM, Mohsen Pahlevanzadeh wrote: body p { margin-bottom: 0cm; margin-top: 0pt; }Dear All,I need to export my articles as EPUB, My context of my odt, contais of code , so i need to syntax highlighting, How can i enable syntax highlighting in odt ?--Regards,Mohsen This is not supported directly by LO, so you have a few options. 1. Do it manually 2. Copy from something that does and paste the code into your document 3. Use something like the code colorizer extension (http://extensions.libreoffice.org/extension-center/code-colorizer-formatter) and hope that it supports your language. What language are you using? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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