Re: [users] Poorly displayed fonts in OOo

2007-06-29 Thread TerryJ
Hello, You could try removing the offending user settings folders (after exiting all OOo processes) or, alternatively, copying the good folder to the recalcitrant accounts. Messy hacking, I know, but that's what you have to do with this software at times. Martin Cockburn wrote: Hello, I am

Re: [users] Macros not active on new machine?

2007-06-29 Thread TerryJ
is having the macro in the My Macros group? Should it be in the spreadsheet name group? Anyway, I still cannot get the macros over to the second machine so I'm really in need of some help. Thanks, Mark On 6/21/07, TerryJ [EMAIL PROTECTED] wrote: Are you using the .ods format? Macros

Re: [users] Say NO to the Microsoft Office format as an ISO standard

2007-06-21 Thread TerryJ
Hagar de l'Est wrote: Hi All, Please sign the petition here : http://www.noooxml.org/petition/ (cookies have to be enabled for this site) Thanks, Hagar 2466 votes at this very minute. I appreciate your efforts, Hagar de l'Est. I saw your post on 8daysaweek.co.uk and voted.

Re: [users] How to run macro on dialog startup?

2007-06-21 Thread TerryJ
adam.schirmacher wrote: Is there a way to run a macro upon the opening of a dialog? I don't mean when any dialog is oepened, but when this specific dialog is opened. You can use a dialogue to run a macro. What exactly do you want to do? -- View this message in context:

Re: [users] Macros not active on new machine?

2007-06-21 Thread TerryJ
Are you using the .ods format? Macros would not, I think, be converted to the .xls format. Mark Knecht wrote: Hi Anthony, The macro was developed on the first machine and in the spreadsheet that I wanted to use it in. That spreadsheet should (I think) already have the macro in it,

Re: [users] Decimal seperator

2007-06-06 Thread TerryJ
Christian Foerg wrote: On Friday June 01 2007 3:21 am, Christian Foerg wrote: Hi guys, I've got a very annoying configuration problem. My default language is German (Germany) so I'd like to have German default settings. Except one: The decimal seperator. Is it possible to change the

Re: [users] Missing VCL resource

2007-06-01 Thread TerryJ
Richard G Morrison wrote: I downloaded and installed Open Office 2 twice with the same subject error. It then returned language Not Determined. I'm running WinXP SP2. Can you tell me what's wrong? One thing you should check, especially when you cannot install the downloaded file, is

Re: [users] Language settings in formulas (Calc)

2007-06-01 Thread TerryJ
Verner Kjærsgaard wrote: Hi list, - foregive me, but I can't seem to find this.. - I'm using OO v2.2 Danish on Linux. Works sweet. - I'd like to use the original english function names when writing formulas in Calc. - in other words, I'd like to write something like:

Re: [users] Decimal seperator

2007-06-01 Thread TerryJ
Christian Foerg wrote: Hi guys, I've got a very annoying configuration problem. My default language is German (Germany) so I'd like to have German default settings. Except one: The decimal seperator. Is it possible to change the default decimal seperator without changing the

Re: [users] File-extension management

2007-06-01 Thread TerryJ
jimw wagner wrote: The other day I loaded the latest Ubuntu, and with it came OO-2.2.2 included. In the process of saving files, I find that it does not have the dialog which allows one to change the file-extension. That is, you can put in the new file extension, but unless you

Re: [users] Calc: eval fcn and store value

2007-06-01 Thread TerryJ
Kenn Goutal wrote: In Calc, I want to be able to store the VALUE of the current date -- whatever it is -- into a particular cell, such that at some future date it will still show today's date. That is, if today is June 1, 2007, I want to store *that*, not an expression that today

Re: [users] OO causes xorg to hang when menu is clicked

2007-06-01 Thread TerryJ
Comments interlineated: Jeff Powell-3 wrote: I am getting a system hang with OO on a CentOS 5 system. Very often when I open a document (double click a desktop document) and then click on the menu the xorg desktop pseudo freezes. The mouse will be able to move in a subset of the current

Re: [users] BasicProviderImpl::getScript: no script!

2007-06-01 Thread TerryJ
mike scott-2 wrote: The title is the error message I'm receiving, in a message box with some not-useful clutter. I'm attempting an automated document conversion from OOo to word format, presently under XP for testing, while the final target wil be freebsd. To this end, I have a

Re: [users] Recording Using Macros

2007-05-31 Thread TerryJ
Russell Butler wrote: Mitchel Cohen wrote: I'm trying to extract email addresses from a list that includes other information as well that I've compiled in an openoffice writer document. Fortunately (for my tired brain, anyway), each email address is at the end of each line. So,

Re: [users] Missing vcl resource

2007-05-31 Thread TerryJ
Derek van der Watt wrote: Hi I extracted the four archives into a selected folder and tried to double click on the application link to open the program and it said 'missing vcl resource. ..it may be a corrupt installation...' - can you help? derek van der watt

Re: [users] Macro

2007-05-31 Thread TerryJ
Dan Lewis wrote: On Thursday May 31 2007 2:35 pm, Don Durand wrote: Is there a way to import (or use) an Excel macro (.xla) into Calc? Thanks. Yes and no. Excel and Calc use two different but somewhat similar macro languages. The Excel macro has to be modified before it will work

Re: [users] I have a problem

2007-05-26 Thread TerryJ
Indira Carvajal wrote: TENGO UN PROBLEMA CON OPENOFFICE EN CUANTO A LA OPCIÓN QUE EN EXCEL SE DENOMINA: CENTRAR LA SELECCIÓN A NIVEL HORIZONTAL. ESTO INGRESANDO POR FORMATO DE CELDAS -- ALINEACIÓN -- HORIZONTAL --- CENTRAR EN LA SELECCIÓN: Centra el contenido de una celda respecto a

Re: [users] Use of templates in 2.2.0

2007-05-24 Thread TerryJ
Graham Davis-2 wrote: What's happened to the templates in 2.2.0? When I try to create a letter from a template I no longer get a WYSIWYG display. What I get is a mess with numerous Sender (fixed) and Placeholder fields. Other fields are in the form User field x = y. -- Graham

Re: [users] installation

2007-05-24 Thread TerryJ
René Petignat wrote: Hello, I've tried to install the french version of OpenOffice but I obtained a message error 1935. Could you tell me what it means ? Thanks a lot Rene It means you have to stop your anti-virus software running while you install OOo, which means you need to go off

Re: [users] .ods file has been corrupt

2007-05-23 Thread TerryJ
Shalin Shah wrote: Hi, i am using following version of open office and i have lost my data from one of the most improted file, that file is password protected and once i enter pass work it's give me the error: The File mastersheet of dealers april -07.ods is corrupt and

Re: [users] .ods file has been corrupt

2007-05-23 Thread TerryJ
noop-3 wrote: On 05/22/2007 11:49 PM, TerryJ wrote: Shalin Shah wrote: snip snip Similar instructions are here: http://documentation.openoffice.org/HOW_TO/misc/Troubleshooting_guide.html [Recovering content from a damaged OpenOffice.org file 7] course you'll need

Re: [users] looking for python integration help

2007-05-23 Thread TerryJ
David Bear wrote: I'd like to find some group that can help me with python and UNO integration. any pointers? -- David Bear College of Public Programs at Arizona State University Try the Macros API section of www.oooforum.org. The UNO project has mailing lists:

Re: [users] .ods file has been corrupt

2007-05-23 Thread TerryJ
noop-3 wrote: On 05/23/2007 04:50 PM, TerryJ wrote: Whatever happened when OOo moved to the new server? I'll need a wider room before I get a screen that wide. (Slight exaggeration.) I understand that the password (no longer in its pristine form) will prevent the use

Re: [users] hello

2007-05-22 Thread TerryJ
m.a.j.o wrote: this is victor from india well in the open office package, I do not find applications such as outlook express or mozilla thunderbird r u planning to comeout with similar type of applications also victor A statement was reported some time last year to the effect that

Re: [users] how to open text file in open office calc

2007-05-22 Thread TerryJ
Leny wrote: Hi there, How to open text file (.txt, .csv, .tsv) in open office calc? when I choose a file (example .txt file) it automatically open by open office writer . If I see the documentation, it explain that there's the In the dialog that appears next, select the Separator

Re: [users] clipboard does not clear and repeats a paste Copy time after time

2007-05-20 Thread TerryJ
Marlene Jones wrote: I have a Mac OS X and OpenOffice.org 2.0 Yesterday I copied a recipe off the Internet and stored it as a document. Today I tried three times to copy and transfer another document as e-mail text. All three times the recipe appeared. Normally the clipboard

Re: [users] LOOKUP reference problem

2007-05-20 Thread TerryJ
JosephK wrote: Is it possible to use the contents of a cell as the column or row index reference in VLOOKUP or HLOOKUP? My scenario is I have a table of 5000 customers with contact details etc. Another table holds prices for about 300 different products. Each customer or group of

Re: [users] LOOKUP reference problem

2007-05-20 Thread TerryJ
JosephK wrote: On 11:17 Sun 20 May , Brian Barker wrote: At 10:05 20/05/2007 +0100, JosephK wrote: Is it possible to use the contents of a cell as the column or row index reference in VLOOKUP or HLOOKUP? A simple test shows that the answer is yes: there is no reason why the third

Re: [users] LOOKUP reference problem

2007-05-20 Thread TerryJ
JosephK wrote: On 05:00 Sun 20 May , TerryJ wrote: JosephK wrote: On 11:17 Sun 20 May , Brian Barker wrote: At 10:05 20/05/2007 +0100, JosephK wrote: Is it possible to use the contents of a cell as the column or row index reference in VLOOKUP or HLOOKUP

Re: [users] LOOKUP reference problem

2007-05-20 Thread TerryJ
Subject: Re: [users] LOOKUP reference problem On 05:00 Sun 20 May , TerryJ wrote: snip Joseph K Hi, Ken. You have wandered on to the wrong thread. If you are using an email client, you need to set it to sort messages by thread rather than time of receipt. -- View

[users] OOo Users Group

2007-05-17 Thread TerryJ
Talk on the forum about the need for improvements led to one member suggesting an OOo Users' Group. For a glimmering of what that might mean, look at the following and ensuing posts: http://www.oooforum.org/forum/viewtopic.phtml?p=225295#225295 If the forum members are left to their own

Re: [users] Templates

2007-05-17 Thread TerryJ
James Elliott-2 wrote: A conversation with another user prompted this question: When I upgrade my OOo by installing the latest version, how come I get to keep my Templates? I am using OOo under Windows XP and after installing the latest version of OOo, if I right click on the icon

Re: [users] Dbase driver and PHP

2007-05-17 Thread TerryJ
Abul Kashem Md. Hasan wrote: Can I use openoffice dbase driver to connect a dbase file from PHP. Regards. Abul Kashem Md. Hasan Associate Specialist, Database/IT Center for Environmental and Geographic Information Services (CEGIS) House # 6, Road # 23/C Gulshan - 1, Dhaka - 1212

Re: [users] copying, installing, importing, exporting macros and dialogs

2007-05-17 Thread TerryJ
Siegfried Wolkenstein wrote: Hello, I wrote a macro with some dialogs. Now I would like to give it to someone who needs it. How can I provide him with an easy method of installing my macros? Also I don't know how export the macros nor the dialogs. Thanks Hello, If you feel

Re: [users] Problems in openoffice calc

2007-05-15 Thread TerryJ
sergio vanetti wrote: The databank formula (dsum())in Openoffice calc, if you have some data in parentesis () the formula doesn't work. Please, see the attach file (there are no virus) I hope to help all the Openoffice users. Sérgio Vanetti Brazil São Paulo - SP The

Re: [users] font-selection crashes some openoffice versions

2007-05-15 Thread TerryJ
Bernt Christandl wrote: Hello, i have a puzzle that i can't solve and would need some help: I have 3 versions of OOo installed into different subdirectories on our fileserver: 2.2, 2.1, 2.0.4 and i have 3 (types of) PCs running some version of (selfmade/Debian-based) linux all

Re: [users] corrective to Problem while using OpenOffice.org with macro OOoLilyPond/basic/script.xlb -see attachemnt-

2007-05-13 Thread TerryJ
Ledocq-Boccart wrote: please disregard the previous message and replace it by this one! see 2 corrections shown hereafter between *** I am using OpenOffice.org version 2.0.3 on winXP . My problem is : on OpenOffice.org with macro Ctrl+M from OOoLilyPond (version 2.10) The Ctrl+M

Re: [users] Calc: empty toolbar I cannot get rid of

2007-05-13 Thread TerryJ
Kenn Goutal wrote: I have somehow wound up with an empty toolbar that I cannot get rid of. See: http://www.flickr.com/photos/[EMAIL PROTECTED]/494998377/ Come to that, I can't even find any reference to it in Tools-Customize-/Toolbars\. That is, there is no toolbar listed

Re: [users] Help to use in Open office

2007-05-13 Thread TerryJ
nitin-6 wrote: Dear Sir, I am Using open office in win98 operating system but network file's are not open direcly, i will open first blank file and than open file-open-than file, it is long process i want to open a networ file direcly like ms-office give support help to using open

Re: [users] helpful advice

2007-05-11 Thread TerryJ
Joe Grech wrote: To all who can help.. I intend to compile a book using various extracts from different sites. They are all different as regards fonts etc. I presume this book, including numerous coloured pix and diagrams, will run to a couple of hundred pages. Any suggestions as

Re: [users] Open Office Spreadsheet Scrolling Problem

2007-05-10 Thread TerryJ
Michael Schatte wrote: Hi folks, I'm on both a MacBook and an iMac running Tiger, and on both systems while using the OpenOffice Spreadsheet program I encounter a frustrating problem. When I use either a scroll wheel on a mouse or the laptop trackpad scrolling function, open

Re: [users] HyperLink Background Color

2007-05-10 Thread TerryJ
Featherstone D. S. wrote: Hi, Thanks for a great product. I imported an Excel spreadsheet and everything works great but I do have a question. In all the cells that have HyperLinks, url's email address', there is a blue background around the link and I can't get rid of it. I

Re: [users] Follow-up to McAfee's Site Advisor Rating

2007-05-08 Thread TerryJ
Larry Kollar-2 wrote: On 5/8/07, Rocky Cooper [EMAIL PROTECTED] wrote: I just brought up my sent email to you, and McAfee displayed a warning that my first email contained a link to a potentially unsafe website, open-oasis.org. Hmmm You might want to consider removing your ties

Re: [users] Screen refresh in spreadsheet

2007-05-07 Thread TerryJ
I've inserted one comment. Cheers. Bill Gradwohl wrote: On Fri, 2007-05-04 at 20:17 -0700, TerryJ wrote: Regarding screen refreshing, there is a discussion here: http://www.oooforum.org/forum/viewtopic.phtml?t=49527 This causes the whole app to disappear showing the desktop instead

Re: [users] Calc

2007-05-06 Thread TerryJ
Stan, it isn't helpful to post a reply as a new thread. The easiest way, probably, to copy the formula is to select the entire range in which you wish to have the formulas (including the cell containing the formula) and use Edit Fill Down. Stan Hutchinson wrote: Thanks, that is what I

Re: [users] When copying from Opera to calc now asked if OK???

2007-05-06 Thread TerryJ
GregChi wrote: On Thu, 03 May 2007 14:21:49 -0400, GregChi wrote: OOo ver 2.2.0 When copying from Opera pasting to Calc a 'Text Import' window pops up (character set unicode) I need to click OK. WHY? (Didn't happen in OOo 2.1) How do I set this to ALWAYS accept the copied info

Re: [users] Calc2

2007-05-06 Thread TerryJ
Stanley Hutchinson wrote: OOPS, Didn't look at it that way Thanks again for the help shandih How are you sending replies? They are being published as separate threads. If you are using an email client, select the message to which you wish to reply, then use

Re: [users] scalc - Extracting certain rows - is it possible

2007-05-04 Thread TerryJ
Hi. Only one comment, interlineated. Mark Knecht wrote: Hi Terry - Thanks for the response. On 5/3/07, TerryJ [EMAIL PROTECTED] wrote: Mark Knecht wrote: SNIP snip What is the criterion for deciding the page to which a particular row is copied? Old stock date sold

Re: [users] Q in OO calc 2.1

2007-05-04 Thread TerryJ
Indra Gunawan-3 wrote: I have 3 files such as file1, file2 'n file3. how to added the value of file1 + file2 and the result in file3. Usually i use Link in excel and everytime the value in one of file was changed. the result automatic changed. how to implement in OO. anyone help me

Re: [users] Screen refresh in spreadsheet

2007-05-04 Thread TerryJ
Bill Gradwohl wrote: Is there any way to stop all screen activity while a macro is executing? I've written some basic macros and during their operation, cells get reset to 0, columns get deleted, things get moved around, etc. Each of those actions causes the screen to refresh which

Re: [users] scalc - Extracting certain rows - is it possible

2007-05-03 Thread TerryJ
Mark Knecht wrote: Hi, I'm not sure if this sort of thing is even possible in a spreadsheet but hopefully this is the place to ask. Thanks in advance for your indulgence. I have a spreadsheet with roughly 5000 stock trades. The basic idea of the data set is that there are always

Re: [users] help please

2007-05-03 Thread TerryJ
Jerry I Mills wrote: Hi, I have just installed vers 2.2 but cannot get it to start. The installation went fine and I see Openoffice and the sub programs in my Programs list. But when I click on it or a sub program like calc nothing happens. Nothing opens. I installed it twice.

Re: [users] Donation

2007-05-03 Thread TerryJ
Carol Rogala wrote: Hi: Your web page will not let me use my credit card because I used to have a Pay Pal account. I am using a valid Visa credit card and it won't go thru. So if you want the donation, please fix this. I think it has to do with you having the credit card info on a

Re: [users] Good place to store Macros for Everyones use...

2007-05-02 Thread TerryJ
process... I wish there was an explanation of what the above process is actually doing (I am an under the hood kinda guy) but maybe now I can figure it out and write it down... So, thanks again for all the help... WPH TerryJ wrote: WP Hewitt wrote: I have been looking around and I

Re: [users] Reference a cell to a document that's OOo password protected does not work

2007-05-02 Thread TerryJ
Kirill S. Palagin wrote: Hello. I have two password-protected spreadsheets. One spreadsheet references cells in the other spreadsheet and if source is closed then Calc would not ask for a password. Is there any workaround (while we wait for issue 24535 to be fixed)? Thanks. WBR, K.

Re: [users] Good place to store Macros for Everyones use...

2007-05-01 Thread TerryJ
WP Hewitt wrote: I have been looking around and I cannot find out where to put Macros so they are accessible and everyone using Open Office can use them Lots on how to write one, but where does one prefer to install them? WPH Look in the following thread for links relating to

Re: [users] Data validation in Calc with dates does not function properly

2007-05-01 Thread TerryJ
Paul Dom wrote: I am using OpenOffice 2.2 Dutch version. I have a problem of validating a date cell in Calc. I try to ensure that the value I enter is before 01/01/2007. (Or after a certain date.) I use the menu Data, Validation and enter Date as content and maximum value =

Re: [users] Calc changes in v2.2 OOo for Windows

2007-05-01 Thread TerryJ
Glenn Skitch wrote: Hi all I am using version 2.2 of OpenOffice in Windows XP sp2+updates. Unfortunately I cannot find an adequate avenue for submitting what may be a bug, and I haven't been able to find it in a FAQ. Anyway, here is the issue. I just upgraded from v2.1 to 2.2,

Re: [users] quick question about formula entering

2007-04-30 Thread TerryJ
Tecmar wrote: Is there a way in CALC to set it so a formula can start with the plus sign? It is so much easier as the plus sign is on the number pad. Office has been doing this forever, am I missing something? Thanks in advance. Jake Script has been published on the forum to

Re: [users] Cannot compile 2.2.0

2007-04-27 Thread TerryJ
Russbucket wrote: On Thursday April 26 2007 17:45, TerryJ wrote: Russbucket wrote: Just downloaded 2.2.0 from the OpenOffice.org website several times. when I execute the following command: tar -xvzf OOo_2.2.0_LinuxIntel_install_wRJE_en-US.tar.gz I get the following errors

Re: [users] How to Purchase Your CD

2007-04-26 Thread TerryJ
George Yankura wrote: Dear Administrator: Yesterday's, 4/24, issue of The New Mexican carried an article by Joseph Jones, The Tech Dude, highly extrolling your program. He advises using your torrent to download the program, however I am unable to find that pathway on your

Re: [users] Cannot compile 2.2.0

2007-04-26 Thread TerryJ
Russbucket wrote: Just downloaded 2.2.0 from the OpenOffice.org website several times. when I execute the following command: tar -xvzf OOo_2.2.0_LinuxIntel_install_wRJE_en-US.tar.gz I get the following errors: tar: OOo_2.2.0_LinuxIntel_install_wRJE_en-US.tar.gz: Cannot open: No such

Re: [users] skip over protected cell in spreadsheet

2007-04-26 Thread TerryJ
Bill Gradwohl wrote: On Wed, 2007-04-25 at 05:50 -0700, TerryJ wrote: The tab key should do that. If not, assign a keybinding using Tools Customise : Keyboard : Navigate : To next unprotected cell. Didn't know that was there. Thanks. But --- this doesn't help me navigate

Re: [users] skip over protected cell in spreadsheet

2007-04-25 Thread TerryJ
Bill Gradwohl wrote: Is there any way to have the application not even land on protected cells? i.e. When arrowing around in any given direction, skip over cells that can't be modified due to protection and land on the next cell in the direction that can be modified (not protected)

Re: [users] I need some help!

2007-04-25 Thread TerryJ
Butch-3 wrote: I used to be fairly fluent in Computereese but I've had a stroke. Now I try to install Open Office 2.2 and I get an icon that doesn't do anything and I can't seem to change the properties for it to open Quickstart. I believe thats what I need to start the program. I

Re: [users] Database

2007-04-25 Thread TerryJ
Dave Barton-4 wrote: Original Message From: Mohd Afifuddin Bin Omar [EMAIL PROTECTED] Date: Thu 26 Apr 2007 12:39:29 EST Hi there, Is there anybody who can assist me on OpenOffice to open MDB file? Thanks. Regards Afifuddin This link may help.

Re: [users] Calc

2007-04-22 Thread TerryJ
d.hedge wrote: Open Office 2.2 Could you please let me know why when I put a date in column A any cell it changes it to a number I can fiddle about and get a date eventually but it is time consuming. Also. Is there a reason why when I go to save the pages to disk it will

Re: [users] OpenOffice org.Calc 2.2

2007-04-18 Thread TerryJ
This list is English. Look here: http://de.openoffice.org/ Gruß Terry Dieter Pohle wrote: Hallo, mein Problem Unterstreichen einer Zelle ist ja nun gelöst. Nun habe ich aber mit der Formel Zählenwenn ein Problem. In Excel kann man z.B. in einer Zelle zwei oder mehrere Namen

Re: [users] Missing Text

2007-04-16 Thread TerryJ
BC Cheah wrote: I am using version 2.02 of Open Office.org. My problem is I have missing text usually towards the end of my sentence after saving. It occurs when I am using Open Office Calc. I have tried to uninstall and install the Open Office software but it doesn't seems to help much.

Re: [users] Calc 2.04 cell colouring dependant on formula result

2007-04-15 Thread TerryJ
Klaas Visser wrote: On 15-Apr-07 16:50 (+1000 UTC), *Hylton Conacher (ZR1HPC)* posted: I have a formula in a cell (=SUM(Apr.D3:Apr.D30)/(COUNT(Apr.D3:Apr.D32)*30)*1000) and would like the cell background of that same cell change colour as the formula result changes. If the formula

Re: [users] Macro question in Calc

2007-04-14 Thread TerryJ
to do. Each cell is independent of the others, so each value is random. I was actually trying to find something along the old GETKEY function to use in an IF statement, but can't get anything to work. Jack On 4/13/07, TerryJ [EMAIL PROTECTED] wrote: Jack Ray wrote: I can't figure

Re: [users] My file cannot be opened. Please help me !

2007-04-14 Thread TerryJ
Aldy Wibowo wrote: I am using version 2.0.2 of OpenOffice.org. My problem is : My confidential file cannot be opened. The reason is corrupt file Can you fix the file ? thanks. Files which are password protected often seem to become corrupted. I believe there is

Re: [users] Using calc in time studies

2007-04-13 Thread TerryJ
Brian Barker wrote: At 08:47 13/04/2007 +0300, Andis Lazdinsh wrote: I'm planning to use openoffice.calc in time studies of forest harvesting, forwarding and other operations. I'm working on the model, where I can insert number of operation (1, 2, 3, ...20) in one column, starting time in

Re: [users] Macro question in Calc

2007-04-13 Thread TerryJ
Jack Ray wrote: I can't figure this out. I need a Macro that will fill a cell with a random integral number, between 2 and 7, when a key is hit, not, as random works normally, whenever the spreadsheet refreshes. Can anyone show me how? Jack I'm guessing this does what you want. It

Re: [users] moving open office from p2p client to my computer

2007-04-13 Thread TerryJ
CAROL ROBINSON wrote: Please help, I have downloaded Open Office (the latest version) using uTorrent p2p, but I don't know how to get it from uTorrent to my computer so I can use it. I realize this is not an Open Office question, but I bet you have lots of users that can help me. thanks

Re: [users] Calc functions

2007-04-12 Thread TerryJ
Johnny Andersson-3 wrote: 2007/4/12, Frank Lohr [EMAIL PROTECTED]: am Donnerstag, 12. April 2007 schrieb Joe Conner: NORMDIST Returns the density function or the normal cumulative distribution. snip This can be found in the Calc Help. I need to know how the NORMDIST()-Funcion

Re: [users] HELP on Uninstalling open office

2007-04-11 Thread TerryJ
vishal gupta-3 wrote: Hi , i am using ooo 2.0.8990 on WinXP professional ( no service packs ) when i try to uninstall it using add/remove programs it asks for the original setup package which i have deleted, and then exits the uninstall. What should i do please help. You may have a

Re: [users] I cannot import from StarWrite

2007-04-11 Thread TerryJ
José Trujillo Carmona wrote: I cannot import texts .sdw of StarWrite 5.0. I obtain: general error of input/output My computer is a AMD 64 running with Debian 4.0 Can you help me? Thank's --- --- --- José Trujillo Carmona UNIVERSIDAD DE EXTREMADURA Facultad de Ciencias

Re: [users] Support the project

2007-04-11 Thread TerryJ
] To: users@openoffice.org Cc: TQ.Hung [EMAIL PROTECTED] Sent: Tuesday, April 10, 2007 8:09 AM Subject: Re: [users] Support the project On Monday April 09 2007 6:05 pm, TerryJ wrote: TQ.Hung wrote: Dear Sir/ Madam ! My name's Hung. I'm working as a project manager in Technological

Re: [users] Calc - Fill series - filling every second row with increment1 ?

2007-04-10 Thread TerryJ
I am always intrigued by questions like this. Assuming your start cell is A1, enter the following formula in A2 and drag it down: =IF(MOD(ROW();2)0;ROW()-ROW($A$1)+1;) Joe Conner wrote: Yes. In cell A1 enter 1. In cell A3 enter =A1+1 Click on cell A2. Holding down the shift key, press

Re: [users] Calc - Fill series - filling every second row with increment1 ?

2007-04-10 Thread TerryJ
I shouldn't have taken 1 as the inevitable beginning: =IF(MOD(ROW();2)0;ROW()-ROW($A$1)+$A$1;) TerryJ wrote: I am always intrigued by questions like this. Assuming your start cell is A1, enter the following formula in A2 and drag it down: =IF(MOD(ROW();2)0;ROW()-ROW($A$1)+1;) Joe

Re: [users] Calc - Fill series - filling every second row with increment1 ?

2007-04-10 Thread TerryJ
My bad. Sorry. I shouldn't have assumed that A1 was the start: (third time lucky) =IF(MOD(ROW()-ROW($A$1)+$A$1;2)0;ROW()-ROW($A$1)+$A$1;) TerryJ wrote: I shouldn't have taken 1 as the inevitable beginning: =IF(MOD(ROW();2)0;ROW()-ROW($A$1)+$A$1;) TerryJ wrote: I am always

Re: [users] Calc - Fill series - filling every second row with increment1 ?

2007-04-10 Thread TerryJ
have been making mischief again yesterday. I tested the issue several times, so it can't have been me. ¿¿¿? =IF(MOD(ROW()-ROW($A$1)+$A$1;2);ROW()-ROW($A$1)+$A$1;) TerryJ wrote: My bad. Sorry. I shouldn't have assumed that A1 was the start: (third time lucky) =IF(MOD(ROW()-ROW($A$1

Re: [users] Question regarding upgrade to OOo 2.2

2007-04-09 Thread TerryJ
Pradeep Srinivas wrote: Folks, Currently running OpenOffice.org 2.1 Intel Linux 2.6.20-1.2311.fc5 Would like to upgrade to OpenOffice.org 2.2 I have downloaded OOo_2.2.0_LinuxIntel_install_wJRE_en-US.tar.gz Questions: Would I need to uninstall OOo 2.1

Re: [users] Default font setting in Calc?

2007-04-09 Thread TerryJ
linuxmaillists wrote: On Monday 09 April 2007, [EMAIL PROTECTED] wrote: In writer I can set the default font to whatever I want it to be so that a new document starts with that font. I have not found where I can do that with Calc. Running 2.2.0 Linux native OOo version on Fedora Core 6

Re: [users] Dumb e-mail question??

2007-04-09 Thread TerryJ
linuxmaillists wrote: On Monday 09 April 2007, William Case wrote: Hi; I couldn't help noticing the number of queries there are on this list from new users / potential users for an integrated Outlook -like component. I use OOo plus evolution. That seems to do everything. What

Re: [users] Excell Macros won't work

2007-04-09 Thread TerryJ
Dan Lewis wrote: On Saturday February 24 2007 1:24 pm, Gerald Glass wrote: I am using Openoffice ver. 2.1 and I cannot get a excell spreadsheet to work in Calc format. It is a spread sheet that I use in my business quite frequently. I obtained the spread sheet from a vendor for doing a

Re: [users] Support the project

2007-04-09 Thread TerryJ
TQ.Hung wrote: Dear Sir/ Madam ! My name's Hung. I'm working as a project manager in Technological Application and Production Company -TECAPRO Which use Open Office software for education's purpose, therefore we need your support in this project interm of Empowerment Letter .

Re: [users] Recent File List

2007-04-09 Thread TerryJ
Gary-88 wrote: Hello, I am currently using Open Office version 2.2 the latest I just recently upgraded from 2.1 now how can I remove the list of recent files in the recent folder as the links are now dead links items I no longer need but cant find a way to the clear the recent list.

Re: [users] Calc - Date auto subtract!

2007-04-08 Thread TerryJ
Steven Lim-3 wrote: Hi. With cell format set to user define - D-MMM-YY, i keyed in 01/01/1972 in cell and the date auto subtracted and appear as 31-Dec-71. Tried several times and this still happens. Please assist. Regards. Steven. The only thing that occurs to me is

Re: [users] I have just download openoffice. I was wondering if you have voice recognition software that is compatible with this program?

2007-04-08 Thread TerryJ
Crystal Brewster wrote: v\:* {behavior:url (#default#vml);} v\:* { BEHAVIOR: url (#default#vml) } Hi. I understand that Dragon Naturally Speaking version 9 works to a degree with Writer at least. Better results are obtained using something called DragonPad.

Re: [users] I have just download openoffice. I was wondering if you have voice recognition software that is compatible with this program?

2007-04-08 Thread TerryJ
Crystal Brewster wrote: v\:* {behavior:url (#default#vml);} v\:* { BEHAVIOR: url (#default#vml) } Hi. My reply got mixed up with your message, so here it is again: I understand that Dragon Naturally Speaking version 9 works to a degree with Writer at least.

Re: [users] OpenOffice.org 2.2 keeps forgetting my dictionary settings, just like OpenOffice.org 2.1 did

2007-04-07 Thread TerryJ
Johnny Andersson-3 wrote: Can anyone please tell me how to make OpenOffice.org to remember that Tools → Options → Language settings → Writing Aids → User defined dictionaries → Johnny's Dictionary always should be checked when OpenOffice.org is started? Every time I start OpenOffice.org,

Re: [users] [moderated] I tried uninstalling Open Office 2 and reinstalling the new version on a partition

2007-04-06 Thread TerryJ
Try these links: http://support.microsoft.com/default.aspx?scid=kb;en-us;290301 http://www.oooforum.org/forum/viewtopic.phtml?t=29662 http://download.microsoft.com/download/e/9/d/e9d80355-7ab4-45b8-80e8-983a48d5e1bd/msicuu2.exe Tom Chilton wrote: Hi, Because of the way windows works you

Re: [users] Calc converts number 4.05 to date - how do I stop?

2007-04-06 Thread TerryJ
Kirill S. Palagin wrote: Hello everybody. I have dot (.) as decimal separator. Whenever I type 4.05 (without quotes) Calc helpfully converts this to date. I can not format cells as Text (or prefix number with apostrophe) because I need to perform calculations on that data. How do I

Re: [users] Question about draw lines in the Calc

2007-04-06 Thread TerryJ
Renaud (Ron) Olgiati wrote: On Friday 06 April 2007 10:47, my mailbox was graced by a missive from Konstantin [EMAIL PROTECTED] who wrote: So, I have one very simple question about Calc. Is there any chance to draw separated lines around cells? (Like on attached screenshot) Format =

Re: [users] Question about draw lines in the Calc

2007-04-06 Thread TerryJ
TerryJ wrote: Renaud (Ron) Olgiati wrote: On Friday 06 April 2007 10:47, my mailbox was graced by a missive from Konstantin [EMAIL PROTECTED] who wrote: So, I have one very simple question about Calc. Is there any chance to draw separated lines around cells? (Like on attached

Re: [users] Downloading the .iso for cd burning

2007-04-06 Thread TerryJ
Renaud (Ron) Olgiati wrote: On Friday 06 April 2007 12:06, my mailbox was graced by a missive from Dan Lewis [EMAIL PROTECTED] who wrote: However, as it states there are no ISO images available yet for 2.2. So I'll jist have tae bide a wee. Ta, Ron. History tells us you

Re: [users] Open Office help w/ calc

2007-04-06 Thread TerryJ
Brian Barker wrote: At 15:09 05/04/2007 -0700, Willam Balderrama wrote: when entering 16 digit numbers on the Open Office Calc, how am I able to cut and paste into cells w/out getting a formula. This happens whenever I enter a lot of digits on one line or try to copy and paste it onto

Re: [users] Question about draw lines in the Calc

2007-04-06 Thread TerryJ
Dan Lewis wrote: On Friday April 06 2007 8:13 pm, Dan Lewis wrote: On Friday April 06 2007 7:59 pm, TerryJ wrote: Renaud (Ron) Olgiati wrote: snip from Konstantin [EMAIL PROTECTED] who wrote: So, I have one very simple question about Calc. Is there any chance to draw

  1   2   3   4   >