Re: [users] Re: What the [deleted] is wrong with autosave on ver3

2008-11-11 Thread Rob Clement
Larry Gusaas wrote: Rob Clement wrote: Larry Gusaas wrote: Rob Clement wrote: Larry Gusaas wrote: Hedley Finger wrote: Larry: The hardware problem is irrelevant. The AutoRecovery feature is there to prevent loss of data when there is a *hardware* [??!?!!!] or software failure. Full au

Re: [users] Open Office Doubt

2008-11-11 Thread kumar v
Hi Alan Boba, We are using windows XP network operating systems only. All the systems are connected in network. Open office version 3.0. Thanks Kumar On 11/11/08, Alan Boba <[EMAIL PROTECTED]> wrote: > > I don't recognize these errors. You might post back to include the network > operating syst

Re: [users] Re: Two different OOorg versions on same Linux machine (solved)

2008-11-11 Thread john d. herron
NoOp wrote: On 11/07/2008 11:46 PM, john d. herron wrote: NoOp wrote: What happens if you do this from a terminal? /opt/openoffice.org3/program/soffice? Here's the output from terminal: (snip) Failed to open device [Java framework]sunjavaplugin.so could not load Java

Re: [users] Re: Reducing complexity of formula in Calc

2008-11-11 Thread Brian Barker
At 16:33 11/11/2008 -0500, Joe Smith wrote: Brian Barker wrote: ... If so, you can do this using an array formula. Enter this into your result cell: =SUM(C2:G2*(C2:G2-1))/(SUM(C2:G2)*(SUM(C2:G2)-1)) ... Nicely done! Oh, but not nearly as nicely done as by you, it transpires! Just one

[users] Re: Settings don't "stick"

2008-11-11 Thread PJH
Brian Barker has written on 11/11/2008 6:03 PM: At 14:46 11/11/2008 -0500, Ponly J Honly wrote: OOo 3.0.0/Win XP Pro SP2 In the spreadsheet, I have most columns set for Arial/9 with cells formatted #,##0.00;[RED]-#,##0.00. I have set the format for a number of rows beyond my last data entry,

[users] Re: Making labels

2008-11-11 Thread Russell Butler
Stan Goodman wrote: At 20:59:52 on Sunday Sunday 09 November 2008, Brian Barker <[EMAIL PROTECTED]> wrote: At 14:30 07/11/2008 +0200, Stan Goodman wrote: I want to print sheets of uniform "labels" on Business-Card stock. The content of these is entirely text, with no variable fields. I have rev

Re: [users] Reducing complexity of formula in Calc

2008-11-11 Thread TomW
Brian Barker wrote: At 21:30 10/11/2008 -0500, Tom Webb wrote: Any chance that your 8 in D2 is actually entered as 7.999. If I plug this into the cell D2, the array formula will give a result of 0.2857 (rounded to 4 decimal places). Sorry, but this isn't so, in fact: as you'd expect, changin

Re: [users] Settings don't "stick"

2008-11-11 Thread Brian Barker
At 14:46 11/11/2008 -0500, Ponly J Honly wrote: OOo 3.0.0/Win XP Pro SP2 In the spreadsheet, I have most columns set for Arial/9 with cells formatted #,##0.00;[RED]-#,##0.00. I have set the format for a number of rows beyond my last data entry, but when I enter new data, the format reverts t

Re: [users] Re: where to get openoffice 3 portable?

2008-11-11 Thread Arnold Huzen
If you REALLY can't wait for the official release of OOo 3 portable than here are some instructions on how to copy your installation of OOo 3 to your portableapps stick. I've tried it and it works fine for me. http://portableapps.com/node/16130#comment-100630 Arnold Huzen Spiderman schreef:

[users] Re: where to get openoffice 3 portable?

2008-11-11 Thread Spiderman
Spiderman schrieb: Spiderman schrieb: James Knott schrieb: Spiderman wrote: Hi, does anybody know where to get openoffice 3 final portable? Thanks in advance. I was looking at: http://portableapps.com/ http://www.ooodev.org/projekte/oooportable/oooportable.html But there is still nothing to

Re: [users] Re: Reducing complexity of formula in Calc

2008-11-11 Thread Graham Smith
Joe, > Just one pointless point: The numerator > > SUM(C2:G2*(C2:G2-1)) > > is equivalent to > > SUMPRODUCT(C2:G2;C2:G2-1) Even better, thanks. Graham - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-ma

[users] Re: Reducing complexity of formula in Calc

2008-11-11 Thread Joe Smith
Brian Barker wrote: ... If so, you can do this using an array formula. Enter this into your result cell: =SUM(C2:G2*(C2:G2-1))/(SUM(C2:G2)*(SUM(C2:G2)-1)) ... Nicely done! Just one pointless point: The numerator SUM(C2:G2*(C2:G2-1)) is equivalent to SUMPRODUCT(C2:G2;C2:G2-1) in wh

[users] Re: where to get openoffice 3 portable?

2008-11-11 Thread Spiderman
Spiderman schrieb: James Knott schrieb: Spiderman wrote: Hi, does anybody know where to get openoffice 3 final portable? Thanks in advance. I was looking at: http://portableapps.com/ http://www.ooodev.org/projekte/oooportable/oooportable.html But there is still nothing to find. I suspect yo

Re: [users] Re: What the [deleted] is wrong with autosave on ver3

2008-11-11 Thread Andis
Hi! The broken auto recovery function is the worst thing with openoffice.org 3 version. In a company where small unit is testing openoffice.org, like in my case, it is very strong argument against broader use of the program. I made a small instruction, how to avoid data losses at least tempor

Re: [users] Empty table of contents

2008-11-11 Thread Andrea Grillini
Andrea Grillini wrote: After successfully creating a table of contents, I re-open the document an I find it empty (just the title e no item). And it stays empty, no matter if I issue the "update" command. The only solution is re-creating the document from scratch. I need to fix this problem as so

[users] Re: where to get openoffice 3 portable?

2008-11-11 Thread Spiderman
James Knott schrieb: Spiderman wrote: Hi, does anybody know where to get openoffice 3 final portable? Thanks in advance. I was looking at: http://portableapps.com/ http://www.ooodev.org/projekte/oooportable/oooportable.html But there is still nothing to find. I suspect you'll have to wait un

[users] Settings don't "stick"

2008-11-11 Thread PJH
OOo 3.0.0/Win XP Pro SP2 In the spreadsheet, I have most columns set for Arial/9 with cells formated #,##0.00;[RED]-#,##0.00. I have set the format for a number of rows beyond my last data entry, but when I enter new data, the format reverts to some default. How do I get the settings to "st

[users] Reverse numbering of a list in Writer

2008-11-11 Thread Laurent Duperval
Hi, How can you do a reverse numbering list in Writer? What I mean is that I want a list numbered as follows: 10. 9. 8. I know I can set the number manually, but then if I insert anything between 8 and 9, I'm in trouble. Any ideas? (I'm on 3.0 if that matters any). Thanks, L -- Get free

[users] Re: What the [deleted] is wrong with autosave on ver3

2008-11-11 Thread Larry Gusaas
Rob Clement wrote: Larry Gusaas wrote: Rob Clement wrote: Larry Gusaas wrote: Hedley Finger wrote: Larry: The hardware problem is irrelevant. The AutoRecovery feature is there to prevent loss of data when there is a *hardware* [??!?!!!] or software failure. Full auto-recovery implies t

Re: [users] A small problem in making labels

2008-11-11 Thread Gene Young
Arnold Huzen wrote: OOo's default is to recognize a URL and then turn it into a link. You can change this under Extra/Autocorrect (if I translate it right from my dutch version). Then click on the third tab called "Options". The fifth one is the recognize URL-setting. Uncheck both boxes and OO

Re: [users] Reducing complexity of formula in Calc

2008-11-11 Thread Eli
Brian Barker wrote: At 21:30 10/11/2008 -0500, Tom Webb wrote: Any chance that your 8 in D2 is actually entered as 7.999. If I plug this into the cell D2, the array formula will give a result of 0.2857 (rounded to 4 decimal places). Sorry, but this isn't so, in fact: as you'd expect, changin

Re: [users] A small problem in making labels

2008-11-11 Thread Arnold Huzen
OOo's default is to recognize a URL and then turn it into a link. You can change this under Extra/Autocorrect (if I translate it right from my dutch version). Then click on the third tab called "Options". The fifth one is the recognize URL-setting. Uncheck both boxes and OOo will no longer con

[users] Selecting data points

2008-11-11 Thread David Trimboli
Is it possible to select more than one data point in a spreadsheet chart at a time, without selecting all data points? I tried Ctrl+Left-click, but that still only selects a single data point. -- David Stardate 8864.3 - To un

Re: [users] where to get openoffice 3 portable?

2008-11-11 Thread James Knott
Spiderman wrote: Hi, does anybody know where to get openoffice 3 final portable? Thanks in advance. I was looking at: http://portableapps.com/ http://www.ooodev.org/projekte/oooportable/oooportable.html But there is still nothing to find. I suspect you'll have to wait until they provide it, a

[users] Re: where to get openoffice 3 portable?

2008-11-11 Thread Spiderman
Spiderman schrieb: Hi, does anybody know where to get openoffice 3 final portable? Thanks in advance. I was looking at: http://portableapps.com/ http://www.ooodev.org/projekte/oooportable/oooportable.html But there is still nothing to find. Sorry, on http://portableapps.com/ it is coming soon.

Re: [users] Open Office Doubt

2008-11-11 Thread Alan Boba
I don't recognize these errors. You might post back to include the network operating system, desktop operating system, and OOo versions. All of those may be helpful to identifying a solution. On Tue, Nov 11, 2008 at 4:15 AM, kumar v <[EMAIL PROTECTED]> wrote: > I have been using Open office I am

[users] where to get openoffice 3 portable?

2008-11-11 Thread Spiderman
Hi, does anybody know where to get openoffice 3 final portable? Thanks in advance. I was looking at: http://portableapps.com/ http://www.ooodev.org/projekte/oooportable/oooportable.html But there is still nothing to find. - To

[users] After conversion from Word, why are headings wrapped in with list-style "Outline"?

2008-11-11 Thread Joerg von Frantzius
Hi, we have a large document that was originally converted from Word. In the contents.xml, the aren't stored as they are, but they are always wrapped like this: Sales region, cou

Re: [users] Reducing complexity of formula in Calc

2008-11-11 Thread Graham Smith
Dale, Apologies for the name confusion, I wasn't entirely convinced that your first name was Robertson, but I was tired. Graham > If one names the cells, the names turn out to be global, in the sense that > they are known to all sheets, ant the prefix "Sheet." isn't needed. > > Cheers Dale ---

Re: [users] Reducing complexity of formula in Calc

2008-11-11 Thread Robertson Dale A.
You're welcome. I hadn't thought about this before, but this is a general way to clean up a sheet, by putting intermediate calculations on another sheet. If one names the cells, the names turn out to be global, in the sense that they are known to all sheets, ant the prefix "Sheet." isn't

Re: [users] Re: What the [deleted] is wrong with autosave on ver3

2008-11-11 Thread Rob Clement
Larry Gusaas wrote: Rob Clement wrote: Larry Gusaas wrote: Hedley Finger wrote: Larry: The hardware problem is irrelevant. The AutoRecovery feature is there to prevent loss of data when there is a *hardware* [??!?!!!] or software failure. Full auto-recovery implies that somewhere all th

Re: [users] Re: Dictionary backups

2008-11-11 Thread Thomas Lange - Sun Germany - ham02 - Hamburg
Hi Gene, >> User dictionaries (the writable ones!) are locate in the user-layer of >> the installation in the user/wordbook sub-directory. You can make >> backups of those by simply copying them. >> >> Thomas >> > > OOo 3.o does not give me the option to add a word to anything but the > stand

[users] Open Office Doubt

2008-11-11 Thread kumar v
Dear All, I have been using Open office I am facing the following problem in open office. Please help me how to solve this issues. In this major problem is at a time many people can open the same file with out *Read-only.* 1. Doesn't show whether the document is opened by any other user

Re: [users] A small problem in making labels

2008-11-11 Thread Mike Scott
Stan Goodman wrote: I have designed a sheet of labels in OOo v2.3.0. The content of each label includes an email address and a URL. The problem is that both of these are underlined, because OOo has made links of them. which is meaningless (but obtrusinve) in a printed label. Selecting the "lin

Re: [users] Making labels

2008-11-11 Thread Stan Goodman
At 20:59:52 on Sunday Sunday 09 November 2008, Brian Barker <[EMAIL PROTECTED]> wrote: > At 14:30 07/11/2008 +0200, Stan Goodman wrote: > >I want to print sheets of uniform "labels" on Business-Card stock. > >The content of these is entirely text, with no variable fields. I > >have reviewed severa

Re: [users] [moderated]

2008-11-11 Thread arnold huzen
Normally you would put the fontfile in de C:\Windows\Fonts directory on your harddrive. After that it should be visible from the fonts dropdownlist in OOo. Arnold Huzen Lelystad The Netherlands Adrian Try <[EMAIL PROTECTED]> schreef: > Hi > > I am interested in installing a font into Open

[users] cd

2008-11-11 Thread Joggie Mentz
thankyou harold

Re: [users] Open Office Chinese version

2008-11-11 Thread Erik Chang
Dear James Knott Thank you for your kind help Regards Erik Chang From: James Knott <[EMAIL PROTECTED]> To: users@openoffice.org; [EMAIL PROTECTED] Sent: Sunday, November 9, 2008 8:22:28 PM Subject: Re: [users] Open Office Chinese version Erik Chang wrote: Dea

Re: [users] Update from 2.3 to 3

2008-11-11 Thread lilrich2
Thanks for your response. dick. - Original Message - From: James Knott Date: Sunday, November 9, 2008 7:20 am Subject: Re: [users] Update from 2.3 to 3 To: users@openoffice.org, [EMAIL PROTECTED] > LILRICH2 wrote: > > Must the 2.3 version be uninstalled before installing version 3? > > d

[users] A small problem in making labels

2008-11-11 Thread Stan Goodman
I have designed a sheet of labels in OOo v2.3.0. The content of each label includes an email address and a URL. The problem is that both of these are underlined, because OOo has made links of them. which is meaningless (but obtrusinve) in a printed label. Selecting the "link" text and clicking

Re: [users] Installing Font on Vista

2008-11-11 Thread A. Silver
Thanks so much Michael. You guys are great. I received three replies. Thanks for the right click infoIt saved the day. A. Silver Michael Adams wrote: On Sun, 09 Nov 2008 18:45:33 +1000 Came this utterance fomulated by Adrian Try to my mailbox: Hi I am interested in installing a font