[users] Re: =IF(FIND(LOWER("card");C14);"yes";"no")

On Tue, 20 Sep 2005 18:25:05 -0500, David Chapman wrote: >=IF(ISERR(FIND("card";LOWER(D8)));0;1) > >> Thank You! >> Now, if the word 'card' or 'Card' is removed from C14 I again get the >> error #VALUE! >> >> Doesn't IF mean if true do this else that? IF(xxx ; is true ; is false) >> >> -- >>

[users] Japanese and English on Linux

Hi, Please let me know how to install Open Office on Linux so that I can use as English Language and also Japanese Language. I can manage to type both languages in Windows XP because Windows XP has already provided for Japanese langauge. I am not sure about Linux (Fedora 4). I installed the Engli

Re: [users] Spelling in Swedish

CPHennessy wrote: On Monday 12 September 2005 07:43, + Mikael Boman wrote: Is there a possibility to run a spell check in the Swedish language? I have only found the English and Italian language. "File" -> "Autopilot" -> "Install Dictionary" ? Please reply to users@openoffice.org only Mr

[users] Re: [webmasters] Re: more than 1 language on 1 computer

[...] >> My own question is a simple one: how can I install more than one >> language of O.O. on my computer? My system is (infested with) [...] Hi Bettina, If you simply want to produce documents in different languages, you don't have to install a separate localized OO suite for each of them!

Re: [users] Re: [website-feedback] OO 2.0 Beta

Steve, Have you tried the Save-As function? It is necessary to change the type/format of file (not just the name of the file). There shouldn't be any issue with MS Office if you are saving your documents as Word documents. Note that there are three different "ages" of Word formats (Word 6, Word 9

Re: [users] Re: [website-feedback] OO 2.0 Beta

On Mon September 19 2005 23:04, Louis Suarez-Potts wrote: > Hello, > > On Sep 16, 2005, at 8:06 AM, Steve Donald wrote: > > Dear OO, > > > > I was very impressed with 2.0 Beta version however all my previous > > MS files > > have been turned into OO ones. In an attempt to revert back to MS > > form

Re: [users] other programs

On Tue September 20 2005 13:56, + Lenka Mojcherova wrote: > I have a document in OPEN OFFICE in WRITER. I need to get it in some > other program in order to work with it in Chinese language. The program > is in master document file and it has quite a lot of pictures and text > in it. I need to know

Re: [users] problem with chinese

On Tue September 20 2005 13:15, + Lenka Mojcherova wrote: > Haia, > > I have installed your beta version into the computer because I got > information that it supports Chinese language. However when I started to > write some sentences in Chinese it could not recognize some words and it > corrupted

Re: [users] Re: [webmasters] Re: more than 1 language on 1 computer

On Tue September 20 2005 02:26, Louis Suarez-Potts wrote: > > On Sep 11, 2005, at 5:49 PM, [EMAIL PROTECTED] wrote: > > My own question is a simple one: how can I install more than one > > language of O.O. on my computer? My system is (infested with) > > Windows XP; I am learning Linux, but it will

Re: [users] Re: [website-feedback] Field function on Open Office 2 (Beta)

On Mon September 19 2005 22:59, Louis Suarez-Potts wrote: > Hello, > > On Sep 13, 2005, at 2:59 PM, Gordon wrote: > > I'm having trouble in OO 2 (beta) with the Fields function. Instead > > of inserting a fixed date (say Septemer 10 2005 it says date(fixed) > > which is no help in a document that I

Re: [users] MUI-Support in OOo

On Tue September 20 2005 11:36, + Pfeifer, Erwin wrote: > [ MODERATED ] > Hello, > in our bilingual society we need the presense of the German-Version and > Italian-Version of OOo on every PC running WinXP in the offices of the > public administration. > Question; Does OOo su

Re: [users] address labels

On Tuesday 20 September 2005 21:38, Beth Brown wrote: > I am trying to make address labels. I am only able to do this one sheet at > a time. Is there a way to make more than one sheet. My labels are all > different addresses. I am using WindowsXP and openoffice 1.1. Thanks, Beth > Brown This is a

Re: [users] MUI-Support in OOo

On Tue, 2005-09-20 at 12:36 +0200, Pfeifer, Erwin wrote: > Hello, > in our bilingual society we need the presense of the German-Version and > Italian-Version of OOo on every PC running WinXP in the offices of the > public administration. > Question; Does OOo support (and what I have to do to make

Re: [users] Re: OOo 1.1.5 excruciatingly slow - what's wrong?

Hallo Ron and all others, Ron Ross schrieb: Pablo Lachmann <[EMAIL PROTECTED]> writes: Am 18.09.2005 um 12:03 schrieb CPHennessy: On Sat September 17 2005 11:35, Ron Ross wrote: Hi, I just installed the new stable version of OOo, and luckily didn't uninstall 1.1.4, because 1.1.5 is not just

Re: [users] Re: =IF(FIND(LOWER("card");C14);"yes";"no")

=IF(ISERR(FIND("card";LOWER(D8)));0;1) On 9/20/05, GregChi <[EMAIL PROTECTED]> wrote: > > On Tue, 20 Sep 2005 10:05:18 -0700, David Chapman wrote: > > >=IF(FIND("card";LOWER(C14));1;0) > > > >On 9/20/05, GregChi <[EMAIL PROTECTED]> wrote: > >> working with OOo 1.9.125: > >> > >> cell C14: "Debit

[users] Re: =IF(FIND(LOWER("card");C14);"yes";"no")

On Tue, 20 Sep 2005 10:05:18 -0700, David Chapman wrote: >=IF(FIND("card";LOWER(C14));1;0) > >On 9/20/05, GregChi <[EMAIL PROTECTED]> wrote: >> working with OOo 1.9.125: >> >> cell C14: "Debit Card Purchase: Exxonmobil75" >> formula in H14: "=IF(FIND("Card";C14);1;0)" >> results : 1 >> >> cell

Re: [users] Re: Forcing a write to disk

Dale Erwin wrote: Park wrote: Thanks for the information. Is there a way to convert my current uncached tables? Or do I have to build new ones from scratch? Fred Toussi, the HSQLDB project leader, tells me that there is, but I'm still looking for how to do it. I'll get back to you as soon a

[users] Re: =IF(FIND(LOWER("card");C14);"yes";"no")

There is no bug here. All formulae working as expected. Look carefully at original poster's formulae and my correction. Dave On 9/20/05, cono <[EMAIL PROTECTED]> wrote: > Hi, > > Is this http://www.openoffice.org/issues/show_bug.cgi?id=52584 > ?? > > Greetings, > Cor > > GregChi wrote: > >

Re: [users] OpenOffice crashes, randomly

On Mon September 19 2005 15:28, Eero Volotinen wrote: > Hello OOList. > > I am with very hard problem with OpenOffice, it randomly hangs or crashes > on my system. There are many users on system, so I am little pain in the > ass, if I can't solve this problem fast. > > System is running 64bit Gento

Re: [users] =IF(FIND(LOWER("card");C14);"yes";"no")

Hi, Is this http://www.openoffice.org/issues/show_bug.cgi?id=52584 ?? Greetings, Cor GregChi wrote: working with OOo 1.9.125: cell C14: "Debit Card Purchase: Exxonmobil75" formula in H14: "=IF(FIND("Card";C14);1;0)" results : 1 cell c14: "Debit ard Purchase: Exxonmobil75" formula in H14:

Re: [users] Impress Slides Going off the Screen

On Tue September 20 2005 18:56, john geldman wrote: > I have two thoughts. I would guess the second is the issue. (Occams Razor) > > First, I've had issues with laptops with two displays using MS Office > (bad settings) where slide shows went to the second screen when it > wasn't there. But I didn'

Re: [users] Development request.

All you can say about this, is why would this guy expect any help with an attitude like that. At least we do get a log of "thank you"s from others which is an encouragemnet when answering new people's problems. -- CPH : openoffice.org contributor Maybe your question has been answered already?

[users] other programs

I have a document in OPEN OFFICE in WRITER. I need to get it in some other program in order to work with it in Chinese language. The program is in master document file and it has quite a lot of pictures and text in it. I need to know how can I transport it into the other program like WORD in or

[users] problem with chinese

Haia, I have installed your beta version into the computer because I got information that it supports Chinese language. However when I started to write some sentences in Chinese it could not recognize some words and it corrupted them. So simply text is not really readable or understandable in

Re: [users] bad url in spanish download area openoffice

On Mon, 2005-09-19 at 13:30 -0300, Juan Manuel De Castro wrote: > hello. > The spanish download area for openoffice (linux version) is bad. > please correct this url whit e valid url. > > > This url don't work > > (http://mirrors.ibiblio.org/pub/mirrors/openoffice/contrib/rc/1.1.5rc2/OOo_1.1.5r

Re: [users] address labels

On Tue, 2005-09-20 at 14:38 -0500, Beth Brown wrote: > I am trying to make address labels. I am only able to do this one > sheet at a time. Is there a way to make more than one sheet. My labels > are all different addresses. I am using WindowsXP and openoffice 1.1. > Thanks, Beth Brown Beth, YOu

Re: [users] address labels

On September 20, 2005 03:38 pm, Beth Brown wrote: > I am trying to make address labels. I am only able to do this one sheet at > a time. Is there a way to make more than one sheet. My labels are all > different addresses. I am using WindowsXP and openoffice 1.1. Thanks, Beth > Brown Hi Beth, List

[users] Re: =IF(FIND(LOWER("card");C14);"yes";"no")

=IF(FIND("card";LOWER(C14));1;0) On 9/20/05, GregChi <[EMAIL PROTECTED]> wrote: > working with OOo 1.9.125: > > cell C14: "Debit Card Purchase: Exxonmobil75" > formula in H14: "=IF(FIND("Card";C14);1;0)" > results : 1 > > cell c14: "Debit ard Purchase: Exxonmobil75" > formula in H14: "=IF(FIND

[users] =IF(FIND(LOWER("card");C14);"yes";"no")

working with OOo 1.9.125: cell C14: "Debit Card Purchase: Exxonmobil75" formula in H14: "=IF(FIND("Card";C14);1;0)" results : 1 cell c14: "Debit ard Purchase: Exxonmobil75" formula in H14: "=IF(FIND("Card";C14);1;0)" results : #VALUE! cell C14: "Debit Card Purchase: Exxonmobil75" if formula i

Re: [users] [moderated]

Bob wrote: > over here our dates start with the days then months then years as 16/09/05 > but your Assuming you are using Calc, you need to configure the cell style. " ">Cell styles >New >Numbers" Category The keyboard shortcut is < C >. This is drop down which contains the following option

Re: [users] address labels

On Tuesday 20 September 2005 14:38, Beth Brown wrote: > I am trying to make address labels. I am only able to do this one sheet at > a time. Is there a way to make more than one sheet. My labels are all > different addresses. I am using WindowsXP and openoffice 1.1. Thanks, Beth > Brown Hello, Eve

[users] address labels

I am trying to make address labels. I am only able to do this one sheet at a time. Is there a way to make more than one sheet. My labels are all different addresses. I am using WindowsXP and openoffice 1.1. Thanks, Beth Brown

Re: [users] [moderated]How to open odg file

Robin wrote: > I could be mean and say that this is what I experience each time someone > sends me a DOC or XLS document and leave it there. I just send people a note asking them to a) Clean out all of the virii in their system; b) Delete all of the macro virii they have on their system; c) Then

[users] Difference?

Last night I downloaded OOo_2.0beta2_ Win32 Now, I see and downloaded OOo_2-1.0beta2_Win32 Now, what's the difference? Greg "Of all the dispositions and habits which lead to political prosperity, religion and morality are indispensable supports. In vain would that man claim the tribute

Re: [users] Calc: is this a bug?

FWIW, Excel has same output. Dave On 9/20/05, Paul Smith <[EMAIL PROTECTED]> wrote: > > Dear All > > I have a squared array with the following elements: 1,2,3,8. When I > apply the formula > > {=IF(AND(A1:B2>2;A1:B2<4);"yes";"no")} > > I get a second squared array filled only with "no", which

Re: [users] Calc: is this a bug?

On 9/20/05, Niklas Nebel <[EMAIL PROTECTED]> wrote: > > I have a squared array with the following elements: 1,2,3,8. When I > > apply the formula > > > > {=IF(AND(A1:B2>2;A1:B2<4);"yes";"no")} > > > > I get a second squared array filled only with "no", which is wrong, as > > the element 3 satisfies

Re: [users] Re: Forcing a write to disk

Park wrote: Thanks for the information. Is there a way to convert my current uncached tables? Or do I have to build new ones from scratch? Fred Toussi, the HSQLDB project leader, tells me that there is, but I'm still looking for how to do it. I'll get back to you as soon as I find something. -

Re: [users] Calc: is this a bug?

Paul Smith wrote: I have a squared array with the following elements: 1,2,3,8. When I apply the formula {=IF(AND(A1:B2>2;A1:B2<4);"yes";"no")} I get a second squared array filled only with "no", which is wrong, as the element 3 satisfies the AND condition. Do you confirm this as a bug? AND i

[users] Calc: is this a bug?

Dear All I have a squared array with the following elements: 1,2,3,8. When I apply the formula {=IF(AND(A1:B2>2;A1:B2<4);"yes";"no")} I get a second squared array filled only with "no", which is wrong, as the element 3 satisfies the AND condition. Do you confirm this as a bug? Thanks in advanc

Re: [users] Impress Slides Going off the Screen

I have two thoughts. I would guess the second is the issue. (Occams Razor) First, I've had issues with laptops with two displays using MS Office (bad settings) where slide shows went to the second screen when it wasn't there. But I didn't see any hint of that mode in a quick look. But, your descr

Re: [users] [moderated]

Le lundi 19 septembre 2005 à 02:21 -0400, [EMAIL PROTECTED] a écrit : > I will soon receive a software program that requires excel. Is the > openoffice software compatible? Thanks Kelly If you mean that your software application calls Excel to open a file that it generates, then in all probabil

[users] Re: =IF(FIND(LOWER("card");C14);"yes";"no")

=IF(FIND("card";LOWER(C14));1;0) On 9/20/05, GregChi <[EMAIL PROTECTED]> wrote: > working with OOo 1.9.125: > > cell C14: "Debit Card Purchase: Exxonmobil75" > formula in H14: "=IF(FIND("Card";C14);1;0)" > results : 1 > > cell c14: "Debit ard Purchase: Exxonmobil75" > formula in H14: "=IF(FIND

[users] =IF(FIND(LOWER("card");C14);"yes";"no")

working with OOo 1.9.125: cell C14: "Debit Card Purchase: Exxonmobil75" formula in H14: "=IF(FIND("Card";C14);1;0)" results : 1 cell c14: "Debit ard Purchase: Exxonmobil75" formula in H14: "=IF(FIND("Card";C14);1;0)" results : #VALUE! cell C14: "Debit Card Purchase: Exxonmobil75" if formula i

[users] Problem with creating a macro in Calc

Dear All I am trying to create a macro in Calc to delete everything in the column C except formulas. I have tried to record the macro as follows: 1. select the whole column C; 2. delete contents, except formulas. However, the macro only works if I select the column C before running the macro. A

Re: [users] Impress Slides Going off the Screen

[EMAIL PROTECTED] wrote: I could be barking up the wrong tree, but I need a starting point. HW: Dell Latitude C610 (1.2GHz/256MB) OS: SUSE Linux OSS (10.0-beta 4) OOo: 1.9.125.1 (2.o-pre) I have created a couple of Impress shows, and when I run them on my laptop, the slides run off the right s

Re: [users] Is this a bug? Icon & Text

The hover help works. I have someone in the office that is trying to learn Open Office and wanted to turn on text for the first couple of weeks to make it easier to learn. It is hard to do that when most of the icons become hidden. Dan Lewis wrote: Here is something that might help you.

Re: [users] Looking for a gentle introduction to Base

On 9/20/05, Dan Lewis <[EMAIL PROTECTED]> wrote: > > Could somebody here please recommend to me a gentle introduction to > > Base? > > http://documentation.openoffice.org/manuals/oooauthors2/index.html > Read Chapter 10: Getting Started with Base. It might be of some help. Thanks, Dan. Paul ---

Re: [users] Re: Mail Merge Wizard & Multiple records per page

On Tuesday 20 September 2005 10:59 am, Marcus Ilgner wrote: > Hello again, > > in a previous post I remarked about strange page numbering issues > after using the Mail Merge Wizard. Though in the case mentioned, the > wizard was effectively the wrong solution, I'm now in a situation > where I reall

[users] landcape for just one page in m125 and m128

OOo draw. Slide 1: portrait Slide 2: landscape Slide 3: portrait Using the help method crashes both. Is it possible yet? Cheers, Steve. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECT

Re: [users] Re: Mail Merge Wizard & Multiple records per page

Hello again, in a previous post I remarked about strange page numbering issues after using the Mail Merge Wizard. Though in the case mentioned, the wizard was effectively the wrong solution, I'm now in a situation where I really want to write a serial letter to a couple of receivers. I successfull

Re: [users] Is this a bug? Icon & Text

Here is something that might help you. Make sure that Tips is checked (ticked). Then when you put your cursor over the icon, its description apears. In 1.1.x, Tips is found at Tools > Tips. Make sure it has a check (tick) mark in front of it. (Help Agent probably should be checked [tic

Re: [users] Is this a bug? Icon & Text

Playing with it some more I see it is as designed to accommodate large description. I think the usability would improve if the Icons where large enough to have two lines of text and thinner. You also don't need the whole text for most of the descriptions. For instance "Hyperlink Dialog". You

[users] Is this a bug? Icon & Text

When I set the tool bar to show Icon and Text, each icon takes up about 3 times the space it needs. So I get maybe 3 or 4 icons on the tool bar with the rest off the screen. I should probably see about 12 to 13 icons. Any one else seeing this? PS Using 1.1.5 on windows -- Thomas Miller Wash

Re: [users] Why are my posts being identified as SPAM?

Hehe, anytime someone claims software has any intelligence, everyone should know they are blowing smoke! I get the spam nonsense from one user on the list, posted earlier as part of this thread. Most people are polite. Jason On 20-Sep-05, at 9:14 AM, Steve Kopischke wrote: How is it then

Re: [users] OpenOffice development & licensing question

David Flor escribió: Please forward to whoever is appropriate... Who do I contact if I have questions regarding distribution of an OpenOffice derivative? Just check the licence in the page. I'm interested in using the word processor on a potentially commercial and "off the shelf" product an

Re: [users] Why are my posts being identified as SPAM?

How is it then that I *never* see these? That is what drove my suggestion to the OP that he check with his ISP. [rant] There are too darn many spam "filters" in corporate use these days with claims of "intelligence" that have none. [/rant] SJK

[users] determining language of installed OOo

Hi, just wanted to update my OOo from 1.1.4 to 1.1.5 but it morons about that the language is different. How can I get to know the language of the installed and new version? How does OOo determines the language? thanks John

Re: [users] Looking for a gentle introduction to Base

On Tuesday 20 September 2005 05:50 am, Paul Smith wrote: > Dear All > > Could somebody here please recommend to me a gentle introduction to > Base? > > Thanks in advance, > > Paul http://documentation.openoffice.org/manuals/oooauthors2/index.html Read Chapter 10: Getting Started with Base. It migh

Re: [users] New Development Request:

Nice request, but far better tools exist. As a UNIX/MacOSX user we have that capability built in and it seems far more pleasing to use, so I understand why you would like it. However I do hope that far more serious things are worked on prior. Jason On 19-Sep-05, at 1:24 PM, [EMAIL PROTECT

Re: [users] Why are my posts being identified as SPAM?

This was also my solution under OSX for these offending individuals. Jason On 20-Sep-05, at 1:31 AM, john geldman wrote: Steve, FWIW, I have gotten a lot of these SPAM warnings. The mail list is obviously getting the messages, and as these messages seem to only get sent to posters, they don'

Re: [users] Development request.

ouch. there are potential users that i would prefer ms support to deal with oh, background and accompanying picture also go well with the style of this person. [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] - go fuck yourself. CPHennessy wrote: PLEASE DO NOT CROSS POST TO SO MANY MAILING LISTS

[users] Looking for a gentle introduction to Base

Dear All Could somebody here please recommend to me a gentle introduction to Base? Thanks in advance, Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] OpenOffice Basic/StarBasic

Hi George, Has OpenOffice Basic / StarBasic the ability to write CLASSES as is possible with VBA? >(without this the thousands of lines of VBA we have will not be vaguely convertible). I know there is the UNO bridge allowing (e.g.) Java apps to communicate with the API, but this seems a little

Re: [users] Development request.

[EMAIL PROTECTED] - go fuck yourself. CPHennessy wrote: PLEASE DO NOT CROSS POST TO SO MANY MAILING LISTS!! ALSO PLEASE DO NOT INCLUDE SUCH BIG DOCUMENTS AS MANY USERS DO NOT HAVE BROADBAND. On Mon September 19 2005 01:47, + [EMAIL PROTECTED] wrote: MS word has ONE really use

[users] bad url in spanish download area openoffice

hello. The spanish download area for openoffice (linux version) is bad. please correct this url whit e valid url. This url don't work (http://mirrors.ibiblio.org/pub/mirrors/openoffice/contrib/rc/1.1.5rc2/OOo_1.1.5rc2_050719_LinuxIntel_install_es.tar.gz) this url work http://mirrors.ibiblio.o

[users] OpenOffice development & licensing question

Please forward to whoever is appropriate... Who do I contact if I have questions regarding distribution of an OpenOffice derivative? I'm interested in using the word processor on a potentially commercial and "off the shelf" product and would like to know what licensing restrictions there are. I

[users] MUI-Support in OOo

Hello, in our bilingual society we need the presense of the German-Version and Italian-Version of OOo on every PC running WinXP in the offices of the public administration. Question; Does OOo support (and what I have to do to make it run) a MUI like interface, i.e. the launch of the right version

[users] Re: Query in Base

Gert Blij wrote: -Original Message- From: Fred Frazelle [mailto:[EMAIL PROTECTED] Sent: Sun 18 September 2005 11:47 PM To: users@openoffice.org Subject: Query in Base www.fundacionanisa.org Does anybody know how to create a one to many query b

Re: [users] Re: [website-feedback] Problem with OpenOffice.org

Thank you very much, I changed the name of the file after doing a search and now Open office is working again. Kindest Regards A Theobald - Original Message - From: "G. Roderick Singleton" <[EMAIL PROTECTED]> To: Cc: "Theobald Family" <[EMAIL PROTECTED]>; Sent: Tuesday, September 2

[users] Korean

Help. I have turned on the Korean language option but cannot figure out how to type in this language nor can I find a keyboard map for it. Van Fountain, NC

[users] Re: Open Office 2.0 features

Adam Pearson wrote: Alan Mead wrote: keith <[EMAIL PROTECTED]> wrote: Thank you for the lead on a grammar checker. When I am putting the ideas on "paper" the ideas flow without much concern about grammar. Then once it is on paper I sometimes done see what I wrote but what I think I wro