[users] Re: [moderated] Open Office Writer 2.0 memory requirements

2006-03-21 Thread Terry North
Terry Maiden worldnet.att.net> writes: > > I have just tried Ubuntu Live CD 5.10 which includes Open Office 2.0. Open Office Writer will not load and run, the CD just grinds and grinds My comments: 1. Forget about trying to run an OS from a CD. I believe the distros distributing so-calle

[users] Re: Calc spreadsheets

2006-03-16 Thread Terry North
> livid dea53.karoo.co.uk> writes: > Is there any way that I can copy a financial report from Excel into a > new OpenOffice.org Calc sheet? > I have at last managed to get the details into a Calc spreadsheet, but I > had to resort to copying just 2 columns at a time and to repeat that 5

[users] Re: Can't find OpenOffice.org Basic Guide

2006-03-08 Thread Terry North
Mac McClain centurytel.net> writes: > When I go to edit a macro and check help it refers me to a document called OpenOffice.org Basice Guide for syntax, etc. Where can I find this document? You will find useful links on these pages: http://www.pitonyak.org/oo.php http://api.openoffice.org/T

[users] Re: Can't find OpenOffice.org Basic Guide

2006-03-08 Thread Terry North
Mac McClain centurytel.net> writes: > > When I go to edit a macro and check help it refers me to a document called OpenOffice.org Basice Guide for syntax, etc. Where can I find this document? You will find useful links on these pages: http://www.pitonyak.org/oo.php http://api.openoffice.or

[users] Re: Calc Help

2006-03-02 Thread Terry North
G. Roderick Singleton openoffice.org> writes: > > On Thu, 2006-03-02 at 04:43 +0000, Terry North wrote: > > Barry Hylton Davies toucansurf.com> writes: > > > I am unable to use OpenOffice.org Calc. Under the relevant > > > entry in Help, I am told

[users] Re: Is it possible prevent "Adapt row height"

2006-03-01 Thread Terry North
havspace yahoo.com> writes: > Is it possible to "turn off" the automatic "Adapt row height" in Calc 2.0? > Even if another format would be > more effective, I would like to know how to disable the "Adapt row height" (or that it cannot be done at this time). > I tried to minimise loading and

[users] Calc Help

2006-03-01 Thread Terry North
Barry Hylton Davies toucansurf.com> writes: > I am unable to use OpenOffice.org Calc. Under the relevant entry > in Help, I am told that this is not available/couldn't be found, followed by: > > "The following data could be helpful in locating the error. > Help ID: text%2Fscalc%2Fmain00

[users] Re: too clever by 1/2

2006-02-26 Thread Terry North
CPHennessy openoffice.org> writes: > > On Fri February 24 2006 14:49, + Permaletter Sign Co. wrote: > > [ MODERATED ] Does such a crude enquiry really deserve a reply? - To unsubscribe, e-mail: [EMAIL PRO

[users] Re: default empty file for write/calc...

2006-02-17 Thread Terry North
Sebastian Reitenbach rapideye.de> writes: > > when opening writer or calc then I have to start with an empty spreadsheet or > writer document. Is there a way to exchange the file with sth. that has our > company logo in the corner... > in short to not start with an empty page but a standard sp

[users] Re: Resumption of Downloading

2006-02-13 Thread Terry North
Cindy Trinidad tri-global.org> writes: > > I saw this: > > http://www.tucows.com/preview/9150 > http://www.krasu.ru/soft/chuchelo/ > http://prozilla.genesys.ro/ > > Or, try Getright with Wine: > > http://www.getright.com/maclinux.html > Thanks for the links. d4x is a gem but I've only u

[users] Resumption of Downloading

2006-02-13 Thread Terry North
Sigrid Kronenberger stud.fh-kl.de> writes: > > a possibility for you can be, that you use a download manager, which can > restart / resume interrupted downloads. When you're using Firefox, the > download-manager can restart interrupted downloads. > I use Firefox and have found it does not resum

[users] Re: Date and calculations inoperative

2006-02-09 Thread Terry North
tony smailes virgin.net> writes: > > Have recently (last 24 hours) discovered openoffice. Last night (GMT) I downloaded your programme but all calculations including dates are inoperative on trial spreadsheet. What have I done incorrectly? Help please. Tony Smailes. You may need to be more speci

[users] Re: spreadsheet calculating

2006-02-08 Thread Terry North
Brandie Benington yahoo.com> writes: > I am using the 2.0 version of OpenOffice.org. I have > been trying to get the spreadsheet to calculate > formulas but with no luck. I have even followed the > example given under the Help topic of Calculating in > Spreadsheets. Allowing cells A3 & A4 to bo

[users] Re: calc -- Reformatting text to date

2006-02-08 Thread Terry North
Victor Chapman sympatico.ca> writes: > > The original column of dates was imported as text. I think that I need > to format the column as containing dates, but I also need to go through > a conversion, perhaps of the original text dates to give them a date > value. I don't know how to do t

[users] Re: Language confusion

2006-02-08 Thread Terry North
Herbert Eppel gmail.com> writes: > > The Write Edit menu in my English OOo installation looks like this (note > Strg+Umschalt): http://homepage.ntlworld.com/herb.eppel_new/temp/OOoLang.jpg > > Is this normal? > No. You seem to have a mix of English and German. Check Tools > Options > Langua

[users] Re: Language confusion

2006-02-08 Thread Terry North
Herbert Eppel gmail.com> writes: > > Some of the options in this window were set to Default, others to > English. I have now set them all to English, but I still see this > http://homepage.ntlworld.com/herb.eppel_new/temp/OOoLang.jpg after > restarting OOo, i.e. wherever one would expect "

[users] Re: Reminder of OOo Knowledgebase

2006-02-02 Thread Terry North
Jonathon Coombes cybersite.com.au> writes: > > Hi All, > > A reminder about the OOo Knowledgebase and what it can offer you. [para.7] > what you want, some may be close, and others not related at all. Thanks for the information, which I have copied to my OO notes. The line above f

[users] Re: Toolbar icons?

2006-02-02 Thread Terry North
CPHennessy openoffice.org> writes: > > On Wed February 1 2006 08:14, James.Mehl fabi.up.ac.za wrote: > > Does anybody perhaps please know where I can download additional > > icons for macros on the toolbars and how I can add them to my setup > > (i.e. which file or configuration folder)? ..

[users] Install without rpms

2006-01-31 Thread Terry North
Allen, Anthony lmco.com> writes: > By the way, do you have a version of openoffice that is not in rpm > format for linux? I would like to use vers 2 on linux, but I need root to do this. (at work) > This is from the Setup Guide and has been used successfully by a user on one of the fo

[users] Re: Format Cells...

2006-01-30 Thread Terry North
Olivier Gaspard chc.be> writes: > ... I try to initialize cells of a spreadsheet to 0 by default. > When I'm going to (right click on the cell => Format cell...) no one > option can do what I'm looking for)... > That's not a matter of formatting. If you want a 0 in every cell, you will have

[users] Re: Help File

2006-01-30 Thread Terry North
Dan Ostroff actcom.net.il> writes: > ... I've downloaded and installed Open Office 2.01 and note that there is > no help file with the program. > > Please > > 1. Where can I download the help file > 2. Where to install the help file > There are posts about this almost daily. If you're

[users] Re: Calc help

2006-01-30 Thread Terry North
Tom Hurrle vitaldirections.com> writes: > > Hi, > The Calc help page could not be found. Help ID: > text%2Fscalc%2F01%2F0408.xhp > The Writer help is present. > Yet another post on this subject! For a fix, the issue and difficulties encountered in applying the fix, see: http://www.8daysawe

[users] Re: Can not open Help files

2006-01-29 Thread Terry North
Paul Quelle xs4all.nl> writes: > > I can not open the help files in Open Office, I get the following text : > > Help ID: text%2Fscalc%2Fmain.xhp > This issue is gathering victims faster than any other. People have experienced problems applying fixes so if you have trouble it may be worth l

[users] Re: calc formatting vs excel and lotus

2006-01-29 Thread Terry North
pollyf1944 comcast.net> writes: > > I was curious about the column formatting feature. In Lotus 123 and Excel it seems that you can format a colum by the number of characters and spaces but in Calc it seems like it wants an exact figure in inches? how can I transition my files and my using the co

[users] Re: Help Function Fails

2006-01-26 Thread Terry North
R. J. (Jerry) Pasley charter.net> writes: > > > When I select a topic from the Index function of Calc, I get the > following message:Could not find Help page.Unfortunately the Help page you > selected was not found. The following data could be helpful in locating > the error: > Help ID: text%2Fs

[users] Re: openoffice won't run

2006-01-26 Thread Terry North
Sandra Hodgman skyenet.net> writes: > I installed openoffice from a CD from thinkall publishing. When I click on it I get the following error message the SAL3.DLL file is linked to missing export Kernel 32.DLL: Is DebuggerPresent Is this something wrong with my computer or the software they s

[users] Re: language /date/currency/date setting in Oo2.0

2006-01-26 Thread Terry North
Ted Parrett netactive.co.za> writes: > Hi everyone, I recently installed OOo 2.0 on a Windows XP machine. My country is South Africa so I have the language set to English (South Africa) in the Windows regional settings options. For this country the decimal separator is a comma and not a decimal po

[users] Re: formula window?

2006-01-25 Thread Terry North
wbg fdi.us> writes: > > I have scoured the "TOOLS" and "VIEW" help pages, and cannot > find a way to cancel the "recently used formulas" window If you still haven't found it, the command is Insert > Formula List. You can instead drag the list to the right edge of the frame and it virtually

[users] Re: help files

2006-01-23 Thread Terry North
Steve Kurti yahoo.com> writes: > ... the help files don't link to anything. I just need basic > function syntax for the spreadsheet. I am sure that this is a normal fix. What do I do to get at the help files? > Are you sure you've got the Help files? A number of people have found them to

[users] Re: Trying to write a search/match formula

2006-01-20 Thread Terry North
GregChi <[EMAIL PROTECTED]> writes: > > In cell c4, I have text entered. > In cells c100 thru c120, I have text, one of which is the same as in > c4. > In cells d100 thru d120, I have numbers. > In cell d4 I want to write a formula that matches c4 to one in the > c100 thru c120 list & prints the c

[users] Re: Looking for search function

2006-01-20 Thread Terry North
Dennis Marks yahoo.com> writes: > > >I have a spreadsheet with multiple records (lines). Within each record > >there is a cell containing 1 or more strings separated by commas. Is there > >a way to search for a string and return the line number of the record that > >contains the cell with

[users] Re: [moderated]

2006-01-19 Thread Terry North
alban landry comcast.net> writes: > > Can someone help me with importing a template to a Calc spreadsheet? > > After I follow the procedures (file-template-organize-name of > template-command-import), the OPEN screen shows. After I enter the > template/file name, I get a reject. > Are you tr

[users] Re: Finding the printer in OOo

2006-01-19 Thread Terry North
bnj web.de> writes: > ... > Is there some place in OpenOffice where I should configure a printer? > Anybody has a suggestion? > In my Linux menu (/System /Configuration) there is a command "openoffice.org-2.0-printeradmin" If you cannot find something similar, look for a file "spadmin" in the O

[users] Re: Script to Convert to/from openoffice format

2006-01-18 Thread Terry North
Loren M. Lang alzatex.com> writes: > > > Loren M. Lang wrote: > > >I have a hundred or so powerpoint presentations or so that I'd like to > > >convert to openoffice format and possibly back again, is there an easy > > >way that I can write a script that simply opens a powerpoint and save it > > >

[users] Re: Conditional formatting - missing Help

2006-01-17 Thread Terry North
Bob shaw.ca> writes: > > On 16/01/2006 20:10, Terry North wrote: > > > > The following link seems to be useful. If not, come back - there are > > others. > > http://www.8daysaweek.co.uk/forums/viewtopic.php?t=311 > > I too had trouble with missing h

[users] Re: Conditional formatting - missing Help

2006-01-16 Thread Terry North
Eugénio Varejao oninetspeed.pt> writes: > > Hi! > > When I press the help button in "conditional formatting" dialog editor I get a page with this: > > Could not find Help page. > Unfortunately the Help page you selected was not found. The following data could be helpful in locating the > erro

[users] Re: Use bracket instead of minus sign for negative in Calc

2006-01-16 Thread Terry North
Fajar Priyanto cbn.net.id> writes: > > Hi all, > We're using OOo 2.0.1. > One of the users asked whether we can use bracket instead of minus sign for > negative value in Calc. > > Ex: > Intead of -5000, she wants it: (5000) > > How do we format the cell? > Thank you. /Cells /Format : Numbe

[users] Font size in the IDE

2006-01-16 Thread Terry North
Someone asked here a month or so ago about changing font size in the IDE. I replied to the effect that changing scaling did that, though it changed other things as well. I've recently discovered that the font size can be changed without affecting the UI by using /Tools /Options /Fonts : Font Sett

[users] Re: Help me for install OOo 2.0.0 on Fedora Core 4 Linux

2006-01-15 Thread Terry North
Ali Farzin yahoo.com> writes: > > Hello, > > I have Fedora Core 4 Linux on my computer for some moons. ... I don,t > install OOo 2.0.0 successfully. ... I do these: > > 1. I went to Add or Remove Applications in Desktop Menu and UnChecked all > programs related to Office category. Then

[users] Re: Calc help error

2006-01-13 Thread Terry North
Leonard Emerson verizon.net> writes: > ... > I tried to use Help in Calc. I got an error message that said: > > "Could not find Help page.Unfortunately the Help page you selected was > not found. The following data could be helpful in locating the error: > > Help ID: text%2Fscalc%2Fmain.xhp

[users] Re: [moderated]

2006-01-13 Thread Terry North
Georges Madore yahoo.ca> writes: > I want to build a few databases (for our community library, addresses). > Does there exist somewhere a guide in pdf format to help a beginner like > me? The Help files I found are all independent elements > List of manuals: http://documentation.openoff

[users] Re: Copy and Paste noncontiguous cells

2006-01-13 Thread Terry North
Dennis Marks yahoo.com> writes: > > I have 81 noncontiguous cells. ... Is there any way to paste initial values into those cells by just using copy (from another sheet) and paste? > Yes, but you'd have to copy and paste all intervening cells as well. Dare I say "Macro, anyone?"

[users] Re: Background-Color and Background-Image

2006-01-13 Thread Terry North
Tom Schindl bestsolution.at> writes: > > why isn't it possible to set a custom background-color in Spreadsheets > or a Background-Image. ... > You can set up your own template with a background image and make it the default template. For background colour alone and/or font colour you can do wha

[users] Re: [moderated] - How to for Calc

2006-01-13 Thread Terry North
Anthony Chilco chilcostreet.ca> writes: > > Hi Cary, > It's almost as simple as click and drag > > Cary Howe wrote: > > > One massive problem with every spreedsheet software I've ever seen including the one in Open Office is they assume you already know how to use them. ... > That takes ca

[users] Re: Spreadsheet features

2006-01-11 Thread Terry North
Jim Andrews gmail.com> writes: > ...I had no trouble color highlighting an entire cell. But when I tried to > change the text color, it would not change I had noticed this also > when wanting to change text color in an Openoffice Word document. > Is there anyway that I can "turn the text co

[users] Re: Is Dynamic Cell Locking Possible?

2006-01-10 Thread Terry North
Dennis Marks yahoo.com> writes: ... > > What I need is conditional cell locking. Does it exist? > I have not checked it out but it might be worth looking at /Edit /Changes /Record and the possibilities that open up once it is activated. -

[users] Re: Help for spreadsheet / del. column

2006-01-09 Thread Terry North
Reiner bigpond.com> writes: ... The help in your program tells me some numbers but i can't access it. There is a problem with "Help" : could not find Help Page Several (perhaps many) people have experienced missing Calc help and there have been threads on this list and on the forums. There

[users] Re: Adding rows in Calc - existing summations (in part) (A defect in Calc)

2006-01-05 Thread Terry North
Andy Lewis ntlworld.com> writes: > > First, you can name a range in a spreadsheet document but the range name is > > only recognised on the sheet where the named range is located. This, I > > believe, is a major defect in Calc. > > Are you sure? I have no trouble referring to a named range fro

[users] Re: Adding rows in Calc - existing summations (in part) (A defect in Calc)

2006-01-02 Thread Terry North
G. Roderick Singleton openoffice.org> writes: > Is there an issue number for this? > My first query produced a list in excess of Bugzilla's listing capacities. Subsequent queries produced zero and I could not see how to "refine" my query. Anyway, in the absence of a readable result, I filed an

[users] Re: Adding rows in Calc - existing summations (in part) (A defect in Calc)

2006-01-02 Thread Terry North
Mark Twenhafel mac.com> writes: The sums are often referenced on another sheet > > My problem lies in adding a row to a set of data. I use Cntl-C then > Paste Special, only pasting in formats and formulas. When I do this > in the middle of the "range" of cells being summed, all i

[users] Re: pasting (into Firefox)

2006-01-01 Thread Terry North
Candida Holme earthlink.net> writes: >... after I copy a document and try to paste it in a designated spot on my browser (Firefox) the document never pastes. > What does paste is an email address. What should I do? Thank you. CH > I may misunderstand you; I gather you wish to see a Writer docume

[users] Re: Associate .doc .xls... with registry to OOo per users

2006-01-01 Thread Terry North
DANET Teddy ebtrans.com> writes: > On a Citrix server ( W2K with Citrix XP FR3), I had install MS Office + > OOo 2.0. > > I search to associate the extensions .xls, .doc, .ppt... for some users > to OOo. The others continue to open automaticaly with MS Office. > > I had read some posts, I search

[users] Re: Installing Openoffice2.0 on Linux for multiple users

2005-12-31 Thread Terry North
Terry North yahoo.com.au> writes: On further reflection (Oops!), since you do not want to detract from root's present rwx permissions, run as root or su: chmod go+rx -R /opt/openoffice.org2.0 That simply gives group (g) and others (o) read and execute permissions. If you need to gi

[users] Re: RSS Feed for this List?

2005-12-31 Thread Terry North
Laurie gmail.com> writes: ... > I like receiving this list, but the traffic is heavy. Is there an RSS feed > for it? There is a digest version of the list and a newsgroup (http://post.gmane.org/post.php?group=gmane.comp.openoffice.questions). Links, from memory, on the following: http://www.

[users] Re: Installing Openoffice2.0 on Linux for multiple users

2005-12-31 Thread Terry North
Chris Corti corti-usa.net> writes: > Openoffice2.0 is already installed on my Fedora 4 system, but it will > only start when I am root. ... How to I allow myself as a > regular account install and use OpenOffice2.0? I'm using a different distro of Linux. I've always been able to open OOo a

[users] Re: Multiple If/Then Functions in your Calc Spreadsheets

2005-12-30 Thread Terry North
Braswell, Brian Zurn.com> writes: ... > I opened up a spreadsheet ... and the multiple If/Then statements were apparently not valid in your program. Does your program even support multiple if/then statements, random 1 through 10, random 1-100 statements? ... I had to adjust to different met

[users] Re: How to force to use calc instead of writer for .csv files

2005-12-29 Thread Terry North
mesa rit yahoo.com> writes: > > I have some csv files ... when I clicked the link > to open from the browser, it always come out an ASCII > filter and OpenOffice writer is used. How can I force > it to use OpenOffice calc? > You need to change file associations in your system if you are opening

[users] macro command "storeToUrl" not working

2005-12-29 Thread Terry North
I devised this for someone on one of the forums. It was producing the desired result but now results in an exception message: "An exception occurred Type:com. sun.star.task.ErrorCodeIOException Message:." I can find nothing wrong and have run out of ideas. Can anyone help? Sub makePPT Dim oDoc

[users] Re: All files have become read only.

2005-12-27 Thread Terry North
Wm L Hall Jr sbcglobal.net> writes: > > For reasons unknown to me all the files in the Open Office files are now "read only". How do I get rid of this restriction? > That depends on your OS. In Linux, chmod. Regards. - T

[users] Re: Calc question

2005-12-22 Thread Terry North
bemeyers.com> writes: > > In Excel, under Data, there is a "Text to columns" wizard to convert > delimited text to proper Excel format. Question: Does Calc perform this > function? ... > There are addons available here: http://www.ooomacros.org/user.php#104183 (text to columns) http://www.oooma

[users] Re: looking for calc cells with a yellow background etc.

2005-12-22 Thread Terry North
_basic/index.html http://www.pitonyak.org/oo.php http://api.openoffice.org/TipsAndTricks/external.html The OO forums may yield some information and help: http://www.oooforum.org/forum/ I believe you'll have to work at it. Regards, Terry North. --

[users] Re: Quickstarter - what does %U do?

2005-12-21 Thread Terry North
Keith Bainbridge gmail.com> writes: > I have a short-cut in start-up the openoffice 'openoffice.org-2.0 -writer %U". > What does %U do? I added it to the command in a KDE panel icon >= openoffice.org-2.0 -calc %U Calc opened at its usually leisurely pace.

[users] Re: Date Formatting in OOo 2.0

2005-12-21 Thread Terry North
Bob shaw.ca> writes: > > I have a column set up in Calc to format dates as MM/DD/YY. This > normally works fine. A couple of days ago I tried to enter two dates, > 09/12/05 (Sep. 12th) and 10/12/05 (Oct. 12th). The program seems to > assume that because I am entering this information in Dec

[users] Re: shortcuts that replace missing excel shortcuts

2005-12-16 Thread Terry North
Gerri Belsito uhaul.com> writes: >... > In Excel I'm used to typing in Ctrl: to get today's date. Is there an > Openoffice shortcut to replace this? Also Ctrl" copied the cell above in > Excel. Does Openoffice have a shortcut for that? There is probably Help on keyboard shortcuts but you

[users] Re: decimal fraction in calc

2005-12-15 Thread Terry North
klaus schmirler online.de> writes: > Dan Lewis wrote: > > > One slight modification: your system would probably show it this way > > =0,/0, results in 0,5. > > It doesn't, but then it shouldn't because QUOTIENT is supposed to > return the integer part only. So the result is 0.

[users] Re: Trouble with links between spreadsheets

2005-12-13 Thread Terry North
> Gordon Burgess-Parker wrote: > > OO 2 final - I am having tremendous dificulty with links between > > spreadsheets. Andy Lewis ntlworld.com> writes: > So if you had such a link set up, and you wanted to change a cell in the > "source" file and see the change reflected in the "receiving" file, y

[users] Re: copy and paste

2005-12-13 Thread Terry North
Martin S gmail.com> writes: > > When copying (selecting text) and pasting (Unix third button pasting) the > selection directly into a cell in Calc I lose my text formating for that > cell. When pasting the text in the "edit box" (where you enter formula etc) > the text formating of the cell is re

[users] Re: Interface display fonts - menus, help etc.

2005-12-09 Thread Terry North
Sorry, I don't use Draw. This is from Help: "View Specifies view options. To access this command... Choose Tools - Options - OpenOffice.org - View User Interface Scaling Uses percentile scaling for font size in user interface elements, such as dialogs and icon labels. The Scaling setting does

[users] Re: Is linking to outside data disabled?

2005-12-08 Thread Terry North
I have found the same with the Mandriva Linux version. You should start a post about this rather than tagging onto an unrelated subject. It may be that an issue can be filed. You may instead be able to use a formula containing a direct reference to the address of a cell in another document (altho

[users] Re: Interface display fonts - menus, help etc.

2005-12-07 Thread Terry North
Malcolm Kay internode.on.net> writes: > > I have recently installed OO2.0 on FreeBSD5.4. It seems that the display size is rather restricted. ... But altering this Scaling seems to also affect the sizes in the work spaces so that a centimetre in a drawing displays as around one and a half centi

[users] Re: Navigation within a spreadsheet

2005-12-07 Thread Terry North
Robert T. Trent hiwaay.net> writes: > > ... My work-around is to put a non-empty cell past W1 and use cntl- rtarrow to go to it. I'd hoped for a slicker solution like maybe some form of hyperlink I'd not discovered. ... > > Another couple of thoughts: if you write a simple macro to select that

[users] How to stop Bullets & Numbering Toolbar appearing in Writer?

2005-12-07 Thread Terry North
Is there some way to stop this very annoying Toolbar popping up unasked? The problem is made worse by the fact that the 'Close' button in the top right corner does not work. The only way to get rid of the cursed thing is to move the cursor to a position where the toolbar is not summoned. Terry.

[users] Re: Navigation within a spreadsheet

2005-12-07 Thread Terry North
Robert T. Trent hiwaay.net> writes: > My worksheet opens with cell A1 at the upper left of my screen > I wish to be able to click in a cell and have cell W1 positioned at the upper left of my screen Since no one has replied, it looks as though no one knows of a way to do that. Clickin

[users] Re: Getting Cell Value in a Macro

2005-12-04 Thread Terry North
Terry North yahoo.com.au> writes: ... > Loop until lVolume > 0 > On further reflection this could lead to a never-ending loop if you have a row with a minus value. Should therefore be Loop until lVolume <> 0 --

[users] Re: Getting Cell Value in a Macro

2005-12-04 Thread Terry North
Russell King bluebottle.com> writes: What I need is a function for my macro that will go > through the top of the sheet, leaving the header row alone, and delete > the rows that have a value (not content) of zero. ... > rk > I composed this before the master (Andrew P.) posted. No liabil

[users] Re: Getting Cell value in macros

2005-12-04 Thread Terry North
Terry North yahoo.com.au> writes: ...For what it's worth, I'll send the document. ... The macro resulted in the value 0.000 in cell B1. ... Of course, this would happen. After my previous post, I closed the IDE, saved the file and (I don't know why) ran the macro again.

[users] Re: Getting Cell value in macros

2005-12-03 Thread Terry North
Andrew Douglas Pitonyak pitonyak.org> writes: > Can you email me a Calc document with the macro that demonstrates the > problem? For example, create a document that has a value in one cell > that is not properly returned by getValue(). Can you then write the > simple macro that fails to return

[users] Re: Conversion (Paste Special) Problem

2005-12-02 Thread Terry North
Dennis J. Tuchler earthlink.net> writes: > I have a list of dates, the first one is typed in as a string (1-16-06), > the next bunch are typed in as formulas (=B6+7). I want to convert the > list to strings (so the first string converted would be 1-23-06) To convert formulas to results,

[users] Re: Getting Cell value in macros

2005-12-01 Thread Terry North
David Chapman gmail.com> writes: > There are three ways of grabbing cell information summarized with examples here.. > http://www.openofficetips.com/blog/archives/2004/11/macros_getting.html ... All I need to do is get the value dumped to a string so that I can compare it. ... RK The value

[users] Re: IDE text size

2005-12-01 Thread Terry North
Fred Grant powercom.net> writes: > > Is there a way to increase the zoom in the IDE? I have done that with Tools /Options /OpenOffice.org /View /User Interface : Scaling by increasing the percentage (in my case to 115%). That also increases the size of the fonts in menus and dialogs. Reg

[users] Re: List 1 default numbering style

2005-11-30 Thread Terry North
Gert Blij icon.co.za> writes: > How can I set my "List 1" numbering style as the default style when I create > a new document? You can modify the default style using Format /Styles and Formatting, save the spreadsheet as a template and set it as the default template using File /Templates /Save +O

[users] Re: Data Menu option Equivalent

2005-11-29 Thread Terry North
Adrian Snyman supply-chain.co.za> writes: ... an option "Text to Columns" ... Is there an equivalent in OO2.0 ?? > There is a macro add-in. The link I have is http://ooomacros.org/user.php#104183 - To unsubscribe, e-mail:

[users] Re: calculate cell value

2005-11-27 Thread Terry North
mattias davidsson comhem.se> writes: ... in two, or more rows I have the following cell values > 23-25, 26 the row for this cell would be split into several rows, one for each number, ie the row with the cell would be split into rows with the cell values 23, 24, 25 and 26 where the values in the

[users] Re: [Calc] Reference to a row

2005-11-25 Thread Terry North
DC esiee.fr> writes: ... I need to have references to entire rows of 'Main' and not only references to a range of cells. ... If you just want the syntax for referring to an entire row, it's (for example) Main.A5:IV5 . You need to preface any component that you want left unchanged when copying f

[users] Re: [Calc] Reference to a row

2005-11-25 Thread Terry North
DC esiee.fr> writes: ... I need to have references to entire rows of 'Main' and not only references to a range of cells. ... One way to shorten the references is to use column A in 'Main' to contain row names and use the row names to refer to the row. For example: A B C

[users] Re: Java runtime environment

2005-11-25 Thread Terry North
Bob Cohen yahoo.com> writes: > > Hello, > > I can't fully use Base without JRE and I don't know > how to get it > JRE is a free download from http://www.java.com/ You enable its use with Tools /Options /OpenOffice.org /Java -

[users] Re: Calc: convert text to several columns

2005-11-22 Thread Terry North
I'd like to rewrite the text of one column ...into several different columns You can use "paste special" with the option "transpose". Regards. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAI

[users] Re: Calc: convert text to several columns

2005-11-22 Thread Terry North
pkg.fr> writes: ... to rewrite the text of one column (i.e. "1.10 m") into several different columns (i.e.1 / 10 /m ). I initially misunderstood. You could use the functions LEFT, MID and RIGHT, then copy the resulting range of cells containing the formulas, place the cell pointer in th

[users] Re: Calc - multiple IF conditions without nesting

2005-11-19 Thread Terry North
In the following paragraph of my previous post "in which case" should read "otherwise" > 3. I want a formula that returns the value in L8 if it is greater than zero and lower than 7.1 (in which case it returns the value 7.1). The following did not work: =IF(AND(L8<7.1;L8>0)="TRUE";L8;7.1). For

[users] Calc - multiple IF conditions without nesting

2005-11-19 Thread Terry North
On the offchance that I'm not the only one who did not already know these things, I thought I'd share some discoveries. Until changing to OOo, I used a software with a very simple method for linking conditions in IF formulas, i.e. #AND# and #OR#. For example: IF (condition1 #AND#condition2; then

[users] Re: Keyboard shortcuts - loading config file erases settings

2005-11-15 Thread Terry North
Johnny.1966 telia.com> writes: ...[Snipped] > I select my settings file and click Open. > > Now I have the followng settings: > > Ctrl+B = Nothing > Ctrl+F = Nothing > > Inow scrolling up and down, only to find that nothing is assigned to > anything... > ...[snipped] > The settings above are

[users] Re: Like operator in Calc IF function

2005-11-15 Thread Terry North
Gert Blij icon.co.za> writes: > > I am trying to do something like this: > > =if(a1 like '*sometext';"YES";"NO") > > But keep getting the #NAME error. What am I doing wrong? > A different tack which, like the others, relies on an exact match is =EXACT("sometext";A1) which will give you TRUE o

[users] Re: Keyboard shortcuts etc...

2005-11-15 Thread Terry North
Johnny Guitar telia.com> writes: > > Hi! > > I downloaded 2.0 today and the first thing I did was trying to change my > keyboard shortcuts (calc in this case). ... Then I changed so that > Bold and Italic was assigned to Ctrl-F and Ctrl-K respectively ("Fet" and > "Kursiv" in Swedish). Si

[users] Re: [moderated]

2005-11-08 Thread Terry North
Joe O'Brien verizon.net> writes: > > Hello! Hoping you can e-mail me back with an answer to my question. I have noticed with most programs that > have icons, one only needs to point the cursor at the icon and an explanation of the object appears. I cannot > seem to get this feature to work (if

[users] Re: default sorting options in calc 2.0 (column headers option)

2005-11-08 Thread Terry North
Margaret Stanley wr14.freeserve.co.uk> writes: > > Every time I sort a page in calc I have to start by going to Options > and ticking the option to use column headers. If there any way of > setting this option as the default. (I cannot find it in HELP) > > Margaret Stanley > I have found tha

[users] Re: Date format as default

2005-11-08 Thread Terry North
Margaret Stanley wr14.freeserve.co.uk> writes: > > Every time I enter a date in Writer I need to explicitly set the > format to , for example 31 Oct 05 instead of 10/31/05. Is there any > way of setting this as a default date format? > > Margaret Stanley > I've only managed to get part of t

[users] Re: Calc - (don't) show grid lines

2005-11-08 Thread Terry North
Bernard BLANCHI wanadoo.fr> writes: > > How can I erase the the lines from a sread sheet ? Use Tools /Options /OpenOffice.org Calc /View and uncheck "Grid Lines". Cannot find a way to turn the option off/on for a particular file. Is there one? --

[users] Re: O/O Writer -- setting the date

2005-11-08 Thread Terry North
Michael Stanbury eastlink.ca> writes: > > How's it done? I know how to insert the date frame into a document but when it comes in it reads: > Date(fixed). Does the program not know the date or time? And if not how do I tell it? > Michael Stanbury, Halifax NS > If you want a field that shows tod

[users] Re: Document language setting in 2.0?

2005-11-03 Thread Terry North
Toralf Lund procaptura.com> writes: > > How do you select language for the current document in OOo 2.0? The > version 1.x way of doing it, i.e. to use "Default language" setting in > Options...>Languages->Language Settings with "For the current document > only" selected, does not seem to be

[users] Re: dates in oo 2.0

2005-11-03 Thread Terry North
Margaret Stanley wr14.freeserve.co.uk> writes: > > I have tried to insert a date in text documents and it comes in the > American format viz 10/31/2005. I would like to change it to words, > viz 31 Oct 2005 but I cannot understand the instructions in the help file. Hope this helps. Click on th

  1   2   >