[users] Re: [moderated] Open Office Writer 2.0 memory requirements
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-called live cds are doing their cause more harm than good. 2. Look for something better than Ubuntu. I'd suggest Mandriva or Suse. I believe Xandros is worth a look. 3. I have had problems with a commonly used Writer document, so much so that I have switched to the pdf version. Writer, I believe, is badly constructed and unnecessarily complex but I can open it generally without problems. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Calc spreadsheets
> 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 more > times for a 12 month document. Further more by copying and pasting, Calc > accepted a 2 decimal place display, BUT after I saved the spreadsheet and > re-opened it the 2 place display had disappeared. > Can someone kindly advise me the correct way of sending such a query to > the correct program section for future queries. 1. To get the financial report into a Calc spreadsheet, try Insert >Sheet from file. All formatting should accompany the data. Alternatively, you could save the XL file as an OO spreadsheet. 2. Otherwise, you can, as someone else has replied, use Format >Cells. If preferred, you can alter the default formatting using the F11 dialog, right -click default and select Modify. You could go further and save a blank spreadsheet so formatted as a template, even setting it as the default template. 3. Contacting "program section": (a) If you mean filing an issue (~ bug report), you need to register with the OpenOffice website and follow links to tracking and filing issues. (b) If you mean a users' site for Calc, go to the forums : http://www.oooforum.org/forum/index.phtml - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Can't find OpenOffice.org Basic Guide
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/TipsAndTricks/external.html Among others, you'll find Andrew Pitonyak's document (I recommend the pdf version). You should also get the Xray Tool: http://www.ooomacros.org/dev.php#101416 and the latest SDK: http://download.openoffice.org/680/sdk.html and this: http://documentation.openoffice.org/manuals/oooauthors2/0115GS -GettingStartedWithMacros.pdf Helpful sites and examples: http://kosh.datateamsys.com/~danny/OOo/Examples/ http://www.oooforum.org/forum/viewtopic.phtml?t=18762 http://disemia.com/software/openoffice/ http://ext.openoffice.org.nz/doku.php http://homepages.paradise.net.nz/hillview/OOo/ http://www.ooomacros.org/dev.php http://www.openofficetips.com/blog/archives/openoffice_basic/index.html http://development.openoffice.org/index.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Can't find OpenOffice.org Basic Guide
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/TipsAndTricks/external.html Among others, you'll find Andrew Pitonyak's document (I recommend the pdf version). You should also get the Xray Tool: http://www.ooomacros.org/dev.php#101416 and the latest SDK: http://download.openoffice.org/680/sdk.html and this: http://documentation.openoffice.org/manuals/oooauthors2/0115GS -GettingStartedWithMacros.pdf Helpful sites and examples: http://kosh.datateamsys.com/~danny/OOo/Examples/ http://www.oooforum.org/forum/viewtopic.phtml?t=18762 http://disemia.com/software/openoffice/ http://ext.openoffice.org.nz/doku.php http://homepages.paradise.net.nz/hillview/OOo/ http://www.ooomacros.org/dev.php http://www.openofficetips.com/blog/archives/openoffice_basic/index.html http://development.openoffice.org/index.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Calc Help
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 that this is not available/couldn't be found, > > > > You forgot an important one, > http://documentation.openoffice.org/faqs/spreadsheet/051.html > > These FAQs and the other FAQs are an important resource for new people. Thanks. That's new to me. Noted. I also think I should have mentioned: http://documentation.openoffice.org./manuals/index.html http://documentation.openoffice.org/HOW_TO/index.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Is it possible prevent "Adapt row height"
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 saving time by setting rows to first to default, then to optimal height. Neither stops the process (whatever it actually does) occurring. It may have something to do with the format in which documents are saved. The same thing occurred with v1. The point is that it seems nothing can be done to avoid it. One tip mentioned on the forums for reducing those times is to use styles rather than "hard formatting." I've followed the advice and my default template now contains a number of styles I commonly use. Styles are created and applied with the F11 dialog. I find that too fiddly for random use so I've created macros which apply particular styles. An example of a style might be, for example, _Titles : - say, green font, centred - which you would use for headings. Another post on the forums mentioned that creating a large number of range names added considerably to loading and saving times. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Calc Help
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%2Fmain.xhp" > You belong to a huge club. There is a fix, evidently at: http://www.8daysaweek.co.uk/forums/viewtopic.php?t=311 If that does not work, there is a repository of files: http://web.mit.edu/ooffice_v2.0.1/distrib/i386_rhel4/openoffice.org2.0/help/en/ The issue, which apparently contains helpful comments: http://www.openoffice.org/issues/show_bug.cgi?id=59499 Many threads in the forums, e.g. http://www.oooforum.org/forum/viewtopic.phtml?p=122883 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: too clever by 1/2
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 PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: default empty file for write/calc...
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 spreadsheet? > Save the document you want opened as a template with File > Templates > Save, then open the Organizer where you get a button labelled "Commands". You will find towards the end of the list of Commands "Set as Default Template". You will need to set separate templates for Writer and Calc. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Resumption of Downloading
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 used it for ftp so far. I tried once with http and did not have the time to work it out properly (ok, the patience). I can definitely recommend it. Prozilla promises a lot. The Mozilla sites mention various downloaders too. I used BitTorrent for the OO downloads because (1) P2P download was available and (2) The traffic on OO is very heavy when a new version is released. Again, I would recommend it. What I like about both programmes is their simplicity and their effectiveness. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Resumption of Downloading
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 resume downloading (at least, not expeditiously). BitTorrent, however, works excellently. I use BitTorrent to stop the download just before the connection is broken, disconnect, reconnect and restart BitTorrent. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date and calculations inoperative
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 specific. In the meantime, check the following setting: Tools > Cell Contents > AutoCalculate. It should be ticked. If it isn't, select it, it will be and your calculations will take effect. If that isn't it, you'll have to give examples of formulas and date entries made and the results. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: spreadsheet calculating
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 both be 1 and > cell B4 to be the example formula of =A3*A4/100 then > pressed enter. It did not calculate the formula but > did print the formula in the cell. ... Check this setting: Tools > Options > OpenOffice.org Calc > View : Display : Formulas. The check box should be unselected if you do not want formulas displayed. Another possibility is that the cell has been formatted as text. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: calc -- Reformatting text to date
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 this. > I believe you are correct. Changing the format of the cells will not alter the original character of the contents. Testing on my test file, I find that the original text acquires a preceding apostrophe. If that has happened in your case, a search and replace technique mentioned in the Calc forum is Search ^. and Replace & You need to select More Options > Regular Expressions on the Search and Replace dialog. If there is no apostrophe, you can convert using the function DATEVALUE in the adjoining column, format that column to show the resulting values as dates, copy the column then special paste making sure you deselect formulas. Substitute the new dates for the old. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Language confusion
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 > Language Settings > Languages : Locale and Default Languages for Documents > Western. You will need, I believe, to set both to English settings. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Language confusion
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 "Ctrl" I see "Strg", and > whereever one would expect "Shift" I see "Umschalt". > > I don't really mind, but it would be nice to have a consistent interface. > > Any more ideas? > I tried to get German to display on my menu. Impossible because I don't have the language pack but I found when returning to the Options dialog that the language setting had reverted to English. This may have to be altered in the software settings. It looks as though it's the keyboard shortcuts which are being obstinate. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Reminder of OOo Knowledgebase
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 from paragraph 7 seems to be an orphan. There must be a wealth of knowledge in posts in the mailing lists and forums. It would be a large task, I know, but is there some way of garnering that knowledge, perhaps from the most popular threads? I've given up searching in gmane for anything. Searches on the forums yield a lot of information. Is it possible to include the knowledge base in such searches, meaning, could a link be established? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Toolbar icons?
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)? > > Not exactly answering your question but I do believe that OOo 2.0.2 will > allow > you to change to a different icon set. Maybe this will help. > If you find any icons that can be used, please publish the information. OO will allow you to import icons only of size 26 * 26 pixels. You can import them from anywhere on your system (if of the correct size) using Customize Toolbar > Modify >Change Icon >Import. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Install without rpms
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 forums who also did not have root privileges: Installation on Other UNIX systems If you have a UNIX distribution that does not have an up-to-date rpm or you are unsure that you system is current and rpm installation is failing, then try the following: b) Get and use rpm2cpio to convert the rpm files to cpio archives and then employ cpio to install the software. There is a perl version of rpm2cpio at http://www.iagora.com/~espel/rpm2cpio that should be portable. However, if it fails, try precompiled rpm-package (including rpm2cpio) from ftp://ftp.rpm.org/pub/rpm/dist/rpm-4.1.x/rpm-4.1.i386.tar.gz or get the sources from ftp://ftp.rpm.org/pub/rpm/dist/rpm-4.1.x/rpm-4.1.tar.gz c) Install any language packs needed for OpenOffice.org. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Format Cells...
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 to enter it. But for what purpose? You will increase the size of the file unduly and gain nothing by it. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Help File
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 referring to missing Calc help, the fix, issue and discussions are here: http://www.8daysaweek.co.uk/forums/viewtopic.php?t=311 http://www.openoffice.org/issues/show_bug.cgi?id=59499 http://www.oooforum.org/forum/viewtopic.phtml?t=28931 http://www.oooforum.org/forum/viewtopic.phtml?t=29628 http://www.oooforum.org/forum/viewtopic.phtml?p=122883 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Calc help
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.8daysaweek.co.uk/forums/viewtopic.php?t=311 http://www.openoffice.org/issues/show_bug.cgi?id=59499 http://www.oooforum.org/forum/viewtopic.phtml?t=28931 http://www.oooforum.org/forum/viewtopic.phtml?t=29628 http://www.oooforum.org/forum/viewtopic.phtml?p=122883 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Can not open Help files
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 looking as some of the forum links. The location which seems to be favoured for the fix: http://www.8daysaweek.co.uk/forums/viewtopic.php?t=311 The issue (for which you may be motivated to vote): http://www.openoffice.org/issues/show_bug.cgi?id=59499 Problems discussed and usually overcome on the forums: http://www.oooforum.org/forum/viewtopic.phtml?t=28931 http://www.oooforum.org/forum/viewtopic.phtml?t=29628 http://www.oooforum.org/forum/viewtopic.phtml?p=122883 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: calc formatting vs excel and lotus
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 columns to format by characters instead of inches? > You can choose optimal width for columns. It seems to set to the maximum length of the selected cells regardless of any preset measurement. It also seems to work whether you de-select "default" or not. It may be that if you de-select "default", it finds the widest contents in the column as a whole, i.e. not just in your selection. Regardless of such finer points, I manage without much trouble to get columns to a suitable width without any complex calculations. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Help Function Fails
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%2Fscalc%2F01%2F0212.xhpWe apologize for any inconvenience. There have been many such complaints. These explain the fix: http://www.8daysaweek.co.uk/forums/viewtopic.php?t=311 http://www.openoffice.org/issues/show_bug.cgi?id=59499 http://www.oooforum.org/forum/viewtopic.phtml?t=28931 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: openoffice won't run
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 sent me? > You can check the software with md5sum. For details, this link: md5sum: http://download.openoffice.org/2.0.0/md5sums.html Those cryptic error messages! If the software passes that check, you may get some information from these: http://download.openoffice.org/2.0.1/instructions.html http://documentation.openoffice.org/setup_guide2/2.x/en/SETUP_GUIDE.pdf - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: language /date/currency/date setting in Oo2.0
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 point. The comma is used for decimal numbers and currency. The thousands separator is a space and not a comma. This is how I have these set up in the Windows regional options dialog I am unable to get Calc 2.0 to display and recognise the PC's regional settings even when I set them up in the user defined cell format dialog I tried your language setting for a group of cells. I was able to get the date format but could not get the space recognised as a thousands separator or a comma recognised as a decimal separator. I had a look at Esperanto. That uses the separators you require. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: formula window?
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 disappears. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: help files
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 be missing. These are relevant links: http://www.8daysaweek.co.uk/forums/viewtopic.php?t=311 http://www.openoffice.org/issues/show_bug.cgi?id=59499 http://www.oooforum.org/forum/viewtopic.phtml?t=29628 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Trying to write a search/match formula
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 corresponding number in d100 thru > d120. > > Lookups/match/choose all use numbers as matches??? > Do any of these work with text? > If so how do I write this? Lookups and match will both look for text, as, according to Help, does Choose. The formula =MATCH(C4;C100:C120;1) in d4 will give the vertical position in the list. If you're after a cell address, insert the column letter and add a number (which I think is 99 in your case) to get the correct row in the spreadsheet, along these lines: ="C" & MATCH(B5;A2:A11;1)+99. In the other cells in the D column: =$D$4 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Looking for search function
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 the string. For example:
> > LINE CELL1 CELL2 CELL3 CELL4 CELL5
> > 0001 B a, b, c, d, E
> > 0002 B e, f, g, h, E
> >
> > Search the column with cell4 and find the line with the f in it. Line 2
> > would be returned. I know that I can search for e,f,g,h and find it but I
> > want to only search for a single item.
> >
I don't follow your example but I think the MATCH function might be what you're
after. To illustrate, I have a vertical list with 14 text codes and a heading,
a total of 15 rows. In the 10th row, the code "HZN". To get an exact match, I
use the parameter 1: =MATCH("HZN";_TableCodes;1) which yields 10. If I change
the parameter to 0 and look for a near match: =MATCH("HSN";_TableCodes;0) I get
9 although the code in the previous row is FML. You work it out, I can't. If I
want an exact match and try =MATCH("HSN";_TableCodes;0), I get #N/A.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: [moderated]
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 trying to import or do you actually want to use a template? If the latter, it's confusing, but the command you use is /File /New /Templates and Documents. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Finding the printer in OOo
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 OO program folder. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Script to Convert to/from openoffice format
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 > > >as openoffice format, or vice-versa? I can't seem to figure out how to > > >save it as a specific format. > > > I just knew Yoda would be on the right side of the software issue. The scripts below will respectively export an OO Impress presentation to powerpoint and save a powerpoint doc as an Impress presentation, assuming a .xxx extension to the filenames. They have not pasted altogether correctly because of the length of lines in the posting form - the following line for example should be part of the preceding line (occurs twice): ( "com.sun.star.presentation.PresentationDocument" ) Then They only work for an open document. To open a document without having its name would probably require a bash script - I don't know. Exporting to .csv may be more complicated. You would increase your chances of getting macro assistance if you also post on the Macros and API forum: http://www.oooforum.org/forum/viewforum.phtml?f=3 Sub makePPT 'This assumes a three character extension following a point - eg .odp oDoc = StarDesktop.getCurrentComponent() If NOT oDoc.SupportsService ( "com.sun.star.presentation.PresentationDocument" ) Then Msgbox "Not a presentation document" : Exit Sub End If If NOT oDoc.hasLocation Then Msgbox "Save document before proceeding" : Exit Sub End If sUrl = oDoc.Url 'This sequence gets a valid url with extension .ppt sName = Left ( sUrl, Len ( sUrl ) - 4 ) sUrl = ConvertToURL ( sName & ".ppt" ) aArgs1(0).Name = "InteractionHandler" aArgs1(0).Value = "" aArgs1(1).Name = "FilterName" aArgs1(1).Value = "MS Powerpoint 97" oDoc.storeToURL ( sUrl , aArgs1() ) End Sub Sub makeImpress 'This assumes a three character extension following a point - eg .ppt oDoc = StarDesktop.getCurrentComponent() If NOT oDoc.SupportsService ( "com.sun.star.presentation.PresentationDocument" ) Then Msgbox "Not a presentation document" : Exit Sub End If If NOT oDoc.hasLocation Then Msgbox "Save document before proceeding" : Exit Sub End If sUrl = oDoc.Url 'This sequence gets a valid url with extension .ppt sName = Left ( sUrl, Len ( sUrl ) - 4 ) sUrl = ConvertToURL ( sName & ".odp" ) oDoc.storeAsURL( sUrl, aNoArg() ) End Sub - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Conditional formatting - missing Help
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 help files. I downloaded the files from > the MIT site that has been linked to several times on this forum. The > new files did restore some of the help files, but not all, by a long > shot. I still get many error messages similar to the above example. > Even when you do get directed to the proper help file the information > does not seem to be nearly as detailed as it has been in previous > versions. Is this because the help files are being totally rewritten > for v.2.0.1, and they are not yet complete? > > I should also draw to your attention that the link to MIT is incorrect, > as has also been mentioned by a couple of other people. Going to the > link that has been consistently given, one gets a message to the effect > that one is not allowed access to that server. Only by playing around > with the version number in the link was I able to finally gain access. > The files at MIT are dated 14/12/05 and don't seem to have been updated > since then. > MIT, I take it, means the 8daysaweek site. I, fortunately, have not been informed of missing Help files. I have the following links, the forum one dealing with difficulties and the other being the issue filed. Those affected might well vote for the issue and could, I understand, benefit from some of the comments filed there. http://www.openoffice.org/issues/show_bug.cgi?id=59499 http://www.oooforum.org/forum/viewtopic.phtml?t=29628 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Conditional formatting - missing Help
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 > error: > Help ID: text%2Fscalc%2Fguide%2Fcellstyle_conditional.xhp > ... The following link seems to be useful. If not, come back - there are others. http://www.8daysaweek.co.uk/forums/viewtopic.php?t=311 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Use bracket instead of minus sign for negative in Calc
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 : Number Tab >Category Number. Choose the format code that best suits (subject to changing the negative symbol), remove the minus sign and substitute brackets. You then click on the tick and the format becomes a user-defined one. E.g, change "General;-General" to "General;(General)". - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Font size in the IDE
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 Settings for HTML and Basic. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Help me for install OOo 2.0.0 on Fedora Core 4 Linux
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, I press Update Key. therefore OOo > Writer, OOo Calc, OOo Base and ... don,t run now. > ... > 4. then, I went to the directory id created with above command, this > dorectory contained some RPM files. In this time, I type below command for > configuration package. > ./configure > > and facing to this message. "bash: ./configure: No such file or directory" > > 5. Helplessness, I went to RPMS directory with CD command and type >rpm -Uvh *.rpm > 6. then. I cd into the desktop-integration directory and execute > rpm -Uvh openoffice.org-redhat-menus-≤release>.noarch.rpm or similar > that was shown office submenu in application menu. > > but I don,t run this applications in neither menu nor Run Applications or terminal window. > > When, I went to GUI in GNOME and doubleclick on all RPM file, the linux is messaged to me that "this package was installed on your system" > > Please help me, that why not execute ./configure and how I install OOo 2.0.0 on my computer > > Steps 1 and 4 are not mentioned in the Setup Guide. It sounds as though you may have the software installed but not have the commands on your menu, in which case, you only need to reverse Step 1. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Calc help error
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" > > What should I do now? > This is from a posting in an earlier thread on this vexed issue: There is a link given on that discussion (although I couldn't use it) and the issue has been recognized by OOo developers etc. However try this First close Openoffice Then visit the following website and download the four files, scalc.db scalc.ht scalc.jar scalc.key http://web.mit.edu/ooffice_v2.0/distrib/i386_rhel4/openoffice.org2.0/help/en/ When downloaded put them into C:\Program Files \OpenOffice .org 2.0\help\en (using the default directory location) This problem is discussed in Issue 59499. I followed the advice given there and downloaded the Linux files. This has restored the Help system. I may, however, download and install the Windows Help files in your reference, above. Thank you. You may have to work at it - see this: http://www.oooforum.org/forum/viewtopic.phtml?t=29628 I'd check the issue first just to get the latest: http://www.openoffice.org/issues/show_bug.cgi?id=59499 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: [moderated]
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.openoffice.org./manuals/index.html List of individual chapters: http://documentation.openoffice.org./manuals/oooauthors2/index.html Guide to base (link broken in two to fit in the posting form): http://documentation.openoffice.org./manuals/oooauthors2/0110GS-[break] GettingStartedWithBase.pdf - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Copy and Paste noncontiguous cells
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?" - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Background-Color and Background-Image
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 what I've done - alter the default settings: /Tools /Options /OpenOffice .org /Appearance : Custom Colors - General : Document Background, Font Color. In my case, the colours I wanted weren't there so I chose similar colours and changed the rgb (red, green, blue) mix to what I wanted. My text documents and spreadsheets have the same background and font colours - cream and navy blue respectively - by default. I've set a default template (/File /Templates /Save) with the font family, font size and number of sheets (one)) that I want by default in a new spreadsheet. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: [moderated] - How to for Calc
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 care of one problem. For the rest, you'll find a list of links here: http://documentation.openoffice.org./manuals/index.html Individual chapters: http://documentation.openoffice.org./manuals/oooauthors2/index.html The calc guide (I've broken the link in two to fit Gmane's posting page) http://documentation.openoffice.org./manuals/oooauthors2/0107GS-[break] GettingStartedWithCalc.pdf - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Spreadsheet features
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 color on" in Openoffice? > I'm not sure this is what you're asking and I did not realise (until checking just now) that this was possible but I have just changed the colour of the "01" in "06/01/2006" to a different colour. You have to select the contents of the cell as text. The easiest way is to double-click on the cell which enables you to use the mouse pointer as a text cursor. Use it to select the portion you wish to highlight and proceed. I have a font colour chooser icon on the toolbar and I was able to use that. Otherwise /Format /Character. I can't help on the Writer question. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Is Dynamic Cell Locking Possible?
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. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Help for spreadsheet / del. column
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 are files you can download. You'll find a reference at this thread: http://www.oooforum.org/forum/viewtopic.phtml?t=29628 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Adding rows in Calc - existing summations (in part) (A defect in Calc)
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 from a > different sheet (I'm using OOo 2.0 on Windows). This "problem" goes back to an earlier installation on my computer. Since then I've installed afresh (for other reasons), deleting traces of any prior installation. After filing an issue, I received the same response as yours and, in disbelief, tried a simple formula, with the result, yes, the range name was recognised across sheets in the document. I withdraw my assertion. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Adding rows in Calc - existing summations (in part) (A defect in Calc)
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 issue (with fingers crossed when specifying a subcomponent): http://qa.openoffice.org/issues/show_bug.cgi?id=59975 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Adding rows in Calc - existing summations (in part) (A defect in Calc)
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 is well. > When the new row is added as the last row of the sum, however, the > new row is not added to the existing sum. > > My workaround: in thinking about this, I decided that since the new > row is being added outside of the range of the existing summation, 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. A corollary of this defect is that the range name will not be recognised in another spreadsheet document except in a hyperlink. Secondly, database ranges are recognised in different sheets of a document so I suggest that you use that tool (/Data /Define Range) rather than simple range names. Thirdly, you may not have to insert a row out of its proper place. I have found that you can obtain automatic extension of a database range by inserting a row after the last row in the range. What I mean is, do not simply paste your data into the next row but first use /Insert /Rows. I was taking advantage of that in a macro until recently when the range failed to extend automatically. I've amended the macro to redefine the range to include the added row. That may be the device you have to use ultimately. Sorry I can't comment on Base. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: pasting (into Firefox)
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 document in Firefox. To do that, use /File /Open File in Firefox. As far as I know, you can only paste into Firefox in the location bar or a dialog. In neither case could you paste a document, although you could paste a link to a document, which is what you're getting. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Associate .doc .xls... with registry to OOo per users
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 with the KB 257592... so I try to > associate with the key of registry : > [HKEY_CURRENT_USER\SOFTWARE\Classes\... > > But It's don't running... I'm not sure if this is what you're asking. On Windows 98SE, I could use a command from Explorer or from the main menu to change file associations. It was not necessary to use the Registry Editor. From memory, the tool was under "Folder Options". It was also possible to right-click and select "Open With", whereupon I believe you could ask for association. When I installed OOo2 (admittedly, on a Linux desktop), the installer enabled OOo for appropriate extensions. You may simply have to alter the default settings or the priority order. There is a manual (not, I believe from MS) which contains a lot of helpful information about altering registry settings. In my Windows archive, it looks as though the relevant installation file is "registry.exe". - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Installing Openoffice2.0 on Linux for multiple users
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 give write permissions, change +rx to +rwx. If you need to alter root's permissions use u (=user); a=all. If you want to check this out: man chmod - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: RSS Feed for this List?
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.openoffice.org/mail_list.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Installing Openoffice2.0 on Linux for multiple users
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 as a user but had a problem accessing something in OO, so ran the following command which gives all users read and execute permissions (you may have to change the path). You need to run as root or su: chmod a+rx -R /opt/openoffice.org2.0 If you need to give write permissions, change +rx to +rwx. Hope it has the desired result. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Multiple If/Then Functions in your Calc Spreadsheets
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 methods for handling this as well. You may get some help, as I eventually did, from the functions AND and OR (in Help under AND function and OR function). Hereunder a sample from one of my files: =(IF(I7<=1;1;IF(AND(I7>1;I7<=15);I7;IF(AND(I7>15;I7<=25);15+((I7-15)*0.3);IF (AND(I7>25;I7<=50);18+((I7-25)*0.2);IF(I7>50;23+((I7-50)*0.1))) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: How to force to use calc instead of writer for .csv files
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 from your file browser. I don't remember how to do that in Windows. If you right click on the file name you may get an "Open With" option that allows you to alter the file associations. Basically, what you need to do is make Calc the first/default option for opening that type of file. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] macro command "storeToUrl" not working
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 as Object, sCut as String, sName as String, sUrl as String, _ aArgs1(1) as new com.sun.star.beans.PropertyValue oDoc = StarDesktop.getCurrentComponent() sUrl = oDoc.Url sCut = Right ( sUrl, 5 ) sName = Left ( sUrl, InStr( 1, sUrl, sCut ) ) sUrl = ConvertToURL ( sName & ".ppt" ) aArgs1(0).Name = "InteractionHandler" aArgs1(0).Value = "" aArgs1(1).Name = "FilterName" aArgs1(1).Value = "MS Powerpoint 97" oDoc.storeToURL ( sUrl, aArgs1() ) Rem oDoc.storeToURL ( "file:///home/terry/Work/announce.ppt" , aArgs1() ) 'This produces the same exception. Using the macro to load the document 'makes no difference. End Sub - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: All files have become read only.
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. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Calc question
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.ooomacros.org/user.php#133089 (text2columnsfixedwidth) I fretted over how to install it but it turned out to be a simple matter of using /Tools /Package Manager. I've seen postings which indicate that it does not completely replace the MS function. Cheers. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: looking for calc cells with a yellow background etc.
JC Helary mx6.tiki.ne.jp> writes: > I have a big sheet and I want to find all the cells with a yellow > background. > > When that is done I want to insert the word "yellow" or some other > string in the cell (not overwrite). > > Is there a simple way to do that ? > > Jean-Christophe Helary > "A simple way" may be asking too much. Simple for the user - possibly with a macro, but that would take time to write. If you want a macro, try some of these: http://www.ooomacros.org/ http://www.openofficetips.com/blog/archives/openoffice_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. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Quickstarter - what does %U do?
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. Regards, Terry North. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date Formatting in OOo 2.0
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 December, then I > must mean Dec. 9th and Dec. 10th, which is not the case. I can not seem > to find a way to override this behaviour. Am I doing something wrong, > or is this a bug? > I take it the dates are displaying as 12/09/05 and 12/10/05 even though you input 09/12/05 and 10/12/05. That is strange because the format DD/MM/YY would still show your input as entered. If your cell formats are still correct, perhaps you need to check language settings - Tools /Options /Language Settings /Languages. You haven't used any other formatting? If you do not format the cells, the format you use seems to be the default format. Perhaps you should put the matter beyond any doubt by selecting English (USA) as the language when formatting the cells. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: shortcuts that replace missing excel shortcuts
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 can investigate, create (with some limitations) and delete them using /Tools /Customize: Keyboard tab. You may have to get/compose macros for the two instances you mention (I do not know). > A- n- d - is there a way to drag two cells down to copy the contents? ( > i.e. If you had 20 cells with the same date) If you drag using the handle in the bottom right corner, you'll get sequential dates. Formatting the date as text produces bizarre results when you drag down. Selecting and dragging down two date cells produces pairs. As far as I know, you'll have to copy and paste. > > I would greatly appreciate any tips or suggestions for better using > Openoffice. Is there anything in openoffice that you feel I might overlook because Excel didn't have it? >... > Gerri Belsito > One thing OpenOffice does not have is Microsoft. I never use their products unless I really must. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: decimal fraction in calc
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. > > klaus > I think people may be talking about different subjects. There is a QUOTIENT function and Help says this about it: QUOTIENT This function is only available if Analysis AddIn is installed. Returns the integer result of a division operation. Syntax QUOTIENT(Numerator;Denominator) Example =QUOTIENT(11;3) returns 3. The remainder of 2 is omitted. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Trouble with links between spreadsheets
> 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, you > would need to: > (1) Save the "source" file > (2) Save the "receiving" file, then do "File - Reload". You will be > asked whether you want your links updated - say yes and they will be. > You can save yourself one step by setting automatic updating of links - Tools /Options /OpenOffice.org Calc /General:Updating. You can get an instant result if you use the Paste icon, click on the arrow to the right and select "DDE link". Unfortunately, you may then have to format the cells to show the contents as you wish. I've never saved and reloaded a file using such links so perhaps the result is not as it first appears. Regards. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: copy and paste
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 retained. > Is this intended behaviour, if so, why? The format of the cell usually changes to that of the material being posted. If you use the paste icon (NOT paste-special), you can click on the arrow to the right of the icon and select a desired format from the drop-down list- it looks as though you want the selection "unformatted text". That works for pasting direct into the cell. The edit box works differently depending, as far as I can tell, on how you copy, i.e whether you copy the cell or select and copy material from the cell. As for why, you probably need to ask the developers. Regards. Terry. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Interface display fonts - menus, help etc.
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 not affect the font size of text in a document." The Scaling is supposed to be limited as above. Perhaps you should file some Issues on the subject. If you are not using the KDE desktop, the KDE tool (similar to what you mention) will not operate system-wide (or perhaps I should say "desktop-wide" since the desktop environment is the GUI of the system). (On my KDE, the command is System /Configuration /KDE /LookNFeel /Fonts). Surely on your system there is some sort of mechanism for altering system/GUI settings (?!). As I understand the blurb on OOo2 (from somewhere), it has been designed, GUI-wise, to mirror your OS. --- Malcolm Kay <[EMAIL PROTECTED]> wrote: - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Is linking to outside data disabled?
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 (although that does not work for me in OOo2). The Help topic is "Referencing a Cell in Another Document". Regards. Sarah charter.net> writes: I am having a problem though with putting a link in my OO spreadsheet. Whe I type a link for a web site it works fine, But, when I try the "link to outside data " option to link to another OO spreadsheet, it seems disabled. The OK is greyed out and it will not give me the option to select the highlighted file for link. I use the XP version of windows. ... Sarah in TN - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Interface display fonts - menus, help etc.
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 centimetres. Is there some way to control these independently? > But a much worse problem is the ghastly hard-to-read non-serif > fonts popularised by Microsoft and used in menus, help, etc. > > In the same set of options I can mark "Use system font for user > interface", but this seems to do nothing and in any case I don't > know to what "system font" refers. > > I had expected that replacing the "interface User" font in > Tools->Options->OpenOffice.org->Fonts would deal with this > problem but it has no effect on menus, help etc. Was this the > intent? Does it work on other platforms? What is the intended > purpose of the pseudo font? > > Can anyone enlighten me? > > Malcolm Kay > I understand that altering the scaling is supposed to affect only the UI. On the replacement issue, the README file in the openoffice.org2.0 directory (the directory in which the programme is installed) states "To change the font of the OpenOffice.org user interface, you have to replace the default font "Andale Sans UI" with another font and mark the "always" setting for this replacement." The default font is not actually listed, you have to type it in. I've got a related problem in that, for ease of visibility, I have increased font sizes using the KDE tool and the increased fonts show up in the OpenOffice UI generally but not in the dialogs so that, if I use scaling to increase the dialog fonts, I get too much size in the UI generally. It may be that your OS enables you to alter font settings system-wide, in which case those settings will be mirrored in OpenOffice, except in the dialogs. Hope this helps. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Navigation within a spreadsheet
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 cell, you could assign it to a keyboard shortcut using Tools /Customize and the Keyboard tab. F5 gets you the Navigator but that's a slow way to move to another cell and, in any case, does not necessarily place the cell at the top left of the page. The navigator would work marginally faster if you gave W1 a name using Insert /Names /Define. If you can contrive to set the width of the previous columns so that column W is the start of a page, you could assign a keyboard shortcut to the command "Page Right" - on the Keyboard tab you'll find that in Functions:Category: "Navigate". Still, that may involve moving one page at a time if the preceding columns occupy more than one page. Cheers. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] How to stop Bullets & Numbering Toolbar appearing in Writer?
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. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Navigation within a spreadsheet
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. Clicking in a cell merely selects that cell, unless you attach a macro (or whatever) using Data /Validity. You could merely position W1 in the top left corner and save the file at that setting. Perhaps I've misunderstood? Regards. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Getting Cell Value in a Macro
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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Getting Cell Value in a Macro
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 liability accepted. It may need altering. It may help. Regards. Do oRange1 = oSheet.getCellRangeByPosition _ ( 0, 4, 255, 4 ) 'this gets A5 to IV5 lVolume = oRange1.computeFunction _ ( com.sun.star.sheet.GeneralFunction.SUM ) ' this gets the total 'of values in the range If lVolume = 0 Then oSheet.Rows.RemoveByIndex( 4, 1 ) 'removes row 5 End If Loop until lVolume > 0 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Getting Cell value in macros
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. It worked! And I cannot get it to not work. I believe in the past I've stopped when the Print test failed to give me the result I needed. I'll work on finding something that does not work. I guess this means using getValue instead of getString from now on. Cheers again. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Getting Cell value in macros
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 the small value? > > I created a sheet that has the value "0.1" in cell A1 on the first > sheet. I then used the following macro: ... > Print d > Print Format(d, "0.###") > End Sub > > The first print statement prints 1e-05. The second print statement > prints "0.1". The cell itself shows the value "0" unless I place the > cursor into the cell or change the number format associated with the cell. > Thanks. For what it's worth, I'll send the document. I did not know about "Print Format(...)" The sheet I prepared to send you contains 0.075 in A1. The cell was formatted for "0.000" and correctly showed the value "0.075". My macro, pretty well the same as yours, returned "7.5E-02" for the first print command. The next (to me, new) command Print Format(dValue, "0.###") returned "0.075". That's more than I've achieved previously but there may still be a problem when you try to do anything with the value other than print or include it in a message. As an example I tried, hastily, to write a macro to set the value of B1 by reference to the value obtained from A1, thus: Dim dValue as Double, oCell as Object, oDoc as Object, oSelect as Object, _ oSheet as Object, tCellAddress, tRangeAddress oDoc = ThisComponent oSelect = oDoc.CurrentSelection oSheet = oDoc.Sheets.getByIndex ( 0 ) dValue = oSelect.getValue ' Print dValue - got me 75E-02 ' Print Format(dValue, "0.###") - this worked oCell = oSheet.getCellbyPosition ( 1, 0 ) oCell.NumberFormat = 107 oCell.setValue ( dValue ) ' oCell.setValue ( Format (dValue, "0.###") ) tried and failed End Sub The number format 107 is "0.000". The macro resulted in the value 0.000 in cell B1. Perhaps it is necessary to create a new number format each time you want to enter or otherwise manipulate a value, but at the time I was writing my (real) macros, it was a darn sight easier to use getString. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Conversion (Paste Special) Problem
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, copy the range, place the cellpointer in the top-left cell of the range, get Paste-Special, de-select "Paste All", select the listed categories except "Formulas" (which should be de-selected), leave the remaining defaults (Options - none, Operations - none, Shift Cells - Don't shift) and press OK. Cheers. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Getting Cell value in macros
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 obtained can be converted to a string with cStr (...). I have been unable to get Basic to read values of less than 1, so I have "cheated" by using .String or .getString rather than .Value or .getValue. I have an idea you're not supposed to do that but I can find no other way of getting small values. I have successfully used the strings so obtained with .setValue (...). - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: IDE text size
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. Regards. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: List 1 default numbering style
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 +Organizer. Regards. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Data Menu option Equivalent
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: calculate cell value
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 other columns for the row are copied > from the oringial row where the cell was. > > is this understandable? ...[previous:] > > I would like to do one of two things > > 1. calculate the following from different cell values > > from cell value 1-4, 7-9(describing ranges of weeks) > > I would like to calculate the number of weeks, in this case 7. > > From cellvalue 2-4, 5,6 > > the same thing, number of weeks is now 5 > > or any variant of the above.. > > the result should be put in a new cell in a new column ... I for one do not understand. It might help if you include a pasting from an actual spreadsheet. If I put 1-4, 7-9 into a cell, it is probably a label, not a value. Certainly, it does not seem to be possible to manipulate such an entry with a formula. I think you need to re-phrase part of your first posting - it's impossible, surely, to split a row into several rows or for a cell to occupy more than one row. If you paste an example, displaying cells as they appear - in rows and columns, it should be easier to follow. It might be a language difference. In OOo2 columns are labelled A to IV (left to right), rows are numbered 1 to 65536 (top to bottom) and a cell is defined by a column label and row number, e.g. C23. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: [Calc] Reference to a row
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 formulas with $ . Since all your formulas will refer to the same sheet, you could change the example given to $Main.A5:IV5 . Regards. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: [Calc] Reference to a row
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 D
[row 5] Row52 4 6
=sum('Row5') > result is 12
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Java runtime environment
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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Calc: convert text to several columns
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: [EMAIL PROTECTED]
[users] Re: Calc: convert text to several columns
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 the first cell and use "Paste Special", deselecting "Paste All" and "Formats" and selecting the other categories. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Calc - multiple IF conditions without nesting
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). Fortunately, the following did: > =IF(AND(L8<7.1;L8>0)=1;L8;7.1). > > Regards, Terry. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Calc - multiple IF conditions without nesting
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 result; otherwise result). I have been mystified that IF in Calc can apparently deal with only 1 condition at a time. My discoveries are: 1. In Calc AND and OR are functions, not operators. 2. The following formula (simplified) yields the result "TRUE": =AND(L8<7.1;L8>0) [where L8 contains the value 7]. 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). Fortunately, the following did: =IF(AND(L8<7.1;L8>0)=1;L8;7.1). In my real life example, I did not use the value 7.1 but a formula that returned that value. The same thing can, of course, be achieved by nesting a second IF condition but I like simplicity and nested formulas can be a pain to review. Hope this is of interest to someone. Maybe someone knows a simpler way. Regards, Terry. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Keyboard shortcuts - loading config file erases settings
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 now verified, so lets try to load my settings which > I saved as "Inställningar OpenOffice" just a short moment ago. > > Tools - Customize... - Keyboard > > Load... > Again, when selecting "Configuration" in the File format field, no files > are shown, so I reselect All files (*.*), then I select my file > "Inställningar OpenOffice", then I hit Open. > > This time every shortcut key for Calc was assigned to nothing and the > OpenOffice.org shortcut keys was not affected at all, maybe because the > Calc radio button was selected. > > Just for fun I now select the OpenOffice.org radio button and then I Load > the "Inställningar OpenOffice" file again, and yes, now everything is > assigned to nothing... ...[Snipped] > So my conclusions about 2.0 are: > 1. Saving and loading keyboard settings does not work... > 2. Configuration files does not have a suffix...?? In the save dialog, > when selecting the file type "Configuration", no files are shown at all, > so "All files (*.*)" must be selected (1.1.5 is the same in this case). > 3. If a configuration file is loaded, every shortcut key will be cleared > (assigned to nothing) for the application selected (OpenOffice.org/Calc in > this case). > > Can anyone else test this to verify if something is wrong with my > installation or if this is a general misbehaviour? ...[Snipped] I have just loaded a keyboard config file - all settings for keyboard shortcuts are erased. I have Mandrake Linux. Do you want to file this as an issue? If so, publish the issue number and I'll vote for it. For the time being, I suggest you simply customize the settings without saving and loading - I have not found that to be necessary. For some time now, I have been using my setting of "Home" instead of "Ctrl-Home" and "End" instead of "Ctrl-End" - both without saving and re-loading. Cheers, Terry. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Like operator in Calc IF function
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 or FALSE. You need to enclose
your text in double quotes, not single quotes.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Keyboard shortcuts etc...
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). Since there is a conflict, because Ctrl-F means
> "Search and Find", I changed the old Ctrl-F to Ctrl-B. Now I saved my
> changes to a file (which seems to have no suffix...) and then I tried to
> verify that my changings was done properly.
>
> So I selected a cell and pressed Ctrl-F to make the text in it Bold (Fet),
> but it wasn't. Then I pressed Ctrl-B and the text was bold. So what did I
> do wrong? How can I save my changes? If not possible, what's the point?
Perhaps you should try again. I just succeeded in saving keyboard changes as a
file (it is saved as a zipped archive in Linux) and getting Ctrl+F to make the
contents of a cell bold (and reverse). Did you delete the old Ctrl+B setting?
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: [moderated]
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 it's supposed to) on Open Office. > I have tried opening different dialog boxes, but fearful of getting myself in a fix I can't get out of, I > haven't pushed this too far. Any advice would be deeply appreciated. > >Best Regards, >Joe O'Brien > jnobrien verizon.net (503) 693-2810 With Linux (and, from memory, I think Windows is similar), you can right click on the icon, select Properties and then enter comment you want displayed. My OOo2 icon displays without any tinkering. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: default sorting options in calc 2.0 (column headers option)
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 that selecting a column of text results in automatic selection of the option to use column headers, as does selecting a column of numbers (including dates) with the column header. Selecting the numbers without the header results in automatic deselection of the option. Selecting a table containing mixed entries, without the column headers, results in deselection of the option. Selecting the whole table, including headers, results in automatic selection of the option. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date format as default
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 the way: Tools /Options /Language Settings /Languages /Locale Setting: Your Choice, Default Languages ... Western: Your Choice. Since I've chosen Australian English, using the simple date field gives me 09/11/05 (instead of the US format 11/09/05) for 9 November 2005. The only way I can find to get a different format is to use the field "other". I too am interested to discover whether there is some way to alter the default format. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Calc - (don't) show grid lines
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? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: O/O Writer -- setting the date
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 today's date rather than a fixed date, use Insert /Fields /Other /Type: Date /Select: Date [NOT date fixed] /Format: [You choose - if none of the displayed formats suit, use "Additional Formats" and the resulting dialog] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Document language setting in 2.0?
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 supported anymore. Which is good, > IMO, as this setup really didn't belong in Options - but what do I use > instead? I can't seem to find a document language setting anywhere else, > and the Help page on this is apparently not updated. > > - T I have Writer open and, using Tools /Options /Language Settings /Languages there is a box "For the current document only." I have RC3, Mandrake Linux. Regards. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: dates in oo 2.0
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 the menu command Insert /Fields /Other, then click on
the "Document" tab. On the tab, in the first column ("Type") choose "Date", in
the next column ("Select") choose "Date" [i.e. not "Date (fixed)"] and in the
last column ("Format") choose "31 Dec 1999".
That gives you one digit for single digit days. If you want two digits (e.g.
04), select (in that column) "Additional formats" (you have to double click),
you get a new dialog, select 31 Dec 1999 and in the box at the bottom ("Format
Code") add another D alongside the existing D, click on the tick mark. On that
dialog, you can change the language, if you want, to English (UK). After
pressing OK, you will find the new format in the first dialog.
Choose Insert, then Close. I found a help item under "date fields;inserting"
Cheers.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
