Re: [libreoffice-users] Which components do you use most?
On Sun, 2014-05-11 at 17:53 -0400, Virgil Arrington wrote: I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer (85% of my use of LO) Calc(10%) Impress (3%, Maybe four to five presentations a year) Base (once a year to print out labels for my Christmas cards) Draw (What's that?) Virgil Writer 10% Calc 30% (but decreasing as I become more familiar with gnuplot_ Impress 10% (not just for presentations, but as a tool for creating graphics to send to customers) Base 0% Draw 0% Give me a link to a more powerful tool for graphing tool, please. Gnuplot is OK, but I deal with millions and millions of samples, and I find generating plots or graphs with zoom and very slow and time consuming. I think gnuplot uses TK, which is not quick, and maybe python in the back end. Something native would be nice, but with the ability to choose samples, rows and columns like gnuplot. Big data is the field, isn't it. Regards, Les H -- 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: [pt-br-usuarios] Estudantes da rede estadual de SP terão Office gratuito para até 5 PCs após parceria
On Sun, 2013-11-03 at 16:39 -0500, Doug wrote: On 11/03/2013 02:06 PM, Upscope wrote: On Saturday, November 02, 2013 12:46:43 PM Urmas wrote: Les Howell: Just a simple question, Do you know who originally designed Microsoft Office? Microsoft mostly. /snip/ Thats not totally correct if I remember right. Office started out as a joint project between IBM and Microsoft for the original PC. There was a differnet of directions and MS wnd IBM went there own ways. MS took a lot of the joint developemt (Stole) with them. we used to use Wordstar on or PC's. Russ It wasn't originally MS Office, it was just MS Word. It ran on DOS, just like WordStar, but it had some basic word-processing functions listed at the bottom, and it worked with a mouse, if I recall, which WordStar did not. WordStar required a bunch of ctrl-x functions, where x was some keyboard letter. This was, I believe, derived from Teletype terminal days, where some k/b functions we expect, even some found on a typewriter, didn't exist. Functions on a modern k/b, like the up/down/left/right arrows were implemented by ctrl-x. Even backspace, which doesn't exist on a teletype machine--ctrl-h will do it. Even on a few programs today, but not T/Bird--I just tried! I think Word was the first word processor to use a mouse, but I could be wrong. After memorizing all the control functions in WordStar, I stayed with it for quite a while, until WordPerfect came out. I still won't use Word--WP is better, imho. I wish it were still available for Linux. --doug -- Blessed are the peacemakers..for they shall be shot at from both sides. --A.M.Greeley Actually Wordstar used control-J to access various functions. It was designed that way to eliminate the need to take your hands off the home row. If you were proficient with Wordstar and a touch typist, you were about 10-15% percent faster than someone using Word. Many newspaper reporters used it just for that reason. Microsoft hated the competition and so captured the control-J function (which happens to be a line feed.) This meant that the Windows systems would not run Wordstar. Wordstar also had WYSIWYG using these sequences to display the various superscript, and subscript and other characters, including the math characters and of course the nice 1/2 and 1/4 symbols as well. Wordstar came with Mailmerge and was a wonderful package for people doing newsletters or other mass mail programs. I hated that microsoft trapped the control J sequence and made it impossible to use Wordstar. The Wordstar team worked out a new interface, but just as they released it, Microsoft made another low level change to the windows interface that made the Wordstar team have to create yet another work around, missing the market window. And losing the ability to not have to use a mouse for the 80% composting task. Word was similar to another word processing program, but I can no longer remember its name. The spreadsheet was a purchase, which Microsoft reengineered and added some features and removed some to make it compatible with their GUI, and they also changed the storage style, which originally was all text based. I don't remember all the changes now. I used that original spreadsheet, It was called supercalc or something like that. Personally I wish Wordstar was still available, before the MOUSE ruined touch typing. But word processors are subject to the whims of taste. I also did some formal materials for marketing. I used a Macintosh with a simple text editor and a program called Ready, Set, Go which was a separate typesetting program, which included the ability to embed 3 to 6 layer color graphics with a WYSIWYG on a Macintosh, but that was in the 1987 time frame I think. The calendar application was similar to the calendar with events that was part of the Wordstar package as well, but Microsoft embedded theirs into Outlook about 1990 something. Wordstar was a full suite if you got all the options, and could do many things that Word didn't begin to accomplish until about 1995. The reason I brought this up is because wordprocessing has been around a very long time. Unix had some nice packages prior to 1984, and I used some of them while I was still in the Navy. But with the demise of Wordstar, I just gave up and started using the mouse. The mouse makes the job both faster to learn and much slower to use, but that seems to be the way of the world. We all have our preferences. Regards, Les H -- 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] Creating LibreOffice Calc document from XML (or some other file?)
On Sun, 2013-11-03 at 21:16 +0100, Regina Henschel wrote: Hi Mario, Mario Splivalo schrieb: Hi, all. Once in the past I stumbled upon a blog where owner explained how one can create a Calc document from the data that's in the XML file. I'm not sure if XML contained only the data which then populated the Calc template, or the whole Calc data was in that XML (not even sure if the source was XML or was it some other human-readable file), but I haven't been able to locate that blog ever since. I'd appreciate any info or pointers on how above mentioned can be achieved. I need to create several daily reports on some processes I'm overseeing, and entering all that data into the Calc spreadsheet is cumbersome - the report resembles of a tax-return/invoice sheet, where various fields need to be populated - and I'm looking for a way to automate this. In which form do you get the data? Perhaps there is nothing like XML needed, but you can import the data directly. Do you want to write macros for Calc or do you want to use another application that manipulates the .ods file source? Mario P.S. I apologize if I posted this to the wrong mailinglist, please redirect me if necessary. users is OK. Kind regards Regina I have done this for some special logging I do, by simplying creating my own template, saving the data in a csv (comma separated value format) and then loading the data into the template. I do this manually, but a macro could be created to do it as well. Regards, Les H -- 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: [pt-br-usuarios] Estudantes da rede estadual de SP terão Office gratuito para até 5 PCs após parceria
On Fri, 2013-11-01 at 23:01 +0700, Urmas wrote: And that is great, as Microsoft Office is designed not by copycats, but for people who actually know what the Office is for. Just a simple question, Do you know who originally designed Microsoft Office? Regards, Les H -- 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 4.1 upgrade from 4.0.4 - now does not find Java
On Sun, 2013-07-28 at 08:23 -0400, James Knott wrote: James Knott wrote: Actually, I believe both the PowerPC and DEC Alpha were earlier. I think the Intel Itanium also predated the AMD. That may depend on your definition of a processor. I had a math chip for my 386 a long time ago that was 80 bit internal floating point from AMD. -- 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] CNET is claiming the best free MSO alternative is not LO
On Mon, 2013-06-10 at 11:02 -0700, Girvin R. Herr wrote: And I remember when car owner's manuals were 1/4 thick at the most, and large (readable) print. My 2008 Toyota Prius owner's manual is 3/4 thick, small print, and spattered with dire paragraphs about everything causing injury or death! Made me want to turn in my license! It is not a good read and, like your experience, information is not easy to find in it. Oh, and the owner's maintenance manual is a separate manual - equally obtuse and with more dire warnings. Usually, when I get a new car, I go to the dealer's parts counter and order the factory shop manual for correct maintenance and understanding of what is under the hood. When I did so for the Prius, the parts counter guy recommended not, saying the shop manual is intricately tied to the shop diagnostic computer system ($) and by itself, is not very helpful. So, i saved $100+ for the first time in my shadetree-mechanic career and, also for the first time in my decades of car-ownership, take it to the dealer for maintenance. Girvin Herr Also most mechanics are used to pure gasoline or diesel engines. I think many of them inherently distrust the electronics, so it has been a real uphill battle for them to port some of their existing knowledge to these new systems. As to the computer system being the fault detector, well, I guess that is kind of all of us Techies fault. Built in diagnostics for complex systems is a lot of overhead, and of course the reading of the actual data may or may not be helpful without a deep understand of how all that information relates to the system operation. The first answer is of course to have a computer crunch that information, and with the early car computers, the crunching power is not there. Today, I don't think that is true, but history holds us prisoner sometimes. The fundamental operation of a hybrid may be primarily electric, or primarily gas. This view will determine a lot how the parts interrelate and how the system overall operates. Other decisions, such a regenerative braking, dynamic power allocation, Battery leveling and other design choices will also affect the interrelation of the controls. And then there is the aspect of multiple computers. Some cars today have 7 computers that I know about. Which ones do what, which sensors each reads and how they share and manipulate information, if they do at all, also makes a huge difference in diagnosis of any issue. Some of these issues will self resolve over time as designers, engineers and mechanics gain familiarity with what works and what doesn't. Over time the solutions will cycle from complexity to simplicity while performance and efficiency will help form the engineering boundaries and comfort, and customer perception will help form the accessibility, reliability and aesthetic boundaries. In short the rate of change is accelerating ;-) But where the is my flying car I want one that shoots down drones and is stealthy while offering me full internet access. 100mpg wouldn't hurt either. Regards, Les H -- 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] Importing PDF problem
On Tue, 2013-04-16 at 22:22 -0500, anne-ology wrote: ah, yes; and photography is such fun. On Tue, Apr 16, 2013 at 1:53 PM, les hlhow...@pacbell.net wrote: On Tue, 2013-04-16 at 11:08 -0700, Girvin Herr wrote: Tom, +5 Don't get me started on this subject! I use 640x480 (300K) on my photos, which are reasonable file sizes to attach to messages and they look good enough to me at 4x5 photo paper sizes. I have no intention of blowing my photos up to 8x10 or larger. That blowup is where the larger pixel count is good, but who does that regularly? I keep getting photos from relatives of their grandson, etc. that are so detailed I can see the pores on the kid's face, but I can't see the entire picture on the screen at once! It is frustrating to scroll around the photo on my screen to get some idea of what the photo is about. Sometimes I just don't bother. Life is too short. One thing that is enabling this megapixel bloat is the increasing size of the memory cards. For example, my camera, at 640x480 (300K), is showing photos available with a few shots already on it and with an 8GB card. At 4608x3456 (16M), it is down to 1877 photos. Yes, it is a 16 megapixel camera. Girvin On 04/16/2013 04:03 AM, Tom Davies wrote: Hi :) They do and it does. :D This mega pixel malarky is hilarious. Everyone else is racing to get more and more mega-pixels (is 12 or 16 mega-pixels the standard issue now?) so that they can have more noise and distortions and file-sizes like a herd of elephants trying to stampeded down my phone-line. One company is trying to market a 4 Mega-pixels camera that gives a better quality image by not adding in random fuzziness. However everyone is going to say this 16 megapixels MUST be better than 4 right? 4 is old isn't it?. meanwhile we getting stunning photos of Mars done on 'old' 2 megapixels cameras. It wouldn't be quite so bad if mega-pixel really meant anything. It clearly does NOT mean 1,000 pixels (or 1,024 in computers) Regards from Tom :) From: Felmon Davis dav...@union.edu To: users@global.libreoffice.org Sent: Tuesday, 16 April 2013, 2:45 Subject: Re: [libreoffice-users] Importing PDF problem On Mon, 15 Apr 2013, Tom Davies wrote: Hi :) Most on-line dictionaries (in the top 10 according to a google search) agree that A neologism is a newly coined term, word, or phrase, that may be in the process of entering common use, but has not yet been accepted into mainstream but my fav is Mirriam-Webster's bucking the trend amusingly a meaningless word coined by a psychotic. Even though it is not apt it's still quietly amusing, to me at least, sorry Felmon bud! :) no problem but seriously, if the people in the telly were constantly sending _you_ neologisms, don't pretend it wouldn't unsettle you a bit too. F. Regards from Tom :) From: Felmon Davis dav...@union.edu To: users@global.libreoffice.org Sent: Monday, 15 April 2013, 21:59 Subject: Re: [libreoffice-users] Importing PDF problem On Mon, 15 Apr 2013, anne-ology wrote: very interesting, yes indeed ;-) well, the more I read this list, 'the more I seem to learn, yet the stupider I feel' ;-) (the glorified typewriter has so surpassed me) I note you've used a 'new' word; acronymonious seems to fit well in this saga - yet I hope you didn't mis-type acrimonious ;-) (oh, surely not) I did not mistype. I went neologistic on you. F. On Mon, Apr 15, 2013 at 11:02 AM, Felmon Davis dav...@union.edu wrote: On Mon, 15 Apr 2013, anne-ology wrote: yikes, sounds as if I need further information - or need to keep studying ... ... ... ;-) not sure how the further discussion would be relevant to you if you just want to use the tool. the link I gave you explains the things pdftk can do. you can then decide if it might be useful. the next step is to determine if you find it convenient to use. of course, if you are also interested in how the tool is built, then that's a different matter. Please update re. this / these tks whenever; I'll stay tuned ;-) Ah, acronyms ;-) tk := http://www.acronymfinder.com/**TK.html http://www.acronymfinder.com/TK.html (well, while waiting to understand all this, my mind tends to wander - puns are so much fun :-) ) don't mean to be acronymonious about it but all disciplines and occupations use abbreviations and have specialist dictionaries
Re: [libreoffice-users] Re: [SOLVED] Calc sheet freezing
On Wed, 2013-04-10 at 05:49 -0700, Karen DInse wrote: V Stuart Foote wrote Several ways of answering this come to mind, but I'll go with the gentler tact. You have some questions to ask yourself (and your collaborators). What is your desired end use--will this Excel 2003 spread sheet continue to be used on Excel 2003? If not will your use be exclusively on LibreOffice or a mix of Apache OpenOffice and LibreOffice? Do you or some number of your users understand what data is being charted and how? Are you (they) familiar with both the Microsoft macros and the LibreOffice macros? Where I'm going is that depending on your intended use, you will need to --port-- the spread sheet either for use in calc. But likely for use in Excel 2007, or 2010 or 2012-- there is that much variation in the macro scripting between the Microsoft products. Sorry, but without seeing the function and logic of your existing spread sheet, the most we'll be able to do is suggest steps in doing a port. Thanks for the insight. Sorry it's taken so long to reply. After discussing with 'the powers that be', the decision was to recreate the data and graphs in Calc. Our goal is to get rid of MSO, so we need to move forward. Some users will still use MSO until we can get everyone moved to Libre office. Their concern was in opening 'older. legacy versions' of the spreadsheet. We have that covered for now. After spending a couple of days working on the spreadsheet in Calc, we have not encountered the 'freezing up' problem. Must have been MSO that was acting strange! -- View this message in context: http://nabble.documentfoundation.org/Calc-sheet-freezing-tp4048140p4049026.html Sent from the Users mailing list archive at Nabble.com. I use Calc a lot for various simulation tasks, and with the installation of F17, I have had numerous new spreadsheets behave very badly with any graph I put in them. The hard to believe part is that older spreadsheets, created with F15 and before all work well. I have basically held off on some new work because this is too difficult to resolve. Moreover, if I play with various things from time to time I will get it to run as before, but I cannot get a consistant setup that makes it so. I did submit a bugzilla earlier, but have not seen any response that showed a fix. Basically any new graph seems to completely refresh the screen and take a very long time, about 1 or 2 seconds for every cell used in the graph. If more information will help, ask and I will send what I can. Regards, Les Howell. -- 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] Accessibility issues - BLIND USER
Thanks, Tom. Les :0 On Sat, 2013-02-23 at 12:43 +, Tom Davies wrote: Hi :) Sorry i didn't forward this to the right list earlier! Have you had any luck solving the problems? I'm not sure if you are subscribed to the right lists so i have made sure you are being CC'd so that you get the responses. Apols and regards from Tom :) From: les hlhow...@pacbell.net To: Wes Will ww...@siu.edu Cc: LibreOffice User Support Mailing List users@global.libreoffice.org Sent: Wednesday, 20 February 2013, 17:03 Subject: Re: [libreoffice-users] Accessibility issues - BLIND USER Hi, Wes, There is an Braille institute in LA, just off the 101 near Universal City as I recall. They should be able to shed some light on these issues. Here is their EMAIL address: l...@brailleinstitute.org Or you can contact a local institute near where you live and they might be able to help. There are other options in California, but I just know a bit because my wife had a vision impaired friend. As my own vision is failing and I have a friend whose vision is also failing, this topic will become more and more important to me as well. Screen readers suck on even their best days, but given the alternatives Good luck. LesH On Wed, 2013-02-20 at 01:33 -0600, Wes Will wrote: Greetings. Just signed up for the list. Have NOT had the time yet to get to the archives and dig for prior messages to this list regarding blind users, so if this is already old news, please forgive me and drop a link to the pertinent archives. I will assuredly be delving for this topic as soon as it is possible. I'll likely wait for daylight, it is presently 0100 hours here (U.S. CST) and it has been a long day. The problem is that I have been talking LibreOffice up to the heavens to a blind friend. He is stuck in a WinBlows environment, has the latest-version-but-one of the JAWS screen reader, and has been scorched by M$ Turd one too many times. It -does- read through his screen reader, but their ribbon foolishness has made the thing completely and utterly useless to him. Simple things that he has always been able to do with a keyboard shortcut (Ctrl-O for opening a new document for instance) no longer work. One keyboard command might do one thing if a certain 'ribbon component' is active, and a completely different thing if another is active. He needs a reliable productivity suite, and I think LibreOffice -ought- to be perfect for him. Except that it ISN'T. He installed it, and was greeted with SILENCE from his screen reader. Keyboard commands, like that Ctrl-O, work fine. It just won't read the screen to him. Nightmare time for a totally blind person who just wants it to talk to him like all the other applications he uses. So I start looking, and I find that there is a REQUIRED additional JAVA API that must be installed. Roadblock ONE. It's on an Oracle site, which ISN'T all that 'blind friendly' and requires license acceptance via a bloody MOUSE CLICK on the web page. MOUSE and BLIND do NOT go together. I can get him by that, eventually, by downloading it myself (done) and sending it to him, but then it goes to roadblock TWO. The API installer is NOT 'blind friendly' either, requiring that he unzip the package, find the correct file for his OS, start it, and then answer (BY MOUSE-CLICKS AGAIN!!) several pages of information. I cannot walk him through this, as I do NOT use Microsoft ANYTHING. I cannot simply do it for him - he is in California and I am in Illinois. There is a 3000 kilometer gap between his keyboard and my hand. Is there ANY WAY that the correct API can be embedded into the LibreOffice package, or put there as an option in the install process? I.E. start the LibreOffice install; somewhere near the beginning be presented with Add Accessibility Java Extension API to LibreOffice; select Accept Oracle License Agreement; Continue installation WITH the added Java API automatically being unpacked and installed in the proper place. Or even a previously-accessibility-extended-install version of the LibreOffice suite installer. Can anyone get me past these roadblocks? I'm at a loss here, I DO think that FOSS software will work well for him, but getting it to actually WORK in the screen reader environment is already a messy, complicated thing for a BLIND MAN. Are there work-arounds or things that can be done to accomplish this? Another thing I noticed in the documentation for accessibility: The JAWS screen reader Version listed as being compatible with the (JAVA Accessibility API-Enabled) LibreOffice suite was SEVEN... They are up to version FOURTEEN, and he is using TWELVE. Has anyone checked these out for compatibility? Again, I
Re: [libreoffice-users] Accessibility issues - BLIND USER
Hi, Wes, There is an Braille institute in LA, just off the 101 near Universal City as I recall. They should be able to shed some light on these issues. Here is their EMAIL address: l...@brailleinstitute.org Or you can contact a local institute near where you live and they might be able to help. There are other options in California, but I just know a bit because my wife had a vision impaired friend. As my own vision is failing and I have a friend whose vision is also failing, this topic will become more and more important to me as well. Screen readers suck on even their best days, but given the alternatives Good luck. LesH On Wed, 2013-02-20 at 01:33 -0600, Wes Will wrote: Greetings. Just signed up for the list. Have NOT had the time yet to get to the archives and dig for prior messages to this list regarding blind users, so if this is already old news, please forgive me and drop a link to the pertinent archives. I will assuredly be delving for this topic as soon as it is possible. I'll likely wait for daylight, it is presently 0100 hours here (U.S. CST) and it has been a long day. The problem is that I have been talking LibreOffice up to the heavens to a blind friend. He is stuck in a WinBlows environment, has the latest-version-but-one of the JAWS screen reader, and has been scorched by M$ Turd one too many times. It -does- read through his screen reader, but their ribbon foolishness has made the thing completely and utterly useless to him. Simple things that he has always been able to do with a keyboard shortcut (Ctrl-O for opening a new document for instance) no longer work. One keyboard command might do one thing if a certain 'ribbon component' is active, and a completely different thing if another is active. He needs a reliable productivity suite, and I think LibreOffice -ought- to be perfect for him. Except that it ISN'T. He installed it, and was greeted with SILENCE from his screen reader. Keyboard commands, like that Ctrl-O, work fine. It just won't read the screen to him. Nightmare time for a totally blind person who just wants it to talk to him like all the other applications he uses. So I start looking, and I find that there is a REQUIRED additional JAVA API that must be installed. Roadblock ONE. It's on an Oracle site, which ISN'T all that 'blind friendly' and requires license acceptance via a bloody MOUSE CLICK on the web page. MOUSE and BLIND do NOT go together. I can get him by that, eventually, by downloading it myself (done) and sending it to him, but then it goes to roadblock TWO. The API installer is NOT 'blind friendly' either, requiring that he unzip the package, find the correct file for his OS, start it, and then answer (BY MOUSE-CLICKS AGAIN!!) several pages of information. I cannot walk him through this, as I do NOT use Microsoft ANYTHING. I cannot simply do it for him - he is in California and I am in Illinois. There is a 3000 kilometer gap between his keyboard and my hand. Is there ANY WAY that the correct API can be embedded into the LibreOffice package, or put there as an option in the install process? I.E. start the LibreOffice install; somewhere near the beginning be presented with Add Accessibility Java Extension API to LibreOffice; select Accept Oracle License Agreement; Continue installation WITH the added Java API automatically being unpacked and installed in the proper place. Or even a previously-accessibility-extended-install version of the LibreOffice suite installer. Can anyone get me past these roadblocks? I'm at a loss here, I DO think that FOSS software will work well for him, but getting it to actually WORK in the screen reader environment is already a messy, complicated thing for a BLIND MAN. Are there work-arounds or things that can be done to accomplish this? Another thing I noticed in the documentation for accessibility: The JAWS screen reader Version listed as being compatible with the (JAVA Accessibility API-Enabled) LibreOffice suite was SEVEN... They are up to version FOURTEEN, and he is using TWELVE. Has anyone checked these out for compatibility? Again, I cannot, since it is a Win-Only application. If I can get my friend in California past this whole mess, I will gladly have him test it out for compatibility and report back here so the documentation can be updated. Ideas? Links to information? Go suck an egg? What should I do here? -- Wes Will -- 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: [libreoffice-marketing] Good Article for LibreOffice
On Wed, 2012-11-28 at 16:14 +0100, Mirosław Zalewski wrote: On 28/11/2012 at 15:55, VA cuyfa...@hotmail.com wrote: That may be the hazard of having a truly open and standard file format. It eliminates a program's ability to survive. This is far from truth. Take a look at e-mail protocols: POP3 and IMAP. Do we have only two e-mail server apps and two e-mail client apps, one for each? No. We have plenty of servers and tons of clients. Take a look at XMPP messaging protocol (this is what Gmail and Facebook uses for their chats). Again: plenty of servers, tons of apps. Take a look at BitTorrent file sharing protocol. There are many clients for every platform. We have standards for HTML and CSS, yet there are at least four competing web browsers out there (although there was time when market was monopolized). This list can go on. Standard file formats are pretty much irrelevant to program's ability to survive. It's number of features, availability on certain OS, UI, branding, number translations and other things which are around standards that matters. -- Best regards Mirosław Zalewski The key issue is user experience. If the tool does what the user wants, in a manner the user understands, and with less effort than any similar tool, that is probably the best tool for that user. That doesn't mean it will be the best tool for all users, as each user values different things, so there will be as many tools as the market will bear and as the market will generate enough capital for support. Free tools exist because someone gets something, prestige, admiration, sense of accomplishment or cash for creating and maintaining that tool. Other tools have different values attached to them, according to the demands of the market place. Marketing can cause a tool to develop a following, and smart developers will find a way to build on their successes. Marketing includes commercials, self promotion, awards that make it into the public awareness, and the best one of all word of mouth. Marketing can overcome some limitations, and so some tools that are quite good may never become successful if they have no marketing at all. That is not to say they will die, because if there is a strong core of support, they will live perhaps for a very long time and may eventually be adopted by a majority of users, especially if the developers listen to their users and keep the experience delivering quality and meeting needs. I love linux. I use and like Fedora (most of the time ;-) ! -- 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
Re: [libreoffice-users] Help with Scoring Bi-nominal Responses
On Fri, 2012-09-21 at 00:34 -0500, Paul Anderson wrote: Thanks to all for the previous help, Also, sorry if you have addressed this already, Brian. But, I know only basic functions within the spreadsheet and will request a more explanatory example. The file was delivered in xlsx format. I would like to maintain the format (using LibreOffice!), but I may have to look to other software. Here is an example of my first two rows of data, cells F23 through S23, with F1-S1 containing variable names *F* *G* *H* *I* *J* *K* *L* *M* *N* *O* *P* *Q* *R* *S* 0 1 0 1 0 0 1 0 0 0 0 0 0 0 1 0 1 1 0 0 1 0 0 0 1 0 0 0 Using a simple example with only two cells (F2L2), I want T2 to equal a 'score' based on a weighted index, like this: IF F2=0 then T2=0; else T2=T2+1; (Where F2 can only take on a value of 0 or 1) AND IF L2=0 OR L2=1 OR L2=2 then T2=T2+0; else T2=T2+3 (Where L2 can take on a value of 0,1,2,or 3) So that: T2 = 0 (if F2=0 and L2=0,1,or 2) OR T2 = 4 (if F2=1 and L2=3) I haven't been able to create the proper syntax for this simple two cell scoring. How can I not only score an individual cell but also link it with another cell in the same row? A simple demonstration will be adequate so that I can create my specific and more complicated function. I hope I have stated my needs in a clearer fashion this time around, and thanks to everyone for the previous help. Regards, -Paul On 9/19/2012 11:58 AM, Jean-Francois Nifenecker wrote: Le 19/09/2012 07:03, Paul Anderson a écrit : Hello all, I have a simple question for which I cannot find the answer. I have a LibreCalc spreadsheet containing binomial data for which I would like to create a final summed score (in Column T) based upon a manually specified score index. Columns F, G, H, J, K, M, N, O, P, O, and R contain pure binomial information (0 or 1) Columns I, L, and S contain multiple numbered responses: I = 0,1,3 L = 0,1,2,3 S = 0,1,2 I want to create a final score (Column T) based upon numerical responses (in Columns F-S) All this makes me think of binary data, hence to have columns F..R (except I, L S) set to hold either 0 or a power of 2. F would hold 0 or 1 G0 or 2 H0 or 4 J0 or 8 and so forth. Then, adding any group of columns would then give a unique meaningful value: -- if you add F+G+H and get 3, you know that only F and G are set -- if you AND F+G+H with, say, 2, you may check if G (value 2) is set : if G AND 2 = 2 then G is set (in Calc use the BITAND function) As I don't know exactly what you're looking to achieve, perhaps my idea is useless. Anyway, just my two euro-cents As I look more and more at this I wonder if a spreadsheet is the right tool for the job. It seems like what you need is a language (a little dated here) pilot, which was specifically created for writing tests and scoring them by an educator. There are also very nice packages for Prolog that can handle this type of coding. First of all T2 must have some value or be formatted to begin with. (format-cell something). Next you cannot do this without referential addressing. Look that up. The reference needs to include the sheet and cell. Finally none of the code can actually go in the T2 cell. It can ONLY be a results cell, or things get nasty quickly. So for example we could code cell x2 with the formula for one bit and cell x3 with the formula for the second bit, but then you would have to set the calc options to control the resolution iterations which may or may not work in the end. My recommendation is to put the keys on one sheet and the formulas on a following sheet. Then the keys are entered, the second sheet is evaluated and gives you the answers. It should also allow you to lock the calculation sheet if that is of any interest to you. I get good fees for homework. Usually about $55/hour, or 3 gallons of coffee, which ever works best for me. This late at night, its the coffee. Regards, Les H IF F2=0 then T2=0; else T2=T2+1; (Where F2 can only take on a value of 0 or 1) AND IF L2=0 OR L2=1 OR L2=2 then T2=T2+0; else T2=T2+3 (Where L2 can take on a value of 0,1,2,or 3) -- 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] Help with Scoring Bi-nominal Responses
On Wed, 2012-09-19 at 00:03 -0500, Paul Anderson wrote: Hello all, I have a simple question for which I cannot find the answer. I have a LibreCalc spreadsheet containing binomial data for which I would like to create a final summed score (in Column T) based upon a manually specified score index. Columns F, G, H, J, K, M, N, O, P, O, and R contain pure binomial information (0 or 1) Columns I, L, and S contain multiple numbered responses: I = 0,1,3 L = 0,1,2,3 S = 0,1,2 I want to create a final score (Column T) based upon numerical responses (in Columns F-S) Generally, scoring should happen like this for binomial answers, though some responses are weighted more than others: if F*=0 then T*=T*+0; else if F*=1 then T*=T*+1; Generally, scoring should happen like this for the columns containing multiple answers, though again, some responses are weighted more than others: if I*=0 then T*=T*+0; if I*=3 then T*=T*+2; I'm sure this function is straightforward, but I have not even been able to get the first column (F) to create a proper score for the final column (T). The if statement is documented in the help file. if (logic conditional,true action, false action) Regards, LesH -- 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