Re: [users] Formula in spread sheet
Oops, thanks! On Tuesday 19 April 2005 07:35, David Chapman wrote: Shouldn't it be... =IF((N25*N26*21,67)=1000;1000;N25*N26*21,67) You originally had a string 1000 in the IF formula. Dave My OpenOffice Calc Website http://www.openofficetips.com On 4/18/05, Chadley Wilson [EMAIL PROTECTED] wrote: Greetings In cells G23 i Have this formula =IF((N25*N26*21,67)=1000;1000;N25*N26*21,67) And in cell G33 I have this formula, =G23+10 When the condition is true for the value to be 1000 then it ignores the value eg: G23 is equal to 1000 G33 = 10 instead of 1010 Why?? I am stumped TIA Chad - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Graphics links not updated in Write
I am using X11 on Panther (MacOS X 10.3.8) and OOo 1.1.1 (I know, it's not the latest one available...) The problem I have is caused when, after I create a new Write document, on my template which has a full page graphic for a background, and I also insert my scanned signature, I then go on to file my new document in its proper directory, only to discover that, when I re-open it, the graphics (background image as well as inserted signature) are not read, and all I see is the signature placeholder with no graphics whatsoever. Nothing at all shows instead of the first page background image. Is there a way to avoid this? Can I instruct OOo to re-read the graphics from their source files? I am little confused, because I see that the filename and path have been preserved within the signature placeholder. All that's changed is the location of the Write document itself, so why can it not go to the path it knows already and read the signature? Thanks, people. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Pocket Excel compatibility
Wisu wrote: I tried opening a Pocket Excel file failed with OOo 1.1.4 calc worked with OOo 1.9.79 except for formulas where =E1+E2+E3 would result ooow:=E1+E2+E3 Thought I'd feed back, or maybe someone has an alternative however I can still manage with deleting the ooow: in front of each formula It's issue 41033, which has been fixed in more recent builds. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Calc - Options
Thanks for the bug reporting instructions, but first things first. I have carried out a fresh download from OO, but the version downloaded is 1.9.79, and of course the problem I have reported still persists in this. I could not find a link on the home page enabling selection of 1.9.93 (or any other versions for that matter) Guidance on this would be appreciated. John B Message-ID: [EMAIL PROTECTED] Date: Mon, 18 Apr 2005 19:23:25 -0500 From: Peter Kupfer OOo [EMAIL PROTECTED] MIME-Version: 1.0 To: users@openoffice.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [users] Calc - Options John Barman wrote: I omitted to say in my last posting, that I now have OO2 Beta and use WinXP SP2 John B There are many beta of 2.0. You should download the latest once, 1.9.93 and see if the problem still exists. I can not replicate in 1.9.92. If it still persist... Borrowed from G. Roderick Singleton: The best way to have problems such as this evaluated is to file an issue. If you haven't already registered, do the following: Go to www.openoffice.org click the Register link at the top right of of the page. Fill in your information and reply to the confirmation email that will be sent to the address you provided. Once you have confirmed, go to www.openoffice.org again and click on the Bugs Issues link in the General links box. Thanks for bringing this to our attention. It is important that you file the issue to ensure reproducibility with your examples. HTH, -- Peter Kupfer -- Using OOo since 'OO4 -- [EMAIL PROTECTED] Want to help? http://www.oooauthors.org For OOo tips: http://openoffice.peschtra.com/tips/ooo_tips_tricks.html To order OOo: http://openoffice.peschtra.com/distro/ooo_distro.html
[users] Re: Calc - Options
John Barman wrote: Thanks for the bug reporting instructions, but first things first. I have carried out a fresh download from OO, but the version downloaded is 1.9.79, and of course the problem I have reported still persists in this. I could not find a link on the home page enabling selection of 1.9.93 (or any other versions for that matter) Guidance on this would be appreciated. John B John Try :http://download.openoffice.org/680/index.html This is on the Download Tab of the home page. HTH Russell - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] duplicating sheet area
is there a way to duplicate some area in a spreadsheet so that everything is preserved (including row height) ? it seems that paste special doesn't provide such functionality -- Rich - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Regex for paragraph find
Matt Needles wrote: Paul B. wrote: Alan McKinnon wrote: On Monday, 18 April 2005 23:02, Paul B. wrote: I think this was mentioned fairly recently, but in case not, is there a regex for finding a new paragraph? I see /n, but its specced only for soft returns, in the Find field anyway. Unless I'm missing it, that seems a strange priority, as I use far more hard than soft paragraph returns. Thanks, Paul Hi Paul, Try using $ - end of a paragrph. For some strange reason it won't find the last para in a doc though Alan I did try that: '$-' did not pick up: ... but others from good will. - Phi 1:15 I'm trying to replace '^-' (or, using more conventional new line notation, '\n-') with ' -' - that is, I'm trying to collapse paragraphs - but tying the search string to the end of the previous paragraph doesn't do it. That's probably because a multiline marker would be needed - another thing I didn't see listed in Help. Thanks, Paul Not sure why you're using the - in your search string. The right one is $ for end-of-paragraph marker, ^ for start-of-paragraph. To find blank lines, use $^, or ^$. Matt Needles Volunteer Tester/Coach for OOo If you look at the example I gave you'll see that '-' is part of the verse reference I'm trying to move up a line. Paul -- Using OOo 1.9.90.1 on Win XP. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Regex for paragraph find
John D. Toppins wrote: Paul B. wrote: Alan McKinnon wrote: On Monday, 18 April 2005 23:02, Paul B. wrote: I think this was mentioned fairly recently, but in case not, is there a regex for finding a new paragraph? I see /n, but its specced only for soft returns, in the Find field anyway. Unless I'm missing it, that seems a strange priority, as I use far more hard than soft paragraph returns. Thanks, Paul Hi Paul, Try using $ - end of a paragrph. For some strange reason it won't find the last para in a doc though Alan I did try that: '$-' did not pick up: ... but others from good will. - Phi 1:15 I'm trying to replace '^-' (or, using more conventional new line notation, '\n-') with ' -' - that is, I'm trying to collapse paragraphs - but tying the search string to the end of the previous paragraph doesn't do it. That's probably because a multiline marker would be needed - another thing I didn't see listed in Help. Thanks, Paul Someone else explained that SEARCH and REPLACE doesn't look across paragraphs - it only looks a paragraph at a time. To collapse them, you have to fool it. i do that by replacing the paragraph marker with a symbol (like %%), then doing your global replace, then replacing %% with new paragraphs. I use this when I inherit a document with paragraph markers at the end of each line and double-spaced paragraph markers between paragraphs. Try replacing $ (the paragraph marker) with %. Then replacing %% (double-spaced lines) with \n (new paragraph marker). John T. I used to do this in Word, via macro. But tell me, how do you replace paragraph markers with the marker string? It's the inability to search for paragraph markers that is exactly my problem here. Paul -- Using OOo 1.9.90.1 on Win XP. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OOo-1.9.82 Debian packages
* Richard [EMAIL PROTECTED] [180405, 21:42]: On Monday 18 April 2005 01:14 pm, Ennio-Sr wrote: Hi all, I downloaded the deb pckgs from the site suggested a few posts ago (ftp://ftp.linux.cz/pub/localization/OpenOffice.org/devel/680/Beta) [cut] The point is that I can't see any 'install' or 'setup' file in those packages. How can I observe the recommendation? My personal opinion is that this is just a hold-over from the OOo1.1.x documentation. To the best of my knowledge, the latest OOo2 betas are in rpm and now in deb format and therefore the old install or setup file information is not germane, just hasn't been updated. regards, Richard. Hi Richard, thanks for your message: you must be right, considering that all works normally :-) Regards, Ennio. -- [Perche' usare Win$ozz (dico io) se ...anche uno sciocco sa farlo. \\?// Fa' qualche cosa di cui non sei capace! (diceva Henry Miller) ](°|°) [Why use Win$ozz (I say) if ... even a fool can do that. )=( Do something you aren't good at! (as Henry Miller used to say) ] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc - Options
To find the lastest version I go to http://download.openoffice.org/680/index.html You can access it through www.openoffice.org http://www.openoffice.org - Download tab - Latest Snapshot Build for OpenOffice.org 2.0 link (2nd link) on 19.04.2005 09:57 Mixu Lauronen said the following: John Barman kirjoitti: Thanks for the bug reporting instructions, but first things first. I have carried out a fresh download from OO, but the version downloaded is 1.9.79, and of course the problem I have reported still persists in this. I could not find a link on the home page enabling selection of 1.9.93 (or any other versions for that matter. Strange... I just got 1.9.93 downloaded. I simply got to www.openoffice.org and selected downloading of 2.0 beta. The English version, at least, was the latest release. I cannot help you any further, sorry. Try again, maybe?
[users] Re: Regex for paragraph find
Andrew Brown wrote: Paul B. [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: I'm trying to replace '^-' (or, using more conventional new line notation, '\n-') with ' -' - that is, I'm trying to collapse paragraphs - but tying the search string to the end of the previous paragraph doesn't do it. That's probably because a multiline marker would be needed - another thing I didn't see listed in Help. Much the easiest way to do this, which works almost infallibly, is simply to go to format-autoformat-apply. I just cleaned up a 4,000 word email like that with only two misjudgements of where the paragraph breaks should come. All the other returns were unwrapped and the paragraph breaks were preserved. This really ought to be in one of the FAQ collections Good tool to know about, and one that will come in handy. But it did nothing for my problem. For the following example Therefore I tell you, whatever you ask in prayer, believe that you have received it, and it will be yours. - Mar 11:24 it only changed the Default paragraph style to Text Body followed by List 1. I think it chose a list style for the second para because of the leading hyphen. So I tried it after deleting the hyphen and space, and sure enough got all Text Body, but still no adoption of the orphans. So, whatever auto format's merits, it's not doing what I need it to. What is needed here is a simple way to search for hard paragraph returns, so the user can do what he needs to. I can't understand why the soft return would be allowed for in searching, but not the far more often used hard. The soft return was even given the symbol, \n, almost universally used for the hard. Thanks, Paul -- Using OOo 1.9.90.1 on Win XP. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Regex for paragraph find
On Tuesday, 19 April 2005 13:06, Paul B. wrote: So, whatever auto format's merits, it's not doing what I need it to. What is needed here is a simple way to search for hard paragraph returns, so the user can do what he needs to. I can't understand why the soft return would be allowed for in searching, but not the far more often used hard. The soft return was even given the symbol, \n, almost universally used for the hard. Thanks, Paul Hi Paul, Search for $ in the Search and Replace dialog box works. You have clicked the Regular expressions check box in the lower left? You have a point with the inconsistency of \n. The Word way using \n and \p is more intuitive to a regular user (who can't be expected to grapple with regexps). Perhaps I should formulate a feature request for this. Alan -- Alan McKinnon [EMAIL PROTECTED] +27 82 337 1935 (C) +27 86 110 2411 (W) +27 12 349 9277 (F) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Problem with v.1.9.93 Base
Andrew Cassels wrote: Hello, I have a problem, I want to open a .odb database, it opens but when I click with the Tables button, there is a error message saying: /The connection to the data source accounts could not be established. / /Error in the script file line: 1 File input/output errorerror / /java.io.IOException opening file - file C:\Documents and / /Settings\Andrew Cassels\Bureau\accounts.data in statement / /[CREATE CACHED TABLE Expenses]/ If I click on more and error buttons I get the following: // /SQL Status: S1000 / /Error code: -29 / /File input/output error C:\Documents and Settings\Andrew Cassels\Bureau\accounts.properties java.io.IOException: No OutputStream/ Thus error never happened with previous versions. I also cannot see the document if I do F5 in a writer or spreadsheet document. Thank you very much for your help If this is a new error and it is repeatable, especially with a newly created database, then be certain to checkthe bug tracker and file a report. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm Free Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Graphics links not updated in Write
On Tuesday 19 April 2005 02:53 am, Alex Zachopoulos wrote: I am using X11 on Panther (MacOS X 10.3.8) and OOo 1.1.1 (I know, it's not the latest one available...) The problem I have is caused when, after I create a new Write document, on my template which has a full page graphic for a background, and I also insert my scanned signature, I then go on to file my new document in its proper directory, only to discover that, when I re-open it, the graphics (background image as well as inserted signature) are not read, and all I see is the signature placeholder with no graphics whatsoever. Nothing at all shows instead of the first page background image. Is there a way to avoid this? Can I instruct OOo to re-read the graphics from their source files? I am little confused, because I see that the filename and path have been preserved within the signature placeholder. All that's changed is the location of the Write document itself, so why can it not go to the path it knows already and read the signature? Thanks, people. There are two possibilities. First, the Write document is only looking within the folder to which you moved it. Secondly, the graphics have been turned off. (On my system, the Graphics On/Off icon is in the Main toolbar on the left side of the window. It is next to the bottom of that toolbar. Click on this icon to see if this is the case. If so, the graphics should re-appear. If not, there is a problem with the links you created. A better way would be to create the document without the links. When inserting a graphic, leave the Link box unchecked. The graphic then becomes a part of the Writer document. This is more likely the problem. You should probably do this for your template first. Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Problem with v.1.9.93 Base
On Tuesday 19 April 2005 03:48 am, Andrew Cassels wrote: Hello, I have a problem, I want to open a .odb database, it opens but when I click with the Tables button, there is a error message saying: /The connection to the data source accounts could not be established. / /Error in the script file line: 1 File input/output errorerror / /java.io.IOException opening file - file C:\Documents and / /Settings\Andrew Cassels\Bureau\accounts.data in statement / /[CREATE CACHED TABLE Expenses]/ If I click on more and error buttons I get the following: // /SQL Status: S1000 / /Error code: -29 / /File input/output error C:\Documents and Settings\Andrew Cassels\Bureau\accounts.properties java.io.IOException: No OutputStream/ Thus error never happened with previous versions. I also cannot see the document if I do F5 in a writer or spreadsheet document. Thank you very much for your help I get similar errors with the database section of 1.9.93. Some times I can make a connection to a specific database, and other times I can not. The database section still needs some work, but it is getting better. I am a little confused with your reference to F5. F4 is used to open the Data Sources window. F5 is used to open the Navigator. Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Regex for paragraph find
Paul B. wrote: John D. Toppins wrote: Paul B. wrote: Alan McKinnon wrote: On Monday, 18 April 2005 23:02, Paul B. wrote: I think this was mentioned fairly recently, but in case not, is there a regex for finding a new paragraph? I see /n, but its specced only for soft returns, in the Find field anyway. Unless I'm missing it, that seems a strange priority, as I use far more hard than soft paragraph returns. Thanks, Paul Hi Paul, Try using $ - end of a paragrph. For some strange reason it won't find the last para in a doc though Alan I did try that: '$-' did not pick up: ... but others from good will. - Phi 1:15 I'm trying to replace '^-' (or, using more conventional new line notation, '\n-') with ' -' - that is, I'm trying to collapse paragraphs - but tying the search string to the end of the previous paragraph doesn't do it. That's probably because a multiline marker would be needed - another thing I didn't see listed in Help. Thanks, Paul Someone else explained that SEARCH and REPLACE doesn't look across paragraphs - it only looks a paragraph at a time. To collapse them, you have to fool it. i do that by replacing the paragraph marker with a symbol (like %%), then doing your global replace, then replacing %% with new paragraphs. I use this when I inherit a document with paragraph markers at the end of each line and double-spaced paragraph markers between paragraphs. Try replacing $ (the paragraph marker) with %. Then replacing %% (double-spaced lines) with \n (new paragraph marker). John T. I used to do this in Word, via macro. But tell me, how do you replace paragraph markers with the marker string? It's the inability to search for paragraph markers that is exactly my problem here. Paul A ha, thanks to Alan's prodding below, I see that searching for regex '$' gets your paragraph ends. That, plus a multiline regex switch, would be a way to get at my problem, but it would be roundabout and clumsy. The problem with this technique in my situation is that one would have to parse the search instance by instance through the file, as not all short paragraphs are orphans. Paul -- Using OOo 1.9.90.1 on Win XP. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Regex for paragraph find
Alan McKinnon wrote: On Tuesday, 19 April 2005 13:06, Paul B. wrote: So, whatever auto format's merits, it's not doing what I need it to. What is needed here is a simple way to search for hard paragraph returns, so the user can do what he needs to. I can't understand why the soft return would be allowed for in searching, but not the far more often used hard. The soft return was even given the symbol, \n, almost universally used for the hard. Thanks, Paul Hi Paul, Search for $ in the Search and Replace dialog box works. You have clicked the Regular expressions check box in the lower left? You have a point with the inconsistency of \n. The Word way using \n and \p is more intuitive to a regular user (who can't be expected to grapple with regexps). Perhaps I should formulate a feature request for this. Alan Yes, I've been using regex searches. Thanks for the reminder about '$', it does find paragraph ends. Without a multiline switch, though, it can't be used to directly do what I'm trying. I promise you - if you write up a request on this, I'll vote for it. :) BTW, I'm not much of a fan of Word's regex handling. I'm much more used to Perl's. Paul -- Using OOo 1.9.90.1 on Win XP. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Problem with auto recovery screen in 2.0 beta
On Monday 18 April 2005 07:14 pm, Peter Kupfer OOo wrote: TANYANIKA LEWIS wrote: Hello, I am having a serious problem with the document auto recovery screen in OpenOffice 2.0 beta. The screen comes up for you to choose the document to recover and it tells you to click on the start recovery button. The problem is that I don't see the start recovery button at the bottom of the screen because it is hidden below the bottom bar. When I slide the bottom bar futher down, and try to move the box up so I can see it, it only goes up a little-still not enough to reveal the buttons. This screen has now prevented me from opening any other document or program linked to OpenOffice until I can recover the document. Do you have any suggestions? I am currently using Operating System 98 SE. If there is any other information that you may need that I haven't thought of, please do not hesitate to let me know. I am trying to get this resolved as quickly as possible. This is not the first time I have heard this concern. I would check for an issue about it or file one. It think it is particular to Win 98. Borrowed from G. Roderick Singleton: The best way to have problems such as this evaluated is to file an issue. If you haven't already registered, do the following: Go to www.openoffice.org click the Register link at the top right of of the page. Fill in your information and reply to the confirmation email that will be sent to the address you provided. Once you have confirmed, go to www.openoffice.org again and click on the Bugs Issues link in the General links box. Thanks for bringing this to our attention. It is important that you file the issue to ensure reproducibility with your examples. I have similar problems with Win 98SE on a laptop. But the real problem is the screen size. The laptop allows a maximum resolution of 800x600. This might help: hold down the Alt key as you drag the auto recovery upward. Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Problem with opening documents created in Word.
One other setting that can cause the behavior: Tools Autocorrect Options Tab Uncheck Apply border -Doug Sandy Thomson wrote: Doug The horizontal lines actually appear under MenuFormatPageBorders. There are no lines in User-defined for header or footer. I've tried removing the existing lines from Borders and then clicking just below the gray area as you suggest but Ooo won't allow me to click in the gray area at all. If I click just above the gray area, the borders still appear above the box for the header and below the footer. Is there another setting that I need to adjust. Thanks, Alex -Original Message- From: Doug Thompson [mailto:[EMAIL PROTECTED] Sandy Thomson wrote: I am trying to use OpenOffice version 1.9.93 to open reports created in Microsoft Word 2000. In Word, there are page borders which are measured from text and do not surround the header and footer. When I file open these documents in Word, the page borders move to below the header and footer. How can I avoid this happening? If it is impossible to avoid this problem at this stage of development, how can I correct the page borders so they show correctly? I don't know how to correct the problem automatically on import. That being said: 1. Menu Format Page 2. Select the Header Tab. 3. At the bottom left, click on More... 4. In the box labelled User-defined, I suspect you will see a horizontal line above the gray area in the center of the box. Click on the visible line to remove it. Click just to the bottom of the gray area to add a line below the header. 5. Go to the Footer tab and repeat the process for the desired results. Doug - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OOo-1.9.82 Debian packages
* G. Roderick Singleton [EMAIL PROTECTED] [180405, 21:53]: On Mon, 2005-04-18 at 21:42 -0400, Richard wrote: On Monday 18 April 2005 01:14 pm, Ennio-Sr wrote: Hi all, I downloaded the deb pckgs from the site suggested a few posts ago (ftp://ftp.linux.cz/pub/localization/OpenOffice.org/devel/680/Beta) untar-zipped them and then ran dpkg -i *1.9.82*deb. Now: In the README file it is recommended to call the installation program of the newer version and choose 'Repair' when you remove the older installation. The point is that I can't see any 'install' or 'setup' file in those packages. How can I observe the recommendation? My personal opinion is that this is just a hold-over from the OOo1.1.x documentation. To the best of my knowledge, the latest OOo2 betas are in rpm and now in deb format and therefore the old install or setup file information is not germane, just hasn't been updated. Richard, Would be nice if you would review http://documentation.openoffice.org/setup_guide2/2.x/en/SETUP_GUIDE_draft.pdf Thanks for your attention. Regards, Ennio. Documentation Co-Lead http://documentation.openoffice.org/ Hi Ger, I had a look at the Setup_Guide after your post. Concerning the Debian install it says that ... If you already had an older version, dpkg will upgrade it rather then installing both versions at once. AAMOF, in my case, both versions were left on my PC (although I didn't try to run 1.9.79 after installing 1.9.82, the full directory was there.). May be the Guide is reflecting a future situation, when everything will have been settled down? I would think so, also because it refers to a single openoffice.deb (dpkg -i openoffice,deb), whereas, at present, at least 19 *.deb's spring out of the .deb.tar.gz package. Regards, Ennio. -- [Perche' usare Win$ozz (dico io) se ...anche uno sciocco sa farlo. \\?// Fa' qualche cosa di cui non sei capace! (diceva Henry Miller) ](°|°) [Why use Win$ozz (I say) if ... even a fool can do that. )=( Do something you aren't good at! (as Henry Miller used to say) ] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: [webmasters] black buttons
You wrote: Hi, I'm writing to you because I'm not sure who to send to. My system: Linux PC, kernel 2.6.11.2, Xorg recent CVS The problem: after installing one of the last cvs of Xorg the buttons of OOo 1.1.1 went (almost all the active) black, some completely black, but some with only the background black. Please note that this happens only in OOo, all others applications seem ok, and that the color depths showing this problem are 16, 24. I've tried OOo 2.0beta, now the buttons are ok, but the small button, up right, that close the window is completely black. Now, I admit that this isn't so important, but I'd like to know if I do not know some feature of Xorg or OOo, or if I have some old library lying around. Thanks This is probably something to do with the driver for your graphics card. You could also try OpenOffice.org 1.1.4. Please reply to users@openoffice.org only -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OOo 1.9.79, Cannot change text doluimn to numbers
On Wednesday 13 April 2005 03:40, Art Fore wrote: Have tried all versios up to the above version, have a file where a column is numbers preceded by ' , selecting Format, then number, will not change this to a number. his screws up someone using the file and wanting to change the column to numbers to do a sum, either in Scalc, or Excell. Any way to change format the column to numbers as advertized? HI Art, In the above email it seems that you are trying to convert a ' character to a number ? Or can you clarify ? -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Installation of OO 2.0beta in Solaris Sparc?
I downloaded both the 2.0beta and the most recent snapshot for Solaris Sparc. After unpacking the tar.gz file, there doesn't seem to be any install program. This is what I find when I untar the most recent snapshot: 2 -rw-r--r-- 1 poshea apg 798 Apr 11 20:58 LICENSE 4 -rw-r--r-- 1 poshea apg 1377 Apr 11 20:58 LICENSE.html 26 -rw-r--r-- 1 poshea apg12566 Apr 11 20:58 README 24 -rw-r--r-- 1 poshea apg11690 Apr 11 20:58 README.html 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:22 openofficeorg-calc/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:20 openofficeorg-core01/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:34 openofficeorg-core02/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:35 openofficeorg-core03/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:38 openofficeorg-core04/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:40 openofficeorg-core05/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:50 openofficeorg-core06/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:57 openofficeorg-core07/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:58 openofficeorg-core08/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:58 openofficeorg-desktop-integratn/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:22 openofficeorg-draw/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:18 openofficeorg-gnome-integration/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:26 openofficeorg-graphicfilter/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:24 openofficeorg-impress/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:27 openofficeorg-javafilter/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:25 openofficeorg-math/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:33 openofficeorg-pyuno/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:27 openofficeorg-spellcheck/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:26 openofficeorg-testtool/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:21 openofficeorg-writer/ 2 drwxr-xr-x 5 poshea apg 512 Apr 11 20:27 openofficeorg-xsltfilter/ So how do I install it? I'm currently using OO 1.1.3. -- Peter O'Shea, Product/Test Engineering Group Leader Analog Devices - Precision Converters / Digital Audio Group 820 Woburn St. MS 627, Wilmington, MA 01887 Phone: (781) 937-1206 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Screw up
After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this program, the word idiots come to my mind, but I will not use it, since it is not nice to do so. Anyway, I look forward to the day when I can use OpenOffice, that is; when it is international (proper English) and not American only. O. Henningson, Canada
[users] Missing Lines on spread sheet. protection is off.
When starting new spread sheet After inserting information and creating the lines I need ,they show up on print preview but do not show up on printed page. I have reinstalled program but still have same problem. any ideas . Norman Bates. E-Mail is [EMAIL PROTECTED]
Re: [users] [moderated]
Eh, Perhaps you don't quite understand that OOo is open software. The mailing lists are the principle ( and very effective ) way of providing support. Software and support are free. The developers who can all be contacted personally on mailing lists, are a bunch of volunteers. Anyone in the entire Internet can file a bug, though it may not be taken seriously. And lastly, if I said something wrong, or just plain dumb here, somebody will correct me. Like democracy, it ain't perfect but its better than Microsoft. PS if in fact there is no CA thesaurus ( theres regional capability for many languages ) then you could help write one, you don't need to be able to write code, just text. On Sun, 2005-04-17 at 17:55 -0600, Orjan Henningson wrote: Finally! An e-mail address where I can send my issue. I just downloaded the latest version and found that I cannot use it. The developers seem to believe that the English speaking population of the world is American only. I am Canadian and do not subscribe to the US version of the English language. The thesaurus is for Americans only. Too bad. OpenOffice is a very good idea and some day I hope to be able to use it. Orjan Henningson, Edmonton, Alberta, Canada John P. Fisher john fisher software santa barbara, california - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Aw: Re: [users] Saving problems openoffice 2.0
Ladies and gentlemen, I received your response, but I didn't find any message, except the one that I sent to you. Kind regards - HDBender - Original Nachricht Von: help hints for unsubscribed users [EMAIL PROTECTED] An: [EMAIL PROTECTED] Datum: 18.04.2005 15:38 Betreff: Re: [users] Saving problems openoffice 2.0 Heinz-Dieter Bender [EMAIL PROTECTED] writes: Ladies and gentlemen, unfortunately it is not possible to save documents that I created or that I opened from version 1.1 in the correct way. All documents that I opened will be saved as zip file, but can no more be opened out of konquerer. If I open 2.0 first, I can open also the documents again. I'm using Linux Mandrake 10.0 as OS. What must be done to open the documents also from konquerer? Mit freundlichen Grüßen - HDBender - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] [moderated]
I downloaded Perfect Pro Office by Cosmi and am now advised I have to download openoffice.org/1.1.4/index, so am doing this.I am trying to break up 30,000 line files into 10,000 line files so if I have 1 file now, I will have 3 files when done etc. Stan
[users] [moderated]
where is the dictionary for the spelling corrector in German, please? Elke
[users] MORE INFO?
HI, I AM WONDERING IF ANYONE CAN HELP SUPPLY A MANUAL FOR OPEN OFFICE I AM NEW AT THE PROGRAMME AND KEEP GETTING LOST WHEN TRYING TO COMPLETE SIMPLE TASKS? THANKS DALLAS [EMAIL PROTECTED]
RE: [users] [moderated]
Thank you for your mail I am sorry. I found the Open Office Org. site, the download corner and there the dictionaries (including the said dictinstaller where the downloaded files are ONLY three gif images!), but I don't know any wizard. I also don't know what to do with your hint: OOo/share/dict/ooo. Is that a directory, or an URL? How do you get there? Entering that into the browser only leads to a dnserror. A search for that particlar character string brought me to a site offering German dictionaries, but there too are many strings, commands or whatever that is, that I do not understand at all. Like: Name : openoffice-dicts-German Version : 2004.01.02 Vendor : Ark Open Source Release : 1ark Requires : /usr/lib/openoffice/program/update-dictionary.lst rpmlib(PayloadIsBzip2) = 3.0.5-1 rpmlib(CompressedFileNames) = 3.0.4-1 /bin/sh rpmlib(PayloadFilesHavePrefix) = 4.0-1 openoffice Does that mean, you HAVE TO BE a computer crack with a lexical knowledge of computer terms/commands otherwise unintelligible to ordinary people in order to install a few dictionaries? If that is the case I simply have to forsake any hope of finding alternatives to Microsoft. My sincere apologies for being so uneducated and asking such foolish questions. Thomas Blasejewicz -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 19, 2005 5:06 AM To: users@openoffice.org; [EMAIL PROTECTED] Subject: Re: [users] [moderated] I'm assuming that you are using file wizards install new dictionaries ... The folder that the dictionaries are installed into is something like OOo/share/dict/ooo as opposed to 'dictinstaller' you mention. Have a check on this directory and advise the list. Paul On 4/16/05, Thomas Blasejewicz [EMAIL PROTECTED] wrote: Ladies and Gentlemen The other day I learned about Open Office through a mailing list. Since I do not like (hate) Microsoft Office, yet have to use it for my job, I would really like to try Open Office. Downloaded several files already and installed (as a test) Version 2 (beta version). Also downloaded several dictionary files. Yet, the folder dictinstaller contains only 3 gif images, but no exe file. the link found on the website: http://www.ooodocs.org/dictinstall/ does not lead anywhere (dnserror) Question: How/where do I get the dictionary installer? Do I need that for Version 2 (it says it works only for Version 1) If not, how do I install the dictionaries? Without dictionaries the Writer would be close to useless. Thank you in advance for your assistance. Thomas Blasejewicz - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Odd behaviour with incorrectly set clock
This is probably more a curiosity than anything, but it might ring a bell with someone. I was running OO 1.1.3 on Debian PPC (iBook), and it so happened that the system clock was way off (giving a date of Jan 1904) probably as a result of PRAM corruption during an OSX upgrade plus failing to get a network connection. While this state presisted, OO failed to refresh the screen properly and was effectively unusable. On correcting the clock normal service was resumed. James -- ++---+-+ | James Tappin | School of Physics Astronomy | O__| | [EMAIL PROTECTED] | University of Birmingham | -- \/` | | Ph: 0121-414-6462. Fax: 0121-414-3722 | | ++-+ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Screw up
On Monday, 18 April 2005 16:18, Orjan Henningson wrote: After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this program, the word idiots come to my mind, but I will not use it, since it is not nice to do so. Anyway, I look forward to the day when I can use OpenOffice, that is; when it is international (proper English) and not American only. O. Henningson, Canada Orjan, Please refrain from such comments on a public list. It is uncalled for. OOo is not American Only, there are internationalized dictionaries for many of the world's languages and dialects. Almost all of them have been written by unpaid volunteers so that you may one day have a completely open and free tool for writing documents. Isn't this the second time recently that you have posted to this list in that tone? Alan -- Alan McKinnon [EMAIL PROTECTED] +27 82 337 1935 (C) +27 86 110 2411 (W) +27 12 349 9277 (F) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] html to pdf
On Mon, 2005-04-18 at 19:37 -0600, Jones'y wrote: I'm trying to export an HTML document to PDF format and have the links still work. I've searched OO.org for answers and found none so far. Win98SE OO 1.1.4 Acrobat 6 (most current for Win98SE) I've created an OO HTML document (currently about 28 pages) with links that simply move the user up and down within the document. Tried export using the PDF button as well as File/Export. Tried selecting All Pages as well as specifying complete Range. Also tried Print as well as Press Optimizations. (PDF file attached.) The result on opening exported PDF is one blank page, though the file size seems right. This result on opening is true also for a WinXPpro machine with Acrobat 7. However, with Acrobat 6 I can open Document Properties and select one specific settings page (I think its titled Sharing, but that doesn't sound right, and my Win98 Acrobat 6 machine is at work) and I will suddenly see the document, but I can't scroll up to the 1st page, and the links no longer work. Any help would be appreciated. With 1.1.4 pdf export is plain unless you use the extendedPDF macro. Look for ooomacros.org on http://documentation.openoffice.org/thirdparty.html This macro will do what you want. If you are adventurous, 2.0beta has this feature built-in but I would not recommend using it in production. -- PLEASE KEEP MESSAGES ON THE LIST. Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Screw up
On Monday 18 April 2005 09:18 am, Orjan Henningson wrote: After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this program, the word idiots come to my mind, but I will not use it, since it is not nice to do so. Anyway, I look forward to the day when I can use OpenOffice, that is; when it is international (proper English) and not American only. O. Henningson, Canada The answer to your problem is found on page 27 of the User's Guide. It comes as part of the download as SETUP_GUIDE.pdf. Do a search on your hard drive(s) for this file. The section you want on page 27 is Assigning File Types. I have to admit that this is the first time someone mentioned OpenOffice.org changing the icons for WP files. Did you perhaps save some of them using MS Office formats? (*.doc, *.ppt, *.xls, etc.) Perhaps you are having more problems than you anticipated because you have not taken the time to learn how it works. While the emphasis in the English version may seem to be based on American whims, it is used in many different English speaking countries around the world. It is used by people in many different languages in their own languages. This includes character languages such as Chinese and Japanese. I understand how frustrating learning a new program can be. That does not always mean that the program is at fault. I have worked with one for several days before I discovered I had made a very serious error. Once I corrected my error, the program ran as advertized. But I was very unhappy until I found my error. Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Screw up
Dnia poniedziaek, 18 kwietnia 2005 16:18, Orjan Henningson napisa: After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this program, the word idiots come to my mind, but I will not use it, since it is not nice to do so. Anyway, I look forward to the day when I can use OpenOffice, that is; when it is international (proper English) and not American only. O. Henningson, Canada May be You have to read same info about a program before use it. OOO has a GB english dictionary and if I properly remember canadian english dictionary. It is so easy. Go to openoffice.org web page. Put word dictionary in search machine (on left side of the page) and you have all data you need. But it look like that you are lazy, or greenhorn or may be even Ms Window user. So go at once for http://lingucomponent.openoffice.org/download_dictionary.html rest is up to you. -- z.a.kaleta (sanskryt), registered Linux User #279350 -- z.a.kaleta (sanskryt), registered Linux User #279350 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Screw up
On Mon, 2005-04-18 at 08:18 -0600, Orjan Henningson wrote: After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. Really? Then you deleted the original files as OOo only imports WP files and does not export them. If you did not delete the originals then they are still on your system somewhere. Did you select that OOo would be the default application for handling your documents? If yes, then this was a choice that you made during installation by selecting the options. See http://documentation.openoffice.org/faqs/various_topics/index.html #016 for direction on how to reverse the actions you took. When I think of the ones developing this program, the word idiots come to my mind, but I will not use it, since it is not nice to do so. Anyway, I look forward to the day when I can use OpenOffice, that is; when it is international (proper English) and not American only. Well File AutoPilot Install new dictionaries certainly offers Canadian tools. I use them in creating documents for OOo; so I do not quite understand where you are coming from. If what is offered is deficient, please take the time to enter an Request for Enhancement (RFE) into Issue Tracker as this is the best way to have requests such as this evaluated or even better join the lingucomponent project ( http://lingucomponent.openoffice.org/ ) and contribute your improved version. If you haven't already registered, do the following: 1. To file an issue you must register with OOo by clicking the Register link at the top right of www.openoffice.org, 2. Fill in your information 3. Reply to the confirmation email that will be sent to the address you provided. 4. Once you have confirmed, go to www.openoffice.org again 5. And click on the Bugs Issues link in the General links box. Thanks for bringing this to our attention. It is important that you file any examples with the issue to ensure your need is understood. -- PLEASE KEEP MESSAGES ON THE LIST. Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Aw: Re: [users] Saving problems openoffice 2.0
On Monday 18 April 2005 01:51 pm, [EMAIL PROTECTED] wrote: Ladies and gentlemen, I received your response, but I didn't find any message, except the one that I sent to you. Kind regards - HDBender - Original Nachricht Von: help hints for unsubscribed users [EMAIL PROTECTED] An: [EMAIL PROTECTED] Datum: 18.04.2005 15:38 Betreff: Re: [users] Saving problems openoffice 2.0 Heinz-Dieter Bender [EMAIL PROTECTED] writes: Ladies and gentlemen, unfortunately it is not possible to save documents that I created or that I opened from version 1.1 in the correct way. All documents that I opened will be saved as zip file, but can no more be opened out of konquerer. If I open 2.0 first, I can open also the documents again. I'm using Linux Mandrake 10.0 as OS. What must be done to open the documents also from konquerer? Mit freundlichen Grüßen - HDBender Right click on the file. Select Open with from the context menu. This opens a window with the name of the file on the top. In this window, you should see the phrase Open with: and below it a box in which to enter the file path. To the right of this box is a blue folder icon. Placing your mouse over this icon should identify it as Open file dialog. Click on this icon, and browse to where the soffice file is located. (Probably in /opt/openoffice1.9.X/programs. I used an X because I do not know which beta version of 2.0 you have.) At the bottom of that window is a check box with the phrase: Remember application association with this type of file. Make sure that it is checked, and then click OK. Bitte shoen. (My German is not good enough to write these directions in German.) Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated]
On Monday 18 April 2005 01:53 pm, [EMAIL PROTECTED] wrote: I downloaded Perfect Pro Office by Cosmi and am now advised I have to download openoffice.org/1.1.4/index, so am doing this.I am trying to break up 30,000 line files into 10,000 line files so if I have 1 file now, I will have 3 files when done etc. Stan We need more information. Is this file a text document or a spreadsheet? Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Problem with auto recovery screen in 2.0 beta
Dan Lewis wrote: I have similar problems with Win 98SE on a laptop. I have no such problems with the 1.1.79 or 1.1.90.1 on Windows 98SE, so I would suggerst it is not a Win98 problem Brian - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: [moderated]
Thomas Blasejewicz wrote: Thank you for your mail I am sorry. I found the Open Office Org. site, the download corner and there the dictionaries (including the said dictinstaller where the downloaded files are ONLY three gif images!), but I don't know any wizard. I also don't know what to do with your hint: OOo/share/dict/ooo. Is that a directory, or an URL? How do you get there? Entering that into the browser only leads to a dnserror. A search for that particlar character string brought me to a site offering German dictionaries, but there too are many strings, commands or whatever that is, that I do not understand at all. Like: Name : openoffice-dicts-German Version : 2004.01.02 Vendor : Ark Open Source Release : 1ark Requires : /usr/lib/openoffice/program/update-dictionary.lst rpmlib(PayloadIsBzip2) = 3.0.5-1 rpmlib(CompressedFileNames) = 3.0.4-1 /bin/sh rpmlib(PayloadFilesHavePrefix) = 4.0-1 openoffice Does that mean, you HAVE TO BE a computer crack with a lexical knowledge of computer terms/commands otherwise unintelligible to ordinary people in order to install a few dictionaries? If that is the case I simply have to forsake any hope of finding alternatives to Microsoft. My sincere apologies for being so uneducated and asking such foolish questions. Thomas Blasejewicz Hi Thomas I'll try and be helpful. Do you have version 1.9.79? The File-Wizards-Install new Dictionaries is broken in that version. This is fixed in 1.9.93 - the current snapshot version. In 1.9.79 you can go to OpenOffice_installation_directory/share/dict/ooo/ directory and should find DicOOo.sxw which is an OpenOffice file with macros to connect to the net and find dictionaries. If you open this with OOo (OpenOffice.org) it should lead you through what you need. May I suggest that you subscribe to [EMAIL PROTECTED] so you will see any and all replies. Like many new things, a little perseverance pays off. Russell - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: [moderated]
[EMAIL PROTECTED] wrote: where is the dictionary for the spelling corrector in German, please? Elke Hi Elke Which version of OOo do you have? Look here: http://user-faq.openoffice.org/faq/ar01s05.html#id2874386 In version 1.1.4 File-Autopilot-Install Dictionary should work, if you are online. In the Beta versions it is File-wizards- HTH Russell CC to OP - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Screw up
Orjan Henningson wrote: After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this program, the word idiots come to my mind, but I will not use it, since it is not nice to do so. Anyway, I look forward to the day when I can use OpenOffice, that is; when it is international (proper English) and not American only. O. Henningson, Canada Did you see: http://user-faq.openoffice.org/faq/ar01s04.html#FILE-ASSOCIATIONS Russell - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: MORE INFO?
DALLAS COPPERTHWAITE wrote: HI, I AM WONDERING IF ANYONE CAN HELP SUPPLY A MANUAL FOR OPEN OFFICE I AM NEW AT THE PROGRAMME AND KEEP GETTING LOST WHEN TRYING TO COMPLETE SIMPLE TASKS? THANKS DALLAS [EMAIL PROTECTED] Hi Dallas See http://support.openoffice.org/index.html There is lots of information there. Russell cc to OP - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated]
It took me a month or so of thinking before I dumped MS- Office -- I started out using NeoOffice, on a few projects, and then made it my default program for opening MS office docs. I have not hit any snags yet -- and yes I copy and paste spreadsheets into Word processing docs. If you already own MS office there is no reason to tie yourself to on application or the other -- keep you options open -- and your wallet in your pocket next time Bill thinks you need an upgrade. Andy Spitfire Computer Services 441 Beaver Street Suite 202 Sewickley, PA 15143 Phone (412) 749-0162 Fax: (412) 749-0203 [EMAIL PROTECTED] www.spitcomp.com On Apr 18, 2005, at 11:06 AM, Charles Boehm wrote: Do appreciate and thank you all for the prompt and informative responses. Have not decided to download the NeoOffice/J yet because I already have the Claris and Excel programs and frankly speaking the Excel does a pretty good job. One can copy and paste directly into a Word document and it is perfectly formatted. Attempting to paste the same document into Claris or Nisus word processors; not so good. So I'm unclear why I need an open source program. Still looking into it all. I'd like to move away from the Gates stuff; but... Again, Thanks! Charles - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Problem with auto recovery screen in 2.0 beta
On Tuesday 19 April 2005 09:40 am, Brian wrote: Dan Lewis wrote: I have similar problems with Win 98SE on a laptop. I have no such problems with the 1.1.79 or 1.1.90.1 on Windows 98SE, so I would suggerst it is not a Win98 problem Brian Would you please quote more of my email? This statement was taken out of context. It is the screen resolution that can cause problems. Older laptops in particular (as mine, a 1998 version) have this problem. I use Win 98SE on that laptop. The main reason for stating what OS I was using was to emphasize how this problem can be solved using that OS: using Alt+mouse drag. Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OOo 1.9.79, Cannot change text doluimn to numbers
* CPHennessy [EMAIL PROTECTED] [180405, 22:30]: On Wednesday 13 April 2005 03:40, Art Fore wrote: Have tried all versios up to the above version, have a file where a column is numbers preceded by ' , selecting Format, then number, will not change this to a number. his screws up someone using the file and wanting to change the column to numbers to do a sum, either in Scalc, or Excell. Any way to change format the column to numbers as advertized? HI Art, In the above email it seems that you are trying to convert a ' character to a number ? Or can you clarify ? -- CPH : openoffice.org contributor Hi CPH and Art, [I deleted Art's original post so I'm following up this one] may be the OP has a column with figures preceded by a ' character that he cannot use as numbers. If this is the case, Art, what you can do is: . Digit: =value(A1) in the first cell of a free column (say X) of your spreadsheet (A to be replaced by the actual letter of the column containing the 'string-numbers') . You'll get the number corresponding to the 'string-number' . point your mouse at the bottom right corner of cell X1 and drag it down until the end of your data in col A: the value of cell X1 is thus copied to all other cells. . Now your col X will contain all 'numbers' you can do calculations on. HTH and there is a shorter way :-) [*] Regards, Ennio. [*] BTW, I thougth it would be possible to search for that particular char: tried with \', \x0027 (as indicated in Help/List of Regular Expressions), \0x0027, to no avail ;( -- [Perche' usare Win$ozz (dico io) se ...anche uno sciocco sa farlo. \\?// Fa' qualche cosa di cui non sei capace! (diceva Henry Miller) ](°|°) [Why use Win$ozz (I say) if ... even a fool can do that. )=( Do something you aren't good at! (as Henry Miller used to say) ] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] duplicating sheet area
Hi Rich, On Tue, Apr 19, 2005 at 13:18:53 +0300, Rich wrote: is there a way to duplicate some area in a spreadsheet so that everything is preserved (including row height) ? Mark the entire row before copying to the clipboard, not just part (some cells) of it. Shift-Space or using the mouse on the row headers will do so. Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] saving chart in calc as an image or encaps. ps file
Hi, I would like to be able to save the chart in my spreadsheet as an image file or even better an encapsulated ps file, as is. also, how to print only the chart to a a printer? when i select the chart and say print, it prints the whole spreadheet.. i am using 002.0 beta (and it actually crashes very often in my linux laptop, but that is another story.) thank you very much for any input! Best Regards, Muge - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Problem with v.1.9.93 Base
Yes, you'r right it is F4 and not F5, my mistake, sorry. on 19.04.2005 12:36 Dan Lewis said the following: On Tuesday 19 April 2005 03:48 am, Andrew Cassels wrote: Hello, I have a problem, I want to open a .odb database, it opens but when I click with the Tables button, there is a error message saying: /The connection to the data source accounts could not be established. / /Error in the script file line: 1 File input/output errorerror / /java.io.IOException opening file - file C:\Documents and / /Settings\Andrew Cassels\Bureau\accounts.data in statement / /[CREATE CACHED TABLE Expenses]/ If I click on more and error buttons I get the following: // /SQL Status: S1000 / /Error code: -29 / /File input/output error C:\Documents and Settings\Andrew Cassels\Bureau\accounts.properties java.io.IOException: No OutputStream/ Thus error never happened with previous versions. I also cannot see the document if I do F5 in a writer or spreadsheet document. Thank you very much for your help I get similar errors with the database section of 1.9.93. Some times I can make a connection to a specific database, and other times I can not. The database section still needs some work, but it is getting better. I am a little confused with your reference to F5. F4 is used to open the Data Sources window. F5 is used to open the Navigator. Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Takes time
HI, I am user of open office. Somethig that I find irritating about this is , it takes a long time to open. For me it takes around 30 sec to 60 sec to open the open office. I am having fedora core 3. 1.9 is slower than 1.1 version. Please let me know if something can be done about this. Regards Renjoy - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] [moderated] Updates and securitiy patches
I want to forward two questions our admins asked me recently, in : a) Is there a strategy or a roadmap for updates and security patches for the future and how often will this occure? b) The security patch of last friday can only be applied to the last version of OpenOffice.org (1.1.4). Is this a general policy of the OpenOffice Team, that only the latest version will be patched? This is important to be able to do a real planning of the work. We have to admin about 6000 PCs and we recently started deploying OpenOffice.org 1.1.2, then last Friday the news of this security gap came in. So we stopped the rollout and are now creating a new package with the patched version of 1.1.4. Kind Regards Pfeifer Erwin _ Autonome Provinz Bozen - Südtirol Provincia Autonoma di Bolzano - Alto Adige Amt für Büroinformatik (9.1) Ufficio informatica individuale Erwin Pfeifer Via Crispi-Str. 15, I-39100 Bozen/Bolzano Tel. (+39)0471414910, Fax 0471414929 eMail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] z.bz.it _
Re: [users] Screw up
Dnia poniedziaek, 18 kwietnia 2005 16:18, Orjan Henningson napisa: After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this program, the word idiots come to my mind, but I will not use it, since it is not nice to do so. Anyway, I look forward to the day when I can use OpenOffice, that is; when it is international (proper English) and not American only. O. Henningson, Canada May be You have to read same info about a program before use it. OOO has a GB english dictionary and if I properly remember canadian english dictionary. It is so easy. Go to openoffice.org web page. Put word dictionary in search machine (on left side of the page) and you have all data you need. But it look like that you are lazy, or greenhorn or may be even Ms Window user. So go at once for http://lingucomponent.openoffice.org/download_dictionary.html rest is up to you. -- z.a.kaleta (sanskryt), registered Linux User #279350 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] TL645MI.DLL installation error
I've installed OpenOffice 1.1.4 in a PC running with WinXP and had no problems at all. When I tried to install the same installation files in a PC with Win Me (Millennium Edition) I've got the TL645MI.DLL error and the suggestion to restart my computer (with no better results... of course). I think it shouldn't be a corrupted download because it worked out the first time in the other computer. How can I fix this problem? I've read that other people had the same trouble.. Thanks Raúl - Do You Yahoo!? Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo. Visíta Yahoo! Noticias.
[users] More than four recent files list
Hi, Is there a way to show more than four items in the recent files list in the File menu of each OOo application? Four items are simply too few, especially if they are shared in all OOo applications. OS: WinXP OOo version: 1.1.4 Thanks! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated]
On Saturday 16 April 2005 06:16 am, Thomas Blasejewicz wrote: Ladies and Gentlemen The other day I learned about Open Office through a mailing list. Since I do not like (hate) Microsoft Office, yet have to use it for my job, I would really like to try Open Office. Reccomend with all my heart that you download OOo114 and wait for the announcement that OOo2 stable is released. How can I safoy this, so that you don't think I'm disparaging OpenOffice.org version 2? OOo2 doesn't exist yet. It is a beta. Currently all beta2s are not ready for daily use. However, if you wish to persist, then realize that part of the cost of running beta software is to report problems to the issuezilla and not to write asking how to do something in OOo2. It is getting better but there are still demons in it. OOo2 is not a release. It is beta. It may eat your dog. Downloaded several files already and installed (as a test) Version 2 (beta version). Also downloaded several dictionary files. Yet, the folder dictinstaller contains only 3 gif images, but no exe file. the link found on the website: http://www.ooodocs.org/dictinstall/ does not lead anywhere (dnserror) Question: How/where do I get the dictionary installer?ç It is incorporated into OOo114 in the menu: File--AutoPilot--InstallNewDictionaries You can use it at least 2 ways, off-line if you have previously downloaded the DictPack for the languages you need, from here: http://lingucomponent.openoffice.org/download_dictionary.html ; or while on-line, it will find them and install the dictionaries you choose. On-line is probably the simplest and least error prone. There is a bug with some of the OOo2betas, so this menu entry doesn't always work. You can still activate the macro manually but then you need to go looking in the directories where you installed OOo. Do I need that for Version 2 (it says it works only for Version 1) If not, how do I install the dictionaries? Without dictionaries the Writer would be close to useless. Well, just not as useful as it could be. regards, Richard. Thank you in advance for your assistance. Thomas Blasejewicz - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] More than four recent files list
Álvaro Vallejo wrote: Hi, Is there a way to show more than four items in the recent files list in the File menu of each OOo application? Four items are simply too few, especially if they are shared in all OOo applications. OS: WinXP OOo version: 1.1.4 Thanks! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] . This may help. http://sourceforge.net/project/showfiles.php?group_id=87718package_id=100070 dave -- David C. Johanson Linux Counter # 116410 Powered by SuSE Linux 7.3 People who behold a phenomenon will often extend their thinking beyond it; people who merely hear about the phenomenon will not be moved to think at all. -- Goethe - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Howdo I configure Palm pdb support for RHEL4 version of Openoffice
On Fri, 15 Apr 2005 16:35:47 +0100, you wrote: I have RHEL 4.0 installed on my PC but the installed version of Openoffice does not read/write Palm .pdb files. Is there a way that I can reconfigure the installation to be able to read/write the .pdb files or will I have to download the latest version and re-install over the top selecting Palm .pdb support? The AportisDoc/Palm .pdb filter is optional. You forgot to say which version of OpenOffice you have. The OO 1.1.0 Setup Guide explains how to run the setup program again, choose Modify and select the filter. This answer was provided by anonymous in http://www.mobiletechreview.com/ubbthreads/showflat.php?Cat=Board=UBB21Number=10266page=0view=collapsedsb=5o=fpart=1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Takes time
On Tue, 2005-04-19 at 16:17 +0530, Renjoy Henry wrote: HI, I am user of open office. Somethig that I find irritating about this is , it takes a long time to open. For me it takes around 30 sec to 60 sec to open the open office. I am having fedora core 3. 1.9 is slower than 1.1 version. I have the same setup you do and opening an 5Mb doc in OOo1.1.4 does take time (about 45 seconds) and 1.1.4 to an empty text document takes about 15 secs under Gnome with no quickstarter. If you are a KDE user then use the quickstarter so you only have the long wait once. As for 1.9, get about the same performance with m94 as with 1.1.4. That said, I would recommend that you check your machine very carefully especially memory and disks. Please let me know if something can be done about this. Regards Renjoy - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- PLEASE KEEP MESSAGES ON THE LIST. Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] TL645MI.DLL installation error
I searched the forums and www and found 2-3 reported incidents of this error (in english anyway) however none discussed a solution. Do you have that .dll on your system? Could it be that it is missing on the winME install? Agree with you on the corrupted download. Don't think this has been much of a help. Sorry... Paul On 4/20/05, Raúl Campiglia [EMAIL PROTECTED] wrote: I've installed OpenOffice 1.1.4 in a PC running with WinXP and had no problems at all. When I tried to install the same installation files in a PC with Win Me (Millennium Edition) I've got the TL645MI.DLL error and the suggestion to restart my computer (with no better results... of course). I think it shouldn't be a corrupted download because it worked out the first time in the other computer. How can I fix this problem? I've read that other people had the same trouble.. Thanks Raúl - Do You Yahoo!? Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo. Visíta Yahoo! Noticias. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Screw up
I am not sure what you are complaining about. The mistake in allowing OOo to change your WP files or not choosing the English that you want in the language selection Chris from SE BC (that is in Canada also) ( oh by the way Canada has a land mass greater than continental US) After I had downloaded OpenOffice, I noted that some of my WordPerfect files had been converted to OpenOffice files with no options to convert it back to WP without changing the format. When I think of the ones developing this program, the word idiots come to my mind, but I will not use it, since it is not nice to do so. Anyway, I look forward to the day when I can use OpenOffice, that is; when it is international (proper English) and not American only. O. Henningson, Canada - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Screw up
Andy: Most of us'n Canuck spell it eh. Chris This is kind of strange -- cause I can pick from 12 different version of English (including one for Canada --ay) , and flip between UK and US versions regularly, and I have never seen open office convert a file without popping up a dialog box warning me that I am going to overwrite an existing file or loose some formatting or something. I am also not sure that I would save Open Office and Word perfect files with the same extension, I would think that would get confusing. Andy Spitfire Computer Services 441 Beaver Street Suite 202 Sewickley, PA 15143 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] working with templates
I saw these instructions for making a new template. I'm not familiar with when/how you do that rather than just opening OpenOffice. 1.1.4. One thing I don't like about OOo is the breaks between pages where some of the text I paste from websites end up not being there, but, apparently, 'hiding' in the black 'trench' between pages. Only way I can see any or part of what's there is to make the font really tiny and then it all may get on the page I pasted onto. Will making a template allow me to get rid of that feature? I do believe that some of my documents don't lose part of the text pasted, but others do. Following the instructions below, If I tried experimenting with different styles or view of the OOo 1.1.4 doc, and save it, will that affect all the other docs I have created or will create in the future, or does it just apply locally to the document I'm working in? 1.Open a new, empty document 2. Edit it until it makes a good template. For example, edit the Styles in the Stylist. Thank you, Joan
Re: [users] working with templates
JoanArc wrote: I saw these instructions for making a new template. I'm not familiar with when/how you do that rather than just opening OpenOffice. 1.1.4. One thing I don't like about OOo is the breaks between pages where some of the text I paste from websites end up not being there, but, apparently, 'hiding' in the black 'trench' between pages. Only way I can see any or part of what's there is to make the font really tiny and then it all may get on the page I pasted onto. Will making a template allow me to get rid of that feature? I do believe that some of my documents don't lose part of the text pasted, but others do. Following the instructions below, If I tried experimenting with different styles or view of the OOo 1.1.4 doc, and save it, will that affect all the other docs I have created or will create in the future, or does it just apply locally to the document I'm working in? 1.Open a new, empty document 2. Edit it until it makes a good template. For example, edit the Styles in the Stylist. Thank you, Joan In these cases, you might want to try paste without formatting. This will probably help. The idea behind a template, is that you define a series of styles that you want to use in all of your documents. You can then create a new document using your template. Your newly created document will have all of the styles and text of your original template. If you later change the styles in a template, the next time you open a document created with the template, you can apply the new styles to the existing document. Pretty cool! -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm Free Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] working with templates
JoanArc wrote: I saw these instructions for making a new template. I'm not familiar with when/how you do that rather than just opening OpenOffice. 1.1.4. One thing I don't like about OOo is the breaks between pages where some of the text I paste from websites end up not being there, but, apparently, 'hiding' in the black 'trench' between pages. Only way I can see any or part of what's there is to make the font really tiny and then it all may get on the page I pasted onto. Will making a template allow me to get rid of that feature? I do believe that some of my documents don't lose part of the text pasted, but others do. snip I am truly sorry to learn that you have been so completely subsumed by The Beast. Why else could you refer to an unwanted behavior as a feature? I hope your recovery is rapid and complete. Doug - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]