Re: [libreoffice-users] Opening a CSV file with Calc
Hi Jeff, Do you apply the correct separator (,;tab) and coding when opening the csv-file? Regards Heinz On Sat, 29 Sep 2012 03:41:17 +0200, Jeff Hahn hahn...@outlook.com wrote: I download financial information from Yahoo Finance. The download is a CSV file format.Athought I am able to open it with MS Excel I am not able to open it using LO except as a text file. Any suggestions on how I can open the file with Calc? Thanks. Jeff -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Opening a CSV file with Calc
Thanks. Unfortunately the suggestions did not work. I am using Windows 7. The only way I have been able to open the file with LO is as a TXT file. When I try to open with Calc the text Import window comes up. The Character Set is unicode and the language is US English. I have tried every combination for Separator Options and Other Options but nothing seems to work. As I stated in my original post, Excel opens the file without difficulty. What I have been doing is opening the downloaded file with Excel and saving it to and ODS file. Thanks. Jeff Date: Fri, 28 Sep 2012 22:26:50 -0400 From: jsloz...@gmail.com To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Opening a CSV file with Calc On 09/28/2012 09:41 PM, Jeff Hahn wrote: I download financial information from Yahoo Finance. The download is a CSV file format.Athought I am able to open it with MS Excel I am not able to open it using LO except as a text file. Any suggestions on how I can open the file with Calc? Thanks. Jeff Jeff, I assume you are using Windows. If so, right click and select Open with then select Calc if the file extension is csv. The csv import wizard should start automatically. Alternately, open Calc and then INSERT Sheet from File. The second method will allow to import *.txt as well as *.csv files. Either way you should see a dialog box showing the current import settings and a preview of the import. If the columns are incorrect you can change the column delimiter. Common delimiters are comma, semicolon, tab, and pipe (|). If you have any dates, click on the standard above the date column and select an appropriate date format. This will ensure the date is imported as a date. Often dates are shown as 2013-26-05 00:00:00. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?
Thanks Don, I'll have a scout about. Regards Mark -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Impress - Blink animation doesn't work
Hi, Dr. R. O Stapf schrieb: On 2012-09-28 23:56, Regina Henschel wrote: [..] It is said to be fixed with https://bugs.freedesktop.org/show_bug.cgi?id=50833 but I have not tested it yet. Unfortunately it is still there. As the bug assitant does not work (at least not for me) I even can't report it and attach a demo file which I created already. Maybe someone else can try to report the bug and leave a note here. It is really fixed, I have tested it now. You need a developer build to test it. I have used LO 3.7.0.0. http://dev-builds.libreoffice.org/daily/ Fixed on master means, that the fix will be included in the next LO 3.n.0 release. Currently master is for LO 3.7.0, which will be published in Feb.2013. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Opening a CSV file with Calc
Hi Jeff, Jeff Hahn schrieb: Thanks. Unfortunately the suggestions did not work. I am using Windows 7. The only way I have been able to open the file with LO is as a TXT file. When I try to open with Calc the text Import window comes up. Then you are using the wrong filter. Start Calc. File Open and in that open dialog select your file. In the lower part of the dialog use the drop-dow list file type, scroll the list till item Text CSV (*.csv, *txt). That item is forth last of the spreadsheet section. Open. If it still opens in Writer, then the file is not a csv file and someone gave it a wrong file name extension. In that case open the file in an editor and post the start of the file here. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: ZOOM: strange or bug??
Hi :) Ok, so you are using LO 3.5.4(?) definitely 3.5.something on openSUSE. I'm not sure how to record your desktop on openSUSE, it's probably the same way i would do it on Ubuntu but i don't know that either. I'm still not clear what the problem is. 1. Is it that when you move the mouse arrow over the screen it gets stuck over the zoom controls at the bottom right of the screen? or does it move away from there but stay stuck with the same controls? Is the problem that once you start zooming then you can't do anything except zoom? 2. Is it that the zoom goes rapidly from minimum to max or vice-versa without allowing you to just zoom in (or out) just a small amount? Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/ZOOM-strange-or-bug-tp4008583p4010023.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Stacking text frames anchored to page
I have anchored two text frames to the bottom of a page; ... I don't think you can do this. One choice is to anchor a frame to a page (not to a point on that page); you can then position the frame in various ways. ... however, instead of being *stacked above* each other, they're *overlaid* over each other. If you position them identically - at the bottom of the page, for instance - then that's what I would expect. Is there an easier solution to stack frames *anchored to bottom of page* instead of overlaying them? Again, they cannot be anchored to the bottom of a page, only to the page itself. Once you have created your frames, you can easily move them to be adjacent instead of overlapping. Select a frame by clicking near its edge - so that you see its eight green handles. Put the cursor into the frame: it will change to a four-headed arrow. You can now click and drag the frame where you need it. You can also drag the handles individually in order to position the sides or corners separately. Repeat as necessary. I trust this helps. The problem is that I have a lot of frames set up this way, manually moving them on top of each other is tedious, plus this means that everytime I edit the text, I have to re-move them... IMHO, there should really be an easier -- automatic -- solution to stack frames... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] MS problems
Hi :) Just had a classic from my boss. He says he prefers Internet Explorer and Adobe because he's never had any trouble with them. He can't download Pdfs though and has the same problem at home. Firefox on his machine here downloads them fine. When Foxit is set as the default Pdf reader then IE does download. Going to microsoft.com showed 26 important security updates that didn't get installed through his auto-updates. None were about adding functionality. Then java and different things needed to be updated separately. The only updates (well upgrades really) that added functionality were for Firefox and LibreOffice. His Internet Explorer is still grumbling about some C++ problem in iexplorer.exe whenever he tries to download pdfs. He still says there is no problem with IE. Regards from Tom :) snip / Hi Tom, Thank you for a very informative answer - it is bad that all this is not mentioned as a basic info about LibO. I am prepared to trust it as true but honestly I have to rely on my own experiences both regarding Win/MSO and LibO. I have been using Windows and many of MS programs since early 1980: all of the modules in the MSO suite, Access, Publisher, Visio, Project, etc never any problems with installing never need to send any kind of bug reports never any need to contact any community/list for help cannot remember not one machine crash when using Windows-MS-programs no courses, no teachers in using Windows/MS programs -- I had no problems to learn all by my self mostly thanks to a good help function; when I was working as IT-help/help desk I could even tutor my colleagues in Word, Excel, PP, Access how to use the special features and functions made a lot of Access-dbs, learned to complete them with VBA and got macros work Some facts about LibO (first 3.4.5, then 3.4.6 -- I didn't dare to install later versions, so now back to OO) in January this year after downloading LibO I had big problems/crashes with getting Base (similar to MSAccess) working - reason: JRE and bad guidings some basic features/functions in Base does not work -- no help from LibO help nor Base Guide I have some rather big (heavy) applications in Calc (several sheets, 200 rows15-30 cols/sheet, remote referenses between sheets) - I've noticed (when tracking why results are wrong) that Calc in some situations does not have power enough to do the automatic recalc through all the rows/cols/pages: there is nothing wrong, it just does not do the recalc -- which means that I cannot trust the calcs to be 100% correct; this is not only inconvenient but can be fatal in economical calcs (my computers do most certainly have all the power needed) the button LibreOffice Help does not directly lead to any kind of help -- the function is totally of no use until you first learn it's logic (if any) -- to find any help can take hours of digging I should very much like to use LibO only (not only because of costs) but cannot afford wasting time and nerves on all the problems. According to this list there are -- in my opinion -- too many others having problems already from the very beginning, with installing. For me -- I represent the ordinary non-LibO-expert user -- it is obvious why not only companies rely on Windows/MSO. I can not see that this is anything to argue about: LibO must be easy-to-use, stable and free from any basic problems if it wants to be really accepted. Note: I am talking about ordinary people and ordinary companies, who value their time. snip / On 27.9.2012 17:07, Tom Davies wrote: Hi :) On the contrary. MS do not fix their problems quickly at all. Even known malware threats remain for months and even years. Their strategy is to blame the users. A typical one being to tell users they shouldn't be using macros because of the likelihood of getting an infected or corrupted one. Read The Emperor’s New Clothes. People are told that MS Office is the best and so when they find problems with it they tend to blame themselves rather than the software. For example when using non-MS software someone would quite happily slate the product with this sort of thing I opened my document and deleted tons of stuff and saved it using the same name. now when i open the document it has all that stuff missing! The stupid program can't even find the stuff that i deleted. No, of course i don't have a back-up of the file before my deletions One problem that has never been solved is that when creating an MS document the style keeps randomly changing without the user doing anything noticeable. So, the language keeps
[libreoffice-users] Re: ZOOM: strange or bug??
Am 28.09.2012 14:00, manuel_songo...@yahoo.it wrote: hello i dont say GESTURES ON LO ok? i say why when my mouse on area zoom slider and why it's activated drag only when area zoom-slider do you undy? how i can record my screen video? so will send you to see what is problem ok? Save your work and close any running office. Just to be sure: $ killall soffice.bin Rename your user profile which is under ~/.config/libreoffice on my Ubuntu system: $ mv ~/.config/libreoffice ~/.config/libreoffice.backup Start your office, let it create a brand new profile and see if there is any difference. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] MS problems
2012/9/29 Tom Davies tomdavie...@yahoo.co.uk Hi :) Just had a classic from my boss. He says he prefers Internet Explorer and Adobe because he's never had any trouble with them. He can't download Pdfs though and has the same problem at home. Firefox on his machine here downloads them fine. When Foxit is set as the default Pdf reader then IE does download. Going to microsoft.com showed 26 important security updates that didn't get installed through his auto-updates. None were about adding functionality. Then java and different things needed to be updated separately. The only updates (well upgrades really) that added functionality were for Firefox and LibreOffice. His Internet Explorer is still grumbling about some C++ problem in iexplorer.exe whenever he tries to download pdfs. He still says there is no problem with IE. Regards from Tom :) snip That was indeed a classic, Tom - of the «just works» tribe ! It may seem strange that people will believe propositions that are directly countered by their own experience, but that's been the case for thousands of years - and what public relations and advertising, not to mention religious organisations, base their considerable success upon Henri -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] MS problems
On 09/29/2012 10:22 AM, Tom Davies wrote: Hi :) Just had a classic from my boss. He says he prefers Internet Explorer and Adobe because he's never had any trouble with them. He can't download Pdfs though and has the same problem at home. Firefox on his machine here downloads them fine. When Foxit is set as the default Pdf reader then IE does download. Going to microsoft.com showed 26 important security updates that didn't get installed through his auto-updates. None were about adding functionality. Then java and different things needed to be updated separately. The only updates (well upgrades really) that added functionality were for Firefox and LibreOffice. His Internet Explorer is still grumbling about some C++ problem in iexplorer.exe whenever he tries to download pdfs. He still says there is no problem with IE. Regards from Tom :) snip Too many users do not realize error messages mean that software is not working correctly. Often, they ignore them instead of asking someone who has enough knowledge to understand them and if possible fix them. Is the IE C++ problem a missing update? Also, many users do not have good security practices about making sure all software is updated. Linux users are spoiled because the distros have a comprehensive package management system while Windows users do not. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
- actually useful formatting concepts for presentations like e.g. LaTeX Beamer provides. Could you elaborate? I don't know Beamer (I have heard the name, but never really used it) and I am interested in knowing what it has to offer that LO is not capable of. Everything that you get from LaTeX: structure markup instead of spaghetti formatting, parameterized formatting, etc... Instead of clicking through dozens of dialogboxes for each and every line of text, slide title, list item, figure, etc. to get everything the way you want it, you just change a few parameters once for the whole document and that's it. As side note of my question: I don't think that LO should mimic every feature of LaTeX, especially WYSIWYM approach (instead of current WYSIWYG). I strongly believe that target group of LibreOffice is different than target group of LaTeX. LaTeX is already free, vital community exists, there are dedicated editors - users who prefer LaTeX approach can just use LaTeX. I just cited LaTeX as one example for structure markup. Other examples are Wordperfect or Framemaker. My point is that LO should not keep the MS Office-style spaghetti content models that were already outdated in the 80s and pile up features on top, but instead LO should focus on providing a functional concept that allows users to work with documents in a more structured and thus more efficient way. MS Office is by far the worst example in the market. And, as such, the example *not* to follow. Sincerely, Wolfgang -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
As an engineer, now retired, I used BASIC for many years, then took a class in Pascal and wrote some code in Pascal. You are correct-- all I wanted, in almost all cases, was command-line input and screen or print (or both) output. I first wrote BASIC on a teletype machine connected by acoustic modem to a mainframe somewhere in Texas. Obviously at that time, Python wasn't available yet. ;-) X-( Sincerely, Wolfgang -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
On 29/09/2012 at 20:10, Wolfgang Keller felip...@gmx.net wrote: Everything that you get from LaTeX: structure markup instead of spaghetti formatting, parameterized formatting, etc... Instead of clicking through dozens of dialogboxes for each and every line of text, slide title, list item, figure, etc. to get everything the way you want it, you just change a few parameters once for the whole document and that's it. That's where styles, templates, master slides etc. comes in. Haven't you heard of them? They give you ability to define paragraphs by their meaning in document structure and change parameters once for the whole document. As far as I know, you can apply direct formatting in LaTeX as well. But this is possible, not necessary. Even if LO encourages users to use direct formatting (by exposing icons on toolbar), it is still totally optional. Or did I miss the part where you pointed out advantages of LaTeX approach to document structure in comparison to LO? -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Can't get Libra office working with Java access bridge and java7.
Hi :) The question did get to the list originally but the list was unusually quiet at the time after an unusually busy period during the paralympics Hopefully someone here can remember how to fix the java-bridge or hopefully this wiki-page might help https://wiki.documentfoundation.org/Faq/Java I think it's a work-in-progress. Regards from Tom :) --- On Sat, 29/9/12, Kevin Cussick the.big.white.sheph...@googlemail.com wrote: snip / Hope this gets to the list. I use Nvda and I can't get Libra office working with java access bridge that should come with java-7. I have installed libra office switched on the accessibility during the install I have under use the computer without a display checked to have the access bridge switched on, I have open office pointing to c:programfilesjava7 please this might not be the exact path to the jre I need to install, but I can assure you it is pointing at the jre-7 folder anyway I have been told that Libra office has forgotten to put the accessibility into the latest version, I have tried older versions 5.0 I think. anyway this dose not work either. some help would be nice thanks in advance. I asked about a year ago but is there no further progress on Ia2 getting ported into libra office? thanks for any help in advance. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Opening a CSV file with Calc
On Sat, 2012-09-29 at 03:12 -0400, Jeff Hahn wrote: Thanks. Unfortunately the suggestions did not work. I am using Windows 7. The only way I have been able to open the file with LO is as a TXT file. When I try to open with Calc the text Import window comes up. The Character Set is unicode and the language is US English. I have tried every combination for Separator Options and Other Options but nothing seems to work. As I stated in my original post, Excel opens the file without difficulty. What I have been doing is opening the downloaded file with Excel and saving it to and ODS file. Thanks. Jeff Date: Fri, 28 Sep 2012 22:26:50 -0400 From: jsloz...@gmail.com To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Opening a CSV file with Calc On 09/28/2012 09:41 PM, Jeff Hahn wrote: I download financial information from Yahoo Finance. The download is a CSV file format.Athought I am able to open it with MS Excel I am not able to open it using LO except as a text file. Any suggestions on how I can open the file with Calc? Thanks. Jeff Jeff, I assume you are using Windows. If so, right click and select Open with then select Calc if the file extension is csv. The csv import wizard should start automatically. Alternately, open Calc and then INSERT Sheet from File. The second method will allow to import *.txt as well as *.csv files. Either way you should see a dialog box showing the current import settings and a preview of the import. If the columns are incorrect you can change the column delimiter. Common delimiters are comma, semicolon, tab, and pipe (|). If you have any dates, click on the standard above the date column and select an appropriate date format. This will ensure the date is imported as a date. Often dates are shown as 2013-26-05 00:00:00. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted If the file contains floating point numbers make sure you click on detect special numbers. Regards, Les H -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted