[libreoffice-users] Re: Excel import
Hi Ludo Ludo Beckers wrote I made a spreadsheet with a data-table in Excel2010 and opened it at home with LibreOffice3.5.7.2 --snip-- Is this expected behaviour, or should I have imported it in some special way in LibreOffice? Why are you using a version released in October 2012? You will probably get much better results using version 4.2.4 recently released... There is no need to import. You simply should open the file as with any ODS spreadsheet. As you are probably aware LibreOffice's goal is to promote open document formats (namely ODF). Importing/exporting documents from/to Microsoft's closed formats is a work in progress (deliberately made difficult by Microsoft so they can sell a new version every other year) HTH, Pedro -- View this message in context: http://nabble.documentfoundation.org/Excel-import-tp4108074p4108212.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Draw problems
Hi Girvin, Le 09/05/2014 23:45, Girvin Herr a écrit : Then I tried using Draw in stand-alone mode (not as an embedded object) to export the figure as a jpeg or png file and inserting that file into the document. I changed the Draw page margins to the 2 by 7.5 figure in order to exclude all but the figure. However, these export functions only allow full page saves, not the small 2 high by 7.5 wide figure I need. When inserting the file into the document, I get a lot of white space and my figure is tiny. On this very problem, you'll notice that the export dialog has a Selection checkbox in the lower left part. To export a selected part of a drawing to some third-party format, which is what you're looking for, do: 1. Select the drawing (part) you're willing to export. If you want the whole drawing, then just Edit Select all (Ctrl + A) 2. Open the Export dialog and tick the Selection checkbox. And you're done! Your new image is now without any white space clutter. Note: the Selection checkbox doesn't retain its state. You'll have to check it again when exporting another drawing. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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: Excel import
I just updated to 4.2.3.3 via ppa (using LinuxMint-KDE) and it solved the issue of missing data! I read in fora that ppa for LibreOffice is quite safe, so yes, it helped - thanks :-) Ludo http://www.potingue.be On Sat, May 10, 2014 at 8:14 AM, Pedro pedl...@gmail.com wrote: Hi Ludo Ludo Beckers wrote I made a spreadsheet with a data-table in Excel2010 and opened it at home with LibreOffice3.5.7.2 --snip-- Is this expected behaviour, or should I have imported it in some special way in LibreOffice? Why are you using a version released in October 2012? You will probably get much better results using version 4.2.4 recently released... There is no need to import. You simply should open the file as with any ODS spreadsheet. As you are probably aware LibreOffice's goal is to promote open document formats (namely ODF). Importing/exporting documents from/to Microsoft's closed formats is a work in progress (deliberately made difficult by Microsoft so they can sell a new version every other year) HTH, Pedro -- View this message in context: http://nabble.documentfoundation.org/Excel-import-tp4108074p4108212.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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: Installing windows explorer extension only
Urmas, I think your posts would be easier to follow if you more clearly distinguished between your words and those of another writer to whom you are responding. My FOSS Thunderbird does that nicely. Virgil On 05/09/2014 11:04 PM, Urmas wrote: Chris Net46: I would like to install the optional component windows explorer extension on a Windows 2008 file server because I need to index open document format files saved on this server. I believe you can perform administrative installation, then copy the oofilt[_x64].dll to your own location and register it with regsvr32. -- 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: crash - crash - crash - crash. !@#$#@!
On Fri, 09 May 2014 11:05:01 -0600 Tom Cloyd tomcloydm...@gmail.com wrote: Greetings. I disagree, Tom, in the strongest possible terms. I've been extremely busy this week, doing what I do - taking care of victims of interpersonal abuse of all sorts. This Urmas matter is far from resolved, as far as I'm concerned. [snip] Tom, It's been addressed. It's been discussed to death. Time to shake the sand out of your panties and move on. You're becoming tedious. Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.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
[libreoffice-users] Native Connector
Hello, It's good to see a native connector for MySQL under 4.2. One question: In the server my.cnf the value for wait_timeout is set to 60 seconds and will not be increased. This is a nuisance if one needs to be connected over longer periods but sometimes has to go away from there client for more than a minute. Under the JDBC-connector there is a possibility to specify ?auto-reconnect=true after the database name. Is there some facility like that under the native connector? Regards H. Stoellinger -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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] Draw problems
Regina, Thank you very much for your suggestions. They are very helpful, especially the suggestion to use the Selection box in the Draw export dialog. I have no idea why I have not noticed that option before. I tried it and it works. I will definitely put your suggestions in my Computer Notes document for future reference. Toward the end of your response, you describe a process to copy-paste a Draw figure into a Writer document. I have never tried that, but how does that differ from an OLE object? One thing I would expect is that changes to the figure would not be reflected in the target document, they would have to be copy-pasted again. To answer some of your other questions, 1. I do not use the latest LO version. I usually wait until x.x.5(+) is released and then stick with that stable version until the next release reaches x.y.5(+). That said, I do have version 4.1.5 in the wings, but I have yet to re-package it for Slackware Linux and I have not had a really good reason to upgrade from 3.6.7.2 yet. Eventually, I will try it. 2. Yes, my document is in Writer. 3. I have more than one reason to use the OLE object rather than inserting a file. First, is that the OLE process maintains my document in one file. When copying it, I don't have to remember to copy the figure files as well. Second, the figure version tracks the document version. By that, I mean that when I create a new document version, I still keep the old version(s) for historical reasons. If I use the external file insertion process, then when I change a figure for a new version, the back versions will also change. That is not what I need. Third, I do believe that when a figure file is inserted, the path to that file is maintained in the document. That is problematic if I change the directory structure, such as renaming a directory or copying the directory to another higher directory. Then that link will break. Using OLE prevents those negative effects. Fourth, is that the OLE object is easier to change while not going outside the Writer document to do other processes. Popping back and forth, is easy. However, there are problems with Draw OLE that have been around for a long time, at least as old as LO, if not OO. One is this rendering error. Another is that the OLE version of Draw has a subset of commands from the stand-alone version of Draw. One that comes to mind is Zoom. The stand-alone version of Draw supports Zoom, the OLE version does not for some reason. I do miss zoom while editing an OLE figure when I need to position a point at an exact location and it keeps jumping around when I move the mouse. Using Grid Snap should help this, but sometimes a point needs to be off-grid and then the lack of being able to zoom in to exactly position the point then zoom back out, is very frustrating. 4. No, I have not checked if this problem has a bug report. However, as I said, this problem has been around for years and I am surprised there wouldn't be a report by someone else in all that time. If there is one and it hasn't been fixed in all these years, then the devs must not think this bug is important. 5. In 1:1 scale, my objects vary in size, but they are around 2 high x 7 wide. 6. My Draw document is letter size by the look of it. However, in OLE mode, the size is whatever is defined by the Writer frame that contains the object. I usually drag the frames (object and Figure/caption) to the size I need to contain the figure. 7. The only reason I use jpeg or png files is that they seem to be widely supported and they render well with good resolution. If I have a choice, usually use jpeg for photos and png for graphics. I am not sure of the other formats and I have not done much experimenting. I do know that I stay away from EPS (Encapsulated PostScript) files like the plague. I once used EPS files for some figures and it brought LO to its knees. It took minutes to scroll to the end of the document. I would guess that the LO rendering engine for EPS is not very efficient. Once I discovered that the same figure in JPEG did not slow LO down (and the file was smaller), I began using jpeg and blacklisted EPS. Now, all this said, after I sent my original message, I had the need to print the figures and they printed just fine! So, it looks like the problem is with the LO video renderer, since the errors only show up in the document and in Print Preview, while the actual print looks fine. That makes this problem an annoying bug for me, but not a show-stopper as I implied in my message. Thanks again and take care. Girvin Herr On 05/09/2014 04:33 PM, Regina Henschel wrote: Hi Girvin, Girvin Herr schrieb: Greetings, I am using Linux LO 3.6.7.2. I see that Draw still has problems rendering drawings correctly as an embedded object. Any chance to
Re: [libreoffice-users] Draw problems
On 05/09/2014 11:25 PM, Jean-Francois Nifenecker wrote: Hi Girvin, Le 09/05/2014 23:45, Girvin Herr a écrit : Then I tried using Draw in stand-alone mode (not as an embedded object) to export the figure as a jpeg or png file and inserting that file into the document. I changed the Draw page margins to the 2 by 7.5 figure in order to exclude all but the figure. However, these export functions only allow full page saves, not the small 2 high by 7.5 wide figure I need. When inserting the file into the document, I get a lot of white space and my figure is tiny. On this very problem, you'll notice that the export dialog has a Selection checkbox in the lower left part. To export a selected part of a drawing to some third-party format, which is what you're looking for, do: 1. Select the drawing (part) you're willing to export. If you want the whole drawing, then just Edit Select all (Ctrl + A) 2. Open the Export dialog and tick the Selection checkbox. And you're done! Your new image is now without any white space clutter. Note: the Selection checkbox doesn't retain its state. You'll have to check it again when exporting another drawing. HTH, Yes, it did. Thanks. Girvin -- 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] Native Connector
If you're referring to the computer-machine shutting down and/or entering sleep-mode, then there's a simple solution; if you're referring to something else - well, I haven't a clue. If the 1st - go to properties/options/ and re-set the timing mechanism to never shut down; you can also do similarly in various programs - as LO - which otherwise decide they want to save every so often, causing me to lose my train of thought while writing ;-) If the 2nd - I'll be awaiting someone else's response on this list; and will attempt to figure out what's what ;-) From: Heinrich Stoellinger hc.stoellin...@aon.at Date: Sat, May 10, 2014 at 8:08 AM Subject: [libreoffice-users] Native Connector To: users@global.libreoffice.org users@global.libreoffice.org Hello, It's good to see a native connector for MySQL under 4.2. One question: In the server my.cnf the value for wait_timeout is set to 60 seconds and will not be increased. This is a nuisance if one needs to be connected over longer periods but sometimes has to go away from there client for more than a minute. Under the JDBC-connector there is a possibility to specify ?auto-reconnect=true after the database name. Is there some facility like that under the native connector? Regards H. Stoellinger -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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: crash - crash - crash - crash. !@#$#@!
Jim, Discussing isn't resolving. You, and a number of others, clearly do not grasp the issue at all. Or maybe you're just indifferent to abuse. Well, I'm not. When I'm finished with this, I'll be quiet, and not before. As I said, I've been occupied with higher priorities all week. That should not cause the matter to become irrelevant. And I find the gender-related slam very revealing. Real men don't attempt to shut up other men either by using abusive language or by suggesting they're somehow acting like the other gender. Looks like another bullying-attempt to me - because it is. I'm quite sure the few women involved in this list recognized the slam, and didn't like it one bit. I've heard from exactly three women about this, one, backchannel. All three spoke in strongly and clearly in their rejection of the bullying behavior which started this thread. That rather tells us who's leading here and who's just irrelevant. If you're disinterested, go elsewhere. Tom On 05/10/2014 07:00 AM, Jim Seymour wrote: On Fri, 09 May 2014 11:05:01 -0600 Tom Cloyd tomcloydm...@gmail.com wrote: Greetings. I disagree, Tom, in the strongest possible terms. I've been extremely busy this week, doing what I do - taking care of victims of interpersonal abuse of all sorts. This Urmas matter is far from resolved, as far as I'm concerned. [snip] Tom, It's been addressed. It's been discussed to death. Time to shake the sand out of your panties and move on. You're becoming tedious. Regards, Jim -- ~~~ Tom Cloyd, MS MA (LMHC, WA State) Cedar City / St. George, UT, U.S.A: (435) 272-3332 * t...@tomcloyd.com (email) TomCloyd.com (website) * Sleight of Mind blog: Sleightmind.com (mental health issues) * Founder: Google+ Trauma and Dissociation Education and Advocacy community ~~~ -- 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] Native Connector
Hello, I am NOT referring to the server-side machine shutting down but - as I mentioned already earlier - to the MySQL-Server-parameter wait_timeout which is specified in my.cnf. It simply defines the interval of no request from a particular client to the server it is connected to. The server shuts down the connection if that period has expired without further hearing from the client. My problem is that I am NOT the system administrator of the server and the sysadmin of the server won't increase that wait_timeout value. JDBC has a way around this by auto-reconnecting the client if this is specified when establishing the connection. This is NOT an ideal situation (re-establishing the connection takes time...) but it is certainly better than having to shutdown/restart LO... Regards H. S. On Sat, 10 May 2014 23:13:38 +0200, anne-ology lagin...@gmail.com wrote: If you're referring to the computer-machine shutting down and/or entering sleep-mode, then there's a simple solution; if you're referring to something else - well, I haven't a clue. If the 1st - go to properties/options/ and re-set the timing mechanism to never shut down you can also do similarly in various programs - as LO - which otherwise decide they want to save every so often, causing me to lose my train of thought while writing ;-) If the 2nd - I'll be awaiting someone else's response on this list; and will attempt to figure out what's what ;-) From: Heinrich Stoellinger hc.stoellin...@aon.at Date: Sat, May 10, 2014 at 8:08 AM Subject: [libreoffice-users] Native Connector To: users@global.libreoffice.org users@global.libreoffice.org on Hello, It's good to see a native connector for MySQL under 4.2. One question: In the server my.cnf the value for wait_timeout is set to 60 seconds and will not be increased. This is a nuisance if one needs to be connected over longer periods but sometimes has to go away from there client for more than a minute. Under the JDBC-connector there is a possibility to specify ?auto-reconnect=true after the database name. Is there some facility like that under the native connector? Regards H. Stoellinger -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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] Native Connector
Sounds like the reason these programs are pre-programmed to save every so often ... yikes ... ... ... ;-0 Well, I think I'll return to referring to these machines as 'glorified typewriters' ;-) the KISs method doesn't allow for comprehending all the inner workings of these thing-a-ma-jigs ;-) Reminds me of ... ... ... ;-) ;-) ;-) `Twas brillig, and the slithy toves Did gyre and gimble in the wabe: All mimsy were the borogoves, And the mome raths outgrabe. ... ... ... by Rev. Charles Lutwidge Dodgson a.k.a. Lewis Carroll From: Heinrich Stoellinger hc.stoellin...@aon.at Date: Sat, May 10, 2014 at 5:46 PM Subject: Re: [libreoffice-users] Native Connector To: users@global.libreoffice.org Hello, I am NOT referring to the server-side machine shutting down but - as I mentioned already earlier - to the MySQL-Server-parameter wait_timeout which is specified in my.cnf. It simply defines the interval of no request from a particular client to the server it is connected to. The server shuts down the connection if that period has expired without further hearing from the client. My problem is that I am NOT the system administrator of the server and the sysadmin of the server won't increase that wait_timeout value. JDBC has a way around this by auto-reconnecting the client if this is specified when establishing the connection. This is NOT an ideal situation (re-establishing the connection takes time...) but it is certainly better than having to shutdown/restart LO... Regards H. S. On Sat, 10 May 2014 23:13:38 +0200, anne-ology lagin...@gmail.com wrote: If you're referring to the computer-machine shutting down and/or entering sleep-mode, then there's a simple solution; if you're referring to something else - well, I haven't a clue. If the 1st - go to properties/options/ and re-set the timing mechanism to never shut down you can also do similarly in various programs - as LO - which otherwise decide they want to save every so often, causing me to lose my train of thought while writing ;-) If the 2nd - I'll be awaiting someone else's response on this list; and will attempt to figure out what's what ;-) From: Heinrich Stoellinger hc.stoellin...@aon.at Date: Sat, May 10, 2014 at 8:08 AM Subject: [libreoffice-users] Native Connector To: users@global.libreoffice.org users@global.libreoffice.org on Hello, It's good to see a native connector for MySQL under 4.2. One question: In the server my.cnf the value for wait_timeout is set to 60 seconds and will not be increased. This is a nuisance if one needs to be connected over longer periods but sometimes has to go away from there client for more than a minute. Under the JDBC-connector there is a possibility to specify ?auto-reconnect=true after the database name. Is there some facility like that under the native connector? Regards H. Stoellinger -- 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
