Re: [libreoffice-users] Any thoughts on Tutor.com's policy of MS Word only?
2014-04-18 15:03 GMT+02:00 Virgil Arrington cuyfa...@hotmail.com: On 04/18/2014 05:35 AM, Tom Davies wrote: Hi :) The courses seem to be entirely about MS products and their own languages and stuff like silverlight. They even seem to expect you to use Internet Explorer. There are Open Source and other alternatives to almost everything they want to teach you. Do you really need to engage with those people and go back into the MS lock-in? Regards from Tom :) This is the ongoing struggle that we have in teaching computer technology. I teach a technology class for paralegal students. My students want and need to learn the technology that they will actually use in their careers. In my professional and geographic areas, that unfortunately remains MSO, so, that's what I teach them in my class. It would do my students no good to teach them how to use LO when no legal office I'm aware of uses it for their work. I focus a lot of my office suite teaching to the teaching of styles. I teach from MSO, but since all decent word processors use styles, I allow my students to use any program they want for their work, as long as it supports styles. I do teach my students that there are alternatives. Although my textbook doesn't mention open source software, I have a small section on it. I also have them do a project comparing and contrasting the relative virtues of Windows, Mac OS, and Ubuntu Linux. I figure I'll at least expose them to the free as in freedom world even if they never use it at work. All that said, I do allow my students to use any OS or office suite they like. I have had Mac users, and LO and AOO users. Virgil Bravo, Virgil ! Your experience mirrors the fact that Microsoft has been extremely successful in establishing a quasi-monopoly with regard to office packages. By making your students aware of the fact that there do exist alternatives to MSO and comparing their advantages and disadvantages, you are helping to breach the walls. We can only hope that more and more instructors and teachers will follow your example and that will help to lead to better competition which benefits all users ! Henri -- 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] Heartbleed checker for websites
2014-04-18 17:15 GMT+02:00 Paul D. Mirowsky p_mirow...@bentaxna.com: http://www.theregister.co.uk/2014/04/18/netcraft_ heartbleed_browser_extension/ If the Netcraft extension determines that a site was vulnerable before news of Heartbleed broke, it checks the date on the site's SSL certificate to make sure it has been recently replaced. If it hasn't, the extension displays an alert... Netcraft's updated browser extension is available as a free download for Firefox 1.0 and later; Chrome 26 and later on Windows, OS X, and Linux; and for Opera 15 and later on OS X and Windows. Versions for other browsers aren't available, unfortunately, which means users of Internet Explorer and Safari are left in the dark. From what I can see, Paul, the Netcraft Toolbar gives libreoffice.org a clean bill of health when checked with both FF and Chrome on my main machine running 64-bit Linux Mint 16. The conclusion I draw is that that website is safe to use, at least as regards Heartbleed Henri On 4/17/2014 2:12 PM, alnuwer wrote: Any idea when the Heartbleed bug will be fixed in LibreOffice? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Can't download from TDF
2014-04-19 4:19 GMT+02:00 MR ZenWiz mrzen...@gmail.com: Fixed, sort of - I went to the archive and could get it from there. But, really, shouldn't the download page just work? If works for me (at least for the windows version). Maybe you hit a temporary downtime? -- 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] LO for Chrome OS - i.e. Samsung Chrome Book
Tom Davies wrote: Hi :) From the Portable Apps http://portableapps.com/ http://portableapps.com/about/what_is_a_portable_app As far as I'm aware, the Portable Apps builds only run on Windows. From the above link (http://portableapps.com/about/what_is_a_portable_app): A portable app is a computer program that you can carry around with you on a portable device and use on any Windows computer. http://portableapps.com/download mentions: Also Works With: Linux, Unix, BSD, etc via Wine Mac OS X via CrossOver, Wineskin, WineBottler, PlayOnMac i.e. a Windows emulator or compatibility layer is needed for other platforms. A portable app works from any device (..., cloud drive, ..., etc) but i've never heard from anyone who has tried installing their portable apps to a Cloud. Each Chromebook links to it's own Cloud space doesn't it? I think that's referring to the fact they don't have to be installed on the local PC's hard disk. You can install them on a flash drive, cloud storage, etc. and then run them from there on any Windows PC. Note there are a few caveats http://portableapps.com/support/libreoffice_portable#additional_options Also i suspect that the WinPenPack probably offers a similar option but they don't go on about it as much. The advantage with WinPenPack is that they tend to get each release of LibreOffice out there quickly and they don't skip any releases. I'm not so familiar with that one, but the name suggests it may also be Windows-only. The installation instructions are certainly focussed on Windows, and http://www.winpenpack.com/en/e107_plugins/faq/faq.php?0.cat.5.24 again suggests the need for Wine to run under Linux. Wrt Chromium, my understand was that Chrome was the OS and Chromium was the web-browser but apparently it's not quite as simple as that; http://en.wikipedia.org/wiki/Chromium_%28web_browser%29 It is rather confusing that they use the same name for the OS and web browser! I guess they want people to forget about the distinction between locally installed and web applications, and between files stored on their own computer and files stored on the cloud. Chromium web browser and Chromium OS are the parts they released as open source, and use as the basis for the Google Chrome web browser and Chrome OS. Regards from Tom :) Mark. -- 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: Heartbleed
Tom Davies wrote: Anyone continuing to use Internet Explorer deserves whatever they get now more than ever. In what way does Heartbleed affect IE users any more than others? Heartbleed is a bug in server-side software, and affects anyone using affected sites regardless of their browser. In fact, from what I've seen, it appears that newer versions of Internet Explorer are amongst the best at handling certificate revocation (which is needed to prevent a compromised certificate from being used to impersonate the server - just installing a new certificate on the server prevent the old one being used up to its expiry date if it's already compromised). e.g.: http://news.netcraft.com/archives/2013/05/13/how-certificate-revocation-doesnt-work-in-practice.html That article is a year old now, so other browsers may have improved since (and if not, it would seem there's now a good reason to do so!) Mark. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Can't download from TDF
Hi :) Yes, it should. Sadly what 'should' be is often different from what is although i've rarely had problems with LibreOffice. Midori on Ubuntu 12.04 had no problem with the download. Hmm, actually the page seemed to think i was on a Mac so it gave me a .dmg to download but that worked. Then i clicked on the change system and the .deb downloaded. Midori has this weird thing where it gives a pop-up asking if i want to open or save or a couple of other options. maybe your web-browser is doing something like that and then just hiding the pop-up? Doesn't sound likely to me as i've only had that sort of thing in Windows but it might be possible. Regards from Tom :) On 19 April 2014 03:19, MR ZenWiz mrzen...@gmail.com wrote: Fixed, sort of - I went to the archive and could get it from there. But, really, shouldn't the download page just work? On Fri, Apr 18, 2014 at 7:17 PM, MR ZenWiz mrzen...@gmail.com wrote: I've tried to download the latest release of 4.2.3 from the Doc Foundation web site and it refuses to download. I can't even get a connection. This also happened last time I tried to download an update. I'm looking at the x64 .deb files. Is there a way around this? Thanks. MR -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Getting back to the Start screen
Thanks Tom. Actually it got an 'interested' comment from a dev within a couple of hours. My comments were slightly tongue-in-cheek and I wasn't necessarily suggesting that LO devs would be off-hand. Since moving to Linux however I've found that bug handling sites can be belittling places for a beginner, some forums likewise (yes, you, Mint on both counts). I haven't honestly found LO forums anything other than helpful; wish I had something to contribute back. Regards David -- View this message in context: http://nabble.documentfoundation.org/Getting-back-to-the-Start-screen-tp4104830p4105776.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
[libreoffice-users] cannot convert text to number in spreadsheet from csv file
Greetings, I have the problem below with LO 3.5.7.2 on a Fedora box. I have a shell script that generates and save to a text file called synthesis.csv many lines like this: |||2013-02-15|Payment A|-100.25|008|fae| |||2013-03-15|Payment B|-50.25|008|fae| Calc loads that file without problems, when tell it to use | as field separator. Lets assume the payments imports (-100.25 and -50.25) end up in cells F1 and F2 if I write in a third cell the formula =sum(F1:F2) I get zero, because F1 and F2 are seen as text. OK, so I select those cells and do Format-Cells-Numbers-Number = -1234.12 But I still get zero, because the operation above adds to the content of \both F1 and F2 a single quote prefix: F1 = '-100.25 F2 = '-50.25 which, right now, I have to remove manually to make the formula work. What is happening, and how can I fix it? Even better: how to make LO automatically format and use strings in the format -1234.12 as numbers when it opens the file? Thanks, Marco -- M. Fioretti http://mfioretti.com http://stop.zona-m.net Your own civil rights and the quality of your life heavily depend on how software is used *around* you -- 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] cannot convert text to number in spreadsheet from csv file
At 20:05 19/04/2014 +0200, Marco Fioretti wrote: I have the problem below with LO 3.5.7.2 on a Fedora box. I have a shell script that generates and save to a text file called synthesis.csv many lines like this: |||2013-02-15|Payment A|-100.25|008|fae| |||2013-03-15|Payment B|-50.25|008|fae| Calc loads that file without problems, when tell it to use | as field separator. Lets assume the payments imports (-100.25 and -50.25) end up in cells F1 and F2. if I write in a third cell the formula =sum(F1:F2) I get zero, because F1 and F2 are seen as text. Your problem is there, of course. I cannot reproduce this if I load that file: in that case, the values are correctly interpreted as numbers. Are you perhaps instead pasting the material into an existing sheet? In that case, the existing cell format of the sheet comes into play. If column F is formatted as text, that's how your values will be interpreted. OK, so I select those cells and do Format-Cells-Numbers-Number = -1234.12. But I still get zero, because the operation above adds to the content of \both F1 and F2 a single quote prefix: F1 = '-100.25 F2 = '-50.25 which, right now, I have to remove manually to make the formula work. It's important to realise that changing cell formatting changes only the way data is displayed: it doesn't change the data itself. So your values are still text. In order to make this clear, an apostrophe is helpfully prepended in the Input Line to values that look like numbers. When you remove those manually, you are asking Calc to reinterpret the values. Now that the cells are formatted as numbers, this will - as you need - create numbers from your text values. What is happening, and how can I fix it? If you cannot solve the problem at source, there is a simpler workaround: o In an unused column, insert the formula =VALUE(F1) in row 1 and fill it down the column. o Copy the column and paste it back over the source column, but using Edit | Paste Special... (or right-click | Paste Special... or Ctrl+Shift+V) instead of ordinary Paste. In the Paste Special dialogue, remove the tick from Paste all and ensure that Numbers is ticked but Formulas *not* ticked. Even better: how to make LO automatically format and use strings in the format -1234.12 as numbers when it opens the file? You seem to be writing from a country where the normal fractional separator would be a comma, not a point. Is this a locale issue? I trust this helps. Brian Barker -- 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] cannot convert text to number in spreadsheet from csv file
Dnia 2014-04-19, o godz. 20:05:40 M. Fioretti mfiore...@nexaima.net napisał(a): What is happening, Judging by your name, I suppose you are Italian. I assume that you are using LibreOffice in your native language, and in Italy, as in most of Europe, you are using coma as decimal number separator. And here is answer to your question: your data uses dot as decimal number separator, but your software expects coma. Since data does not match expected format, LibreOffice falls back to treating data as text. and how can I fix it? Select all columns that have misinterpreted, open Search and Replace dialog. Insert dot (.) in Search and coma (,) in Replace. Make sure that Only selected is checked on, but Regular expression is checked off. Click Replace all. Even better: how to make LO automatically format and use strings in the format -1234.12 as numbers when it opens the file? In text file import dialog, you can see preview of data to be imported. You can click on any column to select it. Then, using Column type drop-down above preview, select English (USA). You can use the same procedure to tell LibreOffice what format your dates are, if different from your native one. -- Best regards Mirosław Zalewski -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: cannot convert text to number in spreadsheet from csv file
On 19-4-2014 20:05, M. Fioretti wrote: Greetings, I have the problem below with LO 3.5.7.2 on a Fedora box. I have a shell script that generates and save to a text file called synthesis.csv many lines like this: |||2013-02-15|Payment A|-100.25|008|fae| |||2013-03-15|Payment B|-50.25|008|fae| Calc loads that file without problems, when tell it to use | as field separator. Lets assume the payments imports (-100.25 and -50.25) end up in cells F1 and F2 if I write in a third cell the formula =sum(F1:F2) I get zero, because F1 and F2 are seen as text. OK, so I select those cells and do Format-Cells-Numbers-Number = -1234.12 But I still get zero, because the operation above adds to the content of \both F1 and F2 a single quote prefix: F1 = '-100.25 F2 = '-50.25 which, right now, I have to remove manually to make the formula work. What is happening, and how can I fix it? Even better: how to make LO automatically format and use strings in the format -1234.12 as numbers when it opens the file? Thanks, Marco Did you click on the column and specify 'standard' as format for this column? What decimal separator do you use? When importing decimal '.', make sure the Language option is set to something that works with decimal dots (i.e. English USA) -- 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] Retrofitting a template to a document
On 4/18/2014 3:40 AM, Tom Davies wrote: Perhaps zoom out so that you get multiple pages on-screen and just race through to see if anything stands out as being horribly wrong? That is what I was doing, and nothing looked wrong. Then I looked at the PDF, and discovered a plethora of minor issues, And that is when I discovered that the template data had been stripped from the documents. So far, going through the PDF, the errors have been because the office suite was using the wrong version of the template. Changing that fixes the errors. ### On 4/17/2014 12:46 AM, Tom Davies wrote: I'd rather deal with Microsoft's bug reporting system for non-paying customers. Do they have one? Yes. It is a very small (¿3?, ¿?4? person) team that looks at one or bugs per year. They pick bugs from any software that Microsoft distributes. If your bug is selected, they take your computer equipment for the duration of the bug fixing --- which ranges from six to twenty-four months. The upside is that the bug does get fixed, and ported into all relevant software updates. I don't remember any more details about the unit. jonathon -- 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] cannot convert text to number in spreadsheet from csv file
On Sat, Apr 19, 2014 20:05:40 PM +0200, Marco Fioretti wrote: Greetings, I have the problem below with LO 3.5.7.2 on a Fedora box. I have a shell script that generates and save to a text file called synthesis.csv many lines like this: thanks to all who quickly answered yesterday. Here are more details, based on your initial comments and suggestions. I am indeed Italian and in Italy, but this is happening on a Fedora Linux computer with US English as system language. The shell environment has LANG=en_US.UTF-8 and English (USA) is the default language in Libreoffice. In the text import form of Calc, charset is western europe(ascii/us), language is english(usa) and all columns have standard format header (but changing the charset to utf8 and/or the format of the interested column to text, or US english doesn't make any difference Besides, I do not paste anything into a new spreadsheet, I directly open the result of the script with Calc at the shell prompt, and then (need to) work on that file in calc, savint it as .ods: # cat sources.*txt | ./analyzer.pl analysis_result.csv ; oocalc analysis_result.csv the two sample lines in my original email |||2013-02-15|Payment A|-100.25|008|fae| |||2013-03-15|Payment B|-50.25|008|fae| where actual lines from analysis_result.csv (which has ASCII encoding, according to the file command), which you may save as test.csv file and load in calc to see what happens (of course, the result would depend on YOUR locale, default language etc, but that IS the actual text I am working on). Summarizing, it seems I need some efficient way to tell Calc, when it opens that file, that all the cells of a certain column, except the header, are NUMBERS, not text, in the -1234.12 format. The reason / end goal is that I and the other final users of that csv file must be able to quickly add formulas to that spreadsheet and have them work as expected without manual reformatting/rewriting of those columns. thanks, Marco -- M. Fioretti http://mfioretti.com http://stop.zona-m.net Your own civil rights and the quality of your life heavily depend on how software is used *around* you -- 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