[users] Calc - sorting by formula, empty cells cause misalignment

2010-05-02 Thread kev
I'm not sure if this is a bug or what, but it's unexpected behavior. Say you make a uniform table, and one of the columns is a formula with references to other cells in the row, and those cells might be blank. If you now sort by the formula column, the cell references in each formula cell may

[users] Base wizard: Business or Personal?!?

2010-05-02 Thread Dotan Cohen
When using the Base Table Wizard, the very first question is Category: Business or Personal. This is very confusing to users, who don't want to answer wrong. If the only difference is in the Sample Tables, then maybe all the sample tables should be together anyway. If the difference is more than

[users] New Member

2010-05-02 Thread dnyteskye-goodsservices
Hi, I have some questions. But first a bit of history. Due to malware issues on a recently acquired second-hand pc, I just reinstalled factory version of Windows XP, which must have had MS Office 2003 factory installed. I have no software and currently have no way to open documents. A few

[users] Open Office suddenly won't open

2010-05-02 Thread goodley simon
Hello, I have Open Office 3.1.1 on my MacBook Pro. Everything was working fine until last week when I installed updates. Now I can't open Open Office. I've tried installing from scratch but that doesn't work either. Any suggestions? Thanks. SG

[users] commercial use

2010-05-02 Thread Robert Weitzel
Hello, can i use the Open Office Suite for commercial purpose? Regards Robert Weitzel

[users] Issue 111210

2010-05-02 Thread H Me
Re: http://www.openoffice.org/issues/show_bug.cgi?id=111210 The uploaded files were newly created by me, since I cannot upload my actual database data (due to data protection). The fact that the letter has a registered database that differs from the DB name is irrelevant - an odb file can be

Re: [users] Excel problem

2010-05-02 Thread Michael Adams
On Sunday 02 May 2010 03:58, Abdul Hai wrote: Thanks for the reply I have only been to the forum so I was not able to reply earlier. How do I change the attribute? Don't worry about it. From Calc just File - Save As... a copy of the file to your documents folder. This new copy will be

[users] Re: Need the program

2010-05-02 Thread Mary Snider
On 5/1/2010 6:56 AM, Mary Snider wrote: Dear Sir, My computer is not able to install OPEN OFFICE.ORG because I have DIAL UP CONNECTION, can't afford nothing else. I was wondering if I could get the program if it is not too much. I tried and tried to install Open Office.org but I can't so

[users] Envelopes

2010-05-02 Thread Fred Crummey
I have a Lexmark printer which only prints envelopes in the center. Why is it so difficult to print an envelope in open office? I have instructions from ehow but I still find it very hard to apply. Any good suggestions? Thanks, Fred

Re: [users] placement on my computer desk top

2010-05-02 Thread Keith R Bainbridge
On 30Apr2010, at 02:18 , Bernice Lott wrote: I have downloaded and when I press on the icon, I get a rectangular bar that hugs the right side of my desk top which I can't seem to move. I am using a Mac 10.3. thanks, bernice lott

Re: [users] Excel problem

2010-05-02 Thread Abdul Hai
Thank you and for the record I like the way it looks and I prefer it Excel. Support solar power in the developing world. http://www.everyclick.com/solaraid http://www.solar-aid.org/ From: Michael Adams linux_m...@paradise.net.nz To: users@openoffice.org

Re: [users] commercial use

2010-05-02 Thread Daniel Lewis
Robert Weitzel wrote: Hello, can i use the Open Office Suite for commercial purpose? Regards Robert Weitzel Yes, you may. Some large companies are doing so already. http://www.openoffice.org/license.html has a list of the licenses that cover the use of OpenOffice.org (OOo). OOo can be

Re: [users] Re: Need the program

2010-05-02 Thread James Wilde
Note to other list members: Mary is not registered on the list so please include her email address if you reply. Note to Mary: I have answered your email by placing my comments in your message in accordance with list rules so please scroll down to see my comments. On May 1, 2010, at 14:02 ,

Re: [users] Re: Need the program

2010-05-02 Thread James Wilde
Note to other list members: Mary is not registered on the list so please include her email address if you reply. Note to Mary: I have answered your email by placing my comments in your message in accordance with list rules so please scroll down to see my comments. On May 1, 2010, at 14:02 ,

[users] I know!

2010-05-02 Thread James Wilde
I know, I said in the first line to add Mary's email address. And then I forgot! Doh! Sorry for the necessary double post. Have a good laugh. :( //J - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional

Re: [users] Base wizard: Business or Personal?!?

2010-05-02 Thread Daniel Lewis
Dotan Cohen wrote: When using the Base Table Wizard, the very first question is Category: Business or Personal. This is very confusing to users, who don't want to answer wrong. If the only difference is in the Sample Tables, then maybe all the sample tables should be together anyway. If the

Re: [users] New Member

2010-05-02 Thread Sigrid Carrera
Hi Diane, Am Sun, 2 May 2010 12:14:18 -0700 (PDT) schrieb dnyteskye-goodsservi...@yahoo.com: Hi, I have some questions. But first a bit of history. Due to malware issues on a recently acquired second-hand pc, I just reinstalled factory version of Windows XP, which must have had MS

Re: [users] commercial use

2010-05-02 Thread James Knott
Robert Weitzel wrote: Hello, can i use the Open Office Suite for commercial purpose? Yes, you can use it for whatever you want. You can also hand it out to others and install on as many computers as you wish. - To

Re: [users] Hiding a value in a spreadsheet conditionally.?

2010-05-02 Thread James Elliott
Thanks for that Tom - I will try it James On 29/04/2010 9:18 AM, TomW wrote: James: By removing the 'T function, changing to a +', and defining a currency style, the following would seem to do what you want. +(IF(A300; STYLE(fmtWhite); STYLE(fmtCurrency))) TomW -- James Elliott BSc