Re: [users] Filter rows

2007-09-09 Thread Johnny Rosenberg
Since you only mentioned columns I thought you were talking about a spreadsheet. I haven't started to explore Base yet, but I THINK you need a macro after all in that case. J.R. 2007/9/9, Dani Valverde <[EMAIL PROTECTED]>: > > Hello, > Thanks. This is for a spreadsheet, isn't it? How could do it

Re: [users] RE: uninstall open office and reset computer to Word as the default word processing program

2007-09-09 Thread James Knott
Joel I. Cohen wrote: > > > > > _ > > From: Joel I. Cohen [mailto:[EMAIL PROTECTED] > Sent: Saturday, September 08, 2007 2:57 PM > To: users@openoffice.org > Cc: 'Joel I. Cohen' > Subject: uninstall open office and reset computer to Word as the default > word processing program > > >

[users] predifined key maps

2007-09-09 Thread Scott Castaline
Is there a listing or someway of finding any pre-assigned special function keystrokes? Such as Alt-F4 to close window which I think is actually an OS function, but may be wrong. - To unsubscribe, e-mail: [EMAIL PROTECTED] For a

Re: [users] RE: uninstall open office and reset computer to Word as the default word processing program

2007-09-09 Thread James Knott
Joel I. Cohen wrote: > > > > > _ > > From: Joel I. Cohen [mailto:[EMAIL PROTECTED] > Sent: Saturday, September 08, 2007 2:57 PM > To: users@openoffice.org > Cc: 'Joel I. Cohen' > Subject: uninstall open office and reset computer to Word as the default > word processing program > > >

Re: [users] System

2007-09-09 Thread James Knott
Sören Andersson wrote: > Hallo! > Can I have windows 98 and use your program and recive the latest file from > for example microsoft office. > Sören > > Depending on your hardware, you should be able to run OpenOffice on Windows 98. It can work with MS Office files, other than the new Office

Re: [users] failed download

2007-09-09 Thread James Knott
[EMAIL PROTECTED] wrote: > I PURCHASED OPEN OFFICE 09-08-07 AND DUE TO PROBLEMS WITH WINDOWS INTERNET > EXPLORER, IT STOPPED RESPONDING AND I WAS UNABLE TO COMPLETE THE DOWNLOAD > PROCESS. PLEASE LET ME KNOW HOW I CAN "RE" DOWNLOAD THE PROGRAM TO MY > COMPUTER. I ALSO PURCHASED AT THE SAME TIM

Re: [users] How print an OpenOffice2 document with HP OfficeJet 7410

2007-09-09 Thread Dave Barton
Copy to Ron - Non-Subscribed Poster. Original Message From: Diabolic Preacher <[EMAIL PROTECTED]> Date: Mon 10 Sep 2007 08:57:02 EST > On 9/9/07, Ron Barton <[EMAIL PROTECTED]> wrote: >> I just downloaded OpenOffice 2 and can't print any documents with >> my HP printer. I've re

Re: [users] RE: uninstall open office and reset computer to Word as the default word processing program

2007-09-09 Thread Richard Detwiler
Copying unsubscribed original poster. Diabolic Preacher wrote: On 9/9/07, Joel I. Cohen <[EMAIL PROTECTED]> wrote: I was given a copy of open office to install on my computer by a company that had the license to distribute. everyone is licensed to distribute. This software has comp

Re: [users] failed download

2007-09-09 Thread Dave Barton
Original Message From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Sun 09 Sep 2007 09:56:30 EST > I PURCHASED OPEN OFFICE 09-08-07 AND DUE TO PROBLEMS WITH WINDOWS > INTERNET EXPLORER, IT STOPPED RESPONDING AND I WAS UNABLE TO COMPLETE > THE DOWNLOAD PROCESS. PLEASE LET ME KNOW

Re: [users] Unable to use spellcheck and autocheck.

2007-09-09 Thread Dave Barton
Copy to Barbara - Non-Subscribed Poster. Original Message From: jonathon <[EMAIL PROTECTED]> Date: Mon 10 Sep 2007 08:19:34 EST > Barbara wrote: > >> how to I persuade it to work? > > a) Download and install English (Canada) dictionaries from ">File >> Wizards >isntall New Dic

Re: [users] Advance Handbook for Base

2007-09-09 Thread Dave Barton
Copy to Eduardo - Non-Subscribed Poster Original Message From: S Perry <[EMAIL PROTECTED]> Date: Mon 10 Sep 2007 09:02:45 EST > There is also [EMAIL PROTECTED] Referenced from the provided link: http://dba.openoffice.org > and > http://documentation.openoffice.org/online_help/ht

Re: [users] Fw: using version 2.2.1 on windows xp; ' ctrl : ' to get today's date;Is there an equivalent on openoffice calc?

2007-09-09 Thread S Perry
You could also write a keyboard macro to do this and assign it to Ctrll+: so that it would be the same as you are used to. Julia Segal <[EMAIL PROTECTED]> wrote: On Excel i used ' ctrl : ' to get today's date; (several times a day; it's driving me mad having to remember the date!) Is there

Re: [users] Fw: using version 2.2.1 on windows xp; ' ctrl : ' to get today's date;Is there an equivalent on openoffice calc?

2007-09-09 Thread S Perry
In Oo Calc you use Shift+Ctrl 3 (on the keyboard, not the number pad). Julia Segal <[EMAIL PROTECTED]> wrote: On Excel i used ' ctrl : ' to get today's date; (several times a day; it's driving me mad having to remember the date!) Is there an equivalent on openoffice calc? Julia Segal [E

Re: [users] Advance Handbook for Base

2007-09-09 Thread S Perry
There is also [EMAIL PROTECTED], and http://documentation.openoffice.org/online_help/htmlhelp/base_index.html Dave Barton <[EMAIL PROTECTED]> wrote: Original Message From: Eduardo Perez Date: Mon 10 Sep 2007 05:07:13 EST > Hello. > I look for information detailed for Base. >

Re: [users] How print an OpenOffice2 document with HP OfficeJet 7410

2007-09-09 Thread Diabolic Preacher
On 9/9/07, Ron Barton <[EMAIL PROTECTED]> wrote: > I just downloaded OpenOffice 2 and can't print any documents with my HP > printer. I've read through some of the HELP information. > Do I need a different printer or different printer software? I didn't fully > understand the HELP suggestions.

Re: [users] failed download

2007-09-09 Thread Diabolic Preacher
download from openoffice.org. who dares charge?? :D On 9/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I PURCHASED OPEN OFFICE 09-08-07 AND DUE TO PROBLEMS WITH WINDOWS INTERNET > EXPLORER, IT STOPPED RESPONDING AND I WAS UNABLE TO COMPLETE THE DOWNLOAD > PROCESS. PLEASE LET ME KNOW HOW

Re: [users] Advance Handbook for Base

2007-09-09 Thread Dave Barton
Original Message From: Eduardo Perez <[EMAIL PROTECTED]> Date: Mon 10 Sep 2007 05:07:13 EST > Hello. > I look for information detailed for Base. > I am advanced user of MS Access. > > Sorry for my poor English Your English is fine. At the moment there is not a lot of advanced

Re: [users] RE: uninstall open office and reset computer to Word as the default word processing program

2007-09-09 Thread Diabolic Preacher
On 9/9/07, Joel I. Cohen <[EMAIL PROTECTED]> wrote: > I was given a copy of open office to install on my computer by a company > that had the license to distribute. everyone is licensed to distribute. This software has completely taken over > all of my Word documents; that is a dramatic way of

Re: [users] curseur direct

2007-09-09 Thread Diabolic Preacher
On 9/10/07, nicolas leprevost <[EMAIL PROTECTED]> wrote: > hello! > i m using OOo 2.2.1, and i don t find the button "curseur direct" (this is > in french, it might be: direct dursor in english). > i really need this option! can you help me please?! > Tools-->Options-->expand Openoffice.org Writer

Re: [users] [moderated]cannot password docs

2007-09-09 Thread jonathon
Lynn wrote: > add the password. So if I go to Save As, the password option is disabled. OOo will password protect documents in its native file format only. It will not attempt to password protect documents for other file formats. xan jonathon -- OOo can not correct for incompetence in creating

Re: [users] Unable to use spellcheck and autocheck.

2007-09-09 Thread jonathon
Barbara wrote: > how to I persuade it to work? a) Download and install English (Canada) dictionaries from ">File >Wizards >isntall New Dictionaries"; b) Create and use language specific styles; xan jonathon - To unsubscribe,

[users] How print an OpenOffice2 document with HP OfficeJet 7410

2007-09-09 Thread Ron Barton
I just downloaded OpenOffice 2 and can't print any documents with my HP printer. I've read through some of the HELP information. Do I need a different printer or different printer software? I didn't fully understand the HELP suggestions. Ron Barton

[users] failed download

2007-09-09 Thread [EMAIL PROTECTED]
I PURCHASED OPEN OFFICE 09-08-07 AND DUE TO PROBLEMS WITH WINDOWS INTERNET EXPLORER, IT STOPPED RESPONDING AND I WAS UNABLE TO COMPLETE THE DOWNLOAD PROCESS. PLEASE LET ME KNOW HOW I CAN "RE" DOWNLOAD THE PROGRAM TO MY COMPUTER. I ALSO PURCHASED AT THE SAME TIME 30 DAYS OF TECH SUPPORT WHICH I

[users] Unable to use spellcheck and autocheck.

2007-09-09 Thread Barbara Lister
I am using version 2.2 of Open Office.org . (Vista Professional is the operating system on this machine) My problem is that spellcheck and automatic check does not work. A message did briefly appear as I tried to sort out the problem saying' that the language English/ Canada does not support sp

[users] Fw: using version 2.2.1 on windows xp; ' ctrl : ' to get today's date;Is there an equivalent on openoffice calc?

2007-09-09 Thread Julia Segal
On Excel i used ' ctrl : ' to get today's date; (several times a day; it's driving me mad having to remember the date!) Is there an equivalent on openoffice calc? Julia Segal [EMAIL PROTECTED]

[users] System

2007-09-09 Thread Sören Andersson
Hallo! Can I have windows 98 and use your program and recive the latest file from for example microsoft office. Sören My E mail: [EMAIL PROTECTED]

[users] RE: uninstall open office and reset computer to Word as the default word processing program

2007-09-09 Thread Joel I. Cohen
_ From: Joel I. Cohen [mailto:[EMAIL PROTECTED] Sent: Saturday, September 08, 2007 2:57 PM To: users@openoffice.org Cc: 'Joel I. Cohen' Subject: uninstall open office and reset computer to Word as the default word processing program I was given a copy of open office to install

[users] Advance Handbook for Base

2007-09-09 Thread Eduardo Perez
Hello. I look for information detailed for Base. I am advanced user of MS Access. Sorry for my poor English - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] curseur direct

2007-09-09 Thread nicolas leprevost
hello! i m using OOo 2.2.1, and i don t find the button "curseur direct" (this is in french, it might be: direct dursor in english). i really need this option! can you help me please?!

[users] [moderated]cannot password docs

2007-09-09 Thread Lynn anderson
OpenOffice.org version other on Windows 95/98/ME. In area Writer, cannot password docs The document was originated in word with a password, when I opened it in ooo it still had the password, but when I go to close it in ooo it warns me that it is closing without the password, but gives no option to

Re: [users] Massaging data in Calc

2007-09-09 Thread S Perry
Upon inspection, it looks as though you're missing a right parenthesis ) near the end of {=IF(ISERR(FIND(" ";D2:D569);D2:D569;LEFT(D2:D569;FIND(" ";D2:D569)))} just before the right bracket. Joe Greene <[EMAIL PROTECTED]> wrote: Sadly enough they are entered in all of the above and occasio

Re: [users] Massaging data in Calc

2007-09-09 Thread Joe Greene
Sadly enough they are entered in all of the above and occasionally there's a name thrown in or a mark like (w) or (c). but if there's more than one in a cell (in some cases there are up to 4) in the column, they are always separated by spaces. The random names and marks I can clean

Re: [users] Open form from another form

2007-09-09 Thread S Perry
Dear Dani, What version of OpenOffice are you using? What platform? There seems to be some misunderstanding of the directions I sent you previously. Bookmarks can only be used in Text files in OpenOffice. If you're using Calc, then your reference must be a Named Range, such as your form, o

Re: [users] Filter rows

2007-09-09 Thread Dani Valverde
Hello, Thanks. This is for a spreadsheet, isn't it? How could do 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

Re: [users] Enter key always goes to the cell below in spreadsheets

2007-09-09 Thread Diabolic Preacher
On 9/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > well i hope i have made it easier for most people to understand > > your special requirements. > > To clear things up this is not my requirements. I was just making > suggestions. aww! so there are needs for votes then. -1 from me. :)

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

Re: [users] Open form from another form

2007-09-09 Thread Dani Valverde
Sorry, but I still having problems. I have a form called DayData, and from it I would like to open a form called Spots. I have inserted a bookmark in the form Spots called Spots, and then in the URL combobox I have written the bokmark name (Spots), but nothing happens. Which could be the proble

Re: [users] Massaging data in Calc

2007-09-09 Thread S Perry
Hi Joe, How are your phone numbers entered? 000333 000-333- 000333444 111222 000-333- 111-222- Or, some other format? This information will help us help you figure this out. Joe Greene <[EMAIL PROTECTED]> wrote: I'm trying to do something I thought wo

Re: [users] Shortcut

2007-09-09 Thread S Perry
Joe, Cor is indeed correct about the shortcut included in Oo 2.3., however, it is only for English keyboard layouts. Shortcut keys show formulas The shortcut key Ctrl~ toggles between formula result and formula For all cells on a sheet. (English keyboard layouts only.)

Re: [users] Shortcut

2007-09-09 Thread Cor Nouws
Hi Joe, Joe Marks schreef: Working in Germany, is there a short cut to change between normal view and formula view that is similar to Strg + # in MS Office? On the list info for 2.3 (some info is to be added though) you can see it here, http://wiki.services.openoffice.org/wiki/New_Features_

Re: [users] Open Office problem in Kubuntu Feisty

2007-09-09 Thread S Perry
Is this a new installation? or a new problem arising in a previous installation? What version of OpenOffice are you using? Gordon Chan <[EMAIL PROTECTED]> wrote: Hello there, I have a problem when I am trying to fire up open office by either clicking the button on menu, or from a shell ("oof

Re: [users] Shortcut

2007-09-09 Thread S Perry
Joe, OpenOffice.org Calc Options Defines various settings for spreadsheets, contents to be displayed, and the cursor direction after a cell entry. You can also define sorting lists, determine the number of decimal places and the settings for recording and highlighting changes.

Re: [users] Enter key always goes to the cell below in spreadsheets

2007-09-09 Thread Diabolic Preacher
On 9/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > its not just a simple enter and home key combo. > > > > it'll be good if more and more people could test for > > abnormalities or 'catches' in this feature. > > You are correct the combo I was talking about using will only work > if the da

Re: [users] Open form from another form

2007-09-09 Thread S Perry
Dani, Here's the information you seem to be seeking that is found by clicking HELP: Inserting Hyperlinks You can insert hyperlinks in two ways: as text or as a button. In both cases, the visible text can be different from the URL. Display the Hyperlink Bar by choosing V

Re: [users] Open form from another form

2007-09-09 Thread Dani Valverde
Furthermore, I would like to open it with a button action. Does anyone have a macro to open a form from another form with a button action? I have no idea on macro programming... En/na S Perry ha escrit: Include a hyperlink to the form you wish to open. It's on the INSERT menu. Dani Valver

Re: [users] Open form from another form

2007-09-09 Thread S Perry
Links are not limited to external data. Simply include the reference to the form that you wish to open, just as you would for making a calculation with a reference to another form or sheet. Dani Valverde <[EMAIL PROTECTED]> wrote: I have been thinking about it, but the problem is that the h

Re: [users] Open form from another form

2007-09-09 Thread Dani Valverde
I have been thinking about it, but the problem is that the hyperlink links you to an external document, and what I need is to open a form from the same database. En/na S Perry ha escrit: Include a hyperlink to the form you wish to open. It's on the INSERT menu. Dani Valverde <[EMAIL PROTE

Re: [users] Open form from another form

2007-09-09 Thread S Perry
Include a hyperlink to the form you wish to open. It's on the INSERT menu. Dani Valverde <[EMAIL PROTECTED]> wrote: Hello, How can I open a form from another form? Best regards, Dani - To unsubscribe, e-mail: [EMAIL PROTECT

[users] Open form from another form

2007-09-09 Thread Dani Valverde
Hello, How can I open a form from another form? Best regards, Dani - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Enter key always goes to the cell below in spreadsheets

2007-09-09 Thread linuxmaillists
On Sunday 09 September 2007 04:07:20 Diabolic Preacher wrote: > On 9/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > On Sunday 09 September 2007 01:58:03 Diabolic Preacher wrote: > > > > This could be done in OOo by setting up a short cut key that > > fires Enter and Home. The cursor would

Re: [users] Open Office problem in Kubuntu Feisty

2007-09-09 Thread Frank Cox
On Sun, 9 Sep 2007 09:55:49 +0100 "Gordon Chan" <[EMAIL PROTECTED]> wrote: > X Error: BadDevice, invalid or uninitialized input device 169 > Major opcode: 148 > Minor opcode: 3 > Resource id: 0x0 > Failed to open device > X Error: BadDevice, invalid or uninitialized input device 169 > M

[users] Shortcut

2007-09-09 Thread Joe Marks
Working in Germany, is there a short cut to change between normal view and formula view that is similar to Strg + # in MS Office? Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user

[users] Filter rows

2007-09-09 Thread Dani Valverde
Hello, I have a table with three columns callesd "Name", "LastName" and "eMailAdress". I enter that data using a form. I would like that only one row can have the same combination of "Name"+"LastName", and that when you intend to submit a duplicated row a message appears saying something like

[users] Open Office problem in Kubuntu Feisty

2007-09-09 Thread Gordon Chan
Hello there, I have a problem when I am trying to fire up open office by either clicking the button on menu, or from a shell ("ooffice -writer"). The Open Office splash screen would appear, but then nothing would happen afterwards. I have provided here the log when I tried to start Open Office fro

Re: [users] Enter key always goes to the cell below in spreadsheets

2007-09-09 Thread Diabolic Preacher
On 9/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > On Sunday 09 September 2007 01:58:03 Diabolic Preacher wrote: > This could be done in OOo by setting up a short cut key that fires > Enter and Home. The cursor would move down and back to the 1st > column. what if your table doesn't start