Re: [users] your office programm
2010/1/28 Rudolf Konheiser rkonhei...@peoplepc.com: Thanks a lot ,but what I need is a Smartcon that sais Add Above like the one in 1 2 3 Lotus , unfortunatly my Smart suit is not compatible with Vista ,so I bought Open Office ,a lot a good that did. Bought?? OpenOffice.org is free, why buying it? Well, donations are probably welcome, but that isn't buying, as far as I know. And it isn't ”our” office suite. I, for example, am a user, just like most people on this list, and just like you. Regards Johnny Rosenberg - Original Message - From: John Meyer pueblonat...@opensuse.us To: users@openoffice.org Cc: Rudolf Konheiser rkonhei...@peoplepc.com Sent: Tuesday, January 26, 2010 2:22 PM Subject: Re: [users] your office programm On 1/26/2010 12:58 AM, Rudolf Konheiser wrote: Like most people I am not to computer smart. What I am trying to do is , set up a Spreadsheet with 18 columns and invinate pages. Ech page to have the Heading of the original , Column Subtotal and Ballance forward on the following page .Your program might be nice and usefull to some .but I'm not attemting to calculate DNA relations betwenn Human and a worm .PLease help me in some way R Konheiser http://documentation.openoffice.org/manuals/userguide3/0100GS3-GettingStartedOOo3.pdf - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Using an OR inside an IF
2010/1/26 Wade Smart w...@wadesmart.com: =IF(F8=(OR(yellow,y)),5,0) IF, F8 is equal to the word yellow or the letter y then return the number 5, otherwise return 0. Im getting that #VALUE! error. ah.. I just read that any text cells are ignored. How would I do that then? This works (I tried it) on OpenOffice.org 3.2 RC1: =IF(OR(F8=yellow;F8=y);5;0) =IF(OR(F8=yellow,F8=y),5,0) on the other hand, gives ”Err:501”. I don't know what build you have. Maybe you use Excel? Excel accepts commas, as far as I've heard. Regards Johnny Rosenberg Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] password doesn't work
2010/1/22 Elizabeth Coons msj...@sbcglobal.net: I paid for membership or something and got a password and user name. it doesn't work. All my downloads are useless, Can i please get my money back ? Elizabeth OpenOffice.org is free to download and use. Exactly what did you pay for and to whom? You should probably ask whoever you paid to, to get your money back. People on this list, like myself, are OpenOffice.org users who ask questions to each other. Sounds like ”a blind helping a blind” a little bit, but some users are experienced in different areas, so it works pretty OK. So writing here to ask for money back is like you bought something somewhere, get disappointed at it and then ask your neighbour to give you your money back… OpenOffice.org won't charge you for anything, but I think donations are welcome, but you don't get anything for it and no one will ever force you to pay anything. Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Outsource a macro programmer
2010/1/22 Eric Wood e...@interplas.com: Is there anyone for hire to do contract macro programming in Writer? I'd like a macro to be called from the command line along with a starting template document, something similar discussed here: http://user.services.openoffice.org/en/forum/viewtopic.php?f=20t=8232 When to document opens, the macro replaces certain text in the document with text fields in the clipboard. Therefore, this merge happens upon loading the document. That's basically it. An external program populates the clipboard and calls soffice.exe from the command line. Writer runs the macro to do the search/replace stuff. Do you ask for someone writing the macro only or also the external program (script?)? It's easy to write a simple script that opens a certain document (in Linux; I don't know about Windows) and in OpenOffice.org you can easily make a macro start when opening a certain document. I have written a few (simple) macros that reads from the clipboard, but I am definitely not some kind of guru or something… Regards Johnny Rosenberg -Eric Wood CTO International Plastics, Inc. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] If statement in calc
2010/1/22 Philipp Giddings webmas...@continentalbook.com: Hello all Trying to create an If statement that will multiply cell value under 10 by 2.5 and 10 and over by 2.5 my non functioning formula below =IF(I210);(I2*2.5) IF(I2=10;(I2*2.4))) Seems like you misunderstood the syntax a bit there. As someone already mentioned, the syntax is: =IF(Condition;Value/statement if condition is true;Value/statement if condition is false) You can have an IF condition inside another one and so on: =IF(A1-15;A1 ℃ is rather cold;IF(A135;A1 ℃ is hot;A1 ℃ is quite allright)) Regards Johnny Rosenberg any help would be appreciated Thanks Philipp - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Faulty MS filters in OOo
2010/1/18 Bob Williams li...@barrowhillfarm.org.uk: Hi, I'm using OpenOffice 3.1.1 on openSUSE 11.2. A lot of my correspondents are stuck with MS Office, so I'm having to save a spreadsheet I've created in .xls format. I chose Microsoft Excel 97/2000/XP as a good compromise, but when I re-open the file in OOo it is in Microsoft Excel 5.0 format. I've had to resort to using Microsoft Excel XP in Vista in a VirtualBox VM, just to edit this one little file, which is definitely a sledgehammer for a nut, as the VM requires half my 4GB RAM to run :( I would rather use OOo on my linux box. Any suggestions? If the receiver is not supposed to edit the document, export to PDF. If editing should be possible, use the ISO/IEC 26300:2006 format (ODF) and thee the receiver to install an ODF plugin to their MS Office suites. Regards Johnny Rosenberg Bob -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.2, Kernel 2.6.31.8-0.1-desktop, KDE 4.3.4 Intel Core2 Quad Q9400 2.66GHz, 4GB DDR RAM, nVidia GeForce 9200GS - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Faulty MS filters in OOo
2010/1/18 Bob Williams li...@barrowhillfarm.org.uk: Hi Jonny, On Monday 18 Jan 2010 18:17:47 Johnny Rosenberg wrote: 2010/1/18 Bob Williams li...@barrowhillfarm.org.uk: Hi, I'm using OpenOffice 3.1.1 on openSUSE 11.2. A lot of my correspondents are stuck with MS Office, so I'm having to save a spreadsheet I've created in .xls format. I chose Microsoft Excel 97/2000/XP as a good compromise, but when I re-open the file in OOo it is in Microsoft Excel 5.0 format. I've had to resort to using Microsoft Excel XP in Vista in a VirtualBox VM, just to edit this one little file, which is definitely a sledgehammer for a nut, as the VM requires half my 4GB RAM to run :( I would rather use OOo on my linux box. Any suggestions? If the receiver is not supposed to edit the document, export to PDF. If editing should be possible, use the ISO/IEC 26300:2006 format (ODF) and thee the receiver to install an ODF plugin to their MS Office suites. Interesting spelling error I made there… I guess I was going to type ”tell” rather than ”thee”… Both good suggestions, but 1) some receivers will need to edit the spreadsheet, Well, I said ”if the receiver is not supposed to edit the document”, didn't I? and 2) there are currently 28 receivers, and rising. I would like to persuade them all to use *.odf, but don't hold much hope. Still, it may be worth a try. If some of them use the latest version of MS Office, I think they don't need to install anything. I think MS Office supports ODF by default these days. Maybe not for 100%, but still more and better than nothing… Bob -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.2, Kernel 2.6.31.8-0.1-desktop, KDE 4.3.4 Intel Core2 Quad Q9400 2.66GHz, 4GB DDR RAM, nVidia GeForce 9200GS - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] information
2010/1/15 Guy Garside garside...@yahoo.com: will all the programs you mention open the files and attachments that you recieve from microsoft programs.? Most of them. Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Open office/ms Office
2010/1/17 jim_mille...@sbcglobal.net: I know nothing about Open Office. Is it really free? Does it compare to MS Office. Can they both be run on the same computer? Will it run on Windows 7? Anything else you can share will be helpful. Thanks, Jim Yes, yes, yes and so on. Well, it's free. Just download it (from http://www.openoffice.org/), install it and see for yourself. It's free as in ”gratis” and it's free as in ”freedom of speech”. You can install it on how many computers as you like. In fact, the more the better. You can contribute with code (the source code is available, of course), ideas and bug reports if you like. In fact quite a few of my bug reports through the years has resulted in changes, so it seems like the developers are at least listening a little bit. Just remember that OpenOffice.org is NOT MS Office and doesn't want to be (why would it? MS Office already exists…), so some things are done differently. OpenOffice.org is more Style oriented, so learning how to manage styles will pay off and save you quite a lot of time in the future, if you use it properly. You don't have to use styles, but it makes things easier once you learned working the OpenOffice.org way with styles… Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Saving as template
1. Open an empty spreadsheet (or any other spreadsheet) 2. Shift+F11 3. Give your new template a name 4. Hit ↵ 5. An error message pops up, reading something like (and I translate from the grammatically incorrect Swedish message): ”Error at when the document noname1 was saved as a template: General error. General input/output error.” Nice that I am given all the details I need so I know what to do next… Well, anyway, does anyone else experience the same thing? OpenOffice.org Calc 3.2 RC1 Ubuntu 8.10 (the Ubuntu version of OpenOffice.org was uninstalled before installing the RC). Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Saving as template
2010/1/16 Cor Nouws oo...@nouenoff.nl: Hi Johnny, Johnny Rosenberg wrote (16-01-10 20:42) 1. Open an empty spreadsheet (or any other spreadsheet) 2. Shift+F11 3. Give your new template a name 4. Hit ↵ 5. An error message pops up, reading something like (and I translate from the grammatically incorrect Swedish message): ”Error at when the document noname1 was saved as a template: General error. General input/output error.” Nice that I am given all the details I need so I know what to do next… Well, anyway, does anyone else experience the same thing? OpenOffice.org Calc 3.2 RC1 Ubuntu 8.10 (the Ubuntu version of OpenOffice.org was uninstalled before installing the RC). I've had the same. And read that this bug was found and repaired for 320rc2. Ok, so I only have to wait for RC2 then. Thanks. Going to look for its release date. Regards Johnny Rosenberg Regards, Cor -- Your office 2010 software: the new OpenOffice.org Cor Nouws - nl.OpenOffice.org marketing contact - Community Council member - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Saving as template
2010/1/16 Johnny Rosenberg gurus.knu...@gmail.com: 2010/1/16 Cor Nouws oo...@nouenoff.nl: Hi Johnny, Johnny Rosenberg wrote (16-01-10 20:42) 1. Open an empty spreadsheet (or any other spreadsheet) 2. Shift+F11 3. Give your new template a name 4. Hit ↵ 5. An error message pops up, reading something like (and I translate from the grammatically incorrect Swedish message): ”Error at when the document noname1 was saved as a template: General error. General input/output error.” Nice that I am given all the details I need so I know what to do next… Well, anyway, does anyone else experience the same thing? OpenOffice.org Calc 3.2 RC1 Ubuntu 8.10 (the Ubuntu version of OpenOffice.org was uninstalled before installing the RC). I've had the same. And read that this bug was found and repaired for 320rc2. Ok, so I only have to wait for RC2 then. Thanks. Going to look for its release date. Regards Johnny Rosenberg Oh, it was 2 days ago… so I'd better download it and install it then… Johnny Rosenberg Regards, Cor -- Your office 2010 software: the new OpenOffice.org Cor Nouws - nl.OpenOffice.org marketing contact - Community Council member - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Inserting page numbers
2010/1/13 t...@seedfield.co.uk t...@seedfield.co.uk: Dear Sir/Madame, I'm currently writing a document for work using vista which is the only programme on my lap top which was highly recommended to me by the company who sold me the lap top. However it appears to make a lot of very simple tasks extremely unnecessarily complicated which costs a lot of my time which I do not need. All I want to do is to pres insert page number and then I expect each page to have its number on the bottom. This is what happened in Word xp but not in Vista. Why is this? I am having great difficulty inserting page numbers in numerical order due to the fact that even when I insert a footer and then go to insert page number it only inserts one page number on one page - what is the point of that? So I individualy tried to do it by hand but when I do that it automatically changes it so that 4 is before 3 etc. Its very annoying. If there is a way you could sort it please could you let me know. A job that should take one second is taking me an hour of wasted time. I would appreciate your help. Sorry if this email sounds short. Well, this is a mail list for OpenOffice.org. If you use Word you should search for a forum or mail list for Word, not for OpenOffice.org. Regards Johnny Rosenberg Kind regards, Tia Danning. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How to install OpenOffice 3.2?
2010/1/12 Sigrid Carrera sigrid.carr...@googlemail.com: Hi Klark, Am Tue, 12 Jan 2010 17:53:05 +0800 schrieb Klark Ooi k...@redhat.com: Hi Henri, I download the rpm files. It gives me a whole bunch of RPMs. I used rpm -i *.rpm but after installed, I can't find any of the pkg and no menu to execute the programs. In the folder ../RPMS is a subfolder called Desktop-integration. Did you install the desktop integration package for your Linux distro? With this package you should have then an entry in your menu list. As alternative you could open a shell (bash or so) type soffice and hit return. This should start OpenOffice.org as well. This command works for me here on Mandriva Linux. Sigrid I was too late… and I wasn't sure about how the rpm stuff works. I installed 3.2 by first deleteing Ubuntu's version entirely, then download the debs and installing them by ”dpkg -i *.deb”, then cd to the desktop integration folder and run the same command again. Before I did the last step there was no icons or anything, so the last step seems to be ”the thing to do” in this case. Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] FW: America]
2010/1/10 John Boyle jbo...@harbornet.com: To ALL who reacted negatively: First, I spent 21 years defending your right to FREE SPEECH, BUT YOU DENY ME MINE! To all of you who are obviously Communist/Socialist at heart, Neither socialists nor communists are against freedom of speech. And please don't refer those so called communist countries (such as the former Sovjet union, Cuba, China, North Korea or whatever) as communists; they are definitely not. Everything (or at least most of) what they did (and in some cases still does) is definitely as far from communism as possible. In most aspects communism is the opposite of what happened in those countries. Yes, they called themselves communists, but when you study communism you should realize that it has really nothing to do with those people at all. Maybe they dreamed of communism or something, but they definitely picked the wrong way for getting there (actually there is probably no way to get there, due to us human's built in egoism that seems to stand in the way in this case, at least for bigger societies). I am glad you have revealed yourselves to me, It means I can filter all of you out and never crowd my computer with your GARBAGE again! Spam, you people do NOT even know what spam is, and NEVER WILL! Without Religious or Political Freedom, this country would NOT exist, nor will it much longer! I do NOT think you people realize how STUPID you sound, and it no longer matters to me! TIME is running out for this country and for you, who think computer programs are the end all or be all! THEY WERE MEANT FOR COMMUNICATION, FIRST AND FOREMOST!! AND AS LONG AS THERE IS NO PROFANITY OR PORNOGRPHY, A *ONE SHOT STATEMENT *LIKE MINE SHOULD NOT HAVE GOTTEN THIS KIND OF REACTION, IF YOU PEOPLE HAD ANY CHRISTIANITY WHATSOEVER IN YOU :o Well, I'm not a Christian, but depending on what the word ”Christianity” means (English is not my language, as you can see), I might have a little or much of it anyway. Not being a Christian doesn't mean that you have to be a terrorist or just evil in general. Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Is Open Office compatible with WIN 7?
2010/1/10 Programmer In Training p...@joseph-a-nagy-jr.us: On 1/9/2010 6:47 PM, Johnny Rosenberg wrote: 2010/1/10 John Boyle jbo...@harbornet.com: To Users: I use WIN XP, and today at my computer club, we had a presentation of WIN 7 and the FACT that MANY programs are NOT compatible with it, OR , the FACT that you have to have the original installation disks, as you have to re-install ALL programs, although you can  and must back up ALL that you have on your computer NOW! Well, you take daily backups anyway like everyone else, don't you? I just want to say, not everyone makes daily backups. To assume so is naive. Well, naive or not, they should, and if they don't it's not my problem… ;P Should we all make backups? Sure. Daily? Not unless you're running a mission critical server that is constantly changing. Well, I edit documents every day nothing says exactly when my HDD will crash, so daily backups is the only option, at least for people like me who don't want to redo weeks of work manually. My backups doesn't take very long, maybe 1 minute in worst case. I backup to an external USB HDD using my own script which use rsync. Only changed files are written to the drive each time, of course, but now and then I do a fresh backup from scratch, which takes a couple of hours though, but I start it right before going to bed, so it's finished next morning. I was given a WIN 7 Upgrade Advisor disk, to take home, this is NOT WIN 7 itself, but it checks out what you have both in devices and in software, and gives you a list of what will work and what won't! BEFORE, anyone upgrades, it would behoove you to get that Advisor from MSFT! Those of you who just got NEW computers with WIN 7 already installed, I say great, but most of us are in deep trouble, as I see it!!! =-O  You will either have to find ALL the original installation disks, or get new versions on disks, except for Open Office, which you will just have to download ALL OVER AGAIN! Well, OpenOffice.org is not a big download. Takes a couple of minutes, if you aren't left behind at stone age with some kind of dial up modem thingy or whatever they are called in English. The stone age isn't so far back. Broadband penetration is under 50% in the US last time I heard. Really? I didn't realize you people were left behind that much, sorry for that. http://www.internetstatistik.se/content/1781-sverige-bast-pa-bredband-i-eu.html This site is in Swedish (the only language I understand), but it says that 56% of the households in EU has broadband (which is also a surprisingly low amount). Sweden 80% Netherlands 77% Denmark 76% Finland 74% The numbers are for 2009 and the article was written in 11th of December 2009 (2009-12-11). Well, OK, all the numbers were lower than I thought, so yes, you're right. But I still think everyone SHOULD have the right to broadband… It seems it is mandatory that you backup ALL your hard drives, even though you still have to have the original installation disks, anyway! Plus you may have to get NEW HARDWARE,  also!  How many think WIN 7 is worth ALL this trouble? :-\ I don't know. I haven't used Windows since summer 2007 and I will never use it again. If only I were so lucky. In fact I have logged in to my Windows partition a few times since summer 2007, but only for troubleshooting, like when our Internet provider fails, I try in Windows to verify that I didn't mess up Ubuntu in some way (so far my Internet provider has been the only one to blame the few times this happened). Johnny Rosenberg -- PIT - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Is Open Office compatible with WIN 7?
2010/1/10 John Boyle jbo...@harbornet.com: To Users: Sticking with the thread, You can also install a 32 bit version of WIN 7, according to the presenter at my computer club! But, you should get the Win 7 upgrade adviser to see how compatible your software and hardware are for the upgrade. When I said you would have to BACK UP your hard drive, I meant TOTALLY , not just daily backups, especially when doing the actual upgrade! This has nothing to do with the dailys you may be doing anyway! :-) And exactly WHY do you have to do that? Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Is Open Office compatible with WIN 7?
2010/1/10 Bob Estes bob_es...@comcast.net: NEW HARDWARE, also! How many think WIN 7 is worth ALL this trouble? :-\ I don't know. I haven't used Windows since summer 2007 and I will never use it again. HA! HA! Never say never. I have been running a dual boot configuration with Windows on one drive and Linux on another. My Linux drive crashed, and I'm back to using Windows only until I can buy another drive. Well, I actually have Windows on a very small partition, but if the drive crash I can't use Widows either. Fortunately we have four computers (this laptop, my wife's desktop and one Eee PC each), so there should never be a reason for me to use Windows, unless my employer forces me to do it, but so far I have used my Eee PC at work (which has Ubuntu 9.10 installed). Sorry for being off topic again. Regards Johnny Rosenberg Bob - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] FW: America] John Boyle
2010/1/10 Gene Young n2...@cfl.rr.com: Johnny Rosenberg wrote: 2010/1/10 John Boyle jbo...@harbornet.com: To ALL: Whether you like it or not, here it is, and you can get angry at me for sending it to you, BUT THIS I BELIEVE!!! :o Yet another reason not to send the crap to this list then. Regards Johnny Rosenberg I have had this individual plonked for several years. Now, thanks to the wonderful individuals who believe it is productive to argue with an insane idiot, his crap has once again invaded my computer, not once but more like thirty times. Please people, realize there are people who are beyond understanding reality and learn to recognize them. Arguing with them does nothing but irritate the hundreds who are trying to ignore them. Just say PLONK. Thank you, -- Gene Y. Yes, of course you're right, but it's hard to resist some times… Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Superior
2010/1/10 James R. Liebert jiml...@neo.rr.com: 10. No one will kill you for not drinking Beer. 9. Beer doesn't tell you how to have sex. 8. Beer has never caused a major war. 7. They don't force Beer on minors who can't think for themselves. 6. When you have a Beer, you don't knock on people's doors trying to give it away. 5. Nobody's ever been burned at the stake, hanged, or tortured over his brand of Beer. 4. You don't have to wait 2000+ years for a second Beer. 3. There are laws saying Beer labels can't lie to you. 2. You can prove you have a Beer. 1. If you've devoted your life to Beer, there are groups to help you stop. 2010/1/10 John Boyle jbo...@harbornet.com: Anti-Communista and Christian To solve your problem we need to know few things that you forgot to mention: 1. You operating system (name and version) 2. You OpenOffice.org version 3. In which part of OpenOffice.org your problem appears (Calc, Writer, Draw etc.) 4. What kind of problem you have Please write back with that information and I am sure someone can identify your problem and help you solving it. Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] FW: America]
2010/1/10 Programmer In Training p...@joseph-a-nagy-jr.us: On 1/10/2010 2:01 PM, RobertHoltzman wrote: On Sun, Jan 10, 2010 at 01:02:13PM -0500, Hal Vaughan wrote: Yeah, it's a good thing atheist regimes never do purges of religious groups. We know that's never happened. Care to name one (just for my own education)? How about the Soviets? Or the N. Koreans. Or the Chinese. Chinese religions: Schamanism, konfucianism, daoism, different forms of buddhism etc. Can't find anything about atheism in China but I am sure it exists there too, but it doesn't seem to be typical for Chine, as far as I found out. But what would I know? Never been there. Johnny Rosenberg Or the Laotians. You can start your search here: https://www.startpage.com/ (I'd provide a link to results but they don't do arguments through the url). -- PIT - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] FW: America]
2010/1/10 John Boyle jbo...@harbornet.com: To ALL: Whether you like it or not, here it is, and you can get angry at me for sending it to you, BUT THIS I BELIEVE!!! :o Yet another reason not to send the crap to this list then. Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Is Open Office compatible with WIN 7?
2010/1/10 John Boyle jbo...@harbornet.com: To Users: I use WIN XP, and today at my computer club, we had a presentation of WIN 7 and the FACT that MANY programs are NOT compatible with it, OR , the FACT that you have to have the original installation disks, as you have to re-install ALL programs, although you can and must back up ALL that you have on your computer NOW! Well, you take daily backups anyway like everyone else, don't you? I was given a WIN 7 Upgrade Advisor disk, to take home, this is NOT WIN 7 itself, but it checks out what you have both in devices and in software, and gives you a list of what will work and what won't! BEFORE, anyone upgrades, it would behoove you to get that Advisor from MSFT! Those of you who just got NEW computers with WIN 7 already installed, I say great, but most of us are in deep trouble, as I see it!!! =-O You will either have to find ALL the original installation disks, or get new versions on disks, except for Open Office, which you will just have to download ALL OVER AGAIN! Well, OpenOffice.org is not a big download. Takes a couple of minutes, if you aren't left behind at stone age with some kind of dial up modem thingy or whatever they are called in English. It seems it is mandatory that you backup ALL your hard drives, even though you still have to have the original installation disks, anyway! Plus you may have to get NEW HARDWARE, also! How many think WIN 7 is worth ALL this trouble? :-\ I don't know. I haven't used Windows since summer 2007 and I will never use it again. Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] FW: America]
2010/1/10 Wade Smart w...@wadesmart.com: Misty Day wrote: My name is not John and I did not send the letter to you. Why are you berating me? Misty, you are on a mailing list. Henris post went out to everyone. One post to many readers. It wasnt aimed at your directly. In fact, it wasn't aimed at him at all, not even indirectly; it was aimed at John. That's why he wrote ”John”… Regards Johnny Rosenberg Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Re: Mathematical division sign.
2010/1/8 t...@twaynesdomain.com: In news:snt103-ds30f27da0adf1b80065bb0d6...@phx.gbl, Doug Hovelson doughovel...@msn.com typed: I'm running WIN XP and the alt + 0247 (on numpad) works for me to get the division symbol. -- From: Thomas Lange - Sun Germany - ham02 - Hamburg thomas.la...@sun.com Sent: Wednesday, December 09, 2009 1:18 AM To: users@openoffice.org Subject: Re: [users] Re: Mathematical division sign. Hi all, Ian L. Target wrote: PatrickG wrote: Ian L. Target wrote: How does a user get the mathematical division sign, the bar a dot above and below it in an OO module? I ended up having to go to my room mate's computer and firing up Office 97. I know that ASCII code of 0247 to get it in MS Word. I ended up emailing myself a copy of the document with the symbol in it and then opening it in OO Writer. Surely there is an easier way . . . Hold down the ALT key type in 0427 (or the appropriate ascii) using the numpad release the ALT key and it should show up. At least it does here, using Writer (OOo 3.1) on WinXP SP3. Patrick G. It must be a Linux thing then. I was aware and had often used the above mentioned method in winders, but apparently it does not work in Linux versions of OO. Actually I think that does not even work with Windows versions. But if you want to do it in Writer you have to use the Insert/Special Character dialog. There you need to set the font and browse to the correct position in the font. (The unicode values of the characters get displayed there, but unfortunately you can't add a value directly. If you want you may file a request for enhancement about this. Me also thinks it is a missing feature here.) If you are using Math you can get it by using the Formula elements toolbox window, or you can just manually enter a div b in the command window to get it displayed. Regards, Thomas - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org It might depend on whether you're using ascii or unicode? Well, it's 2010 now so I guess ASCII is out of the question since 10 years ago or so. Johnny Rosenberg Just a thought. Twayne -- - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OpenOffice.org Calc 3.2 RC1 autosaves whenever it feels like it etc.
2010/1/8 Web Kracked webmas...@krackedpress.com: Johnny Rosenberg wrote: Well, I downloaded OpenOffice.org 3.2 RC1 from the http://www.openoffice.org/ site, unpacked and installed from a terminal with ”dpkg -i *.deb” in the DEBS folder and then the same thing in the ”desktop-integration” folder. Well every time I use the dpkg -i command, the scrolling messages all seem to be skipped . . . . , i.e. it skipped all of the .deb packages. Of course, some times with the .sh file install, the shell program created a folder with the files in it and I cannot edit any .xml files or delete the files or folders. I keep getting the error that I am not the owner of the files or the folder and do not have the permission to to do the commands I typed in [or through the GUI folder viewing package] Nothing was skipped as far as I could see when installing. However, I think I typed ”sudo dpkg -i *.deb”, not only ”dpkg -i *.deb”. Well, with Linux I will wait for a while hoping for 3.2 to come to one of my repositories. For Windows, I install it in a _beta folder instead of the default Programs Folder. This way I can try 3.2.x without messing with 3.1.1. Also this way I can compare the two side-by-side with the same documents. It would be nice, though, if there is no need to go beyond RC2 before the official release come out. It would be great for it to be out by the end of the month, or early February. Then when Ubuntu comes out with its new update and repository, OOo 3.2 will be in it. Today Ubuntu finally went from 2.6.31-16-generic to version -17 for the 32-bit Ubuntu and from -14 to -16 for the 64-bit version. As said before in other threads, it takes a few months for Ubuntu to add the newest version of OOo to their repositories. Apart from the auto save behaviour, I really like the new 3.2. I noticed that they added some features that I really need, like the UNICODE() and UNICHAR() cell functions. I also noticed that they added a feature that I asked for back in the OpenOffice.org 1.0 era…! Click Format → Conditional formatting…. Note the new button in the dialogue. I asked for it almost ten years ago (unfortunately I can't find it in issuezilla, though). It's the button that lets you create a new style while the Conditional formatting dialogue is open. It's a very small feature, but I like it. I will try again, when 3.2 non-RC is out, the dpkg -i *.deb command on both of my Ubuntu systems. I try to make sure the same version is installed on the Win Vista laptop, the Ubuntu 64-bit laptop, and the Ubuntu 32-bit desktop server. No more having one with 3.0.x, and another with 3.1.0 and the last one 3.1.1. All are not running 3.1.1 and will be running 3.2 when it comes out. THANKS for reminding me what the command is for installing the multiple .deb files that are extracted from the install file. I will write it down again. Don't forget the sudo part… Tim Lungstrom. retired and tired of needing to use MS for some of my work. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OpenOffice.org Calc 3.2 RC1 autosaves whenever it feels like it etc.
2010/1/7 TomW tomw...@ctel.net: Cor Nouws wrote: Johnny Rosenberg wrote (06-01-10 12:58) So it seems to be a problem in OpenOffice.org rather than my system, I believe. Forgot to mention my OS, by the way. It's Ubuntu 8.10. Hmm.. since I run 9.10, it *could* be Ubuntu ... Any other users any experience with this? Regards, Cor Cor: There has been some recent comments on the Framework list about this bug causing random saves on large documents. http://www.openoffice.org/issues/show_bug.cgi?id=95335 TomW Thanks. I went there, read it, commented it and gave 2 votes for it. Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] OpenOffice.org Calc 3.2 RC1 autosaves whenever it feels like it etc.
I have a medium large spreadsheet (maybe 5 sheets, most of them with around 2000 rows, maybe 10 columns, but I don't think this is a size issue anyway) and it contains a few buttons, macros and dialogues. Now and then it auto-saves. In Tools → Options → and so on, the auto-save frequency is set to each 15 minutes, but I am pretty sure this happens more often than that. Not only that it saves the spreadsheet, it does it at least 3 times directly after each other! Once, I think, it did it at least 5 times before I could get back to ”work”. And since this spreadsheet takes a few seconds to save this is quite a bit annoying. Am I the only one who have seen this problem? Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OpenOffice.org Calc 3.2 RC1 autosaves whenever it feels like it etc.
2010/1/6 Cor Nouws oo...@nouenoff.nl: Hi Johnny, Johnny Rosenberg wrote (06-01-10 10:23) I have a medium large spreadsheet (maybe 5 sheets, most of them with around 2000 rows, maybe 10 columns, but I don't think this is a size issue anyway) and it contains a few buttons, macros and dialogues. Now and then it auto-saves. In Tools → Options → and so on, the auto-save frequency is set to each 15 minutes, but I am pretty sure this happens more often than that. Not only that it saves the spreadsheet, it does it at least 3 times directly after each other! Once, I think, it did it at least 5 times before I could get back to ”work”. And since this spreadsheet takes a few seconds to save this is quite a bit annoying. Am I the only one who have seen this problem? I see the same. There has some work been done on separating the complete data of a Calc document in several parts. It is my guess, that that is related to this behaviour... I cannot judge if it is a severe problem and have not taken any action, search in issuetracker or whatever. Cor So it seems to be a problem in OpenOffice.org rather than my system, I believe. Forgot to mention my OS, by the way. It's Ubuntu 8.10. Johnny Rosenberg -- Your office 2010 software: the new OpenOffice.org Cor Nouws - nl.OpenOffice.org marketing contact - Community Council member - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OpenOffice.org Calc 3.2 RC1 autosaves whenever it feels like it etc.
2010/1/6 Cor Nouws oo...@nouenoff.nl: Johnny Rosenberg wrote (06-01-10 12:58) So it seems to be a problem in OpenOffice.org rather than my system, I believe. Forgot to mention my OS, by the way. It's Ubuntu 8.10. Hmm.. since I run 9.10, it *could* be Ubuntu ... Still, we are not running the Ubuntu version of OpenOffice.org (there is no 3.2 RC1 Ubuntu version, I think). Johnny Rosenberg Any other users any experience with this? Regards, Cor -- Your office 2010 software: the new OpenOffice.org Cor Nouws - nl.OpenOffice.org marketing contact - Community Council member - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Release Date for 3.2
2010/1/6 Web Kracked webmas...@krackedpress.com: The answer I got from someone off this list is not good. It looks like Ubuntu may not provide an upgrade to their 3.x version to 3.2 until they change version from 9.10 to 9.15 or 9.20. Since the version numbers of Ubuntu keeps to the format Y.MM I doubt they will ever release 9.15 or 9.20, because there are no 15th or 20th month of the year. New Ubuntu versions are usually released in April and October (except for 6.06 which was released in june 2006, just like the version number tells us), så the current version 9.10 was released in October 2009 and the next release will be 10.04 in April 2010 and so on. If the repositories of Ubuntu 10.04 doesn't contain OpenOffice.org 3.2, Ubuntu 10.10 will, unless there is an even newer version by that time. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OpenOffice.org Calc 3.2 RC1 autosaves whenever it feels like it etc.
2010/1/6 Web Kracked webmas...@krackedpress.com: Cor Nouws wrote: Johnny Rosenberg wrote (06-01-10 16:54) 2010/1/6 Cor Nouws oo...@nouenoff.nl: Johnny Rosenberg wrote (06-01-10 12:58) So it seems to be a problem in OpenOffice.org rather than my system, I believe. Forgot to mention my OS, by the way. It's Ubuntu 8.10. Hmm.. since I run 9.10, it *could* be Ubuntu ... Still, we are not running the Ubuntu version of OpenOffice.org (there is no 3.2 RC1 Ubuntu version, I think). No, but the effect could be related to the Ubuntu OS. Any other users any experience with this? I did not read the beginnings of this thread. If you want to contact me off the list at webmas...@krackedpress.com, and give me the information about the problem, etc., I could try it and see if the problem happens on either Ubuntu 9.10 32-bit and 64-bit. I never ran version 8.10 since I started with 9.04. I would be happy to try what you have been doing and see it the errors/problems happen with my setup. You could even attach you file[s]. BUT you would need to do so off this list. Well, I downloaded OpenOffice.org 3.2 RC1 from the http://www.openoffice.org/ site, unpacked and installed from a terminal with ”dpkg -i *.deb” in the DEBS folder and then the same thing in the ”desktop-integration” folder. The default setting fro auto-save seems to be 15 minutes, but it seems like it does that more often and more random (like ”when it feels like it”, kind of). As if that's not enough of a problem, it doesn't only save once or twice; it saves at least three times in a row, or at least it looks like that. Some times more, maybe five or more times at once. With a big spreadsheet this is very annoying. So what you need to do to test this is to install OpenOffice.org 3.2 RC1, create a big spreadsheet (like about 5 sheets with 2000 rows of data and formulas and 10 columns) and just work with it. The reason for having a bid spreadsheet file is that it takes more time to save, so it's more likely that you detect the problem. If you test with an empty spreadsheet, the saving probably is so fast so you won't notice what's happening. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Some characters invisible with OpenOffice.org 3.2 RC1. Bug?
2010/1/3 jonathon jonathon.bl...@gmail.com: On Fri, Jan 1, 2010 at 21:34, Johnny Rosenberg wrote: I actually think it's a good thing that missing characters are substituted. It is a really bad idea, because it encourages non-portable documents, with the document creator not knowing why the other readers/users of the document aren't seeing what was written. Okay, could affect some people. I never send ODF to people, since I always export to PDF before sending my work to anyone, so it wouldn't affect me and those who I send documents to. And no, no one is allowed to edit my documents, so PDF is fine for me. But yes, millions of other people would probably have issues. Do you think it would be a good idea if the ODF standard (and OpenOffice.org) let you include fonts in ODF documents, like a PDF? Johnny Rosenberg I think the best thing was if every character was included in every font, but I realise that it probably isn't realistic. 102 012 code points are specifically defined as glyphs in Unicode 5.0; 137 468 code points are reserved for private use glyphs. There is an informal arrangement that specific glyphs are assigned to specific code points. Thus, a complete font will contain a minimum of 239 480 glyphs. Variants could easily double that number. ( All this is before one considers the book, italic, oblique, bold, black, etc. attributes, each of which is, when correctly done, a different glyph.) Creating even a simple set, that doesn't have the variants, much less different attributes, is a daunting task. Code 2000, arguably the most comprehensive font that is easily available, barely covers the entire Unicode 4.0 Plane 0, with 51 239 characters (61 864 glyphs). GNU Unifont contains 63 446 characters (63 446 glyphs) jonathon -- Ethical conduct is a vice. Corrupt conduct is a virtue. Guiding principles of the legal and ethical system of Nacarima. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Some characters invisible with OpenOffice.org 3.2 RC1. Bug?
Okay, that was a lot of text… ;D 2010/1/2 John Jason Jordan johnjas...@gmail.com: On Fri, 1 Jan 2010 22:34:03 +0100 Johnny Rosenberg gurus.knu...@gmail.com dijo: I don't know what operating system you are running, but in mine, Ubuntu 8.10, the character map (gucharmap) is installed by default. If you have it, just copy the character, switch to the character map, press Ctrl+f (find) and paste it there. Then hit the find button (or is it Search?), the character will be found and there is the character code. Just a word of warning about gucharmap. It displays the glyphs in the regular version of the font, but when you click on Italic, Bold, or Bold-Italic it does not go out and load the respective fonts. All it does is fake the attribute based on the regular version of the font. Thus, it may lead you to believe that a glyph is in the italic, bold or bold-italic versions of a font when the glyph is actually not there at all. I've been badly bitten by this in the past, therefore I never use gucharmap. In case you don't have it, here they are (all the musical symbols are located at U+1D100 – U+1D1FF): 턞 → U+1D11E 턆 → U+1D106 턇 → U+1D107 ♯ → U+266F ♭ → U+266D 턁 → U+1D101 턎 → U+1D10E 턂 → U+1D102 Obviously ♭ and ♯ are not among the musical symbols, and it was stupid of me to bring them up in my example, since they are not among those characters that disappear when switching to Bold. OK, looking in FontForge none of the glyphs are in any of the FreeSans fonts, not even the sharp and flat. In fact, I checked several other fonts that I have installed and didn't find any with those glyphs (although quite a number had the sharp and flat). I would suggest that you might have more reliable output from OOo if you actually set the musical characters with the font that OOo is stealing them from (Euterpe, or whatever it turns out to be). Well… then there is another problem in this particular case. The spreadsheet I am working on is for creating a personal keyboard layout. ON one sheet I enter what characters I want on what key (4 different characters for each key, for example p=p, Shift+p=P, AltGr+p=π and Shift+AltGr+p=℗). The user just enter characters on that sheet, and another sheet konverts to the U+hex form and a third sheet converts from U+hex form to ”description form”, you know words like ”apostroph”, ”dead_macron” and so on, if they exists. The thing is not finished yet, but my idea is that a macro should create a keyboard variant adding lines to /usr/share/X11/xkb/symbols/the file of your choice, in my case ”se”, /usr/share/X11/xkb/rules/evdev.lst and /usr/share/X11/xkb/rules/evdev..xml (or actually first copy them to a local place and then add to the copy and then crate a script that the user can run for installing the new keyboard layout). So this needs to be easy to work with, like just entering characters to a spreadsheet and then pressing a button starting a macro and finally running the script for installation. I think that is advanced enough for most users… Maybe I can let the macro run the script too, I don't know yet if that's possible and safe and how to handle the user's password… OOo has the marvelous ability to record macros, Actually the macro recorder sucks, so I never use it, but please go on… ;D which can be assigned to keystrokes. So just turn on the macro recorder, insert the glyph (via its Unicode value), set it to the correct font, and save the macro. Assign the macro to a special keystroke (like Ctrl+Shift+something). Whenever you want that character just use the special keystroke. It will be faster and more reliable. But I would need thousands of macros then, wouldn't I? I don't know which characters other users will want to use for their keyboard layouts… I actually think it's a good thing that missing characters are substituted. I think the best thing was if every character was included in every font, but I realise that it probably isn't realistic. So it's great not having to have more than one font selected in a text, even if there are a few extra symbols that are not in the currently selected font. Some times when I look for new exiting fonts I get very disappointed since only a few characters are included. I write most stuff in Swedish (which is my main language) and as far as I have seen, characters necessary for writing in Swedish (åäöÅÄÖ) are missing pretty often. Now, it doesn't help much to substitute them with the same character form a different font, because they won't look right anyway, but in some cases it will work to substitute missing characters, for example those musical characters; it doesn't matter if I ise FreeMono, FreeSans or FreeSerif, a g-clef will look the same anyway. I understand that most users like the automatic glyph substitution. It's probably OK for the typical user. But I do a lot of desktop publishing. Substituting glyphs from another font is a serious no-no. Yes, but I am probably more like ”most users” than
Re: [users] [moderated]
2010/1/2 jomali jomali3...@gmail.com: What photo handling program does Microsoft Office have? What do you want to do with such a program? John On Sat, Jan 2, 2010 at 8:05 AM, John Neale stony.ne...@googlemail.comwrote: Does open office have a photo handling program like Microsoft office has. No, but there are tons of them out there waiting for you to search for them. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Some characters invisible with OpenOffice.org 3.2 RC1. Bug?
2010/1/1 NoOp gl...@sbcglobal.net: On 12/31/2009 04:13 PM, Johnny Rosenberg wrote: 2009/12/31 NoOp snip: On 12/31/2009 11:12 AM, NoOp wrote: On 12/31/2009 10:27 AM, Johnny Rosenberg wrote: ... I am on Ubuntu 8.10,by the way, I'm not sure I mentioned that… My other machine, which is running OpenOffice.org 3.1, has Ubuntu 9.10, and no issues with FreeSans or any other (I think) fonts. Then probably JJJ has a valid point: https://launchpad.net/ubuntu/+source/ttf-freefont Jaunty Intrepid use ttf-freefont (20080323-3) Download try the 2009 version see if that fixes the problem: http://packages.ubuntu.com/source/karmic/ttf-freefont Sorry, I gave you the link to the source, here is the deb: http://packages.ubuntu.com/karmic/ttf-freefont Okay, thanks. Seems like it was something wrong with the fonts after all. After installing the new ones all characters are now visible. Thanks! Regards Johnny Rosenberg Actually you might want to thank John Jason Jordan (JJJ) as he's the one the suggested changing the font... I just led you to where it is :-) Well, I didn't express myself very clear, but my intention was to thank everyone for contributing with ideas and testing, but of course JJJ deserves an extra thank for solving my problem. Thanks again JJJ, if you read this! Regards Johnny Rosenberg All the best Happy New Year(s). Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Some characters invisible with OpenOffice.org 3.2 RC1. Bug?
2010/1/1 Johnny Rosenberg gurus.knu...@gmail.com: 2010/1/1 NoOp gl...@sbcglobal.net: On 12/31/2009 04:13 PM, Johnny Rosenberg wrote: 2009/12/31 NoOp snip: On 12/31/2009 11:12 AM, NoOp wrote: On 12/31/2009 10:27 AM, Johnny Rosenberg wrote: ... I am on Ubuntu 8.10,by the way, I'm not sure I mentioned that… My other machine, which is running OpenOffice.org 3.1, has Ubuntu 9.10, and no issues with FreeSans or any other (I think) fonts. Then probably JJJ has a valid point: https://launchpad.net/ubuntu/+source/ttf-freefont Jaunty Intrepid use ttf-freefont (20080323-3) Download try the 2009 version see if that fixes the problem: http://packages.ubuntu.com/source/karmic/ttf-freefont Sorry, I gave you the link to the source, here is the deb: http://packages.ubuntu.com/karmic/ttf-freefont Okay, thanks. Seems like it was something wrong with the fonts after all. After installing the new ones all characters are now visible. Thanks! Regards Johnny Rosenberg Actually you might want to thank John Jason Jordan (JJJ) as he's the one the suggested changing the font... I just led you to where it is :-) Well, I didn't express myself very clear, but my intention was to thank everyone for contributing with ideas and testing, but of course JJJ deserves an extra thank for solving my problem. Thanks again JJJ, if you read this! Regards Johnny Rosenberg All the best Happy New Year(s). Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Even this new version of FreeSans seems to be incomplete. Characters like musical symbols doesn't show up when Bold or Italic, but FreeSans Normal works fine. Those characters are, among others: 턞턆턇♯♭턁턎턂 (Hopefully they display in this email). Well, it's not an OpenOffice.org issue, but rather an FreeFonts issue, I guess, so my problem is solved anyway, in the way that I now know why this happens. Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Some characters invisible with OpenOffice.org 3.2 RC1. Bug?
2010/1/1 John Jason Jordan johnjas...@gmail.com: On Fri, 1 Jan 2010 17:19:36 +0100 Johnny Rosenberg gurus.knu...@gmail.com dijo: 2010/1/1 Johnny Rosenberg gurus.knu...@gmail.com: 2010/1/1 NoOp gl...@sbcglobal.net: On 12/31/2009 04:13 PM, Johnny Rosenberg wrote: 2009/12/31 NoOp snip: On 12/31/2009 11:12 AM, NoOp wrote: On 12/31/2009 10:27 AM, Johnny Rosenberg wrote: ... I am on Ubuntu 8.10,by the way, I'm not sure I mentioned that… My other machine, which is running OpenOffice.org 3.1, has Ubuntu 9.10, and no issues with FreeSans or any other (I think) fonts. Then probably JJJ has a valid point: https://launchpad.net/ubuntu/+source/ttf-freefont Jaunty Intrepid use ttf-freefont (20080323-3) Download try the 2009 version see if that fixes the problem: http://packages.ubuntu.com/source/karmic/ttf-freefont Sorry, I gave you the link to the source, here is the deb: http://packages.ubuntu.com/karmic/ttf-freefont Okay, thanks. Seems like it was something wrong with the fonts after all. After installing the new ones all characters are now visible. Thanks! Regards Johnny Rosenberg Actually you might want to thank John Jason Jordan (JJJ) as he's the one the suggested changing the font... I just led you to where it is :-) Well, I didn't express myself very clear, but my intention was to thank everyone for contributing with ideas and testing, but of course JJJ deserves an extra thank for solving my problem. Thanks again JJJ, if you read this! Regards Johnny Rosenberg All the best Happy New Year(s). Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Even this new version of FreeSans seems to be incomplete. Characters like musical symbols doesn't show up when Bold or Italic, but FreeSans Normal works fine. Those characters are, among others: 턞턆턇♯♭턁턎턂 (Hopefully they display in this email). Well, it's not an OpenOffice.org issue, but rather an FreeFonts issue, I guess, so my problem is solved anyway, in the way that I now know why this happens. It is not at all unusual for a font designer to include more glyphs in the Regular version of a face than in the italic, bold, and bold-italic fonts. I am testing your 턞턆턇♯♭턁턎턂 glyphs with Scribus, which will not fake a glyph. I find that none of these glyphs appear in even the Regular version of FreeSans. That is, OOo is faking the glyphs by borrowing them from some other font. I wish I knew how it does this, because it drives me nuts. As for why OOo does this, it does it because MS Office has always done so. And on recent versions of the MacOS the ability to substitute a glyph from another font for a missing glyph in the font being used is built into the operating system. Apparently users find this feature useful. Can you post the Unicode values for the glyphs above? With the Unicode values I can check the font in FontForge and then we'll know for sure if the font contains the glyphs. I don't know what operating system you are running, but in mine, Ubuntu 8.10, the character map (gucharmap) is installed by default. If you have it, just copy the character, switch to the character map, press Ctrl+f (find) and paste it there. Then hit the find button (or is it Search?), the character will be found and there is the character code. In case you don't have it, here they are (all the musical symbols are located at U+1D100 – U+1D1FF): 턞 → U+1D11E 턆 → U+1D106 턇 → U+1D107 ♯ → U+266F ♭ → U+266D 턁 → U+1D101 턎 → U+1D10E 턂 → U+1D102 Obviously ♭ and ♯ are not among the musical symbols, and it was stupid of me to bring them up in my example, since they are not among those characters that disappear when switching to Bold. I actually think it's a good thing that missing characters are substituted. I think the best thing was if every character was included in every font, but I realise that it probably isn't realistic. So it's great not having to have more than one font selected in a text, even if there are a few extra sy,bols that are not in the currently selected font. Some times when I look for new exiting fonts I get very disappointed since only a few characters are included. I write most stuff in Swedish (which is my main language) and as far as I have seen, characters necessary for writing in Swedish (åäöÅÄÖ) are missing pretty often. Now, it doesn't help much to substitute them with the same character form a different font, because they won't look right anyway, but in some cases it will work to substitute missing characters, for example those musical characters; it doesn't matter if I ise FreeMono, FreeSans or FreeSerif, a g-clef will look the same anyway. Anyway, years ago I missed those musical characters on my Ubuntu system, so I installed one called Euterpe. Since then I have had them, so I suspected that OpenOffice.org used those when needed, BUT when I
Re: [users] Re: Some characters invisible with OpenOffice.org 3.2 RC1. Bug?
2009/12/30 NoOp gl...@sbcglobal.net: On 12/30/2009 01:57 PM, Johnny Rosenberg wrote: I have a calc document created with earlier versions of OpenOffice.org, for example OpenOffice.org 3.1. When I opened the file with OpenOffice.org 3.2 RC1 I noticed that some characters was ”invisible”. I couldn't see them in the cells and I couldn't see them in the input line. Font: FreeSans Characters: ₍₎⁽⁾₊⁺₋⁻ If you can't see them, they are: Left parenthesis subscript (U+208D) Right parenthesis subscript (U+208E) Left parenthesis superior (U+207D) Right parenthesis superior (U+207E) Plus subscript (U+208A) Plus superior (U+207A) Minus subscript (U+208B) Minus superior (U+207B) I changed the font to DejaVuSans and the characters appeared again. I also tried a few different font, but they all work except my favourite font FreeSans. All the caracters look fine with FreeSans in older versions of OpenOffice.org and I also tried with gedit. Worked fine there too. Can anyone confirm (or deny) that this is a bug in OpenOffice.org 3.2 RC1? Regards Johnny Rosenberg Works for me when entered directly and/org when copied from your message into Calc Writer. $ cat /opt/openoffice.org/basis3.2/program/versionrc [Version] buildid=320m8(Build:9472) OOOBaseVersion=3.2 OOOPackageVersion=3.2.0 ProductBuildid=9472 ProductMajor=320 ProductMinor=8 ProductSource=OOO320 Send me a test file I'll be happy to test. I just made one for everyone to test: Here's the ODF version: http://hem.bredband.net/guraknugen/FreeSansOpenOffice.org3.2.ods And here's how it looks for me, which is the PDF version: http://hem.bredband.net/guraknugen/FreeSansOpenOffice.org3.2.pdf Note that I found some strange behaviour when experimenting with bold and italic text. Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Some characters invisible with OpenOffice.org 3.2 RC1. Bug?
2009/12/31 NoOp gl...@sbcglobal.net: On 12/31/2009 03:49 AM, Johnny Rosenberg wrote: 2009/12/30 NoOp ... Works for me when entered directly and/org when copied from your message into Calc Writer. $ cat /opt/openoffice.org/basis3.2/program/versionrc [Version] buildid=320m8(Build:9472) OOOBaseVersion=3.2 OOOPackageVersion=3.2.0 ProductBuildid=9472 ProductMajor=320 ProductMinor=8 ProductSource=OOO320 Send me a test file I'll be happy to test. I just made one for everyone to test: Here's the ODF version: http://hem.bredband.net/guraknugen/FreeSansOpenOffice.org3.2.ods And here's how it looks for me, which is the PDF version: http://hem.bredband.net/guraknugen/FreeSansOpenOffice.org3.2.pdf Note that I found some strange behaviour when experimenting with bold and italic text. Works for me. FreeSans and FreeMono have the underlining issues, but other than that they all seem to render OK. So some characters are missing when underlining? Well, then SOMETHING is bad then isn't it? If not, I guess something in my system is bad. Any suggestions for what to be the next step in debugging? I am on Ubuntu 8.10,by the way, I'm not sure I mentioned that… My other machine, which is running OpenOffice.org 3.1, has Ubuntu 9.10, and no issues with FreeSans or any other (I think) fonts. Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Some characters invisible with OpenOffice.org 3.2 RC1. Bug?
2009/12/31 Programmer In Training p...@joseph-a-nagy-jr.us: Keeping it on the list Sorry, I didn't realize that I only sent it to you. Normaly I only need to hit Reply to reply to the list, but this time this didn't work, obviously. I think the reason for that might be that you wrote to the list AND to me. I am subscribed, so you don't need to add me to the ”to:” field. Regards Johnny Rosenberg On 12/31/2009 12:33 PM, Johnny Rosenberg wrote: 2009/12/31 Programmer In Training p...@joseph-a-nagy-jr.us: snip Have you considered that the issue might be with Ubuntu 8.10 and not OOo? Have you tried the rc for OOo 3.2 on Ubuntu 9.10? If so, are the results the same? If so then it is probably a bug with OOo. If not (e.g. the fonts display fine on Ubuntu 9.10), then the problem probably lies with one of Ubuntu's systems. Just an educated guess. I have had that thought but not yet installed the RC on my Ubuntu 9.10 system, but I will soon. I'll come back with additional comments about that. Johnny Rosenberg Thanks, let us all know what the results are. (: - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Some characters invisible with OpenOffice.org 3.2 RC1. Bug?
2009/12/31 NoOp gl...@sbcglobal.net: On 12/31/2009 10:27 AM, Johnny Rosenberg wrote: 2009/12/31 NoOp : Works for me. FreeSans and FreeMono have the underlining issues, but other than that they all seem to render OK. So some characters are missing when underlining? Well, then SOMETHING is bad then isn't it? If not, I guess something in my system is bad. Any suggestions for what to be the next step in debugging? I am on Ubuntu 8.10,by the way, I'm not sure I mentioned that… My other machine, which is running OpenOffice.org 3.1, has Ubuntu 9.10, and no issues with FreeSans or any other (I think) fonts. No, not missing, but the underlines are as shown in your pdf; the underline is not perfectly _under_ the character. I'm on 9.10, I'll fire up an 8.10 later and test. Well, the subscript parentheses are probably supposed to cross the underline for some fonts, so I'm not sure that is an issue. _x₍₁₊₂₋₃₎_ _x⁽¹⁺²⁻³⁾_ Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Some characters invisible with OpenOffice.org 3.2 RC1. Bug?
2009/12/31 Johnny Rosenberg gurus.knu...@gmail.com: 2009/12/31 NoOp gl...@sbcglobal.net: On 12/31/2009 10:27 AM, Johnny Rosenberg wrote: 2009/12/31 NoOp : Works for me. FreeSans and FreeMono have the underlining issues, but other than that they all seem to render OK. So some characters are missing when underlining? Well, then SOMETHING is bad then isn't it? If not, I guess something in my system is bad. Any suggestions for what to be the next step in debugging? I am on Ubuntu 8.10,by the way, I'm not sure I mentioned that… My other machine, which is running OpenOffice.org 3.1, has Ubuntu 9.10, and no issues with FreeSans or any other (I think) fonts. No, not missing, but the underlines are as shown in your pdf; the underline is not perfectly _under_ the character. I'm on 9.10, I'll fire up an 8.10 later and test. Well, the subscript parentheses are probably supposed to cross the underline for some fonts, so I'm not sure that is an issue. _x₍₁₊₂₋₃₎_ _x⁽¹⁺²⁻³⁾_ Johnny Rosenberg Just installed the RC on the other machine (Eee PC 900 with Ubuntu 9.10) and it works as it should. I can see all the characters. Maybe something in my Ubuntu 8.10 system that causing my problems then. Well, I guess that will make me finally upgrade to the latest Ubuntu after all… (or maybe I'll try Linux Mint this time, it looked promising when I tested it a couple of days ago). Thanks for you help! Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Some characters invisible with OpenOffice.org 3.2 RC1. Bug?
2009/12/31 NoOp gl...@sbcglobal.net: On 12/31/2009 11:12 AM, NoOp wrote: On 12/31/2009 10:27 AM, Johnny Rosenberg wrote: ... I am on Ubuntu 8.10,by the way, I'm not sure I mentioned that… My other machine, which is running OpenOffice.org 3.1, has Ubuntu 9.10, and no issues with FreeSans or any other (I think) fonts. Then probably JJJ has a valid point: https://launchpad.net/ubuntu/+source/ttf-freefont Jaunty Intrepid use ttf-freefont (20080323-3) Download try the 2009 version see if that fixes the problem: http://packages.ubuntu.com/source/karmic/ttf-freefont Sorry, I gave you the link to the source, here is the deb: http://packages.ubuntu.com/karmic/ttf-freefont Okay, thanks. Seems like it was something wrong with the fonts after all. After installing the new ones all characters are now visible. Thanks! Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Some characters invisible with OpenOffice.org 3.2 RC1. Bug?
I have a calc document created with earlier versions of OpenOffice.org, for example OpenOffice.org 3.1. When I opened the file with OpenOffice.org 3.2 RC1 I noticed that some characters was ”invisible”. I couldn't see them in the cells and I couldn't see them in the input line. Font: FreeSans Characters: ₍₎⁽⁾₊⁺₋⁻ If you can't see them, they are: Left parenthesis subscript (U+208D) Right parenthesis subscript (U+208E) Left parenthesis superior (U+207D) Right parenthesis superior (U+207E) Plus subscript (U+208A) Plus superior (U+207A) Minus subscript (U+208B) Minus superior (U+207B) I changed the font to DejaVuSans and the characters appeared again. I also tried a few different font, but they all work except my favourite font FreeSans. All the caracters look fine with FreeSans in older versions of OpenOffice.org and I also tried with gedit. Worked fine there too. Can anyone confirm (or deny) that this is a bug in OpenOffice.org 3.2 RC1? Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Sorting and grouping ?
2009/12/24 William Case billli...@rogers.com: Hi; I may be having a brain cramp but ... In Calc, how do I group some rows together before sorting? For example, I have a small set of data like Col:A Col:B Col:C Col:D row1 jkdfa dsajh ociv row2 djafsh ire q.e ab row3 cd row4 ef row5 zpdd uwen qerw I want to sort on Col:A, however I want to somehow group rows 2, 3 4 together so that at the end of the sort rows 2, 3 4 are still contiguous. I am sure there is a way to do this that I have forgotten. If a help explanation exists, then I have also forgotten the correct help index criteria (word) to search under. I am actually not sure this is possible, but here's a workaround: Your spreadsheet looks like this: Col:A Col:B Col:C Col:D row1 jkdfa dsajh ociv row2 djafsh ire q.e ab row3 cd row4 ef row5 zpdd uwen qerw Make it look like this instead: Col:A Col:B Col:C Col:D row1 jkdfa dsajh ociv row2 djafsh ire q.e ab row3 djafsh ire q.e cd row4 djafsh ire q.e ef row5 zpdd uwen qerw Now, use conditional formatting to make a cell look empty if the cell above it has the same content: Create a style that use the same character colour as the background colour. In the conditional formatting dialogue, select ”cell value is” and enter the following (for A2 in this case): =A1 Then select your new style that should be selected if the statement is true. Johnny Rosenberg A reminder in either case would be helpful -- am starting to get frustrated. -- Regards Bill Fedora 12, Gnome 2.28 Evo.2.28, Emacs 23.1.1 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Free Downloading
2009/12/22 jim walker captjimwal...@yahoo.com: Hello there, I hope you are well. I recently attempted to download your office program so that I could use it and it appears to have been unsuccessful? I also loaded Java. Do I need to register? Log in? How can I tell if it works and how do you do it? Please help w/info. Thanks, Jim You didn't mention any details, like what operating system you use and so on, so I assume your operating system is Ubuntu Linux (since that's the only operating system I know something about): Just click System → Administration → Synaptic package manager, enter your password and search for OpenOffice.org with the quick search thing. Select OpenOffice.org and Synaptic will select everything that's necessary to also install for you. Look through the list to see if there is anything else you want to install, like a thesaurus in your language and things like that. Then click the Apply button and everything will be installed automatically. You'll find most of the OpenOffice.org applications at Programs → Office. I think you'll find OpenOffice.org Draw at Programs → Graphics though. If your operating system is not Ubuntu Linux, then this probably won't work. Then you have to use your web browser and download it manually from the OpenOffice.org web page, and it all will be slightly more complicated. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Replacing fonts in ODT
I have an ODT that is a mess. Originally I used Arial and Courier New as the two main fonts in it, but since I found that FreeSans and FreeMono are more suitable for me, I changed all styles that I use in the document to the new fonts. However, some sentences are a mix of the two fonts and here and there the old fonts are present. Since this is a real mess, it would take very long time to correct. I figured out how to search for a font, but not how to replace it with another one. So what I did was to unzip the document and replace the fonts using a text editor (gedit) instead. I zipped it again and renamed it to Filename.odt. Unfortunately I can not open the document anymore. OpenOffice.org Writer says that the document is corrupt… This is only a copy of the original document, so I still have the original document, so that's not a problem. What I want to know now is if anyone have a better idea how to do this. If using a text editor, in which ones of the all xml files can I search and replace font names, and which ones should I leave as is? I did a search and replace in every xml file in which I could find the word ”Arial” and/or ”Courier New”, but that was obviously not optimal… As I said, I always do this kind of stuff on a copy of the original file, so I can be quite experimental without losing anything. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Replacing fonts in ODT
2009/12/20 Jean-Baptiste Faure jbf.fa...@laposte.net: Le 20.12.2009 12:35, Johnny Rosenberg a écrit : I have an ODT that is a mess. Originally I used Arial and Courier New as the two main fonts in it, but since I found that FreeSans and FreeMono are more suitable for me, I changed all styles that I use in the document to the new fonts. However, some sentences are a mix of the two fonts and here and there the old fonts are present. Since this is a real mess, it would take very long time to correct. I figured out how to search for a font, but not how to replace it with another one. So what I did was to unzip the document and replace the fonts using a text editor (gedit) instead. I zipped it again and renamed it to Filename.odt. Unfortunately I can not open the document anymore. OpenOffice.org Writer says that the document is corrupt… This is only a copy of the original document, so I still have the original document, so that's not a problem. What I want to know now is if anyone have a better idea how to do this. If using a text editor, in which ones of the all xml files can I search and replace font names, and which ones should I leave as is? I did a search and replace in every xml file in which I could find the word ”Arial” and/or ”Courier New”, but that was obviously not optimal… As I said, I always do this kind of stuff on a copy of the original file, so I can be quite experimental without losing anything. Johnny Rosenberg Hi Johnny, You can do that with Altsearch extension : http://extensions.services.openoffice.org/project/AltSearch Thanks. Going to check it out. If you want replace Arial font by DejaVu Serif font, set the following fields: Find field : [:::CharFontName=Arial::] Replace field : \A{CharFontName=DejaVu Serif} check Regular expressions DejaVu fonts are too wide for my taste, but I understand what you mean. What's the ”\A” for? On the other hand, if you do not have to preserve some different font definition, you can select the whole text, then right click and choose default formatting. Well, my document is mainly a mix of two fonts: Arial and Courier New. Arial for explaining text and Courier New for code and commands. I have replaced Arial by FreeSans and Courier New by FreeMono, but there are still fragments of text with at least the Arial font, so I can't select all and select FreeSans for everything, because that means that I have a lot of work to do to manually change many parts of the text to FreeMono. Regards JBF Thanks, Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Replacing fonts in ODT
2009/12/20 Jean-Baptiste Faure jbf.fa...@laposte.net: Le 20.12.2009 12:35, Johnny Rosenberg a écrit : I have an ODT that is a mess. Originally I used Arial and Courier New as the two main fonts in it, but since I found that FreeSans and FreeMono are more suitable for me, I changed all styles that I use in the document to the new fonts. However, some sentences are a mix of the two fonts and here and there the old fonts are present. Since this is a real mess, it would take very long time to correct. I figured out how to search for a font, but not how to replace it with another one. So what I did was to unzip the document and replace the fonts using a text editor (gedit) instead. I zipped it again and renamed it to Filename.odt. Unfortunately I can not open the document anymore. OpenOffice.org Writer says that the document is corrupt… This is only a copy of the original document, so I still have the original document, so that's not a problem. What I want to know now is if anyone have a better idea how to do this. If using a text editor, in which ones of the all xml files can I search and replace font names, and which ones should I leave as is? I did a search and replace in every xml file in which I could find the word ”Arial” and/or ”Courier New”, but that was obviously not optimal… As I said, I always do this kind of stuff on a copy of the original file, so I can be quite experimental without losing anything. Johnny Rosenberg Hi Johnny, You can do that with Altsearch extension : http://extensions.services.openoffice.org/project/AltSearch Have tried it now. Installed it, found it at Tools → Add-Ons, klicked it and… Well, still waiting for anything to happen. OpenOffice.org 3.1.1, vanilla version, on Ubuntu 8.10. Johnny Rosenberg If you want replace Arial font by DejaVu Serif font, set the following fields: Find field : [:::CharFontName=Arial::] Replace field : \A{CharFontName=DejaVu Serif} check Regular expressions On the other hand, if you do not have to preserve some different font definition, you can select the whole text, then right click and choose default formatting. Regards JBF -- Jean-Baptiste Faure French N-L project Lead http://fr.openoffice.org Seuls des formats ouverts peuvent assurer la pérennité de vos documents. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Replacing fonts in ODT
2009/12/20 TomW tomw...@ctel.net: Johnny Rosenberg wrote: 2009/12/20 Jean-Baptiste Faure jbf.fa...@laposte.net: Le 20.12.2009 12:35, Johnny Rosenberg a écrit : I have an ODT that is a mess. Originally I used Arial and Courier New as the two main fonts in it, but since I found that FreeSans and FreeMono are more suitable for me, I changed all styles that I use in the document to the new fonts. However, some sentences are a mix of the two fonts and here and there the old fonts are present. Since this is a real mess, it would take very long time to correct. I figured out how to search for a font, but not how to replace it with another one. So what I did was to unzip the document and replace the fonts using a text editor (gedit) instead. I zipped it again and renamed it to Filename.odt. Unfortunately I can not open the document anymore. OpenOffice.org Writer says that the document is corrupt… This is only a copy of the original document, so I still have the original document, so that's not a problem. What I want to know now is if anyone have a better idea how to do this. If using a text editor, in which ones of the all xml files can I search and replace font names, and which ones should I leave as is? I did a search and replace in every xml file in which I could find the word ”Arial” and/or ”Courier New”, but that was obviously not optimal… As I said, I always do this kind of stuff on a copy of the original file, so I can be quite experimental without losing anything. Johnny Rosenberg Hi Johnny, You can do that with Altsearch extension : http://extensions.services.openoffice.org/project/AltSearch Have tried it now. Installed it, found it at Tools → Add-Ons, klicked it and… Well, still waiting for anything to happen. OpenOffice.org 3.1.1, vanilla version, on Ubuntu 8.10. Johnny Rosenberg If you want replace Arial font by DejaVu Serif font, set the following fields: Find field : [:::CharFontName=Arial::] Replace field : \A{CharFontName=DejaVu Serif} check Regular expressions On the other hand, if you do not have to preserve some different font definition, you can select the whole text, then right click and choose default formatting. Regards JBF -- Jean-Baptiste Faure French N-L project Lead http://fr.openoffice.org Seuls des formats ouverts peuvent assurer la pérennité de vos documents. - To unsubscribe, e-mail: users-unsubscr...@openoffice. Johnny: I found I had to exit the software, close the quickstarter. then reopen OOO before the extension would become functional. TomW I don't use a quickstarter (I am not even sure there is one for Ubuntu. However, I had a spreadsheet open so closing the Writer document and restarting it wasn't enough. Also closing the Spreadsheet helped. Someone perhaps need to take a look at the language of the add-on: ”…was founded 85 times” sounds funny… I guess it should be ”found”, right? Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Formatting code for days HH:MM
I have two dates and I want to calculate how many days, hours and minutes it is between them. The dates are 2009-12-22 16:00 and 2010-01-04 07:00, and as all of you already know it's 12 days and 15 hours between them. But since 12 means ”12th day since 1899-12-30” the result of this calculation is 11 15:00 when formatted as ”DD HH:MM”. I didn't find a way to get around this by formatting only. For example ”0 HH:MM” didn't work. Any suggestions? ”DD HH:MM” will probably work in Excel since 0 in Excel is 1899-12-31, which also means that Calc dates are the same as Excel dates 1900-03-01 - ∞, but not before that date (Excel thinks that 1900 is a leap year). So I guess this was the reason for having 1899-12-30 as day 0 instead of 1899-12-31, right? At least it makes sense. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Formatting code for days HH:MM
2009/12/19 Brian Barker b.m.bar...@btinternet.com: At 14:07 19/12/2009 +0100, Johnny Rosenberg wrote: I have two dates and I want to calculate how many days, hours and minutes it is between them. The dates are 2009-12-22 16:00 and 2010-01-04 07:00, and as all of you already know it's 12 days and 15 hours between them. But since 12 means 12th day since 1899-12-30 the result of this calculation is 11 15:00 when formatted as DD HH:MM. Indeed: as you suggest, DD here refers to a date, not a number of days. I didn't find a way to get around this by formatting only. For example 0 HH:MM didn't work. Any suggestions? No. In any case, since DD represents a date, it could never work for intervals of 32 days or more. My best effort is: =TEXT(INT(DAYS(B1;A1));00 )TEXT(DAYS(B1;A1)-INT(DAYS(B1;A1));HH:MM) Thanks. That didn't work when characters set as Swedish (which is the default on my machine), since ” ” is the thousands delimiter. 15706 days shows up as 16 days… But of course I found a solution: =TEXT(INT(DAYS(B1;A1));0) TEXT(DAYS(B1;A1)-INT(DAYS(B1;A1));HH:MM) Thanks for the hint. I didn't know about the TEXT function, that you could specify a format code in it. Will probably be useful for me in the future. DD HH:MM will probably work in Excel since 0 in Excel is 1899-12-31, which also means that Calc dates are the same as Excel dates 1900-03-01 - ?, but not before that date (Excel thinks that 1900 is a leap year). Even so, an interval of 32 days would show as 1 (representing 1 February 1900) and so on. Yes, you are right. But it would be really nice if ”0 HH:MM” worked. It would be very elegant. Johnny Rosenberg Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc: remove ' character before number
2009/12/17 Dotan Cohen dotanco...@gmail.com: I have a spreadsheet with 1375 rows. One of the colums is a time column, with the format 'hh:mm:ss. Note the leading ' sign. In order to sum this column, I need to remove this character. However, the search and replace dialogue s not recognize this character. How can I remove them all easily? Thanks in advance. -- Dotan Cohen I experimented with a macro that I wrote for this purpose and I found something strange. I wrote a macro that automatically removed all quotes in a selection or the whole current sheet, and it works on my example file. However, it doesn't work on your file. And there's more: Opening my example file I can see numbers in a lot of cells. When selecting a cell, the input line shows, for example: '285 The cell itself displays: 285 BUT… when I manually enter '285 in a cell, that cell actually displays '285, not 285! I also deleted the ' character only and then typed the ' manually without changing the numbers. Same thing! The cell displays the '. I wrote my macro for OpenOffice.org 1.1, or possibly 2.0. Maybe things happened since then? I can see that the function getDataArray() for a cell returns an array with all the numbers, but no '. The same thing with getFormulaArray() for some reason… So I actually don't know how to find the damn ' in your file with a macro. Seems like a huge bug to me. That is if there is no way to detect the ', not just that I couldn't find it. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] NotEqual for SUMIF? does not work
2009/12/17 Dotan Cohen dotanco...@gmail.com: I need to test if the content of a cell is _not_ a certain alphanumerical value. How can I do this? The below code does not work: =SUMIF(F2:F1388; value; G2:G1388) I think you put the quotes at the wrong place. =SUMIF(F2:F1388; value; G2:G1388) where ”value” is a value, for example: =SUMIF(F2:F1388; 3; G2:G1388) or =SUMIF(F2:F1388; A1; G2:G1388) The last one concatenates ”” with whatever is in A1. I think A1 needs to be a number, though. Johnny Rosenberg Thanks in advance. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] To use Alt-* or Ctrl-* for keyboard shortcuts?
2009/12/13 Harold Fuchs hwfa.openoff...@googlemail.com: Dotan Cohen wrote: Many of OOo's menus have keyboard shortcuts underlined. How is the user supposed to know if the modifier key for the shortcut is Ctrl-* or Alt-*? As far as I know, in *Windows* an underlined letter in a menu item *always* means Alt and the letter. If OOo does not follow this convention then I think its authors are in breach of covenant. Can't comment on Linux or Mac though. Seems to be Alt on Linux too. Johnny Rosenberg -- Harold Fuchs London, England Please reply *only* to users@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Mathematical division sign.
2009/12/11 M Henri Day mhenri...@gmail.com: 2009/12/10 Johnny Rosenberg gurus.knu...@gmail.com 2009/12/10 James Wilde james.wi...@sunde-wilde.com: On Dec 10, 2009, at 08:27 , Thomas Lange - Sun Germany - ham02 - Hamburg wrote: Hmm... In that case it must be either my Sun Keyboard or the Sunray rdesktop remote session that is preventing it for me. ^_- I think the big money would be on the second one, Thomas. There was a time when I was connecting to several machines via remote desk top or vnc and similar, and in some combinations I was unable to type any of the Alt-Gr key combinations. The only way I found to resolve this was to have a small text file on the remote machines, containing all the symbols I used most often, and have it permanently open on the remote machine so I could quickly copy and paste. One such was the bar, |, which is a Alt-Gr combination on the swedish keyboard. Imagine typing 'ps -ef | grep command a hundred times a day with no bar! As I said, it's not a very hard work to make your own keyboard layout in Linux. I did and I have the ”|” at Shift+/. The ”/” is located where normal layouts has ”7” (I keep all my numbers at the numerical part of the keyboard and nowhere else). And yes, I have a Swedish keyboard. Johnny Rosenberg Johnny, your Swedish keyboard has a default shortcut for «|», *viz*, «Alt Gr + the / key», which is platform independent. What's the point in introducing a home-grown version, which may not be ?... Henri I know, but hitting Shift + 7 is easier. But I didn't change my keyboard for the | character. I completely changed just about everything, and while doing it I figured that I could move the | to a somewhat more available place. The main point in doing my own layout was to add more characters, expecially some greek characters, like ωΩαβπ and some useful characters like ‰ ≤ ≥ ⩽ ⩾ ≠ ≈ ⅛ ¼ ⅜ ½ ⅝ ¾ ⅞ ⅓ ⅔ ⅕ ⅖ ⅗ ⅘ ⅙ ⅚ ± ÷ · × ℃ ℉ ℗ and some musical symbols like 턞 (g clef), 턋 턉 and so on… (notice also that the three dots at the end av last sentence are not three single dots, but rather one single character). Well, what more? ⁰¹²³⁴⁵⁶⁷⁸⁹₀₁₂₃₄₅₆₇₈₉ could be useful some time. And I can type arrows with my arrow keys now: ←↑↓→⇨⬄ and I can even type with my Enter key: ↵¶. What about a check box? ☐ And a checked one: ☒ ☠☺☹ A german double s, anyone? ß. And some Icelandic characters: ÐðÞþ. For creating characters like ïÿščşç I use dead keys, so I have to combine ˇ and ¸ respectively with other characters. Okay, a bit out of topic perharps… Sorry. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?
2009/12/11 Andreas Saeger saege...@onlinehome.de: Dotan Cohen wrote: Please, please, this is killing me. $ date +%x 2009-12-08 However, Calc insists on using the mm/dd/yy year format in new documents. The settings under Language are all Default. What must I do to have OOo respect the locale settings? That's strange. I have Ubuntu 8.10 and OpenOffice.org Calc 3.1 (vanilla version - not the Ubuntu version) and the default format seems to be YY-MM-DD, which indeed is the Swedish default format. Which OpenOffice.org language pack is installed on your system? Johnny Rosenberg I know that this issue has been addressed tens of time on the list but I cannot find the answer in the archives.There is a bug (or rather, several) on the issue but I think that I saw a method or workaround posted once on the list but I cannot find it. Your locale setting is Default and your operating system locale is US English. The program accepts your locale using its own setup for this particular locale, so your document will look exactly the same on other systems. It makes no sense to use the current system's customized locale settings when documents have to be exchangable across systems. There is no bug, since the number formatting behaves exactly as it has been designed intentionally. Simply use the given formatting facilities, styles in particular, in order to override the plain defaults. Btw: The format of a number is completely irrelevant as long as the value is the correct number. No calculation result depends on number formatting. 8/12, 12/8, 2009/12/08, it's all the same day number 40155 or 4015500%, $40155.00, 40.155,00€, ... - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc cell formatting: hours
2009/12/11 Dotan Cohen dotanco...@gmail.com: Really, is there no input mask or such? No, I think you should use Base for that. Actually I filed a request for enhancement in this matter (input mask) a few years ago, but obviously the priority of this is not too high… Can you link to the bug, I cannot find it. Thanks. I remembered it wrong: I didn't write the bug report, someone else did. I just commented it (my nick=”guraknugen)… Anyway, here it is: http://www.openoffice.org/issues/show_bug.cgi?id=47906 Johnny Rosenberg -- Dotan Cohen http://what-is-what.com http://gibberish.co.il - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Mathematical division sign.
2009/12/10 James Wilde james.wi...@sunde-wilde.com: On Dec 10, 2009, at 08:27 , Thomas Lange - Sun Germany - ham02 - Hamburg wrote: Hmm... In that case it must be either my Sun Keyboard or the Sunray rdesktop remote session that is preventing it for me. ^_- I think the big money would be on the second one, Thomas. There was a time when I was connecting to several machines via remote desk top or vnc and similar, and in some combinations I was unable to type any of the Alt-Gr key combinations. The only way I found to resolve this was to have a small text file on the remote machines, containing all the symbols I used most often, and have it permanently open on the remote machine so I could quickly copy and paste. One such was the bar, |, which is a Alt-Gr combination on the swedish keyboard. Imagine typing 'ps -ef | grep command a hundred times a day with no bar! As I said, it's not a very hard work to make your own keyboard layout in Linux. I did and I have the ”|” at Shift+/. The ”/” is located where normal layouts has ”7” (I keep all my numbers at the numerical part of the keyboard and nowhere else). And yes, I have a Swedish keyboard. Johnny Rosenberg A similar solution might be to have the remote machines character list visible, assuming that the character table includes all characters and not just, say, extended ascii. Having said that, if you've connected your Sun keyboard to a PC then you may have problems there, too. //James - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc cell formatting: hours
2009/12/10 Dotan Cohen dotanco...@gmail.com: I have a column formatted as HH:MM. When the user enters 14 I need it to be registered as 14:00 assuming a 24-hour clock. How can this be achieved? Thanks. As far as I know you can't to that. Entering 14 means day 14, which is the same as 1900-01-13 00:00:00 (ISO8601 style date format). Really, is there no input mask or such? No, I think you should use Base for that. Actually I filed a request for enhancement in this matter (input mask) a few years ago, but obviously the priority of this is not too high… If you want hours, minutes and anything less than one 24 hour period (called ”1 dygn” in Swedish, by the way - English lacks a proper word for it, I think), numbers 1 are required. For example: Input ”=14/24” in a cell formatted as ”HH:MM” and the cell will display 14:00. In Hebrew we also have the word for 24-hour period. An online dictionary translates it as: nf. a whole day (24 hours) Do other spreadsheets work like this? I think Excel did too, but I haven't used Excel in years, so I can't say anything about more recent versions. I will file a feature request as entering hours into a spreadsheet seem like it would be a rather common operation. Maybe that's what I already did a couple of years ago… Johnny Rosenberg If you can accept a few more characters than just ”14”, you should know that you don't need 00 for the minutes; 14:0 will work. Or 14:7 for 14:07 and so on. It is not much more practical, but thanks for the idea. Not what you are looking for, I know, but as far as I can get without using extra cells and things like that… That would be getting too complicated for what surely _should_ be a simple procedure. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Mathematical division sign.
2009/12/9 M Henri Day mhenri...@gmail.com: 2009/12/9 Ian L. Target ia...@comcast.net PatrickG wrote: Ian L. Target wrote: How does a user get the mathematical division sign, the bar a dot above and below it in an OO module? I ended up having to go to my room mate's computer and firing up Office 97. I know that ASCII code of 0247 to get it in MS Word. I ended up emailing myself a copy of the document with the symbol in it and then opening it in OO Writer. Surely there is an easier way . . . Hold down the ALT key type in 0427 (or the appropriate ascii) using the numpad release the ALT key and it should show up. At least it does here, using Writer (OOo 3.1) on WinXP SP3. Patrick G. It must be a Linux thing then. I was aware and had often used the above mentioned method in winders, but apparently it does not work in Linux versions of OO. Can easily be done on a Linux distribution like Ubuntu Karmic by typing «Ctrl + Shift + u», typing the relevant hexcode (00f7), and then taking Enter or the space bar, thus : ÷ Henri Or on Linux (at least Ubuntu) you can easily define your own keyboard layout. I did and I have it on Shift+/: ÷ (That is ”/” on the numerical part of the keyboard). And I hate to use an x for a multiplication sign, so I added × and · as well. And so on… Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc cell formatting: hours
2009/12/8 Dotan Cohen dotanco...@gmail.com: I have a column formatted as HH:MM. When the user enters 14 I need it to be registered as 14:00 assuming a 24-hour clock. How can this be achieved? Thanks. As far as I know you can't to that. Entering 14 means day 14, which is the same as 1900-01-13 00:00:00 (ISO8601 style date format). If you want hours, minutes and anything less than one 24 hour period (called ”1 dygn” in Swedish, by the way - English lacks a proper word for it, I think), numbers 1 are required. For example: Input ”=14/24” in a cell formatted as ”HH:MM” and the cell will display 14:00. If you can accept a few more characters than just ”14”, you should know that you don't need 00 for the minutes; 14:0 will work. Or 14:7 for 14:07 and so on. Not what you are looking for, I know, but as far as I can get without using extra cells and things like that… Johnny Rosenberg -- Dotan Cohen http://what-is-what.com http://gibberish.co.il - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc formula
2009/12/8 John Meyer pueblonat...@opensuse.us: I have several sheets in a workbook with data in the same format (same columns). I want to take that information from all the sheets and put it in a new sheet. The data is in the same format, but I want a column on the side that tells me from what sheet that information comes from (say, if row 1 comes from Sheet1, I want it to print out Sheet 1). Is that possible with a formula? Have you tried =CELL(…)? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: linux exe
2009/12/9 NoOp gl...@sbcglobal.net: On 12/08/2009 01:25 AM, Ярослав Райченко wrote: ... Thank you, gentlmen, for your advices, leads and links. i downloaded xubuntu and was kicking around installation from hard disk by means of grub4dos. when i have done i wll let you know if you are wondering. regards, Alex Please don't. Instead move the discussion to a linux/Ubuntu list; your experiements have nothing further to do with OOo. But feel free to post back when you do have _OOo_ questions/issues. Well, I'd like to know if he manage to run OpenOffice.org on his old machine and how fast it is, and what version he decides to use. This sounds like a OpenOffice.org matter to me, at least. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc question.?
2009/12/6 James Elliott james.elli...@wn.com.au: In Calc (ver 3.x) I have clicked on something to display a list of functions n the right hand side of my screen. This dialogue box has docked itself to my Calc screen and has no exit button x. How can I get rid of it please? What kind of functions is that? Is it the Ctrl+F2 dialogue? Well, probably not, since that dialogue has a Cancel button… But more details would be nice. Maybe you could upload a screen shot somewhere and give us a link to it? Johnny Rosenberg Many thanks, James - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How Do I Combine 2 Writer Files?
2009/12/6 John Gilchrist ooo.for...@gmail.com: Thank you! This sounds too simple!!! If it sounds too simple, it's probably wrong… But hopefully not in this case… Regards Johnny Rosenberg J. Gilchrist On 12/5/09, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2009/12/5 John Gilchrist ooo.for...@gmail.com: Thank you! I sorely need to study page styles. Where is the best place to read about setting up a page style. I apologize for being so ignorant. I definitely appreciate your help. I am not sure you need to read so much about it. Just hit F11. This will bring up the styles dialogue. On top of that dialogue there are a few icons for different kinds of styles. One of these are for Page styles. Click it and you get a list of all available page styles. Right click one of them to modify or create a new one based on the one you right clicked. Double click a style to apply the style to the currently selected page. If more questions, get back here… ☺ Johnny Rosenberg Sincerely, J. Gilchrist On 12/4/09, Guy Voets nimant...@gmail.com wrote: 2009/12/4 Jay Gilchrist ooo.for...@gmail.com: Dear OOo Users, I want to combine Writer file A and with Writer file B. You know, concatenate 2 files. File A has page margins = 1.00 Left and Right. File B has page margins = 0.79 Left and Right. So, another way to get what I want would be to have page margins A for the first n-pages. Then, have page margins B for all pages after page n. How can I do this? Thank you, John Gilchrist Hello, I would create two page styles, one for the A part, with margins of 1, the other for the B part with the smaller margins. When you drop B behind A, you make a manual page break between them and chose the second style... HTH -- Guy using dutch OOo Aqua 3.1.1 on a iMac Intel DualCore Snow Leopard and brazilian OOo Aqua 3.1.1 on an Intel MacBook Pro Leopard -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Who has a larger organization (100 users) using Open Office?
2009/12/6 Graham Smith myotis...@gmail.com: Try http://www.opensourceacademy.gov.uk/osacademy/our_partners/bristol-city-council/bristol-city-council as a starting point. Graham 2009/12/3 Dan Itkis dit...@moderro.com: I'm looking to chat with someone who's migrated their organization to Open Office to gain insight into what to expect. thanks! Dan And the obvious question now is: How can he chat with those? Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: linux exe
2009/12/4 Web Kracked webmas...@krackedpress.com: That is why I suggested using a lite version of a Linux distro like Xubuntu instead of Ubuntu. There are other lite versions of modern distros as well. Since he has Red Hat installed, he might want to look for other RPM versions instead of Deb versions like Ubuntu/Xubuntu. I installed Ubuntu and it found my old equipment (from Win95 days) along with my newer stuff. Alex, please download one of the newest versions of Linux. Red Hat sends you to The Fedora Project web site http://fedoraproject.org/ when you want Red Hat free. They charge for their Red Hat Linux now, so if you want a Red Hat like Linux, go to Fedora. Their download is an ISO image file. Once you burn it to a disc, then you can try it without a full install, since it is a LIVE CD. Just put it in your CD drive and restart your computer. On the OpenOffice.org front, that CD should have one of the latest versions of OOo on it and you can run it from the LIVE CD. I like trying the different LIVE CDs/DVDs to see which one I like best, and which one works best for my computer. If you have a dial-up connection, then it should be able to download in a few hours, so let the ISO download run at bedtime. My point was that no matter how fast your Linux distro is, OpenOffice.org will still be slow, at least 2.0 and newer. They worked a lot to make 3.1 faster and some things are really MUCH faster than earlier versions, but still 3.x is much ”heavier” than 1.x. I hade a Dell Dimension XPS450R (450 MHz, 256 MB RAM, later upgraded to 320 MB) and OpenOffice.org 2.0 on that computer was so slow that it was unusable. 1.1.5 however, was also slow, but it was at least acceptable. The OP's computer is even slower than my Dell, that's why I keep saying this. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How Do I Combine 2 Writer Files?
2009/12/5 John Gilchrist ooo.for...@gmail.com: Thank you! I sorely need to study page styles. Where is the best place to read about setting up a page style. I apologize for being so ignorant. I definitely appreciate your help. I am not sure you need to read so much about it. Just hit F11. This will bring up the styles dialogue. On top of that dialogue there are a few icons for different kinds of styles. One of these are for Page styles. Click it and you get a list of all available page styles. Right click one of them to modify or create a new one based on the one you right clicked. Double click a style to apply the style to the currently selected page. If more questions, get back here… ☺ Johnny Rosenberg Sincerely, J. Gilchrist On 12/4/09, Guy Voets nimant...@gmail.com wrote: 2009/12/4 Jay Gilchrist ooo.for...@gmail.com: Dear OOo Users, I want to combine Writer file A and with Writer file B. You know, concatenate 2 files. File A has page margins = 1.00 Left and Right. File B has page margins = 0.79 Left and Right. So, another way to get what I want would be to have page margins A for the first n-pages. Then, have page margins B for all pages after page n. How can I do this? Thank you, John Gilchrist Hello, I would create two page styles, one for the A part, with margins of 1, the other for the B part with the smaller margins. When you drop B behind A, you make a manual page break between them and chose the second style... HTH -- Guy using dutch OOo Aqua 3.1.1 on a iMac Intel DualCore Snow Leopard and brazilian OOo Aqua 3.1.1 on an Intel MacBook Pro Leopard -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] When I Copy Text into OOo, Only One Space Between Sentence End and Beginning of Next sentence
As a non English speaking person that's very interesting. In Swedish there has never been an extra space required and I started to learn English at school in 1975, and nobody ever mentioned an extra space. So exactly when did this change from being required to NOT being required? On the other hand, in 1975 we didn't use computers at school so maybe that's why they didn't mention anything about spaces… And I am curious about another thing as well: I have noticed that many people writing in English adds an extra space right before a ”!” and a ”?”, which is very ugly and at least in Swedish very wrong. Has that been required too in the past? Johnny Rosenberg Sweden ≠ Switzerland… 2009/12/5 James Wilde james.wi...@sunde-wilde.com: Sorry to barge in here, but in normal usage you are right, Michael, that two spaces after a full stop and colon are no longer required. However, I have been told that manuscripts intended for printing should still have two spaces after full stop and colon, to make it easier for the typesetter to see the difference between full stop and comma, and colon and semi-colon respectively. For this reason also, it is traditional for manuscripts to be in a fixed font, and courier 12 pt is the norm, both in the film world (where it isn't intended for printing of course) and in the book world. I must admit that, like John Gilchrist, it is so ingrained in my system, that I automatically put two spaces in the appropriate places, but then I've been typing for nearly fifty years, so it's had time to become a habit! I'm not saying that J K Rowling wouldn't have been published if she'd sent her manuscript in Arial or something, but she no doubt found it easier to stick to the rules. //James On Dec 5, 2009, at 12:05 , Michael Adams wrote: On Sat, 05 Dec 2009 03:59:59 -0600 Came this utterance formulated by John Gilchrist to my mailbox: *How can I automatically place two spaces between the period at the end of a sentence, and the begining of the next sentence.* Firstly - two spaces at the end of each sentence is no longer a requirement of English. But if you insist that it is a requirement of yours, use Edit - Find and Replace then replace . with . . It can also be suitably ammended to cater for question and exclamation marks. What i would have done is not copied and pasted but File - Opened the .DOC files instead. They will open fine in OpenOffice.org. NOTE to all - If copy and paste does strip extra white spaces, is this behaviour expected or counterable? -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] When I Copy Text into OOo, Only One Space Between Sentence End and Beginning of Next sentence
2009/12/5 Clayton ccorn...@openoffice.org: Johnny Rosenberg wrote: As a non English speaking person that's very interesting. In Swedish there has never been an extra space required and I started to learn English at school in 1975, and nobody ever mentioned an extra space. So exactly when did this change from being required to NOT being required? On the other hand, in 1975 we didn't use computers at school so maybe that's why they didn't mention anything about spaces… The two spaces after a full stop thing links way back to the days of typewriters, and a need for an em-dash sized space after the full stop. It wasn't actually a requirement of the English language... just a standard used by typists (using typewriters that used monospaced fonts), that was influenced by traditional typesetting standards and norms from the 19th century. And I am curious about another thing as well: I have noticed that many people writing in English adds an extra space right before a ”!” and a ”?”, which is very ugly and at least in Swedish very wrong. Has that been required too in the past? This also links back to the days of typewriters, and something called French spacing which for reasons only truly known by people at the time, inserted extra single spaces before and after punctuation marks. Depending on who you consult on it, the gradual change to single space after a full stop started anytime from the 1950s to the 1990s. The real trend is most noticeable with the more common use of variable width fonts and computers with office and DTP apps. Anyone who took traditional typing classes in school, using real typewriters (like me) were likely taught to double-space after a full stop. The habit stuck, and I still do it even in my emails :-) I actually took typing classes in school (around 1980, maybe 1981) and I don't remember anything about double spaces, but then again, I typed in Swedish. Yes, it was real typewriters. I actually had a typewriter at home (my father's but I used it all the time in the second half of the 1970's). Johnny Rosenberg C. -- Clayton Cornell ccorn...@openoffice.org OpenOffice.org Documentation Project co-lead Sun Microsystems, Hamburg, Germany - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: linux exe
2009/12/3 Ярослав Райченко gruz...@rambler.ru: *thank you for advice. this is news for me about puppy linux etc. what i need from office software is ability to compose macros in a similar way as msoffice offers by means of vba ole technology. that's what i have under windows98 msoffice 97. can linux + ooo beet MS on this field or at least be compared? as a newbie for linux i believed this was an operating system not that resource demanding as Win was. am i wrong? Well, remember that Windows 98 is OLD and not very advanced and therefore fast compared to many (but not all) of today's operating systems. It's also very buggy… GNumeric and AbiWord can't do macros (I think) so OpenOffice.org 1.1.5 would be my choice on such an old computer. However, even if Linux is fast in general, OpenOffice.org is not. Also OpenOffice.org 1.1.5 acan't save as ODF, but it can open them. Johnny Rosenberg Alex Johnny Rosenberg gurus.knu...@gmail.com [Thu, 3 Dec 2009 17:59:46 +0100]: 2009/12/3 Ярослав Райченко gruz...@rambler.ru: thank you for reply, i simply trying out linux as it is on my older pc (P1, 120mhz, 200M) than this redhat release to decide if it is ok for me. for instance, i can utilize vba on msoffice, but not sure if staroffice(or the likes) goes well on ooo. Wow… THAT is an old computer… I wouldn't even try to run OpenOffice.org on that one, at least not a newer version. 1.1.5 would be my choice. What do you need OpenOffice.org to do for you? If only simple tasks, there are some lot faster solutions for an old computer like yours (actually there are many different solutions, but here is one of them): Install Puppy Linux (an incredibly fast Linux distro which runs directly from your RAM). OpenOffice.org won't be installed by default but it would be too slow on you computer anyway. Instead, use the much lighter and faster GNumeric and AbiWord, I think both are included in Puppy Linux by default. But as soon as you need to do something advanced, none of these will be a good choice. Johnny Rosenberg the main idea is to put to life old gear by means of linux due to supposedly linux's better performance. with modern gear i am ok with modern mswindows. Alex * John Thompson j...@vector.os2.dhs.org [Wed, 2 Dec 2009 21:30:16 -0600]: On 2009-11-29, Ярослав Райченко gruz...@rambler.ru wrote: i currently am possessing a dvd with OO3.0.0 distributive as exe file, which means it is for Windows. But i want it to install on Linux (red hat7.1 core 2-4-2). is there any way to get it installed on linux (besides redownloding the linux version from site)? Why do you want to run the Windows version on linux? It can be done, in principle at least, using Wine or VMWare but your RedHat installation is very old and unlikely to support the most current and stable versions of these. Why not just get a modern linux distribution CD (IIRC, ubuntu will mail you an installation CD free of charge if you ask) and use the latest OOo and latest linux? This would be far more effective than trying to run Windows' OOo on an ancient version of RedHat. -- Ярослав Райченко. -- Новый ТОП100 - путеводитель по интернету! http://nova.top100.rambler.ru/promo - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org -- Ярослав Райченко. -- Новый ТОП100 - путеводитель по интернету! http://nova.top100.rambler.ru/promo - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: linux exe
2009/12/4 Ярослав Райченко gruz...@rambler.ru: * Web Kracked webmas...@krackedpress.com [Thu, 03 Dec 2009 20:54:50 -0500]: Ярослав Райченко wrote: *thank you for advice. this is news for me about puppy linux etc. what i need from office software is ability to compose macros in a similar way as msoffice offers by means of vba ole technology. that's what i have under windows98 msoffice 97. can linux + ooo beet MS on this field or at least be compared? as a newbie for linux i believed this was an operating system not that resource demanding as Win was. am i wrong? Alex Johnny Rosenberg gurus.knu...@gmail.com [Thu, 3 Dec 2009 17:59:46 +0100]: 2009/12/3 Ярослав Райченко gruz...@rambler.ru: thank you for reply, i simply trying out linux as it is on my older pc (P1, 120mhz, 200M) than this redhat release to decide if it is ok for me. for instance, i can utilize vba on msoffice, but not sure if staroffice(or the likes) goes well on ooo. Wow… THAT is an old computer… I wouldn't even try to run OpenOffice.org on that one, at least not a newer version. 1.1.5 would be my choice. What do you need OpenOffice.org to do for you? If only simple tasks, there are some lot faster solutions for an old computer like yours (actually there are many different solutions, but here is one of them): Install Puppy Linux (an incredibly fast Linux distro which runs directly from your RAM). OpenOffice.org won't be installed by default but it would be too slow on you computer anyway. Instead, use the much lighter and faster GNumeric and AbiWord, I think both are included in Puppy Linux by default. But as soon as you need to do something advanced, none of these will be a good choice. Johnny Rosenberg the main idea is to put to life old gear by means of linux due to supposedly linux's better performance. with modern gear i am ok with modern mswindows. Alex * John Thompson j...@vector.os2.dhs.org [Wed, 2 Dec 2009 21:30:16 -0600]: On 2009-11-29, Ярослав Райченко gruz...@rambler.ru wrote: i currently am possessing a dvd with OO3.0.0 distributive as exe file, which means it is for Windows. But i want it to install on Linux (red hat7.1 core 2-4-2). is there any way to get it installed on linux (besides redownloding the linux version from site)? Why do you want to run the Windows version on linux? It can be done, in principle at least, using Wine or VMWare but your RedHat installation is very old and unlikely to support the most current and stable versions of these. Why not just get a modern linux distribution CD (IIRC, ubuntu will mail you an installation CD free of charge if you ask) and use the latest OOo and latest linux? This would be far more effective than trying to run Windows' OOo on an ancient version of RedHat. -- Ярослав Райченко. -- Новый ТОП100 - путеводитель по интернету! http://nova.top100.rambler.ru/promo It all depends on the flavor of Linux. Some are demanding large resources, while others do not. If you look for the light version. http://www.xubuntu.com This link is the Ubuntu light version. Look for this type and you will get rid of much of the stuff in the desktop environment that would cause your computer to slow down [Quote:] Xubuntu releases: * 9.10, codename Karmic Koala (newest stable release). * 8.04.1, codename Hardy Heron, includes Long Term Support. Minimum system requirements You need 192 MB RAM to run the Live CD or 128 MB RAM to install. The Alternate Install CD only requires you to have 64 MB RAM at install time. To install Xubuntu, you need 2.0 GB of free space on your hard disk. Once installed, Xubuntu can run with starting from 192 (or even just 128) MB RAM, but it is strongly recommended to have at least 256 MB RAM. [unquote:] I started to run it on one old machine, before the power supply died and was not worth replacing. Ran faster than Win 98 or Win 2000/pro on that machine. Win XP home ran too slow, but that is what it's previous owner had loaded when I got it. It was a 166MHz processor. Good luck. At least you can run several language version on the same machine, unlike MS Office, at least it is easy on Windows. I am to new with Linux to know how to do it on Ubuntu. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org thank you for advice, since we drift from the initial topic ,and i have already gleaned from the experiance operating linux, that 1. one has problems to install smth newer than installed linux ver. (device or program), 2. consized or lite linux ver. presumes the mentioned in 1. problems. I personally installed RH7.1 because
Re: [users] Calc sort is NOT working
2009/12/2 newroz suer newroz...@hotmail.com: What is calc? OpenOffice.org Calc is the OpenOffice.org spreadsheet application. The corresponding MS Office application is called ”Excel”. Johnny Rosenberg Date: Wed, 2 Dec 2009 12:40:47 +0100 From: josefu...@gmail.com To: users@openoffice.org Subject: [users] Calc sort is NOT working I've tried all sorts (!) of possibilities and yet no joy. The list contains video titles and include some numbers too. The first two entries are Brave and second is Room... and there they remained no matter what. The rest of the column are sorted. Fyi am using: Data: Sort is that correct? Tks _ Nya Windows 7 - Hitta en dator som passar dig! Mer information. http://windows.microsoft.com/shop - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: linux exe
2009/12/3 Ярослав Райченко gruz...@rambler.ru: thank you for reply, i simply trying out linux as it is on my older pc (P1, 120mhz, 200M) than this redhat release to decide if it is ok for me. for instance, i can utilize vba on msoffice, but not sure if staroffice(or the likes) goes well on ooo. Wow… THAT is an old computer… I wouldn't even try to run OpenOffice.org on that one, at least not a newer version. 1.1.5 would be my choice. What do you need OpenOffice.org to do for you? If only simple tasks, there are some lot faster solutions for an old computer like yours (actually there are many different solutions, but here is one of them): Install Puppy Linux (an incredibly fast Linux distro which runs directly from your RAM). OpenOffice.org won't be installed by default but it would be too slow on you computer anyway. Instead, use the much lighter and faster GNumeric and AbiWord, I think both are included in Puppy Linux by default. But as soon as you need to do something advanced, none of these will be a good choice. Johnny Rosenberg the main idea is to put to life old gear by means of linux due to supposedly linux's better performance. with modern gear i am ok with modern mswindows. Alex * John Thompson j...@vector.os2.dhs.org [Wed, 2 Dec 2009 21:30:16 -0600]: On 2009-11-29, Ярослав Райченко gruz...@rambler.ru wrote: i currently am possessing a dvd with OO3.0.0 distributive as exe file, which means it is for Windows. But i want it to install on Linux (red hat7.1 core 2-4-2). is there any way to get it installed on linux (besides redownloding the linux version from site)? Why do you want to run the Windows version on linux? It can be done, in principle at least, using Wine or VMWare but your RedHat installation is very old and unlikely to support the most current and stable versions of these. Why not just get a modern linux distribution CD (IIRC, ubuntu will mail you an installation CD free of charge if you ask) and use the latest OOo and latest linux? This would be far more effective than trying to run Windows' OOo on an ancient version of RedHat. -- Ярослав Райченко. -- Новый ТОП100 - путеводитель по интернету! http://nova.top100.rambler.ru/promo - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Problem with Open office
2009/11/23 mansoor.k...@vtu.se: Hello We are using OPENOFFICE here in school and I have problem with WRITER 1. When i write swedish alfabets ”å,äö,Å,Ä,Ö” se atyached file. What are the problems with åäöÅÄÖ? I have had no issues with these and I use them all the time. If you speak Swedish: Du vet väl att det finns en svensk lista också? us...@sv.openoffice.org Johnny Rosenberg Hallunda (för tillfället) 2. I have problem with nummerlisting, suddenly it don't work 3. My tabel in atachement have colapsed, se atyached file Have a nice day Mansoor -- Med vänlig hälsning Mansoor Khan Värmdö Tekniska Gymnasium Idrottsvägen 4 134 40 Gustavsberg Tel vxl: 08-122 00 827 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] problemer med brug
2009/11/19 Freddy Holler hol...@it.dk: Til open office jeg har oppen office ligggende påmin pc. men kan ikke åbne f,eks et ny tom side til at skrive på. kan det være fordi programmet ikke er installeret eller noget andet. mvh freddy holler English: Please write in English on this list. I don't know if there is a list in Danish (us...@dk.openoffice.org?), but there is a Swedish list (us...@sv.openoffice.org) that you could try. I am Swedish myself and I understand what you are asking, but on this list most people don't. On the other hand, there's a lot more traffic on this list than on the Swedish (and danish I would guess, if there is one) list. So if you can write in English you would more likely get more replies. This time you got lucky and someone replied, but others who doesn't understand any of the Nordic languages, and who maybe has the same problem, will have big difficulties understanding the question and answers… Svenska: Skriv helst på engelska på denna lista. Jag vet inte om det finns någon dansk lista ((us...@dk.openoffice.org?), men det finns en svensk lista (us...@sv.openoffice.org) som du kan testa. Jag är själv svensk och jag förstår vad du frågar efter, men på denna lista är det nog sällsynt. Å andra sidan är denna lista betydligt mer traffikerad än den svenska (och den danska, antar jag, om den finns). Så om du skriver på engelska till denna lista är chansen betydligt större att du får svar. Nu hade du ju lite tur och fick ett svar, men andra, som inte kan något nordiskt språk, och som kanske har samma problem, har ju svårt att tillgodogöra sig såväl fråga som svar… Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Bilingual file with hidden text-How to replace all hidden with (i.e. nothing)
2009/11/17 subratan...@punjlloyd.com: Dear All, This is an example (attached file) similar problem that the file when opened with MS-Word it shows the contents. But with OO-write it is not openning(showing any contents). Attachments are sometimes stripped off. In this case there is no attachment. Please upload your file somewhere and give us a link to it. Johnny Rosenberg With Regards, SUBRATA NATH SNX27, Silchar. - This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient of this communication, we request you to notify the sender immediately by return email and destroy all copies and the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email is strictly prohibited. The recipient acknowledges that Punj Lloyd Limited or its subsidiaries and associated companies (collectively Punj Lloyd Group) are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any view, opinion or advice expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Punj Lloyd Group. Although we have taken all reasonable precautions to ensure that this communication is free from viruses. We do not assume responsibility for any loss or damage arising from the use of this email. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] USA.GOV sending a resume
2009/11/16 James Knott james.kn...@rogers.com: Kelly wrote: I had used Browse on this website to upload a resume later rec'd an email from USA Gov saying: Why did it not work? Can you send attachments in emails and can they open it on their end? This is caused by the government not accepting ISO standard ODF file format. OpenOffice, by default, saves in ODF formats. Since the government does not accept this, you'll have to save in Microsoft Word format. You can do this by selecting the appropriate format from the drop down box, when using Save as (also ensure automatic file name extension is selected) or, if you want to send an email, click on File Send E-mail as Microsoft Word. While you're at it, you might want to ask your representative why the government fails to accept ISO standard, non-proprietary, document formats. As far as I can read, they DON'T accept Microsoft Word format. They want you to convert it to RTF. Yes, Microsoft was involved in that format to in some way and destroyed it badly, but when you say ”Microsoft Word format” I think most people think you mean DOC or DOCX format. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Problem with OpenOffice.Org Calc 3 that I can't find a solution for.
2009/11/15 Abraham aben...@satx.rr.com: I have the latest update for Open Office 3. I am very pleased with it and I am also fast learning how to use it. I am E-mailing this contact because, as the subject implies, I need a direct contact and response to solve this problem. If I am writing to the wrong contact, I apologize and I would greatly appreciate your navigation of this e-mail to the proper contact. Both Lotus and Excel and have a function, Paste Special, which will change a cell's content from calculations to Value Only (pure numbers or percents). They can do this for columns, rows or areas of cells in which the content consists of mixes of numbers and the calculations of numbers, percents (%), currency, etc, using data from other cells. Open Office also has Paste Special but I can't get as complete and easily done a transition to Value Only. Right now I have a column in an OpenOffice.Org Calc spreadsheet with a mix such as the one described above. When I scan the column and click on Calc Paste I get a list of options none of which I can apply to the WHOLE column. All I can do is convert individual common sets to Value only, one at a time. And, as I previously said, I have the same problem for mixes in rows and areas of cells. Sorry, I really don't understand this. Why can't you do that? If you select a range of cells, no matter if it is a singe cell, single column, single row or a range of several rows and columns, the Paste Special will be applied on exactly the cells that are selected. If you select a range of cells, then Ctrl+c, then select a single cell, then Paste Special → Check Numbers only → OK, the paste special will be applied on a range of the same size as the first one you selected, starting at the cell you selected last time. What more could you possibly want? Sorry for not understanding your problem. Johnny Rosenberg I appreciate your response to this request and hope to soon see, via an E-mail, a detailed explanation on how to activate OpenOffice.Org Calc Paste Special as simply and as well as those of Lotus and Excel. Many thanks, Abe. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: USA.GOV sending a resume
2009/11/16 NoOp gl...@sbcglobal.net: On 11/16/2009 09:00 AM, Johnny Rosenberg wrote: 2009/11/16 James Knott james.kn...@rogers.com: Kelly wrote: I had used Browse on this website to upload a resume later rec'd an email from USA Gov saying: Why did it not work? Can you send attachments in emails and can they open it on their end? This is caused by the government not accepting ISO standard ODF file format. OpenOffice, by default, saves in ODF formats. Since the government does not accept this, you'll have to save in Microsoft Word format. You can do this by selecting the appropriate format from the drop down box, when using Save as (also ensure automatic file name extension is selected) or, if you want to send an email, click on File Send E-mail as Microsoft Word. While you're at it, you might want to ask your representative why the government fails to accept ISO standard, non-proprietary, document formats. As far as I can read, they DON'T accept Microsoft Word format. They want you to convert it to RTF. Yes, Microsoft was involved in that format to in some way and destroyed it badly, but when you say ”Microsoft Word format” I think most people think you mean DOC or DOCX format. Johnny Rosenberg Sure they do... read again. They suggested to convert to RTF if you had problems. I just read it again. I can't really see what you are saying here. I even did a search for the word ”problems” and all I found was this: ”If you continue to experience problems uploading your document, please consult the Application Manager Online Help” Here's the only plave where they mention DOC: ”If the file you uploaded is a text file such as .DOC or .TXT, follow these steps: 1. Open the file. 2. If the file is password protected, remove the password. We cannot process password protected files. 3. Convert the file to Rich Text Format (.RTF), if possible, in order to assure the file contains no macros. Usually, the way to do this is to click on the File menu and select Save As. In the Save As window, choose .rtf as the file type and Save.” It says absolutely nothing about ”if you have problems”. Johnny Rosenberg Also see: http://eshelp.opm.gov/robo/projects/appman001/Document_Upload.htm File Types and Restrictions The following restrictions apply to files submitted through this Document Upload Service: * File format must be in JPG, PDF, TXT, RTF, DOC, WPD, XFD, FDF, XFDF or HTM/HTML. So I suspect that Derek's advise to submit as a MS Word doc will work. He could also export to PDF and submit that. Now, who's going to petition the US Gov to accept .odt/odf files as well :-) - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Where are the default date formats configured from?
2009/11/14 Dotan Cohen dotanco...@gmail.com: In both Writer tables and in Calc, when I enter a date in -MM-DD format it gets reformatted as MM/DD/YY. My locale is set for the -MM-DD format, and OOo is configured to use the default locale settings. So where is this MM/DD/YY date coming from? How can I change it on a global basis? Not sure, but maybe you need to shange the language settings for your operating system. I think so because I currently use OpenOffice.org English (US) version and for me it's the other way around (which doesn't bother me since I always use the Swedish date format anyway, which is the same as the ISO-8601 format (-MM-DD). When I tried to change the format to your default format (MM/DD/) the input line of that cell displayed -MM-DD anyway. My operating system is Ubuntu 8.10 Swedish, so it seems to be an operating system thing here. I could temporary change my operating system to English and see what happens if you want to (it requires a logout - login), to verify that what I'm saying here is true… Johnny Rosenberg Thanks. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Where are the default date formats configured from?
2009/11/15 James R. Liebert jiml...@neo.rr.com: Users may set a Windows system to -MM-DD. All applications depending on the default system date format then will so display. At Calc _T_ools menu: _O_ptions: OpenOffice.org Calc: Calculate, OO users may set default Date format to one of three format variants, which exclude -MM-DD. Have you actually looked at that place yourself? It's NOT about date format. It only sets which date is day 0 (default is 1899-12-30 - 30 dec 1899 that is). This is probably for compensating for the date bug in Excel. Excel thinks that the year 1900 is a leap year, but OpenOffice.org knows it's not. So to make things work anyway, day 0 in Excel i 1899-12-31 and in Calc it is 1899-12-30. This means that dates before 1900-03-01 a dasplayed wrong in Excel and correctly in Calc. Dates from 1900-03-01 and later are displayed correctly in Excel and in Calc. OO users may format particular Calc cells -MM-DD by so entering into the _F_ormat code field at F_o_rmat menu: Numbers tab: _C_ategory: Date. That's what he did, I think. However I think that was described in another thread. OO Writers may _I_nsert: Fields: Other, where they may specify format of individual dates to be inserted. If these simple options are of no avail, write back. JRL Dotan Cohen wrote: In both Writer tables and in Calc, when I enter a date in -MM-DD format it gets reformatted as MM/DD/YY. My locale is set for the -MM-DD format, and OOo is configured to use the default locale settings. So where is this MM/DD/YY date coming from? How can I change it on a global basis? Thanks. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Syntax of an IF
2009/11/12 Walter Hildebrandt wh2...@gmail.com: I am still confused of the semicolons. The following is a color coded summary of what you have said. 1st IF =IF(ISBLANK(A1) ;*Empty*;*IF(A1=0;no Div;A1-40+STYLE(IF(A140;RedText* IF(ISBLANK(A1) (test) *Empty (True)* *IF(A1=0 ;no Div;A1-40+STYLE(IF(A140 ;RedText))) (False)* The function +STYLE changes the style of the current cell so that the *True *and *False* for this IF is in effect. The RedText style only take effect if *False* is the result in the current cell 2nd IF =IF(ISBLANK(A1) ;Empty;IF(A1=0;*no Div*;*A1-40+STYLE(IF(A140;RedText* IF(A1=0 (test). *no Div (True)* *A1-40+STYLE(IF (A140 ;RedText)) (False)* The function +STYLE changes the style of the current cell so that the *True * and *False* for this IF is in effect The RedText style only take effect if *False* is the result in the current cell 3rd IF =IF(ISBLANK(A1) ;Empty;IF(A1=0;no Div;A1-40+STYLE(IF(A140;*RedText* IF(A140 (test) *RedText (True)* *(formula is blank) (nothing is done) (False)* False is omitted therefore the result is zero/blank/null depending on context. In this case either will work because STYLE(), STYLE(0) and STYLE( ) all have the same effect - do nothing. The function +STYLE changes the style of the current cell so that the *True*and *False* for this IF is in effect. The RedText style take effect if *True* is the result in the current cell For the 1st IF, what is the rule or principal that caused the semicolon at the end of the following to be in effect? =IF(ISBLANK(A1) ;*Empty*;*IF(A1=0;no Div;* What is the “rule” or “principal for the 2nd IF. The semicolon at the end of the following seems to work correctly =IF(ISBLANK(A1) ;Empty;IF(A1=0;*no Div*; however the semicolon after the 40 and before “RedText” did not seem to take effect Walter That semicolon is in the third IF statement. And there seem to be one missing there, by the way. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Syntax of an IF
2009/11/11 Gene Young n2...@cfl.rr.com: Walter Hildebrandt wrote: On Wed, Nov 11, 2009 at 10:00 AM, Gene Young n2...@cfl.rr.com wrote: Walter Hildebrandt wrote: I have the following formula: IF*(**ISBLANK(A1)*;*Empty*;IF*(A1=0*;*no Div*;A1-40+STYLE(IF*(A140*; RedText The syntax of an IF consists of three components: 1. *The condition* 2. *What to do if the condition is true* 3. *What to do if the condition is false* What is the syntax is the above formula? Where is the *false condition* for the *(**ISBLANK(A1) IF*(A1=0*;*no Div*;A1-40+STYLE(IF*(A140*;RedText) Am I correct that you are saying that A1-40+STYLE(IF*(A140*;RedTextis the #3 False condition for both (ISBLANK(A1) and (A1=0) Am I correct that you are saying RedText is the #3 False condition for (A140 even where it seems to be the #2 True condition since there is only one condition after the (A140 My apologies. I failed to notice that you left out a condition. You needto change the last if statement to add the false condition: IF*(A140*;RedText;) This states that if your condition is true, RedText if it is false, null. You could of course put any other action in for false, but you must have the else condition. Or maybe this makes it easier to understand: IF(A140;RedText;Default) The whole formula: IF(A1=0;no Div;A1-40+STYLE(IF(A140;RedText;Default))) The ; separates the three parts of the if. In this case: IF(1;2;3(IF(4;5;6))) 1 → A1=0 (condition) 2 → no Div (if 1 → true) 3 → A1-40+STYLE(IF(A140;RedText;Default)) (if 1 → false) 4 → A140 (condition) 5 → RedText (if 4 → true) 6 → Default (if 4 → false) Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc, delete specified range of rows or columns
2009/11/10 Zhengquan Zhang zhang.zhengq...@gmail.com: Use the 'Name Box' to select the range, rows, or columns you want to delete. I have managed to create a name for a range. But How can I delete the range? Select it in the Name Box (the one to the left of the formula field). Then hit the Delete button (or Backspace). Johnny Rosenberg TomW - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org -- Zhengquan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] meaning and the effect of 0
2009/11/9 Harold Fuchs hwfa.openoff...@googlemail.com: 2009/11/9 Walter Hildebrandt wh2...@gmail.com What does 0 mean and what is its effect in various condition? In a numeric context, 0 means zero. If you try to treat *text* in a numeric context then the text will usually be treated as zero. For example : When I got the formula =A1-40+IF(A140;STYLE(RedText);0), I was told “The STYLE function always returns 0, so the formula is mathematically equal to A1-40+0” Correct. I don't know where you got that formula but it doesn't do anything useful. See below. Depends on what is useful… It calculates A1-40 and if A140 the the cell will use the style ”RedText”. If not, it will use the current style. In both cases, the return value is 0, so the result won't change. As I probably already said whan I very quickly made this formula, there are other ways to do this, but since all methods that I knew of already were suggested, I suggested this one as a start, ready for development. What is effect of the 0 at the end of the formula? The syntax of an IF consists of three components: 1. the condition 2. what to do if the condition is true 3. what to do if the condition is false These are separated by semicolons. Thus your IF, which is IF(A140;STYLE(RedText);0) says if the contents of cell A1 is greater than 40 [#1, the condition] set the current cell's value to STYLE(RedText) [#2, what to do if the condition is true] otherwise set the current cell's value to zero [#3, what to do if the condition is false] However, all this is nonsense. Calc's Help on the Style function tells us that its syntax is nothing like the one you cited and that it doesn't do anything like what you've been told. I quote: Still, it works. Of course I tested it before sent my message. begin quote Syntax STYLE(style;time;style2) Style is the name of a cell style assigned to the cell. Style names must be entered in quotation marks. Time is an optional time range in seconds. If this parameter is missing the style will not be changed after a certain amount of time has passed. Style2 is the optional name of a cell style assigned to the cell after a certain amount of time has passed. If this parameter is missing Standard is assumed. ===end quote === For example if “Negative numbers red” is selected (is checked) when formatting cells, 0:[RED]-0 appears in the Format code box. For example I was told “Enter something like this in the format code field: 0% This will just add the % character right after the number, but the number will still act as an ordinary number.” Something like is probably true depending on your definition of the phrase. A dog is something like a horse, perhaps: 4 legs, tail, hair, friend of mankind. But ... Also when entering the O, under different conditions, Is the 0 a zero or a capital letter? usually zero. A bare (unquoted) letter O would normally only be meaningful if you had *named* something (like a print-range) O. Why don't you use the Conditional Formatting menu to do what you want? -- Harold Fuchs London, England Please reply *only* to users@openoffice.org Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] meaning and the effect of 0
2009/11/9 Walter Hildebrandt wh2...@gmail.com: You ask Why don't you use the Conditional Formatting menu to do what you want? I was told that Styles was a good way to do what I wanted to do so I decided to use Styles I had no experience and very little understanding of either Styles or Conditional Formatting. I assumed Styles was easier to learn and use. I now have decided to learn and use Conditional Formatting instead of Styles. I am starting by checking the OOo website to see what information is available. Walter As I tried to explain earlier, both methods (or all three, I think someone suggested a third way to do the same thing) will work but they are suitable for different situations. As I explained, Style() is very good if you need more than three different styles depending on value of a cell. Just name the styles in a smart way and you can do funny stuff, and also useful stuff. In this case, conditional formatting is just as good, if not better. I am pretty sure I mentioned that, if not I apologize. But what's the point mentioning the same method that somebody else already mentioned? So I mentioned another solution. Since I understand that you are a beginner and you seem to be interested in learning, I just thought that I should, or at least could, inform you about this method. Maybe it's not the most suitable for your current problem, but as you go forward in learning this method maybe will give you some inspiration later. Well, something like that anyway. I didn't mean to confuse you, sorry if that happened. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] I can't figure this out… (about conditional format ting)
Create a new style. Call it ”Invisible” and enter in the formatting code field. Select column A except A1. Make sure A2 is the selected cell of that range. Conditional formatting → Cell value is → A1 → Style: Invisible → Click OK. Enter todays date in A2 and A3 and then Tomorrow's date in A4. A3 will now look empty. Works great. But enter text in those cells! No matter what you type, no cells will look empty! I tried all the workaround that I could think of, including Cell protection → Hide, nothing works. Is this even possible to do? For example, if I input the followong in column A: This is is interesting The result of this should look like this: This is interesting Anyone? Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] I can't figure this out… (about condit ional formatting)
2009/11/7 Brian Barker b.m.bar...@btinternet.com: At 18:45 07/11/2009 +0100, Johnny Rosenberg wrote: Create a new style. Call it Invisible and enter in the formatting code field. Select column A except A1. Make sure A2 is the selected cell of that range. Conditional formatting - Cell value is - A1 - Style: Invisible - Click OK. Enter todays date in A2 and A3 and then Tomorrow's date in A4. A3 will now look empty. Works great. But enter text in those cells! No matter what you type, no cells will look empty! I tried all the workaround that I could think of, including Cell protection - Hide, nothing works. Is this even possible to do? Instead of using a formatting code in the cell style, set the font colour to the same as the background colour? I have tried that and it works. That was the way I did this before I tried the method that failed. But if I suddenly decide to change the background colour of the whole sheet, I have to change the font colour AND background colour of that new style(s) making the whole thing a little less automatic… But yes, it's definitely an option. Johnny Rosenberg I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] color of numbers in Calc
2009/11/7 Walter Hildebrandt wh2...@gmail.com: I created a test spreadsheet and put 50 in cell A1, 30 in cell A2, and 40 in cell A3. Putting the formula A1-40+IF(A140;STYLE(RedText);0) in cell B1. I then copied B1 to B2 and to B3. The correct numbers are in B1, B2, and B3. B1 is 10, B2 is -10 and B3 is 0. *The problem is that all the B cells have red numbers.* I have probably not crated the correct RedText style I tried it when I replied to you and it worked. I am not sure why it doesn't for you. Maybe you messed things up when creating the style? Did you somehow change your default style to display red numbers? F11 → Right click Default → Click modify → Click Font effects tab. Is the font colour set to red? If so, change it back to Automatic. Does it work now? If not, highlight the cells that contains the style formula. Right click one of the cells → Format cells… → Font effects. Is the font colour set to red? Change it back to Automatic. Does it stil not work? Please send me the whole spreadsheet, or a similar one that doesn't work, and I will try to debug it for you. Johnny Rosenberg When creating the RedText style, I clicked on the “Font Effects” tab In the “Font color” pull-down menu I selected *Red* I click *OK*. How do I get the minus numbers, such as the -10 in B2, to be black instead of red? On Sat, Nov 7, 2009 at 12:34 AM, Johnny Rosenberg gurus.knu...@gmail.comwrote: 2009/11/7 Johnny Rosenberg gurus.knu...@gmail.com: 2009/11/6 Walter Hildebrandt wh2...@gmail.com: Cell A1 has a number. Cell B1 is to have how much less, or much more, A1 is than 40. When A1 is less than 40 the answer in B1 is to be in black. When A1 is more than 40 the answer in B1 is to be in red. . This means if A1 is 50, the 10 in B1 is red. When A1 is 30, the -10 in B1 is black. Have you tried the STYLE command? First create a style with red text, let's call it RedText. If you don't know how to crate styles, press F11 and experiment a bit from there. Hint: Right clicking an existing style might be a good start… Now, in B1, enter your formula: =A1-40+IF(A140;STYLE(RedText);0) The STYLE function always returns 0, so the formula is mathematically equal to A1-40+0. Using conditional formatting will also work. This is just another way to do the same thing in this case. In some cases conditional formatting is the better choice, in some cases this solution is the one to prefer. A bit OT: I'll give you an example where the use of STYLE is exceptionally good: Let's say that you have a cell than can contain some words (maybe names of people?). Maybe we have a list of when someone will do what. Maybe we have a certain task to do and we decided that we all would share the job. Everyone can take a look on the list to see when he or she is supposed to do the task. Well, if every one of us was assigned a specific colour, it would be easy to see your name in the list, right? So my name maybe will be displayed on a red background, your with a blue backgound, Richard is yellow, Gene is green (which is a rhyme, by the way…) and Brian is Magenta. Well, first we create one style for each person. Give each style the same name as the person associated with it. To do this the easy way (maybe there is even easier ways, please tell me in that case), use one sheet for inputing data and another sheet for viewing it. Name the sheets, maybe ”Input” and ”View”. Let's say that we use column A for date and column B for peoples names. Let's also say the the first row is for headers. So input a date in A2 and a name in B2 and continue with A3, B3 and so on. All this is done on the Input sheet, of course. Now switch to the View sheet. Copy the headers from the Input Sheet. A good way (I think) to do this is to just type ”=Input.A1” (without the quotes, of course, like in the rest of my examples in this message). Type this in A1 on the View sheet, of course. Seems like I forgot to mention that… Johnny Rosenberg Now you can copy this cell where ever you want in the View sheet, and it will display the value of the corresponding cell on the Input sheet. This way, if you change your headings or other cells, you only need to change them on the Input sheet, which is a good thing in most cases. Ok, now input the following in B2: =LEFT(Input.B2 STYLE(Input.B2);LEN(Input.B2)) Highlight B2 (still on the View sheet) and copy it down as far as you need. Without the LEFT function, Walter would have been turned into Walter0, for example, and that doesn't look very good… This way we are not limited to the three conditions of conditional formatting. If we are 100 people, we ”only” need to create 100 styles to make it work. The tough thing in this case is maybe to find 100 different colours that doesn't look like each other… Well, this was only an example and it works (I actually tested
Re: [users] color of numbers in Calc
2009/11/7 Walter Hildebrandt wh2...@gmail.com: Yes, your formula does work. The colors are correct. I added the following at the front of your formula and that works. IF(ISBLANK(A1);Empty;IF(A1=0;zero; I am pushing my luck but there is another change I would like to make. The numbers in the A column are formatted as Numbers but they are actually percent numbers. Is there a way for the numbers in column B to have the % signed included? The B column has just the number without a % sign. Have you tried the % button or format it as %? That will convert your data to %, so 40 will be 4000,00%. Maybe you don't want that. A dirty workaround in that case could be Right click the cell or cell range → Format cells… → Enter something like this in the format code field: 0% This will just add the % character right after the number, but the number will still act as an ordinary number. Johnny Rosenberg On Sat, Nov 7, 2009 at 12:10 PM, Brian Barker b.m.bar...@btinternet.comwrote: At 11:21 07/11/2009 -0700, Walter Hildebrandt wrote: I created a test spreadsheet and put 50 in cell A1, 30 in cell A2, and 40 in cell A3. Putting the formula A1-40+IF(A140;STYLE(RedText);0) in cell B1. I then copied B1 to B2 and to B3. The correct numbers are in B1, B2, and B3. B1 is 10, B2 is -10 and B3 is 0. *The problem is that all the B cells have red numbers.* I have probably not created the correct RedText style No: your style is probably OK. How do I get the minus numbers, such as the -10 in B2, to be black instead of red? I'm not sure why your formula doesn't work: it presumably relates to how the expression is parsed and evaluated. But using STYLE(IF()) instead of IF(STYLE()) appears to solve the problem: =A1-40+STYLE(IF(A140;RedText)) Incidentally, you can refer to the current cell value using the CURRENT() function, so another way to do this is: =A1-40+STYLE(IF(CURRENT()0;Red)) I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] color of numbers in Calc
2009/11/6 Walter Hildebrandt wh2...@gmail.com: Cell A1 has a number. Cell B1 is to have how much less, or much more, A1 is than 40. When A1 is less than 40 the answer in B1 is to be in black. When A1 is more than 40 the answer in B1 is to be in red. . This means if A1 is 50, the 10 in B1 is red. When A1 is 30, the -10 in B1 is black. Have you tried the STYLE command? First create a style with red text, let's call it RedText. If you don't know how to crate styles, press F11 and experiment a bit from there. Hint: Right clicking an existing style might be a good start… Now, in B1, enter your formula: =A1-40+IF(A140;STYLE(RedText);0) The STYLE function always returns 0, so the formula is mathematically equal to A1-40+0. Using conditional formatting will also work. This is just another way to do the same thing in this case. In some cases conditional formatting is the better choice, in some cases this solution is the one to prefer. A bit OT: I'll give you an example where the use of STYLE is exceptionally good: Let's say that you have a cell than can contain some words (maybe names of people?). Maybe we have a list of when someone will do what. Maybe we have a certain task to do and we decided that we all would share the job. Everyone can take a look on the list to see when he or she is supposed to do the task. Well, if every one of us was assigned a specific colour, it would be easy to see your name in the list, right? So my name maybe will be displayed on a red background, your with a blue backgound, Richard is yellow, Gene is green (which is a rhyme, by the way…) and Brian is Magenta. Well, first we create one style for each person. Give each style the same name as the person associated with it. To do this the easy way (maybe there is even easier ways, please tell me in that case), use one sheet for inputing data and another sheet for viewing it. Name the sheets, maybe ”Input” and ”View”. Let's say that we use column A for date and column B for peoples names. Let's also say the the first row is for headers. So input a date in A2 and a name in B2 and continue with A3, B3 and so on. All this is done on the Input sheet, of course. Now switch to the View sheet. Copy the headers from the Input Sheet. A good way (I think) to do this is to just type ”=Input.A1” (without the quotes, of course, like in the rest of my examples in this message). Now you can copy this cell where ever you want in the View sheet, and it will display the value of the corresponding cell on the Input sheet. This way, if you change your headings or other cells, you only need to change them on the Input sheet, which is a good thing in most cases. Ok, now input the following in B2: =LEFT(Input.B2 STYLE(Input.B2);LEN(Input.B2)) Highlight B2 (still on the View sheet) and copy it down as far as you need. Without the LEFT function, Walter would have been turned into Walter0, for example, and that doesn't look very good… This way we are not limited to the three conditions of conditional formatting. If we are 100 people, we ”only” need to create 100 styles to make it work. The tough thing in this case is maybe to find 100 different colours that doesn't look like each other… Well, this was only an example and it works (I actually tested it while I wrote this message). Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] color of numbers in Calc
2009/11/7 Johnny Rosenberg gurus.knu...@gmail.com: 2009/11/6 Walter Hildebrandt wh2...@gmail.com: Cell A1 has a number. Cell B1 is to have how much less, or much more, A1 is than 40. When A1 is less than 40 the answer in B1 is to be in black. When A1 is more than 40 the answer in B1 is to be in red. . This means if A1 is 50, the 10 in B1 is red. When A1 is 30, the -10 in B1 is black. Have you tried the STYLE command? First create a style with red text, let's call it RedText. If you don't know how to crate styles, press F11 and experiment a bit from there. Hint: Right clicking an existing style might be a good start… Now, in B1, enter your formula: =A1-40+IF(A140;STYLE(RedText);0) The STYLE function always returns 0, so the formula is mathematically equal to A1-40+0. Using conditional formatting will also work. This is just another way to do the same thing in this case. In some cases conditional formatting is the better choice, in some cases this solution is the one to prefer. A bit OT: I'll give you an example where the use of STYLE is exceptionally good: Let's say that you have a cell than can contain some words (maybe names of people?). Maybe we have a list of when someone will do what. Maybe we have a certain task to do and we decided that we all would share the job. Everyone can take a look on the list to see when he or she is supposed to do the task. Well, if every one of us was assigned a specific colour, it would be easy to see your name in the list, right? So my name maybe will be displayed on a red background, your with a blue backgound, Richard is yellow, Gene is green (which is a rhyme, by the way…) and Brian is Magenta. Well, first we create one style for each person. Give each style the same name as the person associated with it. To do this the easy way (maybe there is even easier ways, please tell me in that case), use one sheet for inputing data and another sheet for viewing it. Name the sheets, maybe ”Input” and ”View”. Let's say that we use column A for date and column B for peoples names. Let's also say the the first row is for headers. So input a date in A2 and a name in B2 and continue with A3, B3 and so on. All this is done on the Input sheet, of course. Now switch to the View sheet. Copy the headers from the Input Sheet. A good way (I think) to do this is to just type ”=Input.A1” (without the quotes, of course, like in the rest of my examples in this message). Type this in A1 on the View sheet, of course. Seems like I forgot to mention that… Johnny Rosenberg Now you can copy this cell where ever you want in the View sheet, and it will display the value of the corresponding cell on the Input sheet. This way, if you change your headings or other cells, you only need to change them on the Input sheet, which is a good thing in most cases. Ok, now input the following in B2: =LEFT(Input.B2 STYLE(Input.B2);LEN(Input.B2)) Highlight B2 (still on the View sheet) and copy it down as far as you need. Without the LEFT function, Walter would have been turned into Walter0, for example, and that doesn't look very good… This way we are not limited to the three conditions of conditional formatting. If we are 100 people, we ”only” need to create 100 styles to make it work. The tough thing in this case is maybe to find 100 different colours that doesn't look like each other… Well, this was only an example and it works (I actually tested it while I wrote this message). Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How do I adjust size of printed output in calc
2009/11/4 Tim Deaton t...@timdeaton.org: When I print a spreadsheet in Excel, if the sheet is too large for one page, I can adjust the size of the printed output. I can either adjust the size by a percentage (ie: print at 75% of normal size) or I can set it to shrink the document so that it fits within x pages wide by y pages long. I can also adjust the margins of the document. And all this is done from either a Page Setup box that can be accessed either from the Print Preview screen or from the File menu. Where do I find this functionality in Calc? -- Tim Deaton There is no such functionality in OpenOffice.org Calc. He he… only kidding… File → Page Preview → Adjust the scale directly by moving that thing you see between ”Margins” and ”Close Preview”. For more options, click Format Page and look around among the tabs in the dialog that pops up. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] calc
2009/11/3 mohd.n...@afi.com.sa: Hi , Search is not working in my open office calc . Please advise me a solution. regards, Noor And how are we supposed to do that when you tell us absolutely nothing about your problem? Exactly (and I mean exactly) what are you trying to do, how do you do it, what do you expect to happen and exactly what actually happens instead? Are you trying to do a regular expression search? Do you search in formulas or in values? Etc etc etc… Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Search in Calc
2009/10/28 joe g josefu...@gmail.com: I am using Search in Calc and it's telling me Search Key Not Found. I'm using OOo 3.1.1 Could anyone help pl? Since you give almost no information what so ever, I can only guess, so I will do that: My guess is that you search in formulas rather than values or vice versa. But as I said, it's only a guess and nothing more. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Compacting some cells in a different column
Well, the simple answer would probably be to sort columns D and E. Johnny Rosenberg 2009/10/26 Walter Hildebrandt wh2...@gmail.com: My question is, how can I do the following? There are 200 rows involved. The following explains the question. Cell A1 has the number 1 in it, cell A2 has 2 in it, cell A3 has 3, cell A4 has 4 Cells B1 has the name name1 in it, cell B2 has name2 in it, cell B3 has name3, cell B4 has name4 Cell C1 is empty, C2 has hame2 in it, cell C3 is empty, C4 has name4 The 2 from cell A2 is copied into cell D1 and name2 from cell B2 is copied into E1 Also the number 4 in cell A4 is copied into cell D2 and name4 from cell B4 is copied into E2. In other words when both Columns B and C have the same name in them then columns A and B are copied to columns D and E and everything that is copied is compacted so there are on empty rows between what is copied into columns D and E - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] I-T-S
2009/10/26 James R. Liebert jiml...@neo.rr.com: Its = property of it It's = it has; it is: contraction of it and verb. Where are the police when you really need them? Well, we all know this, don't we? So why are you writing this? Does OpenOffice.org handle this the wrong way? J.R. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org