[users] OpenOffice.org Knowledgebase

2005-02-08 Thread Jonathon Coombes
Hi All, Apologies if you were trying to access the knowledgebase the last two days. I forgot to update some settings and I took the database for the tips away. This stopped the system from working and put and error instead. The good news is it is all fixed now, just that there is not tips current

Re: [users] Date conversion in CSV import

2005-02-08 Thread Pascal DeMilly
Crystle, This is also what I have been doing. However often I forget to do this step and I am left with reloading the file. What I was fishing for is a type conversion in OOo, similar to the format conversion. It would be great if one could convert a text to a number or to date or even to a formul

[users] **CORRECTION ** .SXF FILE SAVE OF FORMER WP11 DOCS IN OO ** SORRY

2005-02-08 Thread Lou-
I meant .sxw, not .swf. sorry about that. Proof that the brain's cells do begin to die off as one nears 50, I suppose :) lou- From:"G. Roderick Singleton" <[EMAIL PROTECTED]>To:[EMAIL PROTECTED]:[EMAIL PROTECTED]:Mon, 07 Feb 2005 10:23:51 -0500Subject:re: [users] Corel Word Perfect Office 11

[users] Missing help files, 1.1.4, Linux

2005-02-08 Thread Donald R. C. Robinson
I updated to version 1.1.4 on the Linux platform. On invoking Help, there comes a message saying the database does not exist!! The check sum matches. I followed the setup guide as closely as possible. What are the help files called so I can search for themd? Is it possible to move them to wher

Re: [users] how to unsubscribe

2005-02-08 Thread Paul
Easiest way : To unsubscribe, e-mail: [EMAIL PROTECTED] Paul On Tue, 8 Feb 2005 18:15:04 -0500, Kenneth G. Goutal <[EMAIL PROTECTED]> wrote: > > I need to get off this list in a hurry (and maybe come back at some future > date). > Can someone e-mail directions to me off-list? > I'd really ap

[users] how to unsubscribe

2005-02-08 Thread Kenneth G. Goutal
I need to get off this list in a hurry (and maybe come back at some future date). Can someone e-mail directions to me off-list? I'd really appreciate it. No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.6 - Release Date: 2/7/2005 --

[users] Update

2005-02-08 Thread cosomati.umberto
Dear Sirs, is it possible to update from 1.1 to 1.1.3 or shall I uninstall the previous version before installing the latest one? Thank you in advance for your reply. Best regards Umberto Cosomati

[users] OOo upgrade (1.1.0 to 1.1.3)

2005-02-08 Thread Hylton Conacher (ZR1HPC)
Just like to report to the archives that I did an upgrade of my OOo installation on SuSE 9.0 from 1.1.0 to 1.1.3 on the 9.2 CD set I have. I had no problems, barring a few icon changes and some settings not being ported between versions but otherwise HAPPY DAYS. NICE Work DEVELOPERS, and the li

[users] Appendix number in header

2005-02-08 Thread Andy Howell
I'm can't figure out how to get the name of the Appendix into the page header. In order to have separate chapter and appendix numbering, I have two sets of styles defined. I setup tools->outline number to use level 1-4 for chapters and 5-10 for appendices. I also had to doctor the table of cont

Re: [users] Which MS Office is OpenOffice Equivalent To?

2005-02-08 Thread Bruce Byfield
James W.Greenidge wrote: This doesn't alter my using OpenOffice one iota nor question its more than adequate functions. I'm just asking this as a techno curiosity: OpenOffice would be (roughly?) the equivalent of what version of MS Office? I kind of bristled at one associate who said OpenOffice

[users] Re: Can't add to autocorrect

2005-02-08 Thread Paul B.
Joe Conner wrote: Possibly a reboot? Paul B. wrote: Peter Kupfer wrote: Paul B. wrote: Well, looks like I broke something. I placed as many user support files as I could in one place, and then pointed Options/Paths to that folder (and only this folder, abandoning the other "parallel" files), for

Re: [users] Indirect Addressing in a Calc Function

2005-02-08 Thread Anthony Chilco
Glad to help. Now, for anyone who's racking their brain about the lyrics, they come from a Bobby Curtola (Canada's teen dream of the 60's) hit 'Three Rows Over'. You can read all about him (and get the complete lyrics with guitar chords) here: http://www.curtola.com/bconweb1.html tc Nick Samuel

Re: [users] Indirect Addressing in a Calc Function

2005-02-08 Thread Nick Samuel
Hi Anthony, Thank you! It works, of course. I thought that I had tried this but I obviously got it wrong. It is so much clearer when somebody sets it out. Thanks Again, Nick Anthony Chilco wrote: Hi Nick, The offset function wants an address as the first parameter. Use the indirect function to s

Re: [users] Re: Can't add to autocorrect

2005-02-08 Thread Joe Conner
Possibly a reboot? Paul B. wrote: Peter Kupfer wrote: Paul B. wrote: Well, looks like I broke something. I placed as many user support files as I could in one place, and then pointed Options/Paths to that folder (and only this folder, abandoning the other "parallel" files), for ease of upgrading

Re: [users] Indirect Addressing in a Calc Function

2005-02-08 Thread Anthony Chilco
Hi Nick, The offset function wants an address as the first parameter. Use the indirect function to supply it: offset(indirect(sheet3.D4);3;2) If cell sheet3.D4 contains the value "sheet2.A15" then the function above should return the contents of cell sheet2.C18, which is three rows over and two

Re: [users] Date conversion in CSV import

2005-02-08 Thread Anthony E. Greene
On 17:02 Feb 8, 2005 Crystle Numan <[EMAIL PROTECTED]> wrote: [importing CSV data with dates like MMDD] > >When you import the csv, do you do >Insert->Sheet? If you do, you will >get more options. This does not convert the dates properly in OOo 1.0.2. Try formatting the cells as some kind of

Re: [users] Indirect Addressing in a Calc Function

2005-02-08 Thread Anthony Chilco
Hi Nick, You're right. It is simple. Somewhere I've got a spreadsheet with a similar function and it does work. I'll see if I can find it here (I'm at home). It may be at work, though. tc Nick Samuel wrote: Hello, I am trying to look up values on a sheet from a position specified in another cel

Re: [users] Date conversion in CSV import

2005-02-08 Thread Crystle Numan
On Mon, 2005-02-07 at 23:13 -0800, Pascal DeMilly wrote: > Hi, > > I am importing some CSV files where the datse are in text format either > as YYMMDD or MMDD. How do I tell calc that those cells should be > formatted as Date from a string after it has been imported? When I tried > to use the

[users] Indirect Addressing in a Calc Function

2005-02-08 Thread Nick Samuel
Hello, I am trying to look up values on a sheet from a position specified in another cell on the sheet. I work out, using a formula, where in the sheet I want to start: e.g. sheet2.A15 This appears in a spreadsheet cell e.g. Cell sheet3.D4 contains the value "sheet2.A15" I then tried to use the O

Re: [users] Re: Impress to MPEG or AVI etc?

2005-02-08 Thread Nicu Buculei
Jim Berg wrote: Do you want to make a movie of what you have created Check this out http://www.techsmith.com/products/studio/default.asp It is a movie making program of your screen.. of course you can do this also using free tools: http://www.unixuser.org/~euske/vnc2swf/ - Orig

Re: [users] [moderated]

2005-02-08 Thread Mark Kirchner
Replying off-list, since it's German-only now. On Monday, February 7, 2005, 7:43:35 PM, Josef Krautzberger wrote: > Jetzt habe ich zwar die Wörterbücher gefunden, die Wörterbücher > installieren können, die Sprache einstellen können, auch den Klick > mit der rechten Maustaste gefunden, doch Rechts

[users] Re: Can't add to autocorrect

2005-02-08 Thread Paul B.
Peter Kupfer wrote: Paul B. wrote: Well, looks like I broke something. I placed as many user support files as I could in one place, and then pointed Options/Paths to that folder (and only this folder, abandoning the other "parallel" files), for ease of upgrading. Now, however, autocorrect does

[users] Re: Impress to MPEG or AVI etc?

2005-02-08 Thread Jim Berg
Do you want to make a movie of what you have created Check this out http://www.techsmith.com/products/studio/default.asp It is a movie making program of your screen.. Jim Berg, the oldman from Texas - Original Message - From: "Peter Kupfer" <[EMAIL PROTECTED]> Newsgroups:

Re: [users] Opening Excel files in OpenOffice

2005-02-08 Thread G. Roderick Singleton
On Tue, 2005-02-08 at 11:30 +0500, MIS wrote: > Greetings! > I have an excel file which opens in excel 2003. Note though this file is not > password protected but when I try to open it in OpenOffice 1.1.1 it gives > error "Password Protected File". > Could anybody help me how can I open it in Ope

Re: [users] openoffice.writer

2005-02-08 Thread Andrew Douglas Pitonyak
Marijan Vrhovnik wrote: Dear Sirs, I would like to change the font size and the font style at openoffice writer (at the menue). Because it's bad to read the menues. So, how can i change it. thanks a lot :) If you are not satisfied with the current answers, check out: http://www.openoffice.org/

Re: [users] Which MS Office is OpenOffice Equivalent To?

2005-02-08 Thread Martin Deppe
Hi Jim, this is my decent opinion regarding your issue: it of course depends on the version of OOo you are using (the newer the better - of course) but in general OOo and MSO have there sets of functions which are overlapping but not equal. Therefore there is most of the functions (I guess) very

Re: [users] Which MS Office is OpenOffice Equivalent To?

2005-02-08 Thread Rich
i beleive there is no msoffice 98, it was probably a reference to mso97. there actually is no single answer, because in some areas oo.org is better, in some slightly lacks features. for example, pdf export, page styles, stylist, customizeability, portability(!), source availability - in these ar

Re: [users] help on importing macro from excel file

2005-02-08 Thread G. Roderick Singleton
On Tue, 2005-02-08 at 11:31 +0100, Dott. Giuseppe Gadaleta wrote: > Hello. > I've tried to import an excel file containig macro. After import operation i > cannot find the macro. > I use a pc with winXP pro, openoffice 1.1. > > can you help me? > > > regards > > > giuseppe gadaleta Dotte. Gi

[users] Which MS Office is OpenOffice Equivalent To?

2005-02-08 Thread James W.Greenidge
Greetings: This doesn't alter my using OpenOffice one iota nor question its more than adequate functions. I'm just asking this as a techno curiosity: OpenOffice would be (roughly?) the equivalent of what version of MS Office? I kind of bristled at one associate who said OpenOffice is pretty mu

[users] help on importing macro from excel file

2005-02-08 Thread Dott. Giuseppe Gadaleta
Hello. I've tried to import an excel file containig macro. After import operation i cannot find the macro. I use a pc with winXP pro, openoffice 1.1. can you help me? regards giuseppe gadaleta

[users] excel to openoffice.org calc

2005-02-08 Thread Milen Pankov
Hi, I am planning migration from microsoft office to openoffice.org and want to ask a question. My company work with 2 programs that export data to office - one using word and one excel. Even after checking the fuctions 'excel to openoffice.org calc' and 'winword to openoffice.org writer' none

[users] Calc ODBC query paramaters from worksheet

2005-02-08 Thread Hamish
Hello everyone I would like to convert some ms spreadsheets to OOo, but I am having problems with one point: The spreadsheets get their information from an ODBC query, and can be updated for the latest data. Paramaters for the queries (like from_date etc) can be prompted for, but I want the para

[users] Opening Excel files in OpenOffice

2005-02-08 Thread MIS
Greetings! I have an excel file which opens in excel 2003. Note though this file is not password protected but when I try to open it in OpenOffice 1.1.1 it gives error "Password Protected File". Could anybody help me how can I open it in OpenOffice. Thanking! Mian Muhammad MaShaAllah Disclaimer

Re: [users] [moderated]

2005-02-08 Thread lucas wyrsch
Dear Forum Members I have seen that OpenOffice also is available in traditional Chinese (http://zh.openoffice.org/index.html) but I haven't find it in simplified Chinese! Does there exist also a version in scimplified Chinese or is this projected! Thanks for the update Regards Lucas Wyrsch http:/