Re: [users] W Vista and OO

2007-09-13 Thread Johnny Rosenberg
No, it only works in OS/2 and CP/M. ;P Ok, kidding. Of course it works, at least people say that every time that questions is asked (several times each day I think). J.R. 2007/9/13, Veli Korhonen [EMAIL PROTECTED]: Can I use Open Office with Windows Vista? Veli Korhonen [EMAIL

Re: [users] Help! Can't Open in Word

2007-09-13 Thread Johnny Rosenberg
Just never use a word processor that can't open international standard file format (such as ISO 26300, which is the default format of OpenOffice.org). Word is the only Word processor that I know of that can't do this, so just install a word processor that can. Such as Abiword, OpenOffice.org

Re: [users] Filter rows

2007-09-09 Thread Johnny Rosenberg
You don't need a macro for this. Let's say the following: Column A=Name Column B=Last name Column C=Email Now, let's say that Row 2 contains the first record. A2=Johnny B2=Rosenberg [EMAIL PROTECTED] Now enter the following in D2: =IF(A2=;;A2 B2) In this case, D2 show: Johnny Rosenberg Now

Re: [users] Filter rows

2007-09-09 Thread Johnny Rosenberg
it with a Base table? En/na Johnny Rosenberg ha escrit: You don't need a macro for this. Let's say the following: Column A=Name Column B=Last name Column C=Email Now, let's say that Row 2 contains the first record. A2=Johnny B2=Rosenberg [EMAIL PROTECTED] Now enter

Re: [users] Importing macros...

2007-09-06 Thread Johnny Rosenberg
old last name came to my family several generations ago, when last names was created that old fashioned way Johnny Rosenberg 2007/9/6, Andrew Douglas Pitonyak [EMAIL PROTECTED]: Johnny Rosenberg wrote: OK, so there actually was something that I was missing. Thanks Andrew. You helped me

Re: [users] Importing macros...

2007-09-05 Thread Johnny Rosenberg
OpenOffice.org? Or is it enough if they are in any folder under My Macros? Johnny Rosenberg 2007/9/5, Andrew Douglas Pitonyak [EMAIL PROTECTED]: Johnny, I do not have time to completely answer your question, and you probably do not really care about the complete correct answer. But, can you do

Re: [users] Importing macros...

2007-09-05 Thread Johnny Rosenberg
2007/9/5, Johnny Rosenberg [EMAIL PROTECTED]: OK, so there actually was something that I was missing. Thanks Andrew. You helped me a lot before (when my last name was Andersson) with macros and you did it again. I find it strange that I can not import the standard library and it would

Re: [users] RE: SAVE AS FOR SPREADSHEET

2007-09-04 Thread Johnny Rosenberg
2007/9/4, Stan Goodman [EMAIL PROTECTED]: ** Reply to message from Johnny Rosenberg [EMAIL PROTECTED] on Mon, 3 Sep 2007 22:30:25 +0200 1. Using capitals only is in most situations equal to shouting. It's also hard to read. 2. What do you mean when you say that it will not respond

[users] Importing macros...

2007-09-04 Thread Johnny Rosenberg
Hi! I just tried to import some macros I wrote in Windows XP long ago. Since I don't use Windows any more, even though I still have it installed, I wanted to use my old Basic macros in OpenOffice.org for Linux (Ubuntu 7.04 in my case). Here's what I did: I copied everything in ...\Application

Re: [users] RE: SAVE AS FOR SPREADSHEET

2007-09-03 Thread Johnny Rosenberg
1. Using capitals only is in most situations equal to shouting. It's also hard to read. 2. What do you mean when you say that it will not respond to save as? Exactly what did you do and exactly what happened? Often when using Save As, you want to change the spreadsheet's name or file type. What

Re: [users] help moving a public middle school in San Francisco to FOSS

2007-09-01 Thread Johnny Rosenberg
nails with screwdrivers is not a good idea, even if Calc is made 100 times faster than today. Johnny Rosenberg 2007/9/1, James Knott [EMAIL PROTECTED]: Christian Einfeldt wrote: But the teachers will probably not accept a box that takes even 110 seconds to load this spreadsheet

Re: [users] Re: no programs/software in open office

2007-08-26 Thread Johnny Rosenberg
As I understand it, this is what happens in the MAC version. There are some threads about this, so do a search. J.R. 2007/8/23, jack savage [EMAIL PROTECTED]: Thanks for your response- this e mail addy should be registered. See Below for responses to your responses: Hi! I installed

Re: [users] Calc Question

2007-08-24 Thread Johnny Rosenberg
COUNTIF also works fine in OpenOffice.org; it's probably one of the most commonly used cell formulas, so if it didn't work, many people would be very loud about it and the bug would be corrected rather quickly. I guess it's very hard to tell what's wrong in your case without having a look at the

Re: [users] New User

2007-08-23 Thread Johnny Rosenberg
of the mail then click show original and you will see all the headers. Look at the Delivered-To header to see if it says 'moderator'. If it does then the user is not subscribed. I think... someone correct me if I am wrong Hope this helps On 19 Aug 2007, at 20:37, Johnny Rosenberg wrote

Re: [users] Will not install openoffice 2.2

2007-08-19 Thread Johnny Rosenberg
You said that you downloaded it and tried to run it, but you didn't mention anything about installing it. Did you install it, and if so, did you get any error messages? J.R. 2007/8/18, [EMAIL PROTECTED] [EMAIL PROTECTED]: I have Windows Xp on my computer an I am trying to install the

Re: [users] Q on Calc

2007-08-19 Thread Johnny Rosenberg
Is there anything to paste? I don' know, this is only a guess, but maybe paste is not available when the clipboard is empty? Otherwise, I don't know. Oh, one more thing: Is Edit mode switched off? 2007/8/17, Chuck Davis [EMAIL PROTECTED]: When I open Calc now the paste function is not

Re: [users] Problem: OpenOffice free software does not run correctly with Windows XP?

2007-08-19 Thread Johnny Rosenberg
All I know is that OpenOffice.org runs just fine on both my operating systems, Windows XP SP2 and Ubuntu 7.04, with the only difference that it runs a bit slower on XP, maybe mostly because I have no antivirus software in Ubuntu. So to me it sounds like you have a bad driver or something. Is

Re: [users] vlookup

2007-08-19 Thread Johnny Rosenberg
Or maybe you (Steve) mean that you don't want the #N/A to show up if the search string is not found in an unsorted range? In that case: =IF(A2=;;IF(ISNA(VLOOKUPA2;$B$1:$C$10;2;0));;VLOOKUP(A2;$B$1:$C$10;2;0))) This will probably be a bit slow, however, since in some cases the same VLOOKUP will

Re: [users] New User

2007-08-19 Thread Johnny Rosenberg
Since three users gave you the same link, I guess you now know where to go... ;P J.R. 2007/8/19, Per [EMAIL PROTECTED]: Hi Ed Welcome as an OO.o-user. Follow this link, http://documentation.openoffice.org/ and I hope you should find what you are locking for. Best regards // Per

Re: [users] Spelling in Swedish version will not work

2007-08-19 Thread Johnny Rosenberg
And DON'T download the Swedish dictionary with the Wizard (unless someone updated them since the last months), since it is useless. There is a better one (still useless, but at least better than the other one...) at DSSO.se. Install that one instead. You'll find instructions on that site. DSSO

Re: [users] Question: Download the OpenOffice Writer only?

2007-08-19 Thread Johnny Rosenberg
To whom it concerns: Maybe this is another question to add to the FAQ, if it's not already there? A lot of people seems to ask this. Maybe it should be added in big fat capitals at the download page? J.R. 2007/8/19, James Knott [EMAIL PROTECTED]: V C wrote: Is it possible to download the

Re: [users] Date format bug with Open Office Calc

2007-08-19 Thread Johnny Rosenberg
Works fine in 2.2.0 for Ubuntu 7.04. The date remains the same. J.R. 2007/8/17, Steven Lim [EMAIL PROTECTED]: Hi. I'm using the OO 2.2.1 Notice an bug with Calc. When keying in date with format 11-jan-7x. After keying in the date, i click on other fields. When i return to click

Re: [users] Question: Download the OpenOffice Writer only?

2007-08-19 Thread Johnny Rosenberg
OT: 2007/8/19, Manfred J. Krause [EMAIL PROTECTED]: Hi Johnny, 'Can I download only parts of the OpenOffice.org suite?' http://documentation.openoffice.org/faqs/installation/003.html ... a little bit hidden with slightly antique values ... ;-) Manfred P.S. (late) congratulations, Mr.

Re: [users] New User

2007-08-19 Thread Johnny Rosenberg
]: Original Message From: Johnny Rosenberg [EMAIL PROTECTED] Date: Mon 20 Aug 2007 03:21:20 EST Since three users gave you the same link, I guess you now know where to go... ;P Yes, but only Jonathon cc'd the non-subscribed poster. D.B.

[users] Databases

2007-08-19 Thread Johnny Rosenberg
could think of as proper data source formats, even XLS should work, if you ask me... Any thoughts about this and related things? Johnny Rosenberg

Re: [users] Is this right for my use

2007-08-18 Thread Johnny Rosenberg
About the TOC, I did some work with a friend a while ago. I used OpenOffice.org Writer and he used Word. I did most of the writing and I also did the TOC thing. To be compatible with Word (since those who would read our document only had Word) I tried to export the whole thing to Word. However,

[users] Line thickness...

2007-08-17 Thread Johnny Rosenberg
Windows XP or Ubuntu, the line thickness was in inches. Everything else in millimeters as it should (since I set it to millimeters). Bug? Or is there another parameter to set that I couldn't find? I could also accept pica or points. Johnny Rosenberg

Re: [users] Line thickness...

2007-08-17 Thread Johnny Rosenberg
2007/8/17, Harold Fuchs [EMAIL PROTECTED]: On 17/08/07, Johnny Rosenberg [EMAIL PROTECTED] wrote: I have adjusted line thicknesses many times before, but this time I noticed something odd. I am talking about right clicking on a rectangle, selecting Lines and then trying to adjust its

Re: [users] Re: replacing special characters

2007-08-17 Thread Johnny Rosenberg
does make a difference. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] What about if you want to replace a paragraph break with a line break? Johnny Rosenberg Jesus is back

Re: [users] Expanding Curly Bracket in OOo Math

2007-08-15 Thread Johnny Rosenberg
reinvestment=left lbrace binom {a×p if p0} {0 otherwise} right rbrace or reinvestment=left lbrace binom {a·p if p0} {0 otherwise} right rbrace or reinvestment=left lbrace binom {ap if p0} {0 otherwise} right rbrace depending on what multiplication character you prefer... Johnny Rosenberg 2007/8

Re: [users] Expanding Curly Bracket in OOo Math

2007-08-15 Thread Johnny Rosenberg
Here's a better syntax, if you want more than two lines, found out by experimenting: General formula=left lbrace stack{a # b # c # and so on} right rbrace 2007/8/15, Marshall Feldman [EMAIL PROTECTED]: Hi, I am trying to use OOo Math for equations and other relationships that take on

Re: [users] calc question

2007-08-15 Thread Johnny Rosenberg
It is probably possible with a macro, but I am not 100% sure what you have done. Can you send the file to me or upload it somewhere and give us a link? Or could you do a fake using the same technique as the original? Johnny Rosenberg 2007/8/15, jack wallen [EMAIL PROTECTED]: hello everyone. i

Re: [users] Expanding Curly Bracket in OOo Math

2007-08-15 Thread Johnny Rosenberg
He he he... I was too late. If I had read your suggestion, I wouldn't have written mine... I just tried it, and it works (of course...). I hope the OP likes it. =) Johnny Rosenberg 2007/8/15, Brian Barker [EMAIL PROTECTED]: At 13:35 15/08/2007 -0400, Marshall Feldman wrote: I should have

Re: [users] product key

2007-08-15 Thread Johnny Rosenberg
You don't need one. Why would you need a product key for something that is 100% free? Just install and then run it. You can register if you want to, but you don't have to. Johnny Rosenberg 2007/8/15, ELLEN WARNER [EMAIL PROTECTED]: where can i find my product key? i don't think i ever

Re: [users] Re: impress

2007-08-15 Thread Johnny Rosenberg
Are you referring to thishttp://qa.openoffice.org/issues/show_bug.cgi?id=24969bug? It should be fixed by now, according some of the last comments at that page. Are you sure you have the latest version of OpenOffice.org? Johnny Rosenberg 2007/8/16, Russell Butler [EMAIL PROTECTED]: howard ball

Re: [users] Wow!!

2007-08-14 Thread Johnny Rosenberg
. If you found anything and changed it, zip that folder back again and finally change its name back again to WhateverTheFileWasPreviouslyCalled.ods. Johnny Rosenberg

Re: [users] Re: WHY won't it save?

2007-08-14 Thread Johnny Rosenberg
2007/8/14, olin thompson [EMAIL PROTECTED]: NoOp [EMAIL PROTECTED] wrote:On 08/13/2007 06:10 AM, olin thompson wrote: I downloaded this OpenOffice.org because my publisher uses the program and doesn't like to shift between MSWord and his OO.o. So, I'm writing this book and it goes

Re: [users] prolem setting up open office

2007-08-14 Thread Johnny Rosenberg
I wish that was true, but unfortunately it isn't. OpenOffice.org works with Vista. Just go back to www.OpenOffice.org and download again and check the md5sum to verify that the file isn't corrupted. Then try to install again. What I am trying to say is that I would guess that your downloaded

Re: [users] Re: WHY won't it save?

2007-08-14 Thread Johnny Rosenberg
Do you mean just to see if it works or for test purpose, or do you mean that he always always should be doing that? Because he clearly said that he only use OpenOffice.org because his publisher does, which means that he wants to save in the OpenDocument format, which he can't do in Word, right?

Re: [users] [moderated] Microsoft insecurity

2007-08-12 Thread Johnny Rosenberg
/12, Howard Coles Jr. [EMAIL PROTECTED]: On Saturday 11 August 2007 09:04:14 pm Johnny Rosenberg wrote: I just checked my firewall (I don't really remember when I restarted my laptop last time, but it was certainly not today) and it still shows a total of attacks = 0. In fact I have never seen

Re: [users] [moderated] Microsoft insecurity

2007-08-12 Thread Johnny Rosenberg
2007/8/12, Paul [EMAIL PROTECTED]: Johnny Rosenberg P.S. Will someone please try to attack me so I can verify that the firewall at least does something? D.S. To test that your fire wall is or isn't doing its job properly, surf over to GRC.com and take the 'shields up' test

Re: [users] Re: Help!!!

2007-08-12 Thread Johnny Rosenberg
But what about that her OpenOffice.org-files won't open anymore? I can't see why that should happen. Johnny Rosenberg 2007/8/12, NoOp [EMAIL PROTECTED]: On 08/12/2007 12:10 PM, Helen Mills wrote: Today I opened up my computer and was directed to register with Open Office (I think

Re: [users] Please help

2007-08-11 Thread Johnny Rosenberg
can see the upper part of it, then making it smaller, moving it up a bit again, making it even smaller and so on until the window fits on your screen? Maybe this isn't possible, I don't know, but it might give you some ideas. Johnny Rosenberg 2007/8/11, h kessler [EMAIL PROTECTED]: While

Re: [users] [moderated] Microsoft insecurity

2007-08-11 Thread Johnny Rosenberg
the only one in the world using Linux 2. My Firewall lies to me. 3. Ok, I said two explanations, so I won't bother you with a third one. Johnny Rosenberg P.S. Will someone please try to attack me so I can verify that the firewall at least does something? D.S. 2007/8/11, [EMAIL PROTECTED] [EMAIL

Re: [users] [moderated]Using Word

2007-08-09 Thread Johnny Rosenberg
of this thread or anything, I just wonder why people are so afraid. Who frightened them? And how can we make people understand what it's all about? Johnny Rosenberg 2007/8/9, Paul [EMAIL PROTECTED]: Thanks,Paul, I'm your grandmothers age and do things rather slow. Your explaination is very

Re: [users] read one number but use another

2007-08-09 Thread Johnny Rosenberg
Case 3 To 8 CalculatePoints=9-Position Case else CalculatePoints=0 End Select End Function Johnny Rosenberg 2007/8/9, Johnny Rosenberg [EMAIL PROTECTED]: You can also write your own cell formula. Just write it as a macro, something like: Function

Re: [users] read one number but use another

2007-08-09 Thread Johnny Rosenberg
And what are we doing with this? Well, if your posistion is place in E1 and you want the points in F1, then enter the following in F1: =CalculatePoints(E1) Simple as that. 2007/8/9, Johnny Rosenberg [EMAIL PROTECTED]: Ooops.. sent it before I was finished by mistake... You can also write

Re: [users] [moderated]Using Word

2007-08-09 Thread Johnny Rosenberg
not even ignorant. Maybe uninformed would describe him in this very case, but that sounds a bit lame... ;P Well, he is certainly a better chemist than I am... 2007/8/9, John Meyer [EMAIL PROTECTED]: Johnny Rosenberg wrote: Why are always people asking that (about free Word, free Powerpoint

[users] Size of icons in toolbars

2007-08-09 Thread Johnny Rosenberg
to be an option for that, doesn't it? I want as small icons as possible (as long as I can identify them...) since I want as much work area as possible, but I don't want full screen. Johnny Rosenberg

Re: [users] Clip Art

2007-08-09 Thread Johnny Rosenberg
2007/8/9, Stephanie Boulee [EMAIL PROTECTED]: Is there a way to utilize Microsoft's clip art on OpenOffice? If not is there an OpenOffice version of clip art, or perhaps another freeware/shareware/opensource clip art source that would be compatible with OpenOffice? If your OS/dist is

Re: [users] Size of icons in toolbars

2007-08-09 Thread Johnny Rosenberg
Yes, you're right. Thanks for making me feel stupid... on the other hand I have now small icons and everything looks so much better now! Thanks! 2007/8/9, Brian Barker [EMAIL PROTECTED]: At 20:00 09/08/2007 +0200, Johnny Rosenberg wrote: Since I started use the Linux (Ubuntu) version

Re: [users] Calc: way to add colors to background palette?

2007-08-06 Thread Johnny Rosenberg
Exactly what did you try and what happened/didn't happen? 2007/8/6, Sakthivel S [EMAIL PROTECTED]: i too tried this - but no luck On Monday 06 Aug 2007 19:14:01 Brian Barker wrote: At 13:36 06/08/2007 +0200, Frode Petersen wrote: Kenn Goutal wrote: I want to set the background color of

Re: [users] openoffice.org.1.1 I can't open my documents it comes up with

2007-08-06 Thread Johnny Rosenberg
Windows XP 2000? Do you mean Windows XP or Windows 2000? Or both? There is no XP 2000, is there? 2007/8/6, Michael Smith [EMAIL PROTECTED]: I use Windows XP 2000 and downloaded Openoffice 2.2 Michael -Original Message- From: Harold Fuchs [mailto:[EMAIL PROTECTED] Sent: Monday, 6

Re: [users] further macro problem

2007-08-06 Thread Johnny Rosenberg
I mean anyway, even though it's not important in an OpenOffice.org point of view...) J.R. 2007/8/6, Joe Conner [EMAIL PROTECTED]: Congratulations, (I am assuming a wedding occasioned the name change). Johnny Rosenberg wrote: SNIP Johnny Rosenberg (Andersson until Tuesday this week

Re: [users] microsoft office 2000

2007-08-06 Thread Johnny Rosenberg
If you don't want it, don't delete it. Uninstall it. But as the others said, you can do as you want. 2007/8/5, Orlando Lemos [EMAIL PROTECTED]: No! You don't need to do so... DAVID MARTIN escreveu: Hi Do I delete this program before downloading OpenOffice?? Regards DAVID MARTIN

Re: [users] Outlook in OpenOffice?

2007-08-04 Thread Johnny Rosenberg
Ok, sorry. I didn't know that there was no proper version of Evolution for Windows. 2007/8/4, Harold Fuchs [EMAIL PROTECTED]: On 03/08/07, Johnny Rosenberg [EMAIL PROTECTED] wrote: 2007/8/3, Harold Fuchs [EMAIL PROTECTED]: Zimmer, Lars.L wrote: Dear OpenOffice Team

Re: [users] Outlook in OpenOffice?

2007-08-03 Thread Johnny Rosenberg
2007/8/3, Harold Fuchs [EMAIL PROTECTED]: Zimmer, Lars.L wrote: Dear OpenOffice Team, is there Outlook function or another mail client available in the openoffice package? snip No. If you want a decent free e-mail program, many people recommend Mozilla's Thunderbird from the same

Re: [users] I am using version 2.2.1 of OpenOffice.org. My problem is : Spacing below paragraph keeps reseting to 0.5cm in OOWriter/Web

2007-08-03 Thread Johnny Rosenberg
Or just realize that OpenOffice.org isn't the proper tool for web pages. Try KompoZer instead or type the html directly in a text editor, such as GEdit, Nano, Emacs or whatever you have. 2007/8/2, [EMAIL PROTECTED] [EMAIL PROTECTED]: Simon [EMAIL PROTECTED] wrote: I am trying to make a

Re: [users] further macro problem

2007-08-02 Thread Johnny Rosenberg
possible and I think most OpenOffice.org macro writers work that way. Johnny Rosenberg (Andersson until Tuesday this week) 2007/8/2, F Goodchild [EMAIL PROTECTED]: apologies for not going to the end of my problem(s) I tried to record what I wanted to do after opening the csv file that I

<    3   4   5   6   7   8