[users] Queries to Tables

2006-01-07 Thread Pat K
I am new to OpenOffice database software. I like it, but have a problem: How do I convert a Query result into either a Table or a spreadsheet? Thank you, Patrick Keating

[users] Registing

2006-01-07 Thread Ruud
Hello, Everytime I start my openoffice, its asking for to register which I already have done on previous versions. Help! Greetz, Ruud Bloem

[users] install wants to start internet explorer

2006-01-07 Thread Hazen Middleton
I was about to install OpenOffice... Zonealarm warns that OO wants to start Internet Explorer ! duh I will not allow Internet Explorer to run on my computer. Can I install OO without IE or should I delete the install file and forget it ? Hopefully I will see the reply to this message than

Re: [users] Re: OpenOffice Sudoku Solver addin

2006-01-07 Thread Joe Conner
Why do you not submit your solver to http://ooextras.sourceforge.net/downloads/english/index.php?tab=Calc ? Joe David Chapman wrote: Conditional formatting. Select any subgroup corresponding to a cell in the solution grid and select Format - Conditional Formatting Dave On 1/7/06, Dennis

[users] Re: add db query into a spreadsheet

2006-01-07 Thread Mark Greenbank
Hi again, It seems I can use a data source that has been defined in a database (.odb) that I have open along with the spreadsheet. Is there any way to add a database (in OOo 2.0) in a stand-alone spreadsheet? Thanks, Mark On 1/5/06, Mark Greenbank <[EMAIL PROTECTED]> wrote: > > Hi, > > Is it pos

Re: [users] Compute Miles/Hour Using Time Values

2006-01-07 Thread Shriramana Sharma
Sunday, 08 January 2006 06:23 samaye, Chris BONDE alekhiit: > Is there a simpler way of computing mph given two time values and the > distance? > > =distance/(HOUR(time2-time1)+(MINUTE(time2-time1)/60)+(SECOND(time2-ti > me1)/3600)) Store the two times in two cells A1 and A2, subtract the earlier

[users] Re: Compute Miles/Hour Using Time Values

2006-01-07 Thread Matej Cepl
Dennis Marks wrote: > Is there a simpler way of computing mph given two time values and the > distance? > > =distance/(HOUR(time2-time1)+(MINUTE(time2-time1)/60)+(SECOND(time2-time1)/3600)) > Probably the best what you can hope for is user-defined function -- see help for more how to do it. Mat

Re: [users] Compute Miles/Hour Using Time Values

2006-01-07 Thread Chris BONDE
Is there a simpler way of computing mph given two time values and the distance? =distance/(HOUR(time2-time1)+(MINUTE(time2-time1)/60)+(SECOND(time2-ti me1)/3600)) -- Dennis Marks Dennis: It depends upon what data you have? Generally, miles per hour is considered distance travelled divided by

[users] Re: Change in HTML Editor

2006-01-07 Thread Kelvin Eldridge
Chad Smith gmail.com> writes: > > On 1/6/06, Keith Bates new-life.org.au> wrote: > > > > On Sat, 7 Jan 2006 01:02:13 + (UTC) > > Kelvin Eldridgd onlineconnections.com.au> wrote: > > > > > Hi, > > > > > > I've been updating a page on my website > > > www.onlineconnections.com.au/ozefilter.h

Re: [users] Less or Fewer Options?

2006-01-07 Thread Chris BONDE
On 1/6/06, Chris BONDE <[EMAIL PROTECTED]> wrote: > > > > Now let us look at > 'try and ...' instead of "try to"? How can one try and jump over the fence? You will try TO jump over the fence, then you will find whether you did or did not. "and" is to join two or more 'equal' objects to

Re: [users] Change in HTML Editor

2006-01-07 Thread Chris BONDE
On 1/6/06, Keith Bates <[EMAIL PROTECTED]> wrote: > > On Sat, 7 Jan 2006 01:02:13 + (UTC) > Kelvin Eldridgd <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > I've been updating a page on my website > > www.onlineconnections.com.au/ozefilter.html using the Html Editor > > (Html Document) in OpenOff

Re: [users] Re: OpenOffice Sudoku Solver addin

2006-01-07 Thread David Chapman
Conditional formatting. Select any subgroup corresponding to a cell in the solution grid and select Format - Conditional Formatting Dave On 1/7/06, Dennis Marks <[EMAIL PROTECTED]> wrote: > > As someone who is just learning to use a spreadsheet more advanced than > Works I have a question. How d

[users] Re: Compute Miles/Hour Using Time Values

2006-01-07 Thread Randomthots
Dennis Marks wrote: Is there a simpler way of computing mph given two time values and the distance? =distance/(HOUR(time2-time1)+(MINUTE(time2-time1)/60)+(SECOND(time2-time1)/3600)) Much. Time values are stored as a fraction of a day. So if you subtract two time values you have a decimal nu

[users] Re: OpenOffice Sudoku Solver addin

2006-01-07 Thread Dennis Marks
As someone who is just learning to use a spreadsheet more advanced than Works I have a question. How do you dynamically change the color of fields? Also for version 2 of the solver, add a way to lock the original numbers and a check for invalid entries such as duplicates. "David Chapman" <[EMAI

[users] Compute Miles/Hour Using Time Values

2006-01-07 Thread Dennis Marks
Is there a simpler way of computing mph given two time values and the distance? =distance/(HOUR(time2-time1)+(MINUTE(time2-time1)/60)+(SECOND(time2-time1)/3600)) -- Dennis Marks - To unsubscribe, e-mail: [EMAIL PROTECTED] F

[users] Impress draws top and left "border" line for a chart

2006-01-07 Thread Rainer Dorsch
Hello, I just seen that Impress draws "border" line for a chart. See e.g. the screenshot here: http://alzental-castle.de/~rd/ooochartborder.png They are also visible when I enter the OLE object, but both in chart area and chart wall the lines are marked invisible. Any hints are welcome... Th

[users] Powerpoint like pseudo 3D chart

2006-01-07 Thread Rainer Dorsch
Hello, I am wondering, if there is a powerpoint like pseude 3D chart in openoffice impress, similar to the one shown here http://alzental-castle.de/~rd/pptchart.png I know, OOo has powerful 3 chart drawing tools, but when doing a screen presentation, the non-exactly-vertical or non-exactly-hor

Re: [users] Re: OpenOffice Sudoku Solver addin

2006-01-07 Thread Wangshanpo
Dennis Marks wrote: When I try to copy "Configurations" out of the zip folder I get an error that the file is not there. BTW: Assuming I copy all of the files which one do I run? Just open the complete, downloaded ods file in Calc. Great job David, good fun but when will you add Hard and N

Re: [users] stacking

2006-01-07 Thread Keith Bates
On Sat, 7 Jan 2006 14:57:04 -0500 Doug McIlroy <[EMAIL PROTECTED]> wrote: > I have missed a basic fact about stacking: > how do you get things stacked in the first place? > After trying a raft of different combinations of > Insert->Picture, selecting, moving, typing, and > Arrange->Send-to-back, I

Re: [users] stacking

2006-01-07 Thread Wangshanpo
Doug McIlroy wrote: I have missed a basic fact about stacking: how do you get things stacked in the first place? After trying a raft of different combinations of Insert->Picture, selecting, moving, typing, and Arrange->Send-to-back, I still can't get text to overlap a picture. Thanks for your he

[users] stacking

2006-01-07 Thread Doug McIlroy
I have missed a basic fact about stacking: how do you get things stacked in the first place? After trying a raft of different combinations of Insert->Picture, selecting, moving, typing, and Arrange->Send-to-back, I still can't get text to overlap a picture. Thanks for your help, Doug McIlroy

[users] can't reopen hsql database

2006-01-07 Thread Thisse Pascal
Hello, Happy New Year, I need a little help please. I can't reopen a database with the soft base,can't connect to a hsql database,and the recovery don't help.this problem occur only under windows or in linux to ? - To unsubs

Re: [users] Re: can't reopen hsql database

2006-01-07 Thread Thisse Pascal
Mechtilde a écrit : Hello, Thisse Pascal schrieb: Hello, I can't reopen a database with the soft base,can't connect to a hsql database,and the recovery don't help.this problem occur only under windows or in linux to ? I need more Information: Which OOo Version do you use? Which Java Ver

[users] Re: can't reopen hsql database

2006-01-07 Thread Mechtilde
Hello, Thisse Pascal schrieb: Hello, I can't reopen a database with the soft base,can't connect to a hsql database,and the recovery don't help.this problem occur only under windows or in linux to ? I need more Information: Which OOo Version do you use? Which Java Version do you use? What do

Re: [users] Re: OpenOffice Sudoku Solver addin

2006-01-07 Thread Gareth Curtis
Can't you just change the extension of the zip folder to .ods and run it in OOo2.0.x? Dennis Marks wrote: When I try to copy "Configurations" out of the zip folder I get an error that the file is not there. BTW: Assuming I copy all of the files which one do I run? "David Chapman" <[EMAIL P

Re: [users] exim source code in impress

2006-01-07 Thread Marilyn Davis
On Sat, 7 Jan 2006, Andrew Douglas Pitonyak wrote: > CPHennessy wrote: > > >On Fri January 6 2006 01:54, Marilyn Davis wrote: > > > > > >>Hi, > >> > >>From reading the archives, I learned that the way to import source > >>code snippets into a file is to use emacs' htmlize, and then import > >>t

[users] Re: Re: Upgrading from 1.1.0 to Version 2

2006-01-07 Thread Maurice Batey
On Fri, 06 Jan 2006 17:28:47 -0500, G. Roderick Singleton wrote: > 8daysoftheweek is one. Thanks for the tip, but when I looked just now, they seem to be stuck at 2.0.0. Anyone know of CD availability of 2.0.1, please? -- Maurice Batey (Retired in Hampshire, UK) www.maurice.eur

Re: [users] Importing .CSV into OpenOffice Text

2006-01-07 Thread Jim Parkhurst
Thank you. I will do that. Before posting I queried the message archives. I will check the FAQ space also. >>> [EMAIL PROTECTED] 01/07/06 2:56 AM >>> On Fri January 6 2006 21:14, Jim Parkhurst wrote: > Open Office 2.0.1 > > I have found that attempts to open/import a .CSV file as a TEXT file > fai

Re: [users] exim source code in impress

2006-01-07 Thread Andrew Douglas Pitonyak
CPHennessy wrote: On Fri January 6 2006 01:54, Marilyn Davis wrote: Hi, From reading the archives, I learned that the way to import source code snippets into a file is to use emacs' htmlize, and then import the result. Ok. So I learned to htmlize, and the html looks good. But when I impo

Re: [users] Installation and Use of OpenOffice.org

2006-01-07 Thread Markus Frei
Since you had to retry the download many times, it still looks as if you got a corrupt file. You should try downloading again, maybe ask someone with a proper connection, not dialup, or you can also ask for a CD for a small fee to be sent to you. You can't compare this to the m$ stuff, as you ca

Re: [users] Toolbar positions

2006-01-07 Thread Zoltán Kócsi
> > When the toolbar is docked, the 'lock toolbar position' is grayed > > out so no solution there. > > Hi Zoltan, > I think that the problem with the toolbar appearing in different > places was fixed in 2.0.1, and maybe your other problem was fixed > there also. I'll download that then, thanks!

Re: [users] Impress slideshow

2006-01-07 Thread Zoltán Kócsi
> > Could someone tell me how to make a full-screen show actually > > display on full screen? > > > > The OS is Linux, (SuSE 9.1 and SuSE 10.0), the behaviour is the same > > on both, on 4 different machines. > > Which window manager are you using ? > Impress displays correctly in full screen for

Re: [users] Parenthesis in Right to Left Mode

2006-01-07 Thread CPHennessy
On Fri December 30 2005 14:57, Habib Seifzadeh wrote: > Hi all, > I have a problem with writing parenthesis in right to > left mode. > The problem is: For the begin of sentence and end of > sentence, when I press left parenthesis, OO 2.0 > inserts right parenthesis and when I press right > parenthe

Re: [users] Προώθ.: Re: problem with work

2006-01-07 Thread CPHennessy
On Sun January 1 2006 22:13, ΒΕΡΡΑΣ ΣΤΕΡΓΙΟΣ wrote: > > Dear sir > > I'm writting you asking you to help me with the beginnig of your's open > > office suite. I intsalled it on my computer, but. unfortunately, in every > > try to work with it, appears the message: soffice.BIN has encounter a > > pr

Re: [users] Fix column width

2006-01-07 Thread CPHennessy
On Wed January 4 2006 02:50, + Transicom Admin wrote: > [ MODERATED ] > Hi to you, > > I have problem fixing the spreadsheet column width. After saving a > spreadsheet file, I re-open it to find the column width different/changed > from what I have saved. Hi Margaret, What

Re: [users] Uninstall

2006-01-07 Thread CPHennessy
On Tue January 3 2006 08:26, + Yoav H wrote: > כיצד מבצעים UNINSTALL ל- OPENOFFICE ? > > בתודה מראש, > > יואב הרצנשטין http://openoffice.org.il ? Please reply to users@openoffice.org only -- CPH : openoffice.org contributor Maybe your question has been answered already?

Re: [users] [moderated]

2006-01-07 Thread CPHennessy
On Wed January 4 2006 09:54, + Cyrus Bardouille wrote: > [ MODERATED ] *** > Hi, > > When I opened a MS Word document containing an Excel spreadsheet the Write > application crashed. Also there is not an option to open the embedded > spreadsheet in Calc. What version of Open

Re: [users] how to convert asp file to open office excel

2006-01-07 Thread CPHennessy
On Thu January 5 2006 05:29, + indrakumar Krishnan wrote: > [ MODERATED ] *** > dear sir > > > this mail is to seek help with u for converting asp > files to open office excel files > > i am already using single line code to convert the asp > application to MS-excel format.but

Re: [users] Export to PDF: Reduced size

2006-01-07 Thread CPHennessy
On Thu January 5 2006 16:40, Knight, Jon wrote: > OOo 2.0.1 ... > > I've noticed that PDF files created by Writer & Calc are visible smaller > ... on screen and when printed. It seems the margins are changed as well. > Is this a known issue? Is there a fix/workaround? Hi Jon, Is it possible th

Re: [users] OOo 2.0 Writer

2006-01-07 Thread CPHennessy
On Thu January 5 2006 11:00, + Thierry wrote: > [ MODERATED ] *** > Hi, > > Could you help me with following problems please. > I have several dictionaries installed. My problem is that when i type > words in Dutch, the program automatically fills in words in Dutch but > also i

Re: [users] Re: [webmasters] OpenOrg default

2006-01-07 Thread CPHennessy
> On 1/5/06 1:09 AM Robert Stapleton wrote: > > I want to experiment with OO, not jump in head first. OO someway > > installed itself as the default-all application. I will usually want to > > open a file with the program it was created with (WordPerfect or MS > > Office) when I click on a file.

Re: [users] Installation and Use of OpenOffice.org

2006-01-07 Thread CPHennessy
Please subscribe to the mailing list as you will almost certainly miss some interesting responses. On Fri January 6 2006 22:02, + D.L. Gomez wrote: > [ MODERATED ] > Gentlemen, > > After five attempts, [The first four attempts failed when my dial-up > internet connection was

Re: [users] Less or Fewer Options?

2006-01-07 Thread Chris BONDE
[EMAIL PROTECTED] wrote: > > Is there anything misleading about the term "Less options"? > > > It's grammatically incorrect. Use "less" when you are talking about a substance that cannot be enumerated (I.e. I have less Kool-Aid here than I did an hour ago). Use "fewer" when you are talkin

Re: [users] Importing .CSV into OpenOffice Text

2006-01-07 Thread CPHennessy
On Fri January 6 2006 21:14, Jim Parkhurst wrote: > Open Office 2.0.1 > > I have found that attempts to open/import a .CSV file as a TEXT file > fails. > Opening a .CSV named file opens the file in CALC which is NOT what I > want. > This process worked well under OOO-1.5 (which I had to reinstall w

Re: [users] no subject

2006-01-07 Thread CPHennessy
On Fri January 6 2006 18:27, + [EMAIL PROTECTED] wrote: > [ MODERATED ] *** > > Hi, > > How do I write in Hebrew in the open office, I have the Hebrew version. > You need to install the Hebrew fonts "File" -> Wizard -> Install Fonts There may also be more info at http://openof

Re: [users] (Webmasters) - Problem...still

2006-01-07 Thread CPHennessy
On Fri January 6 2006 15:56, + Alex Gettinby wrote: > [ MODERATED ] *** > Hi. > > I tried using version 2 (Using Open Office.org Calc - Is that the right one > for Ods file?), Yes. > But now it comes up with this slightly different message > when I try to open existing sprea

Re: [users] OO and Win95

2006-01-07 Thread CPHennessy
On Fri January 6 2006 10:01, + Maciej Zielono wrote: > Hi There > Please tell me if there is any possibility to run OO in Win95 > If it is please tell me which version should I have and which version of > Win95 should it be. Hi, As you are not subscribed you may not have seen that: On Sat January

Re: [users] Toolbar positions

2006-01-07 Thread CPHennessy
On Fri January 6 2006 09:01, Zoltán Kócsi wrote: > Is it possible to lock tollbars in OOo2? > > Depending on the actual tool selected some toolbars appear/disappear, > constantly resizing the work area and move the document around a few > millimeters every time I click on an object. It is *extremel

Re: [users] [moderated]

2006-01-07 Thread CPHennessy
On Fri January 6 2006 08:35, + GIACOMO RUFFONI wrote: > Dear Sir/Madam, > > I had for a time the desire to move to Linux operative system, but I am > confuse about which installation will be best for me seeing that I am not a > computer expert. > > Can you advice me on this matter? Hi Giacomo,

Re: [users] Impress slideshow

2006-01-07 Thread CPHennessy
On Fri January 6 2006 08:24, Zoltán Kócsi wrote: > Probably my fault, but can't figure out the full-screen slideshow option > in 2.0.0. In 1.x the slideshow was full-screen, that is, the size of > the screen. If I moved the presentation to an other computer with > larger or smaller screen, it just

Re: [users] OOo for pocket PC

2006-01-07 Thread CPHennessy
On Fri January 6 2006 08:23, + A.Asquin wrote: > Hi, > > Can you tell me if there is an open source release dedicated for my > pocket pc (for the moment, it is Windows mobile 2003); Where can I find > it ? Hi AA, No, there is nothing available for pocket pcs yet. Please reply to users@openoffice

Re: [users] end notes

2006-01-07 Thread CPHennessy
On Fri January 6 2006 03:53, + Tom Katus wrote: > [ MODERATED ] > To whom it may concern: > > I have gone into the Help menu at least a dozen times to try and do end > notes. One would think this a rather simple operation. The menu directs me > to things that are not in my pro

Re: [users] exim source code in impress

2006-01-07 Thread CPHennessy
On Fri January 6 2006 01:54, Marilyn Davis wrote: > Hi, > > From reading the archives, I learned that the way to import source > code snippets into a file is to use emacs' htmlize, and then import > the result. > > Ok. So I learned to htmlize, and the html looks good. But when I > import it into

Re: [users] A question about OpenOffice & Mac OSX

2006-01-07 Thread JC Helary
While I have not found any problems with NeoOffice/J-1.2 (beta) in my limited use of it so far, I would be hesitant to recommend it to others for normal use. It is still a beta at this point. Use at your own risk. The "beta" part is not really about NeoOffice the application, since NeoOff

Re: [users] (Webmasters) - Problem...still

2006-01-07 Thread David Chapman
Having worked through and resolved a similar problem today, allow me to make a comment. The XML file is corrupted. Upgrading OOo to 2.0.1 is good suggestion but it will probably still not be able to read the XML file. Cyrille Moureaux was kind enough to give this advice earlier... >The one thing

Re: [users] A .chm, Strange, probably M$ format file

2006-01-07 Thread Fred A. Miller
On Thursday 05 January 2006 1:12 pm, Gene Heskett wrote: > Greetings; > > I just bought an SBLive 24 bit card, and the manual on the cd is in > the .chm format. Opening it with OOo-2.0.1 gets me about the same as > opening it with less, unintelligible gibberish with a few english > words sprinkled