[libreoffice-users] Mac OSX Intel - DOXC with Pictures
hi all we have a problem on a Mac OSX intel 10.6.8 with libreoffice 3.4.1. See this file http://db.tt/7tOH9Gb, it contains the following: Example.docx - docx with a embedded picture Example.pdf - the pdf, was created from Example.docx Screenshot-01.png - screenshot in edit mode Screenshot-02.png - screenshot in print preview mode i think you will see the problem... Main Problem, picture are there.. but not visible, just with a border... if exporting to pdf or print/preview they are there.. but while working on that docx it's not possible to see the picture... We also found out, that the same problem occurs while creating a new odt on Mac OSX and embed a picture, see following file: http://db.tt/KKCAZdn Myself i'm working on Linux Kubuntu 11.04 with libreoffice 3.3.3 and can open all above file (docx, odt) and see the picture... Hope someone can help or have an idea... Thanks a lot Kind regards thomi -- View this message in context: http://nabble.documentfoundation.org/Mac-OSX-Intel-DOXC-with-Pictures-tp3208813p3208813.html Sent from the Users mailing list archive at Nabble.com. -- 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] Configure LO to use localdisk installation of help manual
Readers, I do not want to rely upon internet access when using LO. Is there a way to configure LO to refer to help documentation installed on the localdisk where LO was installed also? Thanks. -- 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] Formatting question
Sorry it took so long to get back, I was on vacation, but did get a little time to look into it and while I am going to use everyones suggestions it turns out it's not LO but the site I upload to. It reformats and I have to go in through their editor to fix it. Pain. Anyway, again I am going to attempt everyones suggestions in hopes maybe one or all will override this. Thanks again! Night wrote: No, I don't change anything, I just hit enter 3x like I did with OpenOffice and assumed it would work like OpenOffice. So your using empty paragraphs, which should work. I just tried and have no problem. The way your doing it is one way but not the best. You should be using styles to define the looks of the paragraphs and it will be more consistent. Using a word processor like a typewriter is bad form and will lead to formatting issues. Andy Yes, that's it! And it worked with OpenOffice and since they seemed so similar (except LibreOffice is nice, light and quick where OO was slow and clunky), I thought it would work, but once saved and uploaded, I look and it didn't. So I didn't even know it wasn't working till it was all said and done. So, another question would be how do I go about styling paragraphs? Again, I'm new and never had to worry about it with OO. Thank you! It should be working, as I said it works as expected here. As for styles there is no quick answer. Styles are used to define how pages, paragraphs and characters look on a page. You best choice is to got to http://www.libreoffice.org/get-help/documentation/ and download or read the Working with Styles chapter of the Writers guide. Andy -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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 -- 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] LO 3.4.2 plus Native MySQL connection
Hi :) It's not easy to get more than 1 install of LibreOffice/OpenOffice workign on one machine but there are instructions on how to do this here http://wiki.documentfoundation.org/Installing_in_parallel Although the 3.4.2 is claimed to be aimed at enterprises i would be wary about abandoning the 3.3.3 until testing it for yourself. Good luck and regards from Tom :) From: Heinrich Stoellinger hc.stoellin...@aon.at To: users@global.libreoffice.org users@global.libreoffice.org Sent: Fri, 29 July, 2011 10:10:31 Subject: [libreoffice-users] LO 3.4.2 plus Native MySQL connection Hello, I have just (looks like I am a glutton for punishment?) downloaded and installed LO 3.4.2rc3 on my Linux-Debian-Wheezy system. The installation (after removing traces of 3.3.3) went smoothly, but... My favourite connector to my MySQL-DB is the native connector. I hoped that it might work under 3.4.2, but it seems that this might not be the case - would be a pity. So, I'll just have to keep on using ODBC (more complex to install, probably not as fast, etc...) Regards from Salzburg H.S. P.S.: I will stay on 3.3.3 on my W/Vista-Laptop. Things work o.k. there (mostly!) --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --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 -- 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: (help macro base)Open form with a button form another form with filter
Alex , thank you. I will return to the problem when version 3.4.2 is launched (in july) 2011/7/28 Alexander Thurgood alex.thurg...@gmail.com Le 28/07/11 22:11, rogerio dandrea a écrit : Hi Rogerio, Sorry if this is a silly question but, how do I switch the focus from one form to another? I actually looked this up on the OpenOffice.org forum, but I can't find the link to the post anymore. There might also be a bug in LibreOffice that prevents the form from reloading. I seem to recall having seen something similar somewhere, because the filter.appply = true and form.reload used to work with OpenOffice.org. Alex -- 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 -- 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] LO 3.4.2 plus Native MySQL connection
Hi Tom, As I mentioned in my post, I am staying with 3.3.3 on Windows. My MySQL-database is stored on my Debian-system and accessed via the native MySQL-connection from Windows. This combination is not ideal but it works and I can always fall back to it if the Linux-version (using ODBC at the moment) should have trouble. I worked for Big Blue for nearly 30 years as a systems engineer where I even had the pleasure to get to know Ed Codd (inventor of Relational DBs). Now I am retired, still sitting by my PC most of the day, but that time is mainly spent on managing a brass band. This does unfortunately leave NO time that I could dedicate to enhancing very viable and important software such as LO. Enough bla, bla... Regards H. On Fri, 29 Jul 2011 11:39:21 +0200, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) It's not easy to get more than 1 install of LibreOffice/OpenOffice workign on one machine but there are instructions on how to do this here http://wiki.documentfoundation.org/Installing_in_parallel Although the 3.4.2 is claimed to be aimed at enterprises i would be wary about abandoning the 3.3.3 until testing it for yourself. Good luck and regards from Tom :) From: Heinrich Stoellinger hc.stoellin...@aon.at To: users@global.libreoffice.org users@global.libreoffice.org Sent: Fri, 29 July, 2011 10:10:31 Subject: [libreoffice-users] LO 3.4.2 plus Native MySQL connection Hello, I have just (looks like I am a glutton for punishment?) downloaded and installed LO 3.4.2rc3 on my Linux-Debian-Wheezy system. The installation (after removing traces of 3.3.3) went smoothly, but... My favourite connector to my MySQL-DB is the native connector. I hoped that it might work under 3.4.2, but it seems that this might not be the case - would be a pity. So, I'll just have to keep on using ODBC (more complex to install, probably not as fast, etc...) Regards from Salzburg H.S. P.S.: I will stay on 3.3.3 on my W/Vista-Laptop. Things work o.k. there (mostly!) --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --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 -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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] LO 3.4.2 plus Native MySQL connection
Here we go again, I run a 4-core-2.4 GHz PC. When working with LO 3.4.2-rc3 for a while, one of the CPUs gets used at between 90 and 100 p.c. constantly. This continues even though NOTHING external happens. When I then try to enter text into an .odt-Textfile performance is obviously unacceptable. I will try to pin this down more specifically. Regards H.S. On Fri, 29 Jul 2011 12:08:22 +0200, Heinrich Stoellinger hc.stoellin...@aon.at wrote: Hi Tom, As I mentioned in my post, I am staying with 3.3.3 on Windows. My MySQL-database is stored on my Debian-system and accessed via the native MySQL-connection from Windows. This combination is not ideal but it works and I can always fall back to it if the Linux-version (using ODBC at the moment) should have trouble. I worked for Big Blue for nearly 30 years as a systems engineer where I even had the pleasure to get to know Ed Codd (inventor of Relational DBs). Now I am retired, still sitting by my PC most of the day, but that time is mainly spent on managing a brass band. This does unfortunately leave NO time that I could dedicate to enhancing very viable and important software such as LO. Enough bla, bla... Regards H. On Fri, 29 Jul 2011 11:39:21 +0200, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) It's not easy to get more than 1 install of LibreOffice/OpenOffice workign on one machine but there are instructions on how to do this here http://wiki.documentfoundation.org/Installing_in_parallel Although the 3.4.2 is claimed to be aimed at enterprises i would be wary about abandoning the 3.3.3 until testing it for yourself. Good luck and regards from Tom :) From: Heinrich Stoellinger hc.stoellin...@aon.at To: users@global.libreoffice.org users@global.libreoffice.org Sent: Fri, 29 July, 2011 10:10:31 Subject: [libreoffice-users] LO 3.4.2 plus Native MySQL connection Hello, I have just (looks like I am a glutton for punishment?) downloaded and installed LO 3.4.2rc3 on my Linux-Debian-Wheezy system. The installation (after removing traces of 3.3.3) went smoothly, but... My favourite connector to my MySQL-DB is the native connector. I hoped that it might work under 3.4.2, but it seems that this might not be the case - would be a pity. So, I'll just have to keep on using ODBC (more complex to install, probably not as fast, etc...) Regards from Salzburg H.S. P.S.: I will stay on 3.3.3 on my W/Vista-Laptop. Things work o.k. there (mostly!) --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --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 -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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: Base record access unacceptably slow
Am 28.07.2011 08:30, Tom Cloyd wrote: As an aside, have you thoughts to share about HSQLDB vs H2? Any good reason to migrate to H2 (a question entirely separate from the db speed question). I'd be interested to hear your thoughts if you have time to share them. The tiny user community of the Base component gathers on http://user.services.openoffice.org/en/forum/index.php and http://www.oooforum.org/forum/viewforum.phtml?f=10. Have a walk through http://user.services.openoffice.org/en/forum/viewforum.php?f=83 and http://user.services.openoffice.org/en/forum/viewforum.php?f=100. Read contributions by most valued member DACM. He knows everything about embedded HSQLDB, why not to use it, how to transform it to something useful. http://www.oooforum.org/forum/viewtopic.phtml?t=94068 [How to: Migrate Base Projects to Multi-User] http://www.oooforum.org/forum/viewtopic.phtml?t=97522 [Replace HSQLDB with H2 embedded multi-user] http://user.services.openoffice.org/en/forum/viewtopic.php?f=83t=17567p=162653#p162653 [[Tutorial] Avoid data loss by avoiding Embedded databases] Both database engines are just great, even for people who do not intend to write their own Java application around these animals. For my last tiny project I prefered HSQLDB v2 simply because I already had working drafts in embedded HSQLDB v1.8. I tried H2 when HSQLDB v2 was not released and I had to do some analysis work on half a million interrelated records from 2 databases. The single-user local DB simply worked out of the box, just like HSQLDB 1.8 did with less features. I copied dBase and csv data into the prepared database structure, added queries, some macros and dumped the final aggregations in Calc's pivot tables. Replacing one excellent database backend with another excellent database backend makes no sense. The database in a single zip archive (the so called Base document) is the major trouble maker which makes up a slow, inflexible, unsafe, insecure caricature of a database while the advantage is close to zero. -- 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: Base record access unacceptably slow
Hi :) Could that community be prevailed upon to join TDF and manage the Base part of the project? Presumably they have knowledge of key players and have a good idea of what needs to be done to improve Base? Regards from Tom :) From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Sent: Fri, 29 July, 2011 11:30:16 Subject: [libreoffice-users] Re: Base record access unacceptably slow Am 28.07.2011 08:30, Tom Cloyd wrote: As an aside, have you thoughts to share about HSQLDB vs H2? Any good reason to migrate to H2 (a question entirely separate from the db speed question). I'd be interested to hear your thoughts if you have time to share them. The tiny user community of the Base component gathers on http://user.services.openoffice.org/en/forum/index.php and http://www.oooforum.org/forum/viewforum.phtml?f=10. Have a walk through http://user.services.openoffice.org/en/forum/viewforum.php?f=83 and http://user.services.openoffice.org/en/forum/viewforum.php?f=100. Read contributions by most valued member DACM. He knows everything about embedded HSQLDB, why not to use it, how to transform it to something useful. http://www.oooforum.org/forum/viewtopic.phtml?t=94068 [How to: Migrate Base Projects to Multi-User] http://www.oooforum.org/forum/viewtopic.phtml?t=97522 [Replace HSQLDB with H2 embedded multi-user] http://user.services.openoffice.org/en/forum/viewtopic.php?f=83t=17567p=162653#p162653 [[Tutorial] Avoid data loss by avoiding Embedded databases] Both database engines are just great, even for people who do not intend to write their own Java application around these animals. For my last tiny project I prefered HSQLDB v2 simply because I already had working drafts in embedded HSQLDB v1.8. I tried H2 when HSQLDB v2 was not released and I had to do some analysis work on half a million interrelated records from 2 databases. The single-user local DB simply worked out of the box, just like HSQLDB 1.8 did with less features. I copied dBase and csv data into the prepared database structure, added queries, some macros and dumped the final aggregations in Calc's pivot tables. Replacing one excellent database backend with another excellent database backend makes no sense. The database in a single zip archive (the so called Base document) is the major trouble maker which makes up a slow, inflexible, unsafe, insecure caricature of a database while the advantage is close to zero. -- 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 -- 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: Base record access unacceptably slow
Am 29.07.2011 13:42, Tom Davies wrote: Hi :) Could that community be prevailed upon to join TDF and manage the Base part of the project? Presumably they have knowledge of key players and have a good idea of what needs to be done to improve Base? Regards from Tom :) Be assured that those guys did their very best to assist the OOo developers at Sun/Oracle with user support, bug hunting, documentation and moderate (doable) feature requests. Now those days are over. As a heavy Base user I would be very pleased to see a functional, standard compliant, actively maintained, one-way data import facility in LibreOffice. This would require a tiny fraction of the current code without any Java dependency at all. No more database development in this office suite. No more office users overstrained by abstract data models. Simply connect, query and link already existing, well formed databases to document fields as it always used to work since the first version of OOo. This is how the majority of office users uses Base when they create serial letters without even noticing the .odb file on their disk (well, until they delete it ...). Like in OOo 1.x, the Base document should be a simple registration entry with connection info and some SELECT strings because the embedded database document failed completely, drowning gigabytes of user data in binary swamps. Andreas Säger -- 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] Formatting question
Hi :) It might be more productive to contact their webmaster/mistrees or find the people that develop the site somehow. They might be able to giive better advice on how to format stuff. Regards from Tom :) From: Night lady.larm...@gmail.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Fri, 29 July, 2011 9:59:56 Subject: Re: [libreoffice-users] Formatting question Sorry it took so long to get back, I was on vacation, but did get a little time to look into it and while I am going to use everyones suggestions it turns out it's not LO but the site I upload to. It reformats and I have to go in through their editor to fix it. Pain. Anyway, again I am going to attempt everyones suggestions in hopes maybe one or all will override this. Thanks again! Night wrote: No, I don't change anything, I just hit enter 3x like I did with OpenOffice and assumed it would work like OpenOffice. So your using empty paragraphs, which should work. I just tried and have no problem. The way your doing it is one way but not the best. You should be using styles to define the looks of the paragraphs and it will be more consistent. Using a word processor like a typewriter is bad form and will lead to formatting issues. Andy Yes, that's it! And it worked with OpenOffice and since they seemed so similar (except LibreOffice is nice, light and quick where OO was slow and clunky), I thought it would work, but once saved and uploaded, I look and it didn't. So I didn't even know it wasn't working till it was all said and done. So, another question would be how do I go about styling paragraphs? Again, I'm new and never had to worry about it with OO. Thank you! It should be working, as I said it works as expected here. As for styles there is no quick answer. Styles are used to define how pages, paragraphs and characters look on a page. You best choice is to got to http://www.libreoffice.org/get-help/documentation/ and download or read the Working with Styles chapter of the Writers guide. Andy -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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 -- 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 -- 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] LO 3.4.2 plus Native MySQL connection
Here we go again, I run a 4-core-2.4 GHz PC. When working with LO 3.4.2-rc3 for a while, one of the CPUs gets used at between 90 and 100 p.c. constantly. This continues even though NOTHING external happens. When I then try to enter text into an .odt-Textfile performance is obviously unacceptable. I have to restart LO for things to behave normally again. I cannot consciously reproduce th situation and will try to pin this down more specifically. Regards H.S. On Fri, 29 Jul 2011 12:08:22 +0200, Heinrich Stoellinger hc.stoellin...@aon.at wrote: Hi Tom, As I mentioned in my post, I am staying with 3.3.3 on Windows. My MySQL-database is stored on my Debian-system and accessed via the native MySQL-connection from Windows. This combination is not ideal but it works and I can always fall back to it if the Linux-version (using ODBC at the moment) should have trouble. I worked for Big Blue for nearly 30 years as a systems engineer where I even had the pleasure to get to know Ed Codd (inventor of Relational DBs). Now I am retired, still sitting by my PC most of the day, but that time is mainly spent on managing a brass band. This does unfortunately leave NO time that I could dedicate to enhancing very viable and important software such as LO. Enough bla, bla... Regards H. On Fri, 29 Jul 2011 11:39:21 +0200, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) It's not easy to get more than 1 install of LibreOffice/OpenOffice workign on one machine but there are instructions on how to do this here http://wiki.documentfoundation.org/Installing_in_parallel Although the 3.4.2 is claimed to be aimed at enterprises i would be wary about abandoning the 3.3.3 until testing it for yourself. Good luck and regards from Tom :) From: Heinrich Stoellinger hc.stoellin...@aon.at To: users@global.libreoffice.org users@global.libreoffice.org Sent: Fri, 29 July, 2011 10:10:31 Subject: [libreoffice-users] LO 3.4.2 plus Native MySQL connection Hello, I have just (looks like I am a glutton for punishment?) downloaded and installed LO 3.4.2rc3 on my Linux-Debian-Wheezy system. The installation (after removing traces of 3.3.3) went smoothly, but... My favourite connector to my MySQL-DB is the native connector. I hoped that it might work under 3.4.2, but it seems that this might not be the case - would be a pity. So, I'll just have to keep on using ODBC (more complex to install, probably not as fast, etc...) Regards from Salzburg H.S. P.S.: I will stay on 3.3.3 on my W/Vista-Laptop. Things work o.k. there (mostly!) --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --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 -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] How to convert a number(in format YYYYMMDD) to date
Dear readers, I have a document(csv converted to spreadsheet) with bankstatements. Those statements have a date in the form of MMDD (no /'s or -'s). The problem is that I can't make libreoffice recognise those numbers as dates. Can somebody explain how I can make Libreoffice recognise the MMDD numbers as dates. Kind regards, Koen -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date
On 29 July 2011 12:29, Koen van Steekelenburg koenvansteekelenb...@gmail.com wrote: I have a document(csv converted to spreadsheet) with bankstatements. Those statements have a date in the form of MMDD (no /'s or -'s). The problem is that I can't make libreoffice recognise those numbers as dates. Can somebody explain how I can make Libreoffice recognise the MMDD numbers as dates. Assuming the MMDD is in cell A1, I would use =DATEVALUE(CONCATENATE(LEFT(A1,4),-,MID(A1,5,2),-,RIGHT(A1,2))) -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' -- Erasmus -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date
2011/7/29 Koen van Steekelenburg koenvansteekelenb...@gmail.com:
Dear readers,
I have a document(csv converted to spreadsheet) with bankstatements. Those
statements have a date in the form of MMDD (no /'s or -'s). The problem
is that I can't make libreoffice recognise those numbers as dates. Can
somebody explain how I can make Libreoffice recognise the MMDD numbers
as dates.
Kind regards,
Koen
--
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
I would do a search and replace as follows:
Highlight the cell range with the numbers that you want to convert to dates.
Open the search and replace dialogue.
Make sure that ”Regular expressions” is checked (you need to press the
”More options” button first).
Search for:
^([:digit:]{4})([:digit:]{2})([:digit:]{2})$
Replace with:
$1-$2-$3
or
$1/$2/$3
or
$3/$2/$1
or whatever format you'd prefer.
Hit ”Replace all” or search and replace them one by one.
I just tested this on my system (language=Swedish, country=Sweden). I
entered 20110729 in one cell and then replaced
^([:digit:]{4})([:digit:]{2})([:digit:]{2})$ by $1-$2-$3.
The cell displayed 11-07-29 (since the default date format on my
system seems to be YY-MM-DD) and in the formula field I could read
2011-07-29, as expected.
Regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date
Hi Koen, Koen van Steekelenburg schrieb: Dear readers, I have a document(csv converted to spreadsheet) with bankstatements. Those statements have a date in the form of MMDD (no /'s or -'s). The problem is that I can't make libreoffice recognise those numbers as dates. Can somebody explain how I can make Libreoffice recognise the MMDD numbers as dates. In the csv import dialog is a preview of the data. Click on the column header of the date column. This enables the 'Column type' drop down list. There choose 'Date(YMD)'. Now the dates should be recognized as date already when importing the document. Kind regards Regina -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date
2011/7/29 Regina Henschel rb.hensc...@t-online.de: Hi Koen, Koen van Steekelenburg schrieb: Dear readers, I have a document(csv converted to spreadsheet) with bankstatements. Those statements have a date in the form of MMDD (no /'s or -'s). The problem is that I can't make libreoffice recognise those numbers as dates. Can somebody explain how I can make Libreoffice recognise the MMDD numbers as dates. In the csv import dialog is a preview of the data. Click on the column header of the date column. This enables the 'Column type' drop down list. There choose 'Date(YMD)'. Now the dates should be recognized as date already when importing the document. Kind regards Regina Wow, that sounds convenient! I didn't know about that! Sorry for giving a far too complicated answer, when it could be solved that easily. On the other hand, learning regular expressions may come handy in many other situations… Best regards Johnny Rosenberg ジョニー・ローゼンバーグ -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date
On 29 July 2011 13:36, Regina Henschel rb.hensc...@t-online.de wrote: In the csv import dialog is a preview of the data. Click on the column header of the date column. This enables the 'Column type' drop down list. There choose 'Date(YMD)'. Now the dates should be recognized as date already when importing the document. Yes, but I was under the impression that the spreadsheet already existed (was different from the CSV file) -- 'a document(csv converted to spreadsheet)' so did not assume that was an available option. Koen, if you are importing the CSV file from scratch, then setting the import filter is absolutely the way to do the conversion. If the file has already been imported and changes made, use either of the other two options provided. -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' -- Erasmus -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date
Mr. Valentine is right. The document consists of imports of several differently formatted csv-files and added personal notes, so reimport is no option. Koen On 29 July 2011 21:10, T. R. Valentine trvalent...@gmail.com wrote: On 29 July 2011 13:36, Regina Henschel rb.hensc...@t-online.de wrote: In the csv import dialog is a preview of the data. Click on the column header of the date column. This enables the 'Column type' drop down list. There choose 'Date(YMD)'. Now the dates should be recognized as date already when importing the document. Yes, but I was under the impression that the spreadsheet already existed (was different from the CSV file) -- 'a document(csv converted to spreadsheet)' so did not assume that was an available option. Koen, if you are importing the CSV file from scratch, then setting the import filter is absolutely the way to do the conversion. If the file has already been imported and changes made, use either of the other two options provided. -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' -- Erasmus -- 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 -- 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: Base record access unacceptably slow
Am 29.07.2011 03:22, NoOp wrote: Hit F4 in Writer or Calc, right-clickOpen the dBase Bibliography. All the functionality of a flat (unrelational) dBase connection is there. You can connect, query, edit data through forms and dump any row set into office documents. http://www.libreoffice.org/get-help/system-requirements/ quote For certain features of the software - but not most - Java is required. Java is notably required for Base. /quote As a matter of fact you can disable/remove Java, hit F4 ... connect, query, edit and dump. If I would convert our Java databases and remove Java from our systems nobody would notice the change. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date
T. R. Valentine schrieb: On 29 July 2011 13:36, Regina Henschelrb.hensc...@t-online.de wrote: In the csv import dialog is a preview of the data. Click on the column header of the date column. This enables the 'Column type' drop down list. There choose 'Date(YMD)'. Now the dates should be recognized as date already when importing the document. Yes, but I was under the impression that the spreadsheet already existed (was different from the CSV file) -- 'a document(csv converted to spreadsheet)' so did not assume that was an available option. Koen, if you are importing the CSV file from scratch, then setting the import filter is absolutely the way to do the conversion. If the file has already been imported and changes made, use either of the other two options provided. You can use the import filter afterwards too. Cut the dates in the column and immediately insert them at the same place with option Unformatted text (via the drop-down list of the insert icon). That triggers the import dialog. Kind regards Regina -- 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: Base record access unacceptably slow
On 07/29/2011 01:41 AM, Andreas Säger wrote: Am 29.07.2011 03:22, NoOp wrote: Hit F4 in Writer or Calc, right-clickOpen the dBase Bibliography. All the functionality of a flat (unrelational) dBase connection is there. You can connect, query, edit data through forms and dump any row set into office documents. http://www.libreoffice.org/get-help/system-requirements/ quote For certain features of the software - but not most - Java is required. Java is notably required for Base. /quote As a matter of fact you can disable/remove Java, hit F4 ... connect, query, edit and dump. If I would convert our Java databases and remove Java from our systems nobody would notice the change. Interesting. Thanks for the info/confirmation. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: New User: Three Questions
On 07/28/2011 05:13 PM, NoOp wrote: On 07/27/2011 06:46 PM, Rich Shepard wrote: On Wed, 27 Jul 2011, NoOp wrote: I only referred to that as it shows making a ~/.fonts folder etc. Please create and put the BakerSignet font in there see if LO picks it up. Not really, as I don't know what the astrisk is in '1152a___.*' - I know of no fonts that are listed as .* Nor are there any fonts that use a .atm extension. .atm is used for the Adobe Type Manager font catalog/file ATM fonts are generally Type 1 fonts with an .pfb, .afm and .pfm (and possibly .pfa) files. So I'm still confused. The asterisk means multiple suffixes. In this case, 1152a___.afm, 1152a___.inf, 1152a___.pfb, and 1152a___.pfm. I mistyped afm as atm. Got it. Well, I guess LO is different from other apps in that it cannot see fonts in /usr/share/fonts, but does in ~/.fonts. Very strange. Regardless, I will make softlinks in ~/.fonts to the directories in /usr/share/fonts. ... Might be an issue with the slackware build - you might consider filing a bug report. It gets even more interesting; I was experimenting with some old Adobe FrameMaker .pfb files used FontForge to convert a .pdb to the respective .pfa .afm files. Placed those in ~/.fonts and LO 3.3.3 and OOo 3.2.1 pick up the font just fine. However, LO 3.4.2 rc2 (pre-release) and OOo-Dev 3.4.0 do not. I'll file a bug on those if I get time in the next few days. Even stranger... I created .afm files for 400 postscript fonts (licenced of course) and had those in ~/.fonts (the .pfb and .afm files) and LO 3.3..x picked them up fine, but LO 3.4.x did not. So I moved them to /usr/share/fonts/PSFONTS, updated the fc-cache, and now LO 3.4 is picking them up as well. Duplicated on a different machine w/o issue, so I reckon that I'll pass on filing the bug. Note that my system is Ubuntu (debian based) and not slackware, so this info may not be of use to Rich and his system. -- 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: Base record access unacceptably slow
. tomcloyd wrote: , On 07/28/2011 12:53 AM, Tom Cloyd wrote: Ug. This is getting ugly really fast. I'm really not on home ground here at all. FWIW, here is a relatively painless way to install an older JRE along side the default Ubuntu one. ( I'm using Ubuntu 10.10 64bit ) It definitely sped up my Base table browsing, but then I don't have any binaries embedded in my tables. It has the bonus of not messing with the existing JRE Overview: 1. Download the JRE archive (approx. 20 mb) 2. Extract in /tmp 3. as root, copy the extracted directory to /usr/lib/jvm 4. set this JRE as the JRE of choice in LO (ToolsOptionsJava) 5. Exit LO restart Instructions: 1.Download jdk-6u21-linux-i586.bin (for i386) or jdk-6u21-linux-x64.bin for x86_64 from http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jdk-6u21-b07-oth-JPR JRE archive at ORACLE . Save to /tmp 2.run it using: sh jdk-6u21-linux-i586.bin . The JRE is now extracted to /tmp/jre1.6.0_21/ 3. copy to /usr/lib/jvm sudo cp -a jre1.6.0_21/ /usr/lib/jvm 4. Exit restart office. In ToolsOptionsJava, choose 1.6.0_21. Exit restart office 5. Load you Base file compare the speed. If you want to remove it simply set the JRE back to the old one in ToolsOptionsJava sudo rm -rf /usr/lib/jvm/jre1.6.0_21/ -- View this message in context: http://nabble.documentfoundation.org/Base-record-access-unacceptably-slow-tp3202820p3211034.html Sent from the Users mailing list archive at Nabble.com. -- 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: QUESTION: Libreoffice documents constantly need recovery
At 07:16 29/07/2011 +0300, David Nelson wrote: On Fri, Jul 29, 2011 at 2:02 AM, Juan Carlos juanzeppe...@hotmail.com wrote: I have the same problem with L.O Writer 3.4.1 in Ubuntu 10.10. L.O. uses java 1.6.0_26. Also I downloaded the deb packages from the web page (not from PPA) Is there any news about this problem? It's not actually an erroneous behavior. It depends how you close the document(s). For example, if you work on a doc, save it, leave it open (and, therefore, leave LibreOffice open), and then exit Ubuntu perfectly normally then, the next time you open LibreOffice, you will be prompted to recover the docs as if some horrible disaster had happened, even though there has been no data loss or anything. If you don't want this behavior to happen then, before you exit Ubuntu, cleanly close your doc(s) and cleanly exit your LibreOffice, and THEN exit Ubuntu. The above was just an example of when it happens. It can happen in other circumstances, too. It's actually considered to be perfectly normal AFAIK. Microsoft Office 2010, for instance, behaves in pretty much the same way. Are you suggesting that if you log out of or shut down Windows when you have some component part of Microsoft Office 2010 open then it will just abort and complain next time it is opened? Are you joking? Even if you have an unsaved document open, Word (or whatever) - being closed by Windows - will challenge you to save or discard your changes. You may have a good reason to choose your operating system and application software, but made-up stories about others is not. Brian Barker -- 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: Base record access unacceptably slow
Hi On Fri, 2011-07-29 at 17:55 -0700, ponsiarceds wrote: . tomcloyd wrote: , On 07/28/2011 12:53 AM, Tom Cloyd wrote: Ug. This is getting ugly really fast. I'm really not on home ground here at all. FWIW, here is a relatively painless way to install an older JRE along side the default Ubuntu one. ( I'm using Ubuntu 10.10 64bit ) It definitely sped up my Base table browsing, but then I don't have any binaries embedded in my tables. It has the bonus of not messing with the existing JRE Overview: 1. Download the JRE archive (approx. 20 mb) 2. Extract in /tmp 3. as root, copy the extracted directory to /usr/lib/jvm 4. set this JRE as the JRE of choice in LO (ToolsOptionsJava) 5. Exit LO restart Instructions: 1.Download jdk-6u21-linux-i586.bin (for i386) or jdk-6u21-linux-x64.bin for x86_64 from http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jdk-6u21-b07-oth-JPR JRE archive at ORACLE . Save to /tmp 2.run it using: sh jdk-6u21-linux-i586.bin . The JRE is now extracted to /tmp/jre1.6.0_21/ 3. copy to /usr/lib/jvm sudo cp -a jre1.6.0_21/ /usr/lib/jvm 4. Exit restart office. In ToolsOptionsJava, choose 1.6.0_21. Exit restart office 5. Load you Base file compare the speed. If you want to remove it simply set the JRE back to the old one in ToolsOptionsJava sudo rm -rf /usr/lib/jvm/jre1.6.0_21/ -- View this message in context: http://nabble.documentfoundation.org/Base-record-access-unacceptably-slow-tp3202820p3211034.html Sent from the Users mailing list archive at Nabble.com. Thank you for the step by step instructions, I am sure many will find them useful -- Jay Lozier jsloz...@gmail.com -- 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: Base record access unacceptably slow
Hi Thanks you for this tips and to all for Base and data bases tips ! Regards, Jorge Rodríguez El vie, 29-07-2011 a las 17:55 -0700, ponsiarceds escribió: . tomcloyd wrote: , On 07/28/2011 12:53 AM, Tom Cloyd wrote: Ug. This is getting ugly really fast. I'm really not on home ground here at all. FWIW, here is a relatively painless way to install an older JRE along side the default Ubuntu one. ( I'm using Ubuntu 10.10 64bit ) It definitely sped up my Base table browsing, but then I don't have any binaries embedded in my tables. It has the bonus of not messing with the existing JRE Overview: 1. Download the JRE archive (approx. 20 mb) 2. Extract in /tmp 3. as root, copy the extracted directory to /usr/lib/jvm 4. set this JRE as the JRE of choice in LO (ToolsOptionsJava) 5. Exit LO restart Instructions: 1.Download jdk-6u21-linux-i586.bin (for i386) or jdk-6u21-linux-x64.bin for x86_64 from http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jdk-6u21-b07-oth-JPR JRE archive at ORACLE . Save to /tmp 2.run it using: sh jdk-6u21-linux-i586.bin . The JRE is now extracted to /tmp/jre1.6.0_21/ 3. copy to /usr/lib/jvm sudo cp -a jre1.6.0_21/ /usr/lib/jvm 4. Exit restart office. In ToolsOptionsJava, choose 1.6.0_21. Exit restart office 5. Load you Base file compare the speed. If you want to remove it simply set the JRE back to the old one in ToolsOptionsJava sudo rm -rf /usr/lib/jvm/jre1.6.0_21/ -- View this message in context: http://nabble.documentfoundation.org/Base-record-access-unacceptably-slow-tp3202820p3211034.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- 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] Libreoffice message footer
At the risk of starting another round of arguments regarding subscribing unsubscribing I would like to point out that the information for unsubscribing in the footer of messages on this list is incorrect. I just changed my email address so I had to unsubscribe the old one and subscribe the new one. It all went without a hitch because I checked first at the get-help page on the Libreoffice.org website and found out that the correct unsubscribe address is users+unsubscr...@global.libreoffice.org, NOT users+h...@global.libreoffice.org. Is there a way to get whomever is in charge of the mail list program put the correct information in the footer? It would save a lot of hassle for people. -- 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: LO3.3.1-Older OO Feature still in LO - How to disable pop-up Menus?
emarkay wrote: Ya' know the Table one that appears sometimes when you click something in a table. This also happens with other operations; ...snipped if I wanted this menu, I'd already have it there...snipped Bump on this. Exactly what I was looking for an answer to. Doesn't anyone know how to keep those pop-outs from popping? -- View this message in context: http://nabble.documentfoundation.org/LO3-3-1-Older-OO-Feature-still-in-LO-How-to-disable-pop-up-Menus-tp2653048p320.html Sent from the Users mailing list archive at Nabble.com. -- 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: Base record access unacceptably slow
I'll chime in - thanks indeed. I just removed my current sun-java, and installed sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb and sun-java6-jre_6.22-0ubuntu1~10.04_all.deb Everything seems to run fine. However, the increase in Base/HYPERSQL speed is only about 25%. Disappointing. This still isn't a good solution. I'll restore fully updated sun-java, then follow your instructions, as a temporary fix. Meanwhile, I working on a solution is not dependent upon a graphical db at all, using a more primitive approach which I recently used for an in-memory entity-relationship db/DSL I wrote about a year ago: I write db output not to an interactive programmed GUI, but to a set of files which lie open in the jEdit programmers editor. As soon as an output file is updated (rewritten), jEdit reloads it, so it's available for me to peruse. I can have far more files open for ready viewing than I can screens. If I need to write into something, I use the DSL to say what, and I get an open file labeled fields, into which I write, or edit, if I'm making a correction. Returning to the command line, I indicate the file is read to be read (since I just saved and closed it) and the program receives the input. I'll grant you that this is primitive, but it works right well, is far more flexible, allows me to use my Ruby skills (such as they are), and frees me from dependance upon someone else's GUI. Why don't I write my own? I don't have that skill, nor the time to acquire it. I like simple, not shiny, and I just need information, not colors on the screen, which this surely gives me. And, it can be used with any db engine. So...that's where I'm going with my db needs. I just cannot afford to get further invested in the sink-hole that Base is looking like, much as I really do like the interface, etc. It's too slow, I might be able to figure out how to have two subforms, but why not TWELVE? With my approach, no problem. Something from my library of quotes: The most important rule in our development is always to do the simplest thing that could possibly work. ...Simplicity is the most important contributor to the ability to make rapid progress. http:// www.xprogramming.com/Practices/PracSimplest.html t. ~~ Tom Cloyd / t...@tomcloyd.com / (435) 272-3332 On 07/29/2011 06:55 PM, ponsiarceds wrote: . tomcloyd wrote: , On 07/28/2011 12:53 AM, Tom Cloyd wrote: Ug. This is getting ugly really fast. I'm really not on home ground here at all. FWIW, here is a relatively painless way to install an older JRE along side the default Ubuntu one. ( I'm using Ubuntu 10.10 64bit ) It definitely sped up my Base table browsing, but then I don't have any binaries embedded in my tables. It has the bonus of not messing with the existing JRE Overview: 1. Download the JRE archive (approx. 20 mb) 2. Extract in /tmp 3. as root, copy the extracted directory to /usr/lib/jvm 4. set this JRE as the JRE of choice in LO (ToolsOptionsJava) 5. Exit LO restart Instructions: 1.Download jdk-6u21-linux-i586.bin (for i386) or jdk-6u21-linux-x64.bin for x86_64 from http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jdk-6u21-b07-oth-JPR JRE archive at ORACLE . Save to /tmp 2.run it using: sh jdk-6u21-linux-i586.bin . The JRE is now extracted to /tmp/jre1.6.0_21/ 3. copy to /usr/lib/jvm sudo cp -a jre1.6.0_21/ /usr/lib/jvm 4. Exit restart office. In ToolsOptionsJava, choose 1.6.0_21. Exit restart office 5. Load you Base file compare the speed. If you want to remove it simply set the JRE back to the old one in ToolsOptionsJava sudo rm -rf /usr/lib/jvm/jre1.6.0_21/ -- View this message in context: http://nabble.documentfoundation.org/Base-record-access-unacceptably-slow-tp3202820p3211034.html Sent from the Users mailing list archive at Nabble.com. -- 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] Turning Off Numbering/Outlining/Bullets
Okay, I think it's cool that LO, like so many editors now, will jump into an outline or bullet mode automatically, but what if you don't want that? I'm taking a written test and I want to number the items like this: 1) Question one text: (And here is the answer) 2) Question two text: (And here is answer 2) But with the automated bullets and lists, there is no way I can do that and hit RETURN at the end of a paragraph without it going into outline mode. I looked this up in Help and basically it looks like I turn it off AFTER I type what I need to. Is there any way to turn off this mode in a document? This is totally absurd if you don't want it! Hal -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] how to add watermark in a presentation?
is there any way to add a watermark to the slides of a presentation from menu directly?i could not find anything. i mean the ability to select something from the menu to add a watermark with custom text and be in something like 80% transparent black by default or similar. is it possible? -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- 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] Libreoffice message footer
thank you 4 sharing On 30 July 2011 07:37, Cliff Scott ae...@qsl.net wrote: At the risk of starting another round of arguments regarding subscribing unsubscribing I would like to point out that the information for unsubscribing in the footer of messages on this list is incorrect. I just changed my email address so I had to unsubscribe the old one and subscribe the new one. It all went without a hitch because I checked first at the get-help page on the Libreoffice.org website and found out that the correct unsubscribe address is users+unsubscr...@global.libreoffice.org, NOT users+h...@global.libreoffice.org. Is there a way to get whomever is in charge of the mail list program put the correct information in the footer? It would save a lot of hassle for people. -- 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 -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- 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: help recovering? SOLVED
congrats for getting it back in one piece On 30 July 2011 07:55, JeepNut jeep...@zoho.com wrote: Because I really like closure, thought I would post the resolution to the problem of the file I lost. Admittedly a fairly unsophisticated user of the office suite, I overlooked a very easy answer to the problem of recovering the file that crashed and ended up being completely empty Find the backup copy. I didn't even realize one existed! But after continuing to review posts in this excellent forum and getting a few ideas here and there about how to stabilize my also-frequently-crashing office suite, I became aware of the option in the Tools / Options menu that allows for a backup copy to be saved. Once I found the Paths option and located the hidden subfolders where backups and various other LibreOffice system files are saved, I discovered (to my great joy!) the most recent backed up copy of that trashed file! I thank all the folks that attempted to recover the document and offered suggestions. But in this case, the simplest answer of all seems to have been just overlooked by everyone. It's a complex set of tools and software, so it's not surprising that there is a lot to learn if one wants to become a proficient user. The experience and subsequent follow-up has taught me a lot. I just really appreciate the hard work and dedication of the entire team of folks who have made this open source solution even POSSIBLE and I thank you all for your continued efforts at improving it. Overall satisfactory and very beneficial results have been achieved. -- View this message in context: http://nabble.documentfoundation.org/help-recovering-tp3191906p3211104.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date
awesome,thanks On 30 July 2011 00:06, Regina Henschel rb.hensc...@t-online.de wrote: Hi Koen, Koen van Steekelenburg schrieb: Dear readers, I have a document(csv converted to spreadsheet) with bankstatements. Those statements have a date in the form of MMDD (no /'s or -'s). The problem is that I can't make libreoffice recognise those numbers as dates. Can somebody explain how I can make Libreoffice recognise the MMDD numbers as dates. In the csv import dialog is a preview of the data. Click on the column header of the date column. This enables the 'Column type' drop down list. There choose 'Date(YMD)'. Now the dates should be recognized as date already when importing the document. Kind regards Regina -- Unsubscribe instructions: E-mail to users+help@global.libreoffice.**orgusers%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- 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
