Re: [users] Formula in spread sheet

2005-04-19 Thread Chadley Wilson
Oops, thanks! On Tuesday 19 April 2005 07:35, David Chapman wrote: Shouldn't it be... =IF((N25*N26*21,67)=1000;1000;N25*N26*21,67) You originally had a string 1000 in the IF formula. Dave My OpenOffice Calc Website http://www.openofficetips.com On 4/18/05, Chadley Wilson [EMAIL

[users] Graphics links not updated in Write

2005-04-19 Thread Alex Zachopoulos
I am using X11 on Panther (MacOS X 10.3.8) and OOo 1.1.1 (I know, it's not the latest one available...) The problem I have is caused when, after I create a new Write document, on my template which has a full page graphic for a background, and I also insert my scanned signature, I then go on to

Re: [users] Pocket Excel compatibility

2005-04-19 Thread Niklas Nebel
Wisu wrote: I tried opening a Pocket Excel file failed with OOo 1.1.4 calc worked with OOo 1.9.79 except for formulas where =E1+E2+E3 would result ooow:=E1+E2+E3 Thought I'd feed back, or maybe someone has an alternative however I can still manage with deleting the ooow: in front of each formula

[users] Calc - Options

2005-04-19 Thread John Barman
Thanks for the bug reporting instructions, but first things first. I have carried out a fresh download from OO, but the version downloaded is 1.9.79, and of course the problem I have reported still persists in this. I could not find a link on the home page enabling selection of 1.9.93 (or any

[users] Re: Calc - Options

2005-04-19 Thread Russell Butler
John Barman wrote: Thanks for the bug reporting instructions, but first things first. I have carried out a fresh download from OO, but the version downloaded is 1.9.79, and of course the problem I have reported still persists in this. I could not find a link on the home page enabling selection

[users] duplicating sheet area

2005-04-19 Thread Rich
is there a way to duplicate some area in a spreadsheet so that everything is preserved (including row height) ? it seems that paste special doesn't provide such functionality -- Rich - To unsubscribe, e-mail: [EMAIL PROTECTED]

[users] Re: Regex for paragraph find

2005-04-19 Thread Paul B.
Matt Needles wrote: Paul B. wrote: Alan McKinnon wrote: On Monday, 18 April 2005 23:02, Paul B. wrote: I think this was mentioned fairly recently, but in case not, is there a regex for finding a new paragraph? I see /n, but its specced only for soft returns, in the Find field anyway. Unless I'm

[users] Re: Regex for paragraph find

2005-04-19 Thread Paul B.
John D. Toppins wrote: Paul B. wrote: Alan McKinnon wrote: On Monday, 18 April 2005 23:02, Paul B. wrote: I think this was mentioned fairly recently, but in case not, is there a regex for finding a new paragraph? I see /n, but its specced only for soft returns, in the Find field anyway. Unless I'm

Re: [users] OOo-1.9.82 Debian packages

2005-04-19 Thread Ennio-Sr
* Richard [EMAIL PROTECTED] [180405, 21:42]: On Monday 18 April 2005 01:14 pm, Ennio-Sr wrote: Hi all, I downloaded the deb pckgs from the site suggested a few posts ago (ftp://ftp.linux.cz/pub/localization/OpenOffice.org/devel/680/Beta) [cut] The point is that I can't see any

Re: [users] Calc - Options

2005-04-19 Thread Andrew Cassels
To find the lastest version I go to http://download.openoffice.org/680/index.html You can access it through www.openoffice.org http://www.openoffice.org - Download tab - Latest Snapshot Build for OpenOffice.org 2.0 link (2nd link) on 19.04.2005 09:57 Mixu Lauronen said the following: John

[users] Re: Regex for paragraph find

2005-04-19 Thread Paul B.
Andrew Brown wrote: Paul B. [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: I'm trying to replace '^-' (or, using more conventional new line notation, '\n-') with ' -' - that is, I'm trying to collapse paragraphs - but tying the search string to the end of the previous paragraph doesn't do

Re: [users] Re: Regex for paragraph find

2005-04-19 Thread Alan McKinnon
On Tuesday, 19 April 2005 13:06, Paul B. wrote: So, whatever auto format's merits, it's not doing what I need it to. What is needed here is a simple way to search for hard paragraph returns, so the user can do what he needs to. I can't understand why the soft return would be allowed for in

Re: [users] Problem with v.1.9.93 Base

2005-04-19 Thread Andrew Douglas Pitonyak
Andrew Cassels wrote: Hello, I have a problem, I want to open a .odb database, it opens but when I click with the Tables button, there is a error message saying: /The connection to the data source accounts could not be established. / /Error in the script file line: 1 File input/output

Re: [users] Graphics links not updated in Write

2005-04-19 Thread Dan Lewis
On Tuesday 19 April 2005 02:53 am, Alex Zachopoulos wrote: I am using X11 on Panther (MacOS X 10.3.8) and OOo 1.1.1 (I know, it's not the latest one available...) The problem I have is caused when, after I create a new Write document, on my template which has a full page graphic for a

Re: [users] Problem with v.1.9.93 Base

2005-04-19 Thread Dan Lewis
On Tuesday 19 April 2005 03:48 am, Andrew Cassels wrote: Hello, I have a problem, I want to open a .odb database, it opens but when I click with the Tables button, there is a error message saying: /The connection to the data source accounts could not be established. / /Error

[users] Re: Regex for paragraph find

2005-04-19 Thread Paul B.
Paul B. wrote: John D. Toppins wrote: Paul B. wrote: Alan McKinnon wrote: On Monday, 18 April 2005 23:02, Paul B. wrote: I think this was mentioned fairly recently, but in case not, is there a regex for finding a new paragraph? I see /n, but its specced only for soft returns, in the Find field

[users] Re: Regex for paragraph find

2005-04-19 Thread Paul B.
Alan McKinnon wrote: On Tuesday, 19 April 2005 13:06, Paul B. wrote: So, whatever auto format's merits, it's not doing what I need it to. What is needed here is a simple way to search for hard paragraph returns, so the user can do what he needs to. I can't understand why the soft return would be

Re: [users] Problem with auto recovery screen in 2.0 beta

2005-04-19 Thread Dan Lewis
On Monday 18 April 2005 07:14 pm, Peter Kupfer OOo wrote: TANYANIKA LEWIS wrote: Hello, I am having a serious problem with the document auto recovery screen in OpenOffice 2.0 beta. The screen comes up for you to choose the document to recover and it tells you to click on the start

Re: [users] Problem with opening documents created in Word.

2005-04-19 Thread Doug Thompson
One other setting that can cause the behavior: Tools Autocorrect Options Tab Uncheck Apply border -Doug Sandy Thomson wrote: Doug The horizontal lines actually appear under MenuFormatPageBorders. There are no lines in User-defined for header or footer. I've tried removing the existing lines from

Re: [users] OOo-1.9.82 Debian packages

2005-04-19 Thread Ennio-Sr
* G. Roderick Singleton [EMAIL PROTECTED] [180405, 21:53]: On Mon, 2005-04-18 at 21:42 -0400, Richard wrote: On Monday 18 April 2005 01:14 pm, Ennio-Sr wrote: Hi all, I downloaded the deb pckgs from the site suggested a few posts ago

Re: [users] Re: [webmasters] black buttons

2005-04-19 Thread CPHennessy
You wrote: Hi, I'm writing to you because I'm not sure who to send to. My system: Linux PC, kernel 2.6.11.2, Xorg recent CVS The problem: after installing one of the last cvs of Xorg the buttons of OOo 1.1.1 went (almost all the active) black, some completely black, but some with only

Re: [users] OOo 1.9.79, Cannot change text doluimn to numbers

2005-04-19 Thread CPHennessy
On Wednesday 13 April 2005 03:40, Art Fore wrote: Have tried all versios up to the above version, have a file where a column is numbers preceded by ' , selecting Format, then number, will not change this to a number. his screws up someone using the file and wanting to change the column to

[users] Installation of OO 2.0beta in Solaris Sparc?

2005-04-19 Thread Peter O'Shea
I downloaded both the 2.0beta and the most recent snapshot for Solaris Sparc. After unpacking the tar.gz file, there doesn't seem to be any install program. This is what I find when I untar the most recent snapshot: 2 -rw-r--r-- 1 poshea apg 798 Apr 11 20:58 LICENSE 4

[users] Screw up

2005-04-19 Thread Orjan Henningson
After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this program, the word idiots come to my mind, but I will not use it,

[users] Missing Lines on spread sheet. protection is off.

2005-04-19 Thread Normanbates U.S.N. Retired
When starting new spread sheet After inserting information and creating the lines I need ,they show up on print preview but do not show up on printed page. I have reinstalled program but still have same problem. any ideas . Norman Bates. E-Mail is [EMAIL PROTECTED]

Re: [users] [moderated]

2005-04-19 Thread john fisher
Eh, Perhaps you don't quite understand that OOo is open software. The mailing lists are the principle ( and very effective ) way of providing support. Software and support are free. The developers who can all be contacted personally on mailing lists, are a bunch of volunteers. Anyone in the entire

Aw: Re: [users] Saving problems openoffice 2.0

2005-04-19 Thread hdbender
Ladies and gentlemen, I received your response, but I didn't find any message, except the one that I sent to you. Kind regards - HDBender - Original Nachricht Von: help hints for unsubscribed users [EMAIL PROTECTED] An: [EMAIL PROTECTED] Datum: 18.04.2005 15:38 Betreff:

[users] [moderated]

2005-04-19 Thread STCO112
I downloaded Perfect Pro Office by Cosmi and am now advised I have to download openoffice.org/1.1.4/index, so am doing this.I am trying to break up 30,000 line files into 10,000 line files so if I have 1 file now, I will have 3 files when done etc. Stan

[users] [moderated]

2005-04-19 Thread EAStandish
where is the dictionary for the spelling corrector in German, please? Elke

[users] MORE INFO?

2005-04-19 Thread DALLAS COPPERTHWAITE
HI, I AM WONDERING IF ANYONE CAN HELP SUPPLY A MANUAL FOR OPEN OFFICE I AM NEW AT THE PROGRAMME AND KEEP GETTING LOST WHEN TRYING TO COMPLETE SIMPLE TASKS? THANKS DALLAS [EMAIL PROTECTED]

RE: [users] [moderated]

2005-04-19 Thread Thomas Blasejewicz
Thank you for your mail I am sorry. I found the Open Office Org. site, the download corner and there the dictionaries (including the said dictinstaller where the downloaded files are ONLY three gif images!), but I don't know any wizard. I also don't know what to do with your hint:

[users] Odd behaviour with incorrectly set clock

2005-04-19 Thread James Tappin
This is probably more a curiosity than anything, but it might ring a bell with someone. I was running OO 1.1.3 on Debian PPC (iBook), and it so happened that the system clock was way off (giving a date of Jan 1904) probably as a result of PRAM corruption during an OSX upgrade plus failing to get

Re: [users] Screw up

2005-04-19 Thread Alan McKinnon
On Monday, 18 April 2005 16:18, Orjan Henningson wrote: After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this program,

Re: [users] html to pdf

2005-04-19 Thread G. Roderick Singleton
On Mon, 2005-04-18 at 19:37 -0600, Jones'y wrote: I'm trying to export an HTML document to PDF format and have the links still work. I've searched OO.org for answers and found none so far. Win98SE OO 1.1.4 Acrobat 6 (most current for Win98SE) I've created an OO HTML document

Re: [users] Screw up

2005-04-19 Thread Dan Lewis
On Monday 18 April 2005 09:18 am, Orjan Henningson wrote: After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this program,

Re: [users] Screw up

2005-04-19 Thread z.a.kaleta
Dnia poniedziaek, 18 kwietnia 2005 16:18, Orjan Henningson napisa: After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this

Re: [users] Screw up

2005-04-19 Thread G. Roderick Singleton
On Mon, 2005-04-18 at 08:18 -0600, Orjan Henningson wrote: After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. Really? Then you deleted the original files as

Re: Aw: Re: [users] Saving problems openoffice 2.0

2005-04-19 Thread Dan Lewis
On Monday 18 April 2005 01:51 pm, [EMAIL PROTECTED] wrote: Ladies and gentlemen, I received your response, but I didn't find any message, except the one that I sent to you. Kind regards - HDBender - Original Nachricht Von: help hints for unsubscribed users [EMAIL PROTECTED]

Re: [users] [moderated]

2005-04-19 Thread Dan Lewis
On Monday 18 April 2005 01:53 pm, [EMAIL PROTECTED] wrote: I downloaded Perfect Pro Office by Cosmi and am now advised I have to download openoffice.org/1.1.4/index, so am doing this.I am trying to break up 30,000 line files into 10,000 line files so if I have 1 file now, I will have 3

Re: [users] Problem with auto recovery screen in 2.0 beta

2005-04-19 Thread Brian
Dan Lewis wrote: I have similar problems with Win 98SE on a laptop. I have no such problems with the 1.1.79 or 1.1.90.1 on Windows 98SE, so I would suggerst it is not a Win98 problem Brian - To unsubscribe, e-mail: [EMAIL

[users] Re: [moderated]

2005-04-19 Thread Russell Butler
Thomas Blasejewicz wrote: Thank you for your mail I am sorry. I found the Open Office Org. site, the download corner and there the dictionaries (including the said dictinstaller where the downloaded files are ONLY three gif images!), but I don't know any wizard. I also don't know what to do with

[users] Re: [moderated]

2005-04-19 Thread Russell Butler
[EMAIL PROTECTED] wrote: where is the dictionary for the spelling corrector in German, please? Elke Hi Elke Which version of OOo do you have? Look here: http://user-faq.openoffice.org/faq/ar01s05.html#id2874386 In version 1.1.4 File-Autopilot-Install Dictionary should work, if you are online.

[users] Re: Screw up

2005-04-19 Thread Russell Butler
Orjan Henningson wrote: After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this program, the word idiots come to my mind, but

[users] Re: MORE INFO?

2005-04-19 Thread Russell Butler
DALLAS COPPERTHWAITE wrote: HI, I AM WONDERING IF ANYONE CAN HELP SUPPLY A MANUAL FOR OPEN OFFICE I AM NEW AT THE PROGRAMME AND KEEP GETTING LOST WHEN TRYING TO COMPLETE SIMPLE TASKS? THANKS DALLAS [EMAIL PROTECTED] Hi Dallas See http://support.openoffice.org/index.html There is lots of

Re: [users] [moderated]

2005-04-19 Thread Andrew Fisk
It took me a month or so of thinking before I dumped MS- Office -- I started out using NeoOffice, on a few projects, and then made it my default program for opening MS office docs. I have not hit any snags yet -- and yes I copy and paste spreadsheets into Word processing docs. If you already

Re: [users] Problem with auto recovery screen in 2.0 beta

2005-04-19 Thread Dan Lewis
On Tuesday 19 April 2005 09:40 am, Brian wrote: Dan Lewis wrote: I have similar problems with Win 98SE on a laptop. I have no such problems with the 1.1.79 or 1.1.90.1 on Windows 98SE, so I would suggerst it is not a Win98 problem Brian Would you please quote more of my email?

Re: [users] OOo 1.9.79, Cannot change text doluimn to numbers

2005-04-19 Thread Ennio-Sr
* CPHennessy [EMAIL PROTECTED] [180405, 22:30]: On Wednesday 13 April 2005 03:40, Art Fore wrote: Have tried all versios up to the above version, have a file where a column is numbers preceded by ' , selecting Format, then number, will not change this to a number. his screws up someone

Re: [users] duplicating sheet area

2005-04-19 Thread Eike Rathke
Hi Rich, On Tue, Apr 19, 2005 at 13:18:53 +0300, Rich wrote: is there a way to duplicate some area in a spreadsheet so that everything is preserved (including row height) ? Mark the entire row before copying to the clipboard, not just part (some cells) of it. Shift-Space or using the mouse

[users] saving chart in calc as an image or encaps. ps file

2005-04-19 Thread Muge Karagoz Unel
Hi, I would like to be able to save the chart in my spreadsheet as an image file or even better an encapsulated ps file, as is. also, how to print only the chart to a a printer? when i select the chart and say print, it prints the whole spreadheet.. i am using 002.0 beta (and it actually crashes

Re: [users] Problem with v.1.9.93 Base

2005-04-19 Thread Andrew Cassels
Yes, you'r right it is F4 and not F5, my mistake, sorry. on 19.04.2005 12:36 Dan Lewis said the following: On Tuesday 19 April 2005 03:48 am, Andrew Cassels wrote: Hello, I have a problem, I want to open a .odb database, it opens but when I click with the Tables button, there is a error

[users] Takes time

2005-04-19 Thread Renjoy Henry
HI, I am user of open office. Somethig that I find irritating about this is , it takes a long time to open. For me it takes around 30 sec to 60 sec to open the open office. I am having fedora core 3. 1.9 is slower than 1.1 version. Please let me know if something can be done about this. Regards

[users] [moderated] Updates and securitiy patches

2005-04-19 Thread Pfeifer, Erwin
I want to forward two questions our admins asked me recently, in : a) Is there a strategy or a roadmap for updates and security patches for the future and how often will this occure? b) The security patch of last friday can only be applied to the last version of OpenOffice.org (1.1.4). Is this

Re: [users] Screw up

2005-04-19 Thread z.a.kaleta
Dnia poniedziaek, 18 kwietnia 2005 16:18, Orjan Henningson napisa: After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this

[users] TL645MI.DLL installation error

2005-04-19 Thread Raúl Campiglia
I've installed OpenOffice 1.1.4 in a PC running with WinXP and had no problems at all. When I tried to install the same installation files in a PC with Win Me (Millennium Edition) I've got the TL645MI.DLL error and the suggestion to restart my computer (with no better results... of course). I

[users] More than four recent files list

2005-04-19 Thread Álvaro Vallejo
Hi, Is there a way to show more than four items in the recent files list in the File menu of each OOo application? Four items are simply too few, especially if they are shared in all OOo applications. OS: WinXP OOo version: 1.1.4 Thanks!

Re: [users] [moderated]

2005-04-19 Thread Richard
On Saturday 16 April 2005 06:16 am, Thomas Blasejewicz wrote: Ladies and Gentlemen The other day I learned about Open Office through a mailing list. Since I do not like (hate) Microsoft Office, yet have to use it for my job, I would really like to try Open Office. Reccomend with all my heart

Re: [users] More than four recent files list

2005-04-19 Thread David Johanson
Álvaro Vallejo wrote: Hi, Is there a way to show more than four items in the recent files list in the File menu of each OOo application? Four items are simply too few, especially if they are shared in all OOo applications. OS: WinXP OOo version: 1.1.4 Thanks!

Re: [users] Howdo I configure Palm pdb support for RHEL4 version of Openoffice

2005-04-19 Thread Mark R. Blain
On Fri, 15 Apr 2005 16:35:47 +0100, you wrote: I have RHEL 4.0 installed on my PC but the installed version of Openoffice does not read/write Palm .pdb files. Is there a way that I can reconfigure the installation to be able to read/write the .pdb files or will I have to download the latest

Re: [users] Takes time

2005-04-19 Thread G. Roderick Singleton
On Tue, 2005-04-19 at 16:17 +0530, Renjoy Henry wrote: HI, I am user of open office. Somethig that I find irritating about this is , it takes a long time to open. For me it takes around 30 sec to 60 sec to open the open office. I am having fedora core 3. 1.9 is slower than 1.1 version.

Re: [users] TL645MI.DLL installation error

2005-04-19 Thread Paul
I searched the forums and www and found 2-3 reported incidents of this error (in english anyway) however none discussed a solution. Do you have that .dll on your system? Could it be that it is missing on the winME install? Agree with you on the corrupted download. Don't think this has been much

Re: [users] Screw up

2005-04-19 Thread Chris BONDE
I am not sure what you are complaining about. The mistake in allowing OOo to change your WP files or not choosing the English that you want in the language selection Chris from SE BC (that is in Canada also) ( oh by the way Canada has a land mass greater than continental US) After I had

Re: [users] Screw up

2005-04-19 Thread Chris BONDE
Andy: Most of us'n Canuck spell it eh. Chris This is kind of strange -- cause I can pick from 12 different version of English (including one for Canada --ay) , and flip between UK and US versions regularly, and I have never seen open office convert a file without popping up a dialog box

[users] working with templates

2005-04-19 Thread JoanArc
I saw these instructions for making a new template. I'm not familiar with when/how you do that rather than just opening OpenOffice. 1.1.4. One thing I don't like about OOo is the breaks between pages where some of the text I paste from websites end up not being there, but, apparently,

Re: [users] working with templates

2005-04-19 Thread Andrew Douglas Pitonyak
JoanArc wrote: I saw these instructions for making a new template. I'm not familiar with when/how you do that rather than just opening OpenOffice. 1.1.4. One thing I don't like about OOo is the breaks between pages where some of the text I paste from websites end up not being there, but,

Re: [users] working with templates

2005-04-19 Thread Doug Thompson
JoanArc wrote: I saw these instructions for making a new template. I'm not familiar with when/how you do that rather than just opening OpenOffice. 1.1.4. One thing I don't like about OOo is the breaks between pages where some of the text I paste from websites end up not being there, but,