[users] Calc - sorting by formula, empty cells cause misalignment
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 now refer to the cells in other rows (where the blanks were) instead of the row where they are now located. If you simply insert a dummy value into those empty cells, the formula references will be preserved correctly, but filling in the blanks can be tedious. Is this a bug or is there a way to work around it? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Base wizard: Business or Personal?!?
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 that, then there should be an explanation. Thoughts on improvement? -- Dotan Cohen http://bido.com http://what-is-what.com - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] New Member
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 days ago, I installed Open Office 3.2. In reading Welcome Notes on Installation in readme file, I see info re registration of Open Office as a default application for MS Office formats. Questions: Was I supposed to choose /msoreg=1 while installing? (I don't remember seeing any options) Should I uninstall and reinstall? How? (Don't see uninstall option on start-up menu dropdown) If I do, will I see that option? If I register, will I be given a choice? (I've been busy setting up pc, so am just now exploring info and haven't registered yet) Is there something else I can do to be able to have access to my documents? As a suggestion, it might make it easier for new members to switch over if there was easily accessible information for MS users. I've chosen to use Firefox instead of IE, and Firefox made the transition easy by providing an overview and clear information about importing info from IE. Thanks for your assistance. Diane
[users] Open Office suddenly won't open
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
Hello, can i use the Open Office Suite for commercial purpose? Regards Robert Weitzel
[users] Issue 111210
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 registered in OO.org under any name - even one completely different from the file name. I have done this before from Tools - Options - Openoffice.org Base - Databases - New Hence, closing the Issue on this basis is unfounded. This is not a frivolous report. I have been using Base for several years and have distributed logbooks for cardiology trainees in the format. It appears that this particular DB is unable to transfer from OO.org 3.0 to 3.2 and still preserve its merge function. In order to merge my letter, I have to export the Base query (which works) to Excel (MS Excel - since it does not work in OO.org Calc either), and transfer the Merge letter to MS Word prior to performing the merge. This may be a problem with the way I use Writer, but the process I have performed is identical to what I was using in 3.0, which worked. I have tried changing the Exchange DB, deleting and recreating the DB registration, and manually re-entering the fields, but I am unable to merge a letter to a single odt file, which had previously worked properly. Thanks for your consideration of re-opening the report. HR _ http://clk.atdmt.com/UKM/go/195013117/direct/01/ We want to hear all your funny, exciting and crazy Hotmail stories. Tell us now
Re: [users] Excel problem
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 editable. HTH -- Michael - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Need the program
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 please help me. Can't afford Microsoft Office. Let me know something please. Thank you, Mary Snider 105 Broadway Poteet, TX 78065 830-742-3216 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Envelopes
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 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] placement on my computer desk top
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 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Good morning Bernice, Have a look at: http://user.services.openoffice.org/en/forum/viewtopic.php?f=17t=10573 Not sure when OSX would accept a standard OOo install but I think 10.4+ The upgrade to 10.6 has worked well for me. Keith Bainbridge PO Box 324 BELMONT Vic 3216 +61 (0)408 522 706 kei...@akrb.name - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Excel problem
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 Sent: Sun, 2 May, 2010 3:54:46 Subject: Re: [users] Excel problem 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 editable. HTH -- Michael - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] commercial use
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 used for any legal purpose on as many computers as you want. You can read all of this in the license. Dan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Need the program
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 , Mary Snider wrote: 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. If you go to this page on the Openoffice.org site, you will find details of companies who provide Open Office on a cd. They make a small charge for this, which may vary depending on whether they also offer support. I cannot vouch for any of them, and Open Office does not endorse them but makes a page available for contact information. Here is the page: http://distribution.openoffice.org/cdrom/index.html#cdrom Other ways to get Open Office are perhaps on the cover CD with many computer magazines, although you may not get the latest version that way. Or you can try asking a friend with a faster connection to download it for you and put it on a USB stick or burn it to a CD for you. Just make sure (s)he has the same operating system. I'm assuming you have Windows, so get your friend to download the Windows version. It doesn't matter which version of Windows you have. Other users may be able to suggest other ways of getting Open Office. I suggest you join our mailing list - go to this page: http://support.openoffice.org/index.html and click on the word Subscribe beside the heading Users Mail List. In here you'll find lots of other users who try to help newcomers with using Open Office, everything from 'how do I start it' to more detailed technical questions. Good luck with Open Office. //James - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Need the program
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 , Mary Snider wrote: 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. If you go to this page on the Openoffice.org site, you will find details of companies who provide Open Office on a cd. They make a small charge for this, which may vary depending on whether they also offer support. I cannot vouch for any of them, and Open Office does not endorse them but makes a page available for contact information. Here is the page: http://distribution.openoffice.org/cdrom/index.html#cdrom Other ways to get Open Office are perhaps on the cover CD with many computer magazines, although you may not get the latest version that way. Or you can try asking a friend with a faster connection to download it for you and put it on a USB stick or burn it to a CD for you. Just make sure (s)he has the same operating system. I'm assuming you have Windows, so get your friend to download the Windows version. It doesn't matter which version of Windows you have. Other users may be able to suggest other ways of getting Open Office. I suggest you join our mailing list - go to this page: http://support.openoffice.org/index.html and click on the word Subscribe beside the heading Users Mail List. In here you'll find lots of other users who try to help newcomers with using Open Office, everything from 'how do I start it' to more detailed technical questions. Good luck with Open Office. //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
[users] I know!
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 commands, e-mail: users-h...@openoffice.org
Re: [users] Base wizard: Business or Personal?!?
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 difference is more than that, then there should be an explanation. Thoughts on improvement? What is confusing? The sample tables in the Business category contain fields to be used in a business database. The sample tables in the Personal category contain fields to be used in a personal database. To me, this is obvious when you look at the names of the suggested tables. Dan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] New Member
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 Office 2003 factory installed. I have no software and currently have no way to open documents. A few days ago, I installed Open Office 3.2. In reading Welcome Notes on Installation in readme file, I see info re registration of Open Office as a default application for MS Office formats. Questions: Was I supposed to choose /msoreg=1 while installing? (I don't remember seeing any options) Don't worry about this. If I remember correctly, OpenOffice automatically does this for you. (This is a somewhat recent change, so the readme.txt might not be changed yet.) If you have MS Office on your computer, then it won't grab the .doc, .xls, .docx, .xlsx for itself but leave it for MS. If you don't have MS Office installed, then OOo registers those suffixes for itself. Should I uninstall and reinstall? How? (Don't see uninstall option on start-up menu dropdown) If I do, will I see that option? No, you don't need to un-/reinstall. If you ever need to reinstall, go to the setup.exe file and doubleclick on it. Then the installation wizard will appear and you can choose to either do a repair installation or an uninstall. You should arrive at the same place, if you go to Start System preferences Software and click there on the change button. Please note, that you need to have the unzipped installation files. Otherwise OOo can't be uninstalled. If I register, will I be given a choice? (I've been busy setting up pc, so am just now exploring info and haven't registered yet) Is there something else I can do to be able to have access to my documents? Not sure, what you mean. The registration is just for counting how many installations of OOo are in the whole world. That's all. If you don't want to, you don't have to register. As a suggestion, it might make it easier for new members to switch over if there was easily accessible information for MS users. I've chosen to use Firefox instead of IE, and Firefox made the transition easy by providing an overview and clear information about importing info from IE. What are you missing? I agree, that the readme should give you correct advice, but this was just a human error. I'm sure it will be changed soon. Do you have any other remarks? Would be useful to hear back from you, so that the userguides can deal with those questions. Thanks for your assistance. Diane I hope, that my answers help. :) Sigrid - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] commercial use
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 unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Hiding a value in a spreadsheet conditionally.?
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 JP Private mail account: james.elli...@wn.com.au Address: PO Box 44, Boddington WA 6390 Phone: +61 8 9883 8178Fax: +61 8 9883 9519 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org