[users] location of style info in content.xml
All, I've got an application that inserts tables into an existing odt file (oo 2.0) via the content.xml file. The spec document (OpenDocument-v1.0-os.sxw) in section 8.2.1 on page 188 shows a code scheme that has a table style declaration and then the table code. I'd like to be able to define styles outside of styles.xml or office:automatic-styles. It would be great if I could define the style right before the table definition (as in the example). However, I can't get it to work. Am I reading the spec to literally? Can styles be defined right before the table? Below is the content.xml file that I've been unsuccessfully testing with. Any suggestions? Thanks in advance, Max -- snip here -- ?xml version=1.0 encoding=UTF-8? office:document-content xmlns:office=urn:oasis:names:tc:opendocument:xmlns:office:1.0 xmlns:style=urn:oasis:names:tc:opendocument:xmlns:style:1.0 xmlns:text=urn:oasis:names:tc:opendocument:xmlns:text:1.0 xmlns:table=urn:oasis:names:tc:opendocument:xmlns:table:1.0 xmlns:draw=urn:oasis:names:tc:opendocument:xmlns:drawing:1.0 xmlns:fo=urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0 xmlns:xlink=http://www.w3.org/1999/xlink;; xmlns:dc=http://purl.org/dc/elements/1.1/;; xmlns:meta=urn:oasis:names:tc:opendocument:xmlns:meta:1.0 xmlns:number=urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0 xmlns:svg=urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0 xmlns:chart=urn:oasis:names:tc:opendocument:xmlns:chart:1.0 xmlns:dr3d=urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0 xmlns:math=http://www.w3.org/1998/Math/MathML;; xmlns:form=urn:oasis:names:tc:opendocument:xmlns:form:1.0 xmlns:script=urn:oasis:names:tc:opendocument:xmlns:script:1.0 xmlns:ooo=http://openoffice.org/2004/office;; xmlns:ooow=http://openoffice.org/2004/writer;; xmlns:oooc=http://openoffice.org/2004/calc;; xmlns:dom=http://www.w3.org/2001/xml-events;; xmlns:xforms=http://www.w3.org/2002/xforms;; xmlns:xsd=http://www.w3.org/2001/XMLSchema;; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;; office:version=1.0 office:scripts/ office:font-face-decls style:font-face style:name=Tahoma1 svg:font-family=Tahoma/ style:font-face style:name=Arial Unicode MS svg:font-family=apos;Arial Unicode MSapos; style:font-pitch=variable/ style:font-face style:name=Tahoma svg:font-family=Tahoma style:font-pitch=variable/ style:font-face style:name=Times New Roman svg:font-family=apos;Times New Romanapos; style:font-family-generic=roman style:font-pitch=variable/ /office:font-face-decls office:automatic-styles style:style style:name=BasicTable2 style:family=table style:table-properties style:width=6.925in table:align=margins/ /style:style style:style style:name=BasicTable2.A style:family=table-column style:table-column-properties style:column-width=3.4625in style:rel-column-width=32767*/ /style:style style:style style:name=BasicTable2.B style:family=table-column style:table-column-properties style:column-width=3.4625in style:rel-column-width=32768*/ /style:style style:style style:name=T1 style:family=text style:text-properties fo:color=#ff/ /style:style /office:automatic-styles office:body office:text text:sequence-decls text:sequence-decl text:display-outline-level=0 text:name=Illustration/ text:sequence-decl text:display-outline-level=0 text:name=Table/ text:sequence-decl text:display-outline-level=0 text:name=Text/ text:sequence-decl text:display-outline-level=0 text:name=Drawing/ /text:sequence-decls text:p text:style-name=Standard/ style:style style:name=BasicTable style:family=table style:table-properties style:width=4in table:align=margins/ /style:style style:style style:name=BasicTable.A style:family=table-column style:table-column-properties style:column-width=2in / /style:style style:style style:name=BasicTable.B style:family=table-column style:table-column-properties style:column-width=2in / /style:style style:style style:name=T1 style:family=text style:text-properties fo:color=#ff/ /style:style table:table table:name=BasicTable table:style-name=Table1 table:table-column table:style-name=BasicTable.A/ table:table-column table:style-name=BasicTable.B/ table:table-row table:table-cell office:value-type=string text:p text:style-name=Standard0.2 /text:p /table:table-cell table:table-cell office:value-type=string text:p text:style-name=Standardsetosa /text:p /table:table-cell /table:table-row table:table-row table:table-cell office:value-type=string text:p text:style-name=Standard0.2 /text:p /table:table-cell table:table-cell office:value-type=string text:p text:style-name=Standardsetosa /text:p /table:table-cell /table:table-row table:table-row table:table-cell office:value-type=string text:p text:style-name=Standard0.2 /text:p /table:table-cell table:table-cell office:value-type=string
[users] Unsubscribe problem
Hi, I do need no longer help on OO and the number of messages is quit important I would like to unsubscribe. Doing like is said on sending an empty email seems not to work. I did receive the reply in order to confirm my unsubscription, but it seems not to work and I receive failiure messages. How do I do ? Thanks. Jan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Cursor not saved to last position
Hi all, Sorry, I should have mentioned I'm using 2.0.1, and yes, I have all my user information filled in. It's very strange. ... Up to yesterday, whenever I called up a file it came up with the cursor at the last position it had been at. Since this morning, the cursor is at the very top of each document, whether old or new, when I call up the document. Which version are you using? 2.0 or 1.1.5? Have you entered your user-informations in the OOo-dialogue? Your name is necessary in OOo 2.0.x. Additionally, you'll have to select Recovery | Edit-view (or something similar - since I'm using only the German version) under Tools - Options. Hope this helps you. I don't know with which version the behaviour changed. OpenOffice used to always store the cursor position when the douments view was closed and restored the view to that position when it was opened. I also liked this a lot because it was an easy way to have a 'bookmark' of the position where to continue with reading. Unfortunately at some point it was decided that this is not what the average user would want because reading should start from the first page. So now the the documents always gets opened with the view on the first page. That is unless you are the author! In that case the last position is used because it was assumed the author usually want's to continue writing the document. That's why it should be essential if the your user info matches the one stored with the document. Unfortunately there also was no option introduced to allow the user to customize this behaviour. The only thing done was to introduce a keyboard shortcut (I think it was sth like Shift-F5) to return the cursor to the last editing position which should be pretty much what you and I wanted to have by default. I personally still would prefer the old solution though. :-/ Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Update OpenOffice.org from 2.0 to 2.0.2 RC1
Joe Conner wrote: [cut] After further investigation, part of what I reported earlier was inaccurate. My appologies for getting this wrong earlier. I had selected CUSTOM and modified the suggested install directory to previous tree minus previous OOo2.0.1 install directory\OOo202. It did install there after all but it totally uninstalled my production OOo prior to installing the release candidate. Still nasty, but not as bad as I had previously reported. I am going to uninstall rc1, reinstall 2.0.1 using the default directory, and reinstall rcq. I will report if the rc1 still uninstalls 2.0.1 before installing itself. Don't bother; it does! I'll try rc2 later today. By the way I am running WinXP Pro with 512MB ram and AMD XP1900 cpu. Joe Similar - WinXP Pro + SP2 Peter HB - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc formula question.?
On Mon, 2006-02-20 at 15:01, Joe Conner wrote: If this is for recording blood glucose readings, I have a spreadsheet that is designed to do this. If you want me to send it to you directly let me know. Joe Conner, Poulsbo, WA 98370 USA James Elliott wrote: I have a Calc spreadsheet (OOo 2.0; Win XP) which has a column of dates and a column of data readings. Sometimes there are three readings on the same day. This is what it looks like: 17/02/06 7.9 (@ 1300 hrs) 17/02/06 5.4 (@ 1500 hrs) 17/02/06 9.9 (@ 1700 hrs) 18/02/06 6.7 (@ 1300 hrs) 18/02/06 8.0 (@ 1500 hrs) 18/02/06 7.1 (@ 1700 hrs) 19/02/06 4.4 (@ 1300 hrs) 19/02/06 6.7 (@ 1450 hrs) 19/02/06 5.2 (@ 1800 hrs) I want to: 1. average these results 2. report the number of data points (readings) 3. report the number of days over which readings were taken. I can get the average by using the AVERAGE function. I can get the number of readings by using the COUNT function. ... but, how do I get the number of days? If I use the CountA function it returns 9 days when readings were recorded clearly over only 3 days. What I need is something like a COUNT-DISTINCT function. Can anyone help with a solution to this question. Many thanks, James Elliott - Perhaps you could set up a column and enter A2-A1 (assuming the dates are in col A. Copy that down and you should have zeros where the date stayed the same and ones where the date changed. This column could then be summed. I didn't try this but it might be a start. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Paste Calc columns as table in Writer
Hi Samuel, Use 'edit / paste special' and select 'html' as the type of data. It will create a table that you can then customize. tc Samuel Murray wrote: G'day everyone Is it possible to copy multiple columns in Calc and paste them as a table in Writer? I've tried doing it but Writer just pastes the Calc columns as an embedded object of sorts. Thanks Samuel - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Update OpenOffice.org from 2.0 to 2.0.2 RC1
G. Roderick Singleton wrote: On Mon, 2006-02-20 at 13:40 -0800, Joe Conner wrote: When I installed 2.0.2rc1 it uninstalled my 2.0.1 as a part of the installation process. I had used "CUSTOM" install because I wanted to install along side 2.0.1, which is my production software. BAD IDEA,It still uninstalled 2.0.1 and doggedly installed itself in the default directory no matter what I told it to do. You will not get as many people to test a release candidate unless the install behaves itself. Joe Please confirm that you selected the Change button and changed the target. I installed 2.02.rc2 beside 2.0.2rc1 using the Custom install under XP Pro. If you are talking about the menus, then yes these do appear to be updated to the new version but this is easily fixed manually. After further investigation, part of what I reported earlier was inaccurate. My appologies for getting this wrong earlier. I had selected "CUSTOM" and modified the suggested install directory to previous tree minus previous OOo2.0.1 install directory\OOo202. It did install there after all but it totally uninstalled my production OOo prior to installing the release candidate. Still nasty, but not as bad as I had previously reported. I am going to uninstall rc1, reinstall 2.0.1 using the default directory, and reinstall rcq. I will report if the rc1 still uninstalls 2.0.1 before installing itself. By the way I am running WinXP Pro with 512MB ram and AMD XP1900 cpu. Joe SNIP - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] CVS access to OOo sources?
I've often wondered if and how I can access the OOo code via CVS. The CVS info under http://development.openoffice.org/ is not very helpful; it talks a lot about Cygwin installation and advanced features like CVS tunnelling, but fails to provide basic info on the CVS repository setup. Help, anyone? - Toralf - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated]
On Mon, 2006-02-20 at 17:57 -0500, Sheryl Andrew Wales wrote: Hello, I have a question about OpenOffice. I understand that it is compatible with Microsoft Office. I presently do not have MS Office, and require an office system for my home based business. Friends and collegues have sent me files that they have created in MS Office that I can open and read but not actually correct/change. Likewise, they are not able to open any of my files since it is not MS Office. If I install this OpenOffice program, will I be able to create/open/change any files that they have sent me and likewise will they be able with their MS Office installed on their computers be able to open/correct/change any documents that I have sent to them created with OpenOffice? Sorry to bother you with these questions, but it has been a real hassle not being able to always communicate with others without MS Office. The price of MS Office is also a bit of a hinder to it's purchase, $299.00. Thank you in advance for your time. If you could also cc this message to my other email address at [EMAIL PROTECTED] com I would really appreciate it, since this email address does not always seem to work. Sincerely, Sheryl Wales Sheryl, OOo is quite compatible. Not 100% but very close. Thus, for the most part, you will be able to edit and save the files that are sent to you. At $299, MSO is pricey but OOo is $0. This is free and open source to boot. I would recommend you give it a try just for that reason alone. To get it simply click on the Download section on http://www.openoffice.org/ and answer three questions and you will get an archive from which you may install. If you use windows, the download image is self extracting and start the install procedure automatically. Can't get much easier. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated] YOU MUST GIVE A SUMMARY HERE
Other may differ, but I would install NeoOfiice from www.neooffice.org. Have fun 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 Feb 20, 2006, at 9:10 AM, Bart Dragtsma wrote: I am using Mac OS X, 10.4.4 and my question is: Which choice of Open Office to download is the best for me? Bart Dragtsma Netherlands - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How do I read Adobe
Don't think that is an OpenOffice.org issue -- I use type 1 fonts all the time and don't have an issue have you tried creating a PDF with acrobat? Thanks 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 Feb 20, 2006, at 10:39 PM, John W. Kennedy wrote: Cor Nouws wrote: Hello Dana, Blake Dana Allen wrote: I am running open office. I can't seem to read anything written in adobe or acrobat How can I fix this? With OpenOffice.org you can export your files to .pdf. That is indeed very handy, since free pdf-readers are available, so everyone can read your files (if you wo want). However writing a pdf is not the same thing as reading (other) acrobat/adobe files. I believe PDF's created with OpenOffice.org go ca-ca when Type 1 fonts are used. I just had to switch a document to a lookalike TrueType font, myself. -- John W. Kennedy But now is a new thing which is very old-- that the rich make themselves richer and not poorer, which is the true Gospel, for the poor's sake. -- Charles Williams. Judgement at Chelmsford - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: openoffice 2.0 trying to access the internet. why?
I'm afraid that I can't answer your question. It only happened the first time I ran Open Office and I blocked the connection. I have searched my logs and can't find any reference to that occasion. ZoneAlarm has not reported any further attempt by Open Office to access the internet since I blocked it. Derek Andreas Kahl [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I do not know what exactly OOo does that alerts your Firewalls (I have only the Mac-Version and cannot test other OSes). But it could be possible that OOo just opens a local loopback connection (to / from localhost) for some functionality (e.g. Base). Such a connection would not be able to send or receive any data from outside your computer, but it is considered as a network connection by your firewalls anyway. To verify what kind of connection your OOo really sets up, please send the exact message of your firewall. Please try to find out, to which IP address does the connection go, which ports are opened. If your message does not provide this information, try to read your firewall's logfiles, look for a button indicating 'Details' or something similar. Regards Andreas c.bell schrieb: why is open office 2.0 trying to access the internet everytime i open the program from the program list in windows xp. I am using zone alarm. it gives me a warning of suspicious activity with openoffice 2.0 trying t get on the internet. is this normal activity. if so why ? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (Darwin) iD8DBQFD+Eyp3wMBldQqmLkRAvuUAJ4ykbpV2AA9JA8DpPL/Vjuklb2c3gCgixpr HVXq173faUP079a4GKbgldY= =/rkB -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Update OpenOffice.org from 2.0 to 2.0.2 RC1
On Tue, 2006-02-21 at 08:53 +, Peter Hillier-Brook wrote: Joe Conner wrote: [cut] After further investigation, part of what I reported earlier was inaccurate. My appologies for getting this wrong earlier. I had selected CUSTOM and modified the suggested install directory to previous tree minus previous OOo2.0.1 install directory\OOo202. It did install there after all but it totally uninstalled my production OOo prior to installing the release candidate. Still nasty, but not as bad as I had previously reported. I am going to uninstall rc1, reinstall 2.0.1 using the default directory, and reinstall rcq. I will report if the rc1 still uninstalls 2.0.1 before installing itself. Don't bother; it does! I'll try rc2 later today. By the way I am running WinXP Pro with 512MB ram and AMD XP1900 cpu. Joe Similar - WinXP Pro + SP2 The issue has been changed to RFE because this can be fixed by modifying bootstrap.ini. See http://www.openoffice.org/issues/show_bug.cgi?id=62360 -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Applying function returns to cell addresses
On Tue, 2006-02-21 at 13:57 +1100, Ross Johnson wrote: On Mon, 2006-02-20 at 20:44 -0500, Paul_B wrote: On Tue, 21 Feb 2006 12:02:13 +1100, Ross Johnson wrote: On Mon, 2006-02-20 at 18:52 -0500, Paul_B wrote: On Sun, 19 Feb 2006 20:27:22 -0500, Paul_B wrote: On Mon, 20 Feb 2006 09:31:28 +1100, Ross Johnson wrote: On Sun, 2006-02-19 at 15:29 -0500, Paul_B wrote: On Sun, 19 Feb 2006 10:59:58 -0600, Rod Engelsman wrote: Paul_B wrote: Is there any way to set up a multiple case logic test? Currently I have =IF(B27=;;B27-(14.325+(E$25-70.35)*0.28)) as a formula in a column of cells. It tests another column's cell, if it's empty the result is null, otherwise a tax approximation kicks in. However, I'd like to allow for a few tax brackets. To do so I'd need to account for the null possibility plus three other possible number ranges (as income increases, a different tax formula should be invoked). Currently I don't see how this is possible. Thanks, paul You can use nested IF() statements. =IF(B27=;;IF(B27=... Ahh. Ok, thanks. Hadn't thought of that. A case select command would be nice, but this should do what I need. Have you tried using lookup tables for this kind of thing. Functions: LOOKUP, VLOOKUP etc in Help. I use them for this purpose in my own tax sheets and they work. That indeed looks like it would do it, as it amounts to a powerful case select statement. Should be interesting working out the details. Will get on this maybe tomorrow. Thanks much, Paul Ok, I'm trying to set this up. Is there any way to use a function's return as part of a cell address? For instance: =MATCH($E$26;$H$3:$H$8) finds the row in which the H column matches cell E26. but =G(MATCH($E$26;$H$3:$H$8)) doesn't work. I want to find the row which contains the value searched for, and then use that number in the address of another value, here found under column G. Use something like =INDIRECT(GMATCH($E$26;$H$3:$H$8)+2) But LOOKUP does this for you. E.g. = LOOKUP($E$26;$H$3:$H$8;$G$3:$G$8) You definitely know your stuff, The INDIRECT formula is awesome, and you even caught the need for an offset of 2 in my MATCH formula. I was getting LOOKUP to return the row number, as does your formula above, but only because I set up column G to contain that data. But how then would I use the returned row number to specify which cells to poll for the tax data? That's where I'm stuck. Using the INDIRECT formula, I came up with =IF(B26=;;B26-( INDIRECT(iMATCH($E$25;$H$3:$H$8)+2) +INDIRECT(jMATCH($E$25;$H$3:$H$8)+2)*($E$25-LOOKUP(E$25;$H$3:$H$8;$H$3:$H$8 which successfully takes the income in B26 and then subtracts off the base tax and incremental tax bracket tax. But this is very unwieldy. If LOOKUP can do this directly, it would be a big improvement. Hey. Compliments always work :) I guess this has turned into a bit of a tutorial on lookup tables now. I assume your tax brackets are structured the same as mine, i.e a table like this (top left at cell H3): 0 0 0 Tax free threshold 1 1 0 0.15$0 plus $0.15 for each $ over $1 2 3 15000.25 4 5 65000.30 6 8 95000.35 9 2 0.45$2 plus $0.45 for each $ over $9 $9 is the top threshold. If you don't have a tax-free threshold where you are then you can see how the table would change. The second column isn't actually needed in the formulae. Tax: =IF(B260;0;LOOKUP(B26;$H$3:$H$7;$J$3:$J$7) +(B26-LOOKUP(B26;$H$3:$H$7;$J$3:$J$7)) *LOOKUP(B26;$H$3:$H$7;$K$3:$K$7)) Of course, the formula is a lot simpler if you store the base tax amount for your income in another cell. Base Tax: B27 =LOOKUP(B26;$H$3:$H$7;$J$3:$J$7) Tax: =IF(B260;0;B27+(B26-B27)*LOOKUP(B26;$H$3:$H$7;$K$3:$K$7)) I give no warranty that these formulae won't get you a jail term :) Oops. Change the ranges to $H$3:$H$8 etc. or you will get a jail term :/ I added the 9 row to make it more realistic but forgot to change the ranges. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Applying function returns to cell addresses
On Mon, 2006-02-20 at 20:44 -0500, Paul_B wrote: On Tue, 21 Feb 2006 12:02:13 +1100, Ross Johnson wrote: On Mon, 2006-02-20 at 18:52 -0500, Paul_B wrote: On Sun, 19 Feb 2006 20:27:22 -0500, Paul_B wrote: On Mon, 20 Feb 2006 09:31:28 +1100, Ross Johnson wrote: On Sun, 2006-02-19 at 15:29 -0500, Paul_B wrote: On Sun, 19 Feb 2006 10:59:58 -0600, Rod Engelsman wrote: Paul_B wrote: Is there any way to set up a multiple case logic test? Currently I have =IF(B27=;;B27-(14.325+(E$25-70.35)*0.28)) as a formula in a column of cells. It tests another column's cell, if it's empty the result is null, otherwise a tax approximation kicks in. However, I'd like to allow for a few tax brackets. To do so I'd need to account for the null possibility plus three other possible number ranges (as income increases, a different tax formula should be invoked). Currently I don't see how this is possible. Thanks, paul You can use nested IF() statements. =IF(B27=;;IF(B27=... Ahh. Ok, thanks. Hadn't thought of that. A case select command would be nice, but this should do what I need. Have you tried using lookup tables for this kind of thing. Functions: LOOKUP, VLOOKUP etc in Help. I use them for this purpose in my own tax sheets and they work. That indeed looks like it would do it, as it amounts to a powerful case select statement. Should be interesting working out the details. Will get on this maybe tomorrow. Thanks much, Paul Ok, I'm trying to set this up. Is there any way to use a function's return as part of a cell address? For instance: =MATCH($E$26;$H$3:$H$8) finds the row in which the H column matches cell E26. but =G(MATCH($E$26;$H$3:$H$8)) doesn't work. I want to find the row which contains the value searched for, and then use that number in the address of another value, here found under column G. Use something like =INDIRECT(GMATCH($E$26;$H$3:$H$8)+2) But LOOKUP does this for you. E.g. = LOOKUP($E$26;$H$3:$H$8;$G$3:$G$8) You definitely know your stuff, The INDIRECT formula is awesome, and you even caught the need for an offset of 2 in my MATCH formula. I was getting LOOKUP to return the row number, as does your formula above, but only because I set up column G to contain that data. But how then would I use the returned row number to specify which cells to poll for the tax data? That's where I'm stuck. Using the INDIRECT formula, I came up with =IF(B26=;;B26-( INDIRECT(iMATCH($E$25;$H$3:$H$8)+2) +INDIRECT(jMATCH($E$25;$H$3:$H$8)+2)*($E$25-LOOKUP(E$25;$H$3:$H$8;$H$3:$H$8 which successfully takes the income in B26 and then subtracts off the base tax and incremental tax bracket tax. But this is very unwieldy. If LOOKUP can do this directly, it would be a big improvement. Hey. Compliments always work :) I guess this has turned into a bit of a tutorial on lookup tables now. I assume your tax brackets are structured the same as mine, i.e a table like this (top left at cell H3): 0 0 0 Tax free threshold 1 1 0 0.15$0 plus $0.15 for each $ over $1 2 3 15000.25 4 5 65000.30 6 8 95000.35 9 2 0.45$2 plus $0.45 for each $ over $9 $9 is the top threshold. If you don't have a tax-free threshold where you are then you can see how the table would change. The second column isn't actually needed in the formulae. Tax: =IF(B260;0;LOOKUP(B26;$H$3:$H$7;$J$3:$J$7) +(B26-LOOKUP(B26;$H$3:$H$7;$J$3:$J$7)) *LOOKUP(B26;$H$3:$H$7;$K$3:$K$7)) Of course, the formula is a lot simpler if you store the base tax amount for your income in another cell. Base Tax: B27 =LOOKUP(B26;$H$3:$H$7;$J$3:$J$7) Tax: =IF(B260;0;B27+(B26-B27)*LOOKUP(B26;$H$3:$H$7;$K$3:$K$7)) I give no warranty that these formulae won't get you a jail term :) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Cursor not saved to last position
On Tue, 2006-02-21 at 09:48 +0100, Thomas Lange wrote: Hi all, Sorry, I should have mentioned I'm using 2.0.1, and yes, I have all my user information filled in. It's very strange. That is not all you have to do. You have to make other choices. Like setting the Reply-To heading so it goes to the list rather than a Post To: field. I and others would appreciate it if you would configure your client appropriately. If you do not know how, ask your system administrator. As to your supposed problem, please try setting the following: Tools Options OpenOffice.org View with any settings you personally need that are different from the default. For example, Restore Editing view. For detail, click Help on the dialogue box Help button and follow the links. ... Up to yesterday, whenever I called up a file it came up with the cursor at the last position it had been at. Since this morning, the cursor is at the very top of each document, whether old or new, when I call up the document. Which version are you using? 2.0 or 1.1.5? Have you entered your user-informations in the OOo-dialogue? Your name is necessary in OOo 2.0.x. Additionally, you'll have to select Recovery | Edit-view (or something similar - since I'm using only the German version) under Tools - Options. Hope this helps you. I don't know with which version the behaviour changed. OpenOffice used to always store the cursor position when the douments view was closed and restored the view to that position when it was opened. I also liked this a lot because it was an easy way to have a 'bookmark' of the position where to continue with reading. Unfortunately at some point it was decided that this is not what the average user would want because reading should start from the first page. So now the the documents always gets opened with the view on the first page. That is unless you are the author! In that case the last position is used because it was assumed the author usually want's to continue writing the document. That's why it should be essential if the your user info matches the one stored with the document. Unfortunately there also was no option introduced to allow the user to customize this behaviour. The only thing done was to introduce a keyboard shortcut (I think it was sth like Shift-F5) to return the cursor to the last editing position which should be pretty much what you and I wanted to have by default. I personally still would prefer the old solution though. :-/ Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OpenOfficeorg Base
James Elliott wrote: Andy Ericson I read your post because I had some questions of my own about Base and was hoping to be educated. As it was I was bitterly disappointed at your unrealistic, vindictive, and vitriolic attack on Open Office and Sun Microsystems. Why do we bother to respond to such attacks? If this person wanted help, don't you think he would have asked for it instead of attacking OO for its deficiencies? -- Pete Holsberg Columbus, NJ Treat everyone the way you want to be treated. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Cursor not saved to last position
On Tue, 2006-02-21 at 08:48 -0500, G. Roderick Singleton wrote: On Tue, 2006-02-21 at 09:48 +0100, Thomas Lange wrote: Hi all, Sorry, I should have mentioned I'm using 2.0.1, and yes, I have all my user information filled in. It's very strange. As to your supposed problem, please try setting the following: Tools Options OpenOffice.org View with any settings you personally need that are different from the default. For example, Restore Editing view. For detail, click Help on the dialogue box Help button and follow the links. There's a curious sentence in Help for Restore Editing view, which says that Write documents always open on page 1. So whatever has changed seems to have warranted a conscious statement in Help. ... Up to yesterday, whenever I called up a file it came up with the cursor at the last position it had been at. Since this morning, the cursor is at the very top of each document, whether old or new, when I call up the document. Which version are you using? 2.0 or 1.1.5? Have you entered your user-informations in the OOo-dialogue? Your name is necessary in OOo 2.0.x. Additionally, you'll have to select Recovery | Edit-view (or something similar - since I'm using only the German version) under Tools - Options. Hope this helps you. I don't know with which version the behaviour changed. OpenOffice used to always store the cursor position when the douments view was closed and restored the view to that position when it was opened. I also liked this a lot because it was an easy way to have a 'bookmark' of the position where to continue with reading. Unfortunately at some point it was decided that this is not what the average user would want because reading should start from the first page. So now the the documents always gets opened with the view on the first page. That is unless you are the author! In that case the last position is used because it was assumed the author usually want's to continue writing the document. That's why it should be essential if the your user info matches the one stored with the document. Unfortunately there also was no option introduced to allow the user to customize this behaviour. The only thing done was to introduce a keyboard shortcut (I think it was sth like Shift-F5) to return the cursor to the last editing position which should be pretty much what you and I wanted to have by default. I personally still would prefer the old solution though. :-/ Regards, Thomas - 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] Drawing objects from Python...
Hi ! I want to draw mail paths in OpenOffice Draw. I get this information from eml header received tags. The problem, that I need to call OpenOffice in some way (COM, OLE ???), and need to draw rectagles and connectors. How to I do it ? Anybody can help me with some source code and links ? Thanx for it: dd - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Drawing objects from Python...
On Tue, 2006-02-21 at 15:38 +0100, Durumdara wrote: Hi ! I want to draw mail paths in OpenOffice Draw. I get this information from eml header received tags. The problem, that I need to call OpenOffice in some way (COM, OLE ???), and need to draw rectagles and connectors. How to I do it ? Anybody can help me with some source code and links ? Thanx for it: dd Check the Download tab for the sources with which you want to start and once you have digested the details, I suggest you ask your programming questions on dev@openoffice.org to start. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] disk space
depends on components you choose in my case (linux, installed almost everything ;) ) - 287M Joe Marks wrote: How much disk space does 2.0 require on a computer? -- Rich - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] use fonts from /usr/lib/openoffice/fonts ONLY
Hi, I am new to the list. My question is how I can handle a very strict font management since I am from the DTP front and only want to use _some high quality_ fonts in OpenOffice. The idea is to deny OpenOffice to use any font from the Linux standard dirs like /usr/share/fonts and only use the fonts I installed with spadmin inside /usr/lib/openoffice/fonts/(truetype?)/. But I couldn't find an option to only permit this one dir, neither in the Path section nor in the Fonts section of the Options dialog. I use OOo-2.0.1 on Gentoo Linux. Thanks in advance for your help! Sebastian - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] disk space
Hi Joe, On Win2k, mine is 207meg. tc Rich wrote: depends on components you choose in my case (linux, installed almost everything ;) ) - 287M Joe Marks wrote: How much disk space does 2.0 require on a computer? -- Rich - 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] I'm using MACOSX 10.3.9 OpenOffice 2.0 under X11 1.0 - XFree86 4.3.0
Ross, Thanks for your explination. But, I did exactly all that, and once I click on the DMG file, it does not work. Ideas? I have downloaded the software 3-4 times on different occasions and tried installing it. Joseph 2006/2/21, Ross Bernheim [EMAIL PROTECTED]: Andy, There is no need to move any files. Once you double click the dmg file and the disk icon appears on the desktop, double click to open it if a window doesn't open automatically. Once opened, just double click on the installer or package and it will install or work from there. The dmg is a disk image and when unpacked you have a usable image mounted on the desktop. You can move the contents to your hard disk or use as is. Using from the image is quick and easy and once closed, the original compressed dmg file is still on your disk if you need to use it again. Sorry if some of this is a bit basic, but there are many neophytes who read this list and may not be familiar with it. I use both OOo 2 and NeoOffic/J. Both have their charms and foibles. Ross Bernheim
[users] Re: Re: Applying function returns to cell addresses
On Tue, 21 Feb 2006 13:57:40 +1100, Ross Johnson wrote: On Mon, 2006-02-20 at 20:44 -0500, Paul_B wrote: On Tue, 21 Feb 2006 12:02:13 +1100, Ross Johnson wrote: On Mon, 2006-02-20 at 18:52 -0500, Paul_B wrote: On Sun, 19 Feb 2006 20:27:22 -0500, Paul_B wrote: On Mon, 20 Feb 2006 09:31:28 +1100, Ross Johnson wrote: On Sun, 2006-02-19 at 15:29 -0500, Paul_B wrote: On Sun, 19 Feb 2006 10:59:58 -0600, Rod Engelsman wrote: Paul_B wrote: Is there any way to set up a multiple case logic test? Currently I have =IF(B27=;;B27-(14.325+(E$25-70.35)*0.28)) as a formula in a column of cells. It tests another column's cell, if it's empty the result is null, otherwise a tax approximation kicks in. However, I'd like to allow for a few tax brackets. To do so I'd need to account for the null possibility plus three other possible number ranges (as income increases, a different tax formula should be invoked). Currently I don't see how this is possible. Thanks, paul You can use nested IF() statements. =IF(B27=;;IF(B27=... Ahh. Ok, thanks. Hadn't thought of that. A case select command would be nice, but this should do what I need. Have you tried using lookup tables for this kind of thing. Functions: LOOKUP, VLOOKUP etc in Help. I use them for this purpose in my own tax sheets and they work. That indeed looks like it would do it, as it amounts to a powerful case select statement. Should be interesting working out the details. Will get on this maybe tomorrow. Thanks much, Paul Ok, I'm trying to set this up. Is there any way to use a function's return as part of a cell address? For instance: =MATCH($E$26;$H$3:$H$8) finds the row in which the H column matches cell E26. but =G(MATCH($E$26;$H$3:$H$8)) doesn't work. I want to find the row which contains the value searched for, and then use that number in the address of another value, here found under column G. Use something like =INDIRECT(GMATCH($E$26;$H$3:$H$8)+2) But LOOKUP does this for you. E.g. = LOOKUP($E$26;$H$3:$H$8;$G$3:$G$8) You definitely know your stuff, The INDIRECT formula is awesome, and you even caught the need for an offset of 2 in my MATCH formula. I was getting LOOKUP to return the row number, as does your formula above, but only because I set up column G to contain that data. But how then would I use the returned row number to specify which cells to poll for the tax data? That's where I'm stuck. Using the INDIRECT formula, I came up with =IF(B26=;;B26-( INDIRECT(iMATCH($E$25;$H$3:$H$8)+2) +INDIRECT(jMATCH($E$25;$H$3:$H$8)+2)*($E$25-LOOKUP(E$25;$H$3:$H$8;$H$3:$H$8 which successfully takes the income in B26 and then subtracts off the base tax and incremental tax bracket tax. But this is very unwieldy. If LOOKUP can do this directly, it would be a big improvement. Hey. Compliments always work :) I guess this has turned into a bit of a tutorial on lookup tables now. I assume your tax brackets are structured the same as mine, i.e a table like this (top left at cell H3): 0 0 0 Tax free threshold 1 1 0 0.15$0 plus $0.15 for each $ over $1 2 3 15000.25 4 5 65000.30 6 8 95000.35 9 2 0.45$2 plus $0.45 for each $ over $9 $9 is the top threshold. If you don't have a tax-free threshold where you are then you can see how the table would change. The second column isn't actually needed in the formulae. Tax: =IF(B260;0;LOOKUP(B26;$H$3:$H$7;$J$3:$J$7) +(B26-LOOKUP(B26;$H$3:$H$7;$J$3:$J$7)) *LOOKUP(B26;$H$3:$H$7;$K$3:$K$7)) Of course, the formula is a lot simpler if you store the base tax amount for your income in another cell. Base Tax: B27 =LOOKUP(B26;$H$3:$H$7;$J$3:$J$7) Tax: =IF(B260;0;B27+(B26-B27)*LOOKUP(B26;$H$3:$H$7;$K$3:$K$7)) I give no warranty that these formulae won't get you a jail term :) Wow, it's so simple once I see it. I was missing the obvious step of looking up the tax bracket floor again and subtracting it from the actual income, in preparation for multiplication by the incremental rate. Thanks very much for taking the time to lay this out. Hopefully others have gained from it as much as I. Gratefully, Paul -- Using OOo 2.0 on Win XP sp2. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] use fonts from /usr/lib/openoffice/fonts ONLY
Font management is found in the Tools Options OpenOffice.org Writer Basic Fonts. I would suggest installing the high quality fonts you want first. Then go to the place I mentioned. Change the settings to the fonts you want to use. You can also manage your fonts by using styles. Each style has a Font tab where you can select the one you want to use with that style. In the documentation section of the OOo web site, there are manuals explaining how to use styles. In the German Section of this web site, there should be at least some of these manuals in German if you prefer. Thanks Dan, but this steps are not radical enough for me! I wont only my approved fonts to show up in the fonts drop down menu of the writer gui at all. I am working with templates ans styles very often - but none the less a good (small) collection of fonts in that drop down menu is very usefull, e.g. when creating new styles/documents. Isn't there any possibility to disable the loading of the general fonts on my system? I can not quite believe this :-( - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] disk space
30Gb for less than $70Cdn does not seem all that expensive. On Tue, 2006-02-21 at 09:55 -0800, Joe Conner wrote: Notebook hard drives are generally small and costly in comparison. wbg wrote: On Tue, 2006-02-21 at 08:13, Joe Marks wrote: How much disk space does 2.0 require on a computer? When you can buy a 300Gb drive for $69.95, why would it matter? g Brewster - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I'm using MACOSX 10.3.9 OpenOffice 2.0 under X11 1.0 - XFree86 4.3.0
But, I did exactly all that, and once I click on the DMG file, it does not work. But it did work in the past at least once right ? Did you look for files that were left by the previous installation ? JC - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] disk space
Notebook hard drives are generally small and costly in comparison. wbg wrote: On Tue, 2006-02-21 at 08:13, Joe Marks wrote: How much disk space does 2.0 require on a computer? When you can buy a 300Gb drive for $69.95, why would it matter? g Brewster - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I'm using MACOSX 10.3.9 OpenOffice 2.0 under X11 1.0 - XFree86 4.3.0
Hello again, It did workinthe past with OO v1.x I have not had time to try removing the files that youmentioned. I will work on that this week. Merci Joseph (de Montreal) 2006/2/21, JC Helary [EMAIL PROTECTED]: But, I did exactly all that, and once I click on the DMG file, it does not work. But it did work in the past at least once right ? Did you look for files that were left by the previous installation ? JC - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I'm using MACOSX 10.3.9 OpenOffice 2.0 under X11 1.0 - XFree86 4.3.0
Andy, There is no need to move any files. Once you double click the dmg file and the disk icon appears on the desktop, double click to open it if a window doesn't open automatically. Once opened, just double click on the installer or package and it will install or work from there. The dmg is a disk image and when unpacked you have a usable image mounted on the desktop. You can move the contents to your hard disk or use as is. Using from the image is quick and easy and once closed, the original compressed dmg file is still on your disk if you need to use it again. Sorry if some of this is a bit basic, but there are many neophytes who read this list and may not be familiar with it. I use both OOo 2 and NeoOffic/J. Both have their charms and foibles. Ross Bernheim On Feb 20, 2006, at 19:25, Andrew Fisk wrote: Ah ha! Did you try dragging it to you applications folder -- moving a file from a disk image to the desktop does not copy the package(s) -- if your memory goes back far enough to remember using some kind of removable RW media (floppy/zip/Jazz...etc) you will recall that if you moved a file to the desktop, ejected the media and inserted it in another mac, the file would disappear from the first machine's desktop and appear on the second one. Some Applications seem to run fine from a disk image while other have issues. I am sure you answered this question already, but you do have X11 installed Thanks 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 Feb 20, 2006, at 9:25 PM, Joe Hogan wrote: Let me correct something I said before. I must correct what I said about downloading and clicking on the file and it timing out. I downloaded the file from the OO website I clicked on the dmg file It opened in a window and there was an install file. I moved the file to the desktop I clicked on the file I then get the response: command timed out Then I click OK, and it quits. Well, that is the whole sequence. Ideas... Joe On Feb 20, 2006, at 8:35 AM, Derick Centeno wrote: I have the same setup except I have DSL. Is it possible that something is wrong with the file which was downloaded. Did anyone run the md5 test after the file was downloaded but before the file was invoked to startup? The md5 value for OO is posted on the OO website. The way to run the md5 test from within OS X is to open Terminal and do: $ md5 filename Where filename is the OO file which was downloaded. I recommend that the md5 test embedded within Apple's disk utility not be used as it is proprietary and not standard with the accepted md5 algorithm. In brief, if you use Apple's md5, you'll never see a match with any other md5 value which wasn't generated by Apple or Apple based routines. If that is ok, then trying checking one's wires, cables and connections. If one was using dial-up, there could be lot's of glitches there. Also just because one may choose a higher bandwidth for file transfer doesn't mean downloads will be perfect. On Feb 20, 2006, at 7:58 AM, Joe Hogan wrote: Jean-Cristophe, If you read the guys message, he gives you ALL the details. Like i also said in my message, after downloading the file from the website, I click on the file to download it. After waiting about 30-40 seconds, I get the message that the other guy wrote: command timed out Thats it. We do not get anywhere near actually installing anything. Joseph On Feb 20, 2006, at 2:24 AM, JC Helary wrote: Could you give more details ? How do you launch OpenOffice ? What do you see ? Jean-Christophe On 2006/02/20, at 7:25, Esther Aizcorbe wrote: Hello When i launch openoffice. there's a message command timed out. Can you tell me why and how to fixed the problem. Thank you very much. MDO -- --- 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] I bought a box of powdered water, but I didn't know what you add Steven Wright - 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] I bought a box of powdered water, but I didn't know what you add Steven Wright - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To
Re: [users] I'm using MACOSX 10.3.9 OpenOffice 2.0 under X11 1.0 - XFree86 4.3.0
On Tue, 2006-02-21 at 13:06 -0500, Joe Hogan wrote: Ross, Thanks for your explination. But, I did exactly all that, and once I click on the DMG file, it does not work. Ideas? Please confirm that you checked that the download was successful by using md5sum against the list at http://porting.openoffice.org/mac/md5sums.html From the description you gave, I suspect a bad download. I have downloaded the software 3-4 times on different occasions and tried installing it. Joseph 2006/2/21, Ross Bernheim [EMAIL PROTECTED]: Andy, There is no need to move any files. Once you double click the dmg file and the disk icon appears on the desktop, double click to open it if a window doesn't open automatically. Once opened, just double click on the installer or package and it will install or work from there. The dmg is a disk image and when unpacked you have a usable image mounted on the desktop. You can move the contents to your hard disk or use as is. Using from the image is quick and easy and once closed, the original compressed dmg file is still on your disk if you need to use it again. Sorry if some of this is a bit basic, but there are many neophytes who read this list and may not be familiar with it. I use both OOo 2 and NeoOffic/J. Both have their charms and foibles. Ross Bernheim -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I'm using MACOSX 10.3.9 OpenOffice 2.0 under X11 1.0 - XFree86 4.3.0
On Feb 21, 2006, at 10:06, Joe Hogan wrote: Ross, Thanks for your explination. But, I did exactly all that, and once I click on the DMG file, it does not work. Ideas? I have downloaded the software 3-4 times on different occasions and tried installing it. Joseph Joseph, There are two possible sources of the problem that I can think of. First, the file from OOo is bad. Some credence is added to this thought since others are having the problem as well. Second, a problem on your Mac. Perhaps the extracting program that turns the dmg into an image is at fault. Or there is another program that has changed or corrupted something on your Mac that causes the problem. Ross Bernheim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Help! Where are the backup files?
It gets it from the same place. When it crashes however there is another file put there to indicate that the recovery process needs to be started. I'm not 100% sure of the details. /paul On 2/22/06, John Jordan [EMAIL PROTECTED] wrote: On 22 Feb 2006, at 7:47, Paul wrote: What backup's do is copy the currently open file to a different location. For instance I'm working on file AB.odt in directory c:\mydirectory\ ... If I've got backup's turned on and working it will save a copy to c:\[OOo install dir]\..\backup in case the original gets corrupted. I _think_ (someone may have to confirm this) that the backup's disappear once you've closed the open file however. Not too sure there is another way of retrieving your file sorry... I've never had a corrupted file. But I've often inadvertently deleted a file or overwritten it. Just about every program I've ever used that has an automatic backup feature does it by always renaming the previously saved file as the backup and then doing a new save. Thus you've always got the old version in a backup folder. The way OO.o does it (assuming you're rght) is very dangerous. There is no security whatsoever for accidents. Wait ... on occasion OO.o Writer has crashed on me. When I restart it it always pops up a retrieve window. Where does it get that file from? - 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] Problema problem
Hola Roberto, Roberto E. Sepulveda Franco [EMAIL PROTECTED] schrieb: señores open office perdón, but my Spanish isn't so good, that I can write my answer to your question in this really beautiful language. :) mi inconveniente es que no me permite revisar la ortografia en español, ya tengo el paquete de lenguaje español y no me ha cargado la linguistica para la revision de la gramatica en español I think, you have to download the different dictionaries. Please use File | Wizards | More dictionaries (or something similar, I'm using only a German version of OOo). Follow the instructions, given in that file and after closing OOo (incl. quickstarter) you can use the Spanish dictionaries. thank you You're welcome. :) Sigrid - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: md5sum idea
I am writing to correct some misunderstanding regarding md5 and it's availability on OS X. Too bad, it's going to get lost in amongst all the other emails. Apple does have it's own very of md5 within it's Disk Utility application. However, that version provides a very different type of processing in determining md5 values. The more common md5sum test is available, and it is not necessary to refer outside of OS X for it -- nor is it necessary to install anything extraneous to what is already found within OS X itself. The md5sum test which is very familiar to Windows and Linux users, is available within an application in OS X called Terminal. Do: $ md5 filename where filename is the name of the file to be tested and the md5sum test will report in the same format one sees in Linux or other environments. Try it out. Best wishes On Feb 21, 2006, at 1:36 PM, Joe Hogan wrote: Well, Thanks for forwarding me the links. I did a little reading, and this, unfortunately from what I read, does not help me at all:( The original problem was the inability to install OO on Mac OS X. The md5sum is LInux and Windows only:( Is there a version for Mac? Any new ideas? Joseph 2006/2/21, G. Roderick Singleton [EMAIL PROTECTED]: M. Hogan, This question should have been sent to the list. I happened to find it in my junk filter by accident. The information you have asked for is on http://download.openoffice.org/2.0.1/index.html near the bottom. Specifically, http://download.openoffice.org/2.0.1/md5sums.html I have copied the mailing list for you. On Tue, 2006-02-21 at 13:26 -0500, Joe Hogan wrote: Hello, Could you explain how the md5sum thing is done? I want to be able to eliminate all possibilities. I just find it odd that I can download anything and everything but OO. NeoOffice downloads fine... Thanks for letting be know how. (what software, and how do I go abotu it?) Joseph -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Making Address Labels
I've been trying to create address lables from an existing Microsoft Excel file. From your help info I get to line #12 fairly easy. When I click on the Data to Fields icon the data from my Excel spreadsheet does not appear in the Avery 5160 label display. What am I doing wrong? Do you have any suggestions? Thanks, Ken B.
[users] Autocorrect - Replace tab
I am using Version 2 of Open Office and am new to it. I wish to add a couple of autocorrections in the replace tab and have completed the Replace and With boxes, clicked New and O.K. but when I type the Replace abbreviation in a document it does not change. I have tried making the entries in Autocorrect many times but it will not work for me. Any other listed correction will change, so that part of the program is working. Strangely, when I open a Microsoft Word document in Open Office the autocorrect entries of Microsoft still operate. Can you help me please? With many thanks, Peter Gerrie
[users] [moderated]
I have a question on use of the spreadsheet program. I have a cell in one spreadsheet (file A) which is linked to a cell in another spreadsheet (file B). At some point in time I want to break the link and freeze the value in the cell in file A at its current value. The only way I have been able to figure out to do this is by typing in the value I want. Is there another way? In Excel I could do this by selecting the cell in file A, copy it, select paste special, and select value. Thanks for any help you can provide. Robert Beene - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Setting print area
Dear Sirs, How do you set the print area? There is no help file for this either. Thanks, Peter Bull
Re: [users] Re: md5sum idea
Questions regarding OS X and using md5 with open office has appeared several times within the open office mail in various discussions. The information here ought to be posted somewhere as a reference permanently. I'm willing to rewrite it in English or Spanish as necessary. I am writing to correct some misunderstanding regarding md5 and it's availability on OS X. Too bad, it's going to get lost in amongst all the other emails. Apple does have it's own very of md5 within it's Disk Utility application. However, that version provides a very different type of processing in determining md5 values. The more common md5sum test is available, and it is not necessary to refer outside of OS X for it -- nor is it necessary to install anything extraneous to what is already found within OS X itself. The md5sum test which is very familiar to Windows and Linux users, is available within an application in OS X called Terminal. Do: $ md5 filename where filename is the name of the file to be tested and the md5sum test will report in the same format one sees in Linux or other environments. Try it out. Best wishes On Feb 21, 2006, at 1:36 PM, Joe Hogan wrote: Well, Thanks for forwarding me the links. I did a little reading, and this, unfortunately from what I read, does not help me at all:( The original problem was the inability to install OO on Mac OS X. The md5sum is LInux and Windows only:( Is there a version for Mac? Any new ideas? Joseph 2006/2/21, G. Roderick Singleton [EMAIL PROTECTED]: M. Hogan, This question should have been sent to the list. I happened to find it in my junk filter by accident. The information you have asked for is on http://download.openoffice.org/2.0.1/index.html near the bottom. Specifically, http://download.openoffice.org/2.0.1/md5sums.html I have copied the mailing list for you. On Tue, 2006-02-21 at 13:26 -0500, Joe Hogan wrote: Hello, Could you explain how the md5sum thing is done? I want to be able to eliminate all possibilities. I just find it odd that I can download anything and everything but OO. NeoOffice downloads fine... Thanks for letting be know how. (what software, and how do I go abotu it?) Joseph -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - 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] Re: use fonts from /usr/lib/openoffice/fonts ONLY
Sebastian Röder wrote: Font management is found in the Tools Options OpenOffice.org Writer Basic Fonts. I would suggest installing the high quality fonts you want first. Then go to the place I mentioned. Change the settings to the fonts you want to use. You can also manage your fonts by using styles. Each style has a Font tab where you can select the one you want to use with that style. In the documentation section of the OOo web site, there are manuals explaining how to use styles. In the German Section of this web site, there should be at least some of these manuals in German if you prefer. Thanks Dan, but this steps are not radical enough for me! I wont only my approved fonts to show up in the fonts drop down menu of the writer gui at all. I am working with templates ans styles very often - but none the less a good (small) collection of fonts in that drop down menu is very usefull, e.g. when creating new styles/documents. Isn't there any possibility to disable the loading of the general fonts on my system? I can not quite believe this :-( I've never encountered a word processor or publishing program that does this, so far as I know. Do you, yourself, know of any program that allows filtering of fonts, other than dedicated font managers? Normally such a demand is satisfied by a font manager utility. Those I have used have always worked globally on any particular machine, but I understand there are some now available that can be configured to show or hide particular sets of fonts in respect to particular applications. Whether there are any such available for Linux I do not know. Jallan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Setting print area
[EMAIL PROTECTED] wrote: Dear Sirs, How do you set the print area? There is no help file for this either. Setting the print area is found under Format - Print Ranges Jallan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Problema problem
Estimado Señor Sepulveda: Por favor refiérse a las pagínas dedicado a usar el éspañol: http://es.openoffice.org/resources/product_desc.html On Feb 21, 2006, at 10:53 AM, Roberto E. Sepulveda Franco wrote: señores open office mi inconveniente es que no me permite revisar la ortografia en español, ya tengo el paquete de lenguaje español y no me ha cargado la linguistica para la revision de la gramatica en español thank you Ing. Roberto E. Sepulveda Franco Jefe de Operaciones y Proyectos SIIR - 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] Re: md5sum idea
A lot of folks are dropping md5sum support because of a possible spoof that has been shown to work. SHA-1 hasn't been compromised in that manner (yet). Agrred that seems to be the case. There are however some attacks on SHA-1 (albiet reduced rounds) as well... As someone mentioned on sci.crypt there is no such things as a collision free hash .. /paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I'm using MACOSX 10.3.9 OpenOffice 2.0 under X11 1.0 - XFree86 4.3.0
Hello, There are two possible sources of the problem that I can think of. First, the file from OOo is bad. Some credence is added to this thought since others are having the problem as well. Who do we contact on the OO team to verify the state of the downlaodable file? Second, a problem on your Mac. Perhaps the extracting program that turns the dmg into an image is at fault. Or there is another program that has changed or corrupted something on your Mac that causes the problem. Well, when looking at a DMG (disk image) is a system thing. I use it quite often while downloading other files. While it might be a problem, it does not seem to cause problem in any of my other downloaded files. Has anyone else had problems using DMG files other than OO? Joseph
Re: [users] Help! Where are the backup files?
On 22 Feb 2006, at 7:47, Paul wrote: What backup's do is copy the currently open file to a different location. For instance I'm working on file AB.odt in directory c:\mydirectory\ ... If I've got backup's turned on and working it will save a copy to c:\[OOo install dir]\..\backup in case the original gets corrupted. I _think_ (someone may have to confirm this) that the backup's disappear once you've closed the open file however. Not too sure there is another way of retrieving your file sorry... I've never had a corrupted file. But I've often inadvertently deleted a file or overwritten it. Just about every program I've ever used that has an automatic backup feature does it by always renaming the previously saved file as the backup and then doing a new save. Thus you've always got the old version in a backup folder. The way OO.o does it (assuming you're rght) is very dangerous. There is no security whatsoever for accidents. Wait ... on occasion OO.o Writer has crashed on me. When I restart it it always pops up a retrieve window. Where does it get that file from? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Help! Where are the backup files?
John Jordan wrote: OO.o 1.9-something, Ubuntu-64 Breezy. K, I screwed up just now. I opened a homework file for Chapter 12 of the textbook we are using in one of my classes (Ex_Chapt_12.odt), intending to use it as a template to start doing the homework for Chapter 13. I deleted all but the first page information, intending to do a Save As under the name Ex_Chapt_13. But without thinking I hit Ctrl-s. Oops! No problem, I thought. I know this thing is making automatic backups all the time, because sometimes it interrupts me while I am typing. I'll just go get the backup file. I assumed that every time I did a Save it deleted the old backup file, then renamed the previously saved copy as the new backup. So I carefully did a Save As of the open document to Ex_Chapt_13.odt, then opened the file manager to look for the backup file. Nothing. Nada. Not there. According to Options the backup files are supposed to be in /home/jjj/.openoffice.org2/backups. The folder is there, but it is empty. I searched the entire disk from the root forward for Ex_Chapt_12*.*. No backup files. All I found was the newly saved version. Evidently automatic backup doesn't automatically make backups. What does it actually do? As far as I can tell it does nothing at all. And can someone tell me if there is any way to retrieve the old version of this file? And what can I do to prevent this sort of thing from happening again? This setup is very dangerous. There is no production OOo 1.9. The last official production release of version 1 is 1.1.5. The 1.9 series were beta releases for version 2, often with known bugs, supplied for testing only, with a warning about this on the OpenOffice.org site download page where they were available. Automatic backup does work with OpenOffice.org 2.0.1 (and I believe worked in earlier production releases, but I recently purposely blew away all old OOo directories and so can't confirm this, other than noticing a large number of .BAK files existed where they were supposed to exist.) Probably the only way you might recover your earlier version of the file is through dedicated disk recovery software. If you have not done much writing to disk following your mishap, your file *may* still be there. (But if you have no deleted file recovery software on your system, simply downloading it may wipe out your file.) Jallan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Autocorrect - Replace tab
[EMAIL PROTECTED] wrote: I am using Version 2 of Open Office and am new to it. I wish to add a couple of autocorrections in the replace tab and have completed the Replace and With boxes, clicked New and O.K. but when I type the Replace abbreviation in a document it does not change. I have tried making the entries in Autocorrect many times but it will not work for me. Any other listed correction will change, so that part of the program is working. Strangely, when I open a Microsoft Word document in Open Office the autocorrect entries of Microsoft still operate. Check through Format - Character - Font that the language setting for the text which is not being autocorrected is identical to the language setting that appears at the top of the Tools - AutoCorrect dialog box. If it is not the same, either make it the same, or obtain or create an AutoCorrect file for that particular language. The best way to reset the language in text is to check the paragraph style of the text as it appears in the Applied Style box at left of the formatting toolbar (to the left of the current font name box), and then change the language appropriate in the paragraph style that appears by pressing F11, selecting the same paragraph style from the list, right-clicking it, selecting Modify, and changing the language under the Fonts tab. Jallan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] use fonts from /usr/lib/openoffice/fonts ONLY
On Tuesday 21 February 2006 10:55 am, Sebastian Röder wrote: Hi, I am new to the list. My question is how I can handle a very strict font management since I am from the DTP front and only want to use _some high quality_ fonts in OpenOffice. The idea is to deny OpenOffice to use any font from the Linux standard dirs like /usr/share/fonts and only use the fonts I installed with spadmin inside /usr/lib/openoffice/fonts/(truetype?)/. But I couldn't find an option to only permit this one dir, neither in the Path section nor in the Fonts section of the Options dialog. I use OOo-2.0.1 on Gentoo Linux. Thanks in advance for your help! Sebastian Font management is found in the Tools Options OpenOffice.org Writer Basic Fonts. I would suggest installing the high quality fonts you want first. Then go to the place I mentioned. Change the settings to the fonts you want to use. You can also manage your fonts by using styles. Each style has a Font tab where you can select the one you want to use with that style. In the documentation section of the OOo web site, there are manuals explaining how to use styles. In the German Section of this web site, there should be at least some of these manuals in German if you prefer. Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] disk space
On Tue, 2006-02-21 at 08:13, Joe Marks wrote: How much disk space does 2.0 require on a computer? When you can buy a 300Gb drive for $69.95, why would it matter? g Brewster -- ** W. Brewster Gillett [EMAIL PROTECTED] Portland, OR USA ** - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] [moderated]
I am not able to make changes to my database. It is as if it is in read only mode. I think I may have something linked to it, but if that is the case, I don't know how to fix the problem. Thanks for any help or sympathy! Larry Lockman
[users] Viewing equation for regression lines in charts
I am using version 2.0 of OpenOffice.org. My problem is that I cannot find how to display the equation for the linear regression on a chart. I am able to make the chart just fine, and I have no problem adding the regression line into the chart, I just can't see the values of the slope and y-intercept. I would appreciate a quick response if at all possible. Thank you very much for your time. Sincerely, Lindsay Willett - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] [moderated]
I have attempted to download your office program several times today. During download it seems to just stop. The icons apear on the desk top, but when I try to open or run them I get an error report saying that the file is damaged in it can not be opened. I will try to download it again tonight, but could you get back to me and let me know what you think I should do. How can I restart the download so I dont have to do it over again. Thanks, Christal Aberle - Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, more on new and used cars.
[users] Re: trouble opening wpd files
On Mon, 20 Feb 2006 18:06:01 -0500, G. Roderick Singleton wrote: On Mon, 2006-02-20 at 16:25 -0500, Steve Campbell wrote: I have version 2.0.1 of Open office and find it a very good program. However, I cannot open wpdd files. Is there something else I need to download? I hope you meant wpd files :-) I can say the 2.0.2rc2 opens wpd files very well under XP. Have not tried under Linux. So I suggest that you enter an issue into Issue Tracker as this is the best way to have requests such as this evaluated. wpd files open fine under Linux with ooo2.0.2 rc2. I can't comment on how close to the original they look as I no longer have WordPerfect. -- John [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Help! Where are the backup files?
On Tuesday 21 February 2006 01:09 pm, John Jordan wrote: On 22 Feb 2006, at 7:47, Paul wrote: What backup's do is copy the currently open file to a different location. For instance I'm working on file AB.odt in directory c:\mydirectory\ ... If I've got backup's turned on and working it will save a copy to c:\[OOo install dir]\..\backup in case the original gets corrupted. I _think_ (someone may have to confirm this) that the backup's disappear once you've closed the open file however. Not too sure there is another way of retrieving your file sorry... I've never had a corrupted file. But I've often inadvertently deleted a file or overwritten it. Just about every program I've ever used that has an automatic backup feature does it by always renaming the previously saved file as the backup and then doing a new save. Thus you've always got the old version in a backup folder. The way OO.o does it (assuming you're rght) is very dangerous. There is no security whatsoever for accidents. Wait ... on occasion OO.o Writer has crashed on me. When I restart it it always pops up a retrieve window. Where does it get that file from? Have you looked in your /home/jjj/tmp folder (directory) ? There should be some folders in it with some odd names. sv111.tmp and sv1fc.tmp are the names of a couple of mine. You may be able to find something in them. Have you tried Control+Z with this file open? Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I'm using MACOSX 10.3.9 OpenOffice 2.0 under X11 1.0 - XFree86 4.3.0
On Feb 21, 2006, at 11:09, Joe Hogan wrote: Hello, There are two possible sources of the problem that I can think of. First, the file from OOo is bad. Some credence is added to this thought since others are having the problem as well. Who do we contact on the OO team to verify the state of the downlaodable file? Second, a problem on your Mac. Perhaps the extracting program that turns the dmg into an image is at fault. Or there is another program that has changed or corrupted something on your Mac that causes the problem. Well, when looking at a DMG (disk image) is a system thing. I use it quite often while downloading other files. While it might be a problem, it does not seem to cause problem in any of my other downloaded files. Has anyone else had problems using DMG files other than OO? Joseph Joseph, It looks as though you have eliminated the second possible cause. That leaves the first. It could very well be a problem in the OOo file you downloaded, or the original dmg file on the OOo server. Some have suggested using the MD5 signature to check that the file downloaded correctly. (I am not conversant with doing so, but someone else in the thread did post instructions on how to do so.) If it did download correctly, then the problem may well be the file on the OOO server and you should contact someone on the site to check it. Ross Bernheim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Problems with Mail Merge
- I have Writer documents linked to MS Access databases. I can retrieve data from Access tables and queries, but not if those queries use functions. This functions are defined in the same mdb file where the queries are, and they work ok if I open them from Access, but not when called from OpenOffice. - I want to display data in the Writer document from two linked tables of the database. One of them (child) has a column which references the primary key of the other one (parent). I know how to get data from a single table or query but not from something like this. Thanks for your replies. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] default empty file for write/calc...
Hi, Hi Sebastian As you are not subscribed you may not have seen that: On Sat February 18 2006 05:12, Terry North wrote: Save the document you want opened as a template with File Templates Save, then open the Organizer where you get a button labelled Commands. You will find towards the end of the list of Commands Set as Default Template. You will need to set separate templates for Writer and Calc. Thank you very much. Next time I shall make my homework better. kind regards Sebastian - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Help! Where are the backup files?
On 21 Feb 2006, at 14:27, Steven Cox wrote: On Tue, 21 Feb 2006 14:13:42 -0500, Jallan [EMAIL PROTECTED] wrote: I know this thing is making automatic backups all the time, because sometimes it interrupts me while I am typing. I'll just go get the backup file. In Version 2 (I can't speak for other versions) you go to Tools - Options - Load/Save - General and check the box for always create backups. If you scroll up from Open/Save to OpenOffice.org and pick Paths you can see where it sends the backups. Ah. That solves the problem. I'm screwed for the one I lost, but that box is now checked. And I just did a save on another file and it now made a .bak version of it in the backup folder. So the only remaining question is, why the hell didn't the install utility have that box checked by default? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated]
Hi Larry, Larry Lockman [EMAIL PROTECTED] schrieb: I am not able to make changes to my database. It is as if it is in read only mode. I think I may have something linked to it, but if that is the case, I don't know how to fix the problem. Have you defined a row as primary key? I don't have a lot of experience with databases, but this is the reason in 95 % of the time, when someone can't access to his database. Thanks for any help or sympathy! Hope, this helps. Sigrid - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: md5sum idea
On Tuesday 21 February 2006 14:06, Paul wrote: Here is a link to some software which will calculate MD5's for Mac's : http://homepage.mac.com/nojiri/soft/mysoftsus.html It seems that Mac's natively prefer to use the _better_ (and no I don't want to start a flame war over this) method of SHA-1 but that's another story... It also seems that the MD5's are only available for the non-Neo release, found here: http://porting.openoffice.org/mac/md5sums.html I think this relates to how the projects are structured, but you'd have to ask someone from the Neo team where the MD5's can be found. /paul A lot of folks are dropping md5sum support because of a possible spoof that has been shown to work. SHA-1 hasn't been compromised in that manner (yet). On 2/22/06, Joe Hogan [EMAIL PROTECTED] wrote: Well, Thanks for forwarding me the links. I did a little reading, and this, unfortunately from what I read, does not help me at all:( The original problem was the inability to install OO on Mac OS X. The md5sum is LInux and Windows only:( Is there a version for Mac? Any new ideas? Joseph 2006/2/21, G. Roderick Singleton [EMAIL PROTECTED]: M. Hogan, This question should have been sent to the list. I happened to find it in my junk filter by accident. The information you have asked for is on http://download.openoffice.org/2.0.1/index.html near the bottom. Specifically, http://download.openoffice.org/2.0.1/md5sums.html I have copied the mailing list for you. On Tue, 2006-02-21 at 13:26 -0500, Joe Hogan wrote: Hello, Could you explain how the md5sum thing is done? I want to be able to eliminate all possibilities. I just find it odd that I can download anything and everything but OO. NeoOffice downloads fine... Thanks for letting be know how. (what software, and how do I go abotu it?) Joseph -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Cheers, Gene People having trouble with vz bouncing email to me should add the word 'online' between the 'verizon', and the dot which bypasses vz's stupid bounce rules. I do use spamassassin too. :-) Yahoo.com and AOL/TW attorneys please note, additions to the above message by Gene Heskett are: Copyright 2006 by Maurice Eugene Heskett, all rights reserved. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] disk space
because that matters when you are creating images for corporate cloning ? because some people would like to use older machines ? because he wanted to compare to other office packages/applications ? because he was simply curious ? i believe that was normal question :) wbg wrote: On Tue, 2006-02-21 at 08:13, Joe Marks wrote: How much disk space does 2.0 require on a computer? When you can buy a 300Gb drive for $69.95, why would it matter? g Brewster -- Rich - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Help! Where are the backup files?
So the only remaining question is, why the hell didn't the install utility have that box checked by default? That's a good question... I have a feeling that most folks don't want the backup file, although I've no idea why not. Perhaps it's just an oversight by the programmers, but there's probably a reason behing it. On Tue, 21 Feb 2006 15:57:01 -0500, John Jordan [EMAIL PROTECTED] wrote: On 21 Feb 2006, at 14:27, Steven Cox wrote: On Tue, 21 Feb 2006 14:13:42 -0500, Jallan [EMAIL PROTECTED] wrote: I know this thing is making automatic backups all the time, because sometimes it interrupts me while I am typing. I'll just go get the backup file. In Version 2 (I can't speak for other versions) you go to Tools - Options - Load/Save - General and check the box for always create backups. If you scroll up from Open/Save to OpenOffice.org and pick Paths you can see where it sends the backups. Ah. That solves the problem. I'm screwed for the one I lost, but that box is now checked. And I just did a save on another file and it now made a .bak version of it in the backup folder. So the only remaining question is, why the hell didn't the install utility have that box checked by default? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Steven Cox Mectek - Inetprime www.inetprime.net - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: md5sum idea
Well, Thanks for forwarding me the links. I did a little reading, and this, unfortunately from what I read, does not help me at all:( The original problem was the inability to install OO on Mac OS X. The md5sum is LInux and Windows only:( Is there a version for Mac? Any new ideas? Joseph 2006/2/21, G. Roderick Singleton [EMAIL PROTECTED]: M. Hogan, This question should have been sent to the list. I happened to find it in my junk filter by accident. The information you have asked for is on http://download.openoffice.org/2.0.1/index.html near the bottom. Specifically, http://download.openoffice.org/2.0.1/md5sums.html I have copied the mailing list for you. On Tue, 2006-02-21 at 13:26 -0500, Joe Hogan wrote: Hello, Could you explain how the md5sum thing is done? I want to be able to eliminate all possibilities. I just find it odd that I can download anything and everything but OO. NeoOffice downloads fine... Thanks for letting be know how. (what software, and how do I go abotu it?) Joseph -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/
Re: [users] Help! Where are the backup files?
On 21 Feb 2006, at 13:17, Dan Lewis wrote: Have you looked in your /home/jjj/tmp folder (directory) ? There should be some folders in it with some odd names. sv111.tmp and sv1fc.tmp are the names of a couple of mine. You may be able to find something in them. Have you tried Control+Z with this file open? Thanks for the suggestion. There is a folder in /tmp that looks like what you described. But inside it are just half a dozen very small files, all with a time stamp that could not possibly have anything to do with the lost file. And yeah, I did try a Ctrl-z, and also looked at the Edit Undo menu, but a file save is apparently not undoable. The file is lost. I do have a paper printout copy that I made yesterday, so it's not a total disaster. More importantly, Steven Cox knew what was wrong -- the checkbox for Always Make Backups was not checked. It is now, so this will not happen again. However, I know I never unchecked that box. That means that the installation utility leaves that box unchecked by default. That is very bad. I don't like the Windows way of holding the user's hand all the time, but something like this defnitely should be the default. Thanks to all for the suggestions and help. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] disk space
How much disk space on XP Home Edition in a normal installlaion? Is there any options so less space is required? Joe Marks [EMAIL PROTECTED] wrote: How much disk space does 2.0 require on a computer? - Brings words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail. - Relax. Yahoo! Mail virus scanning helps detect nasty viruses!
Re: [users] OS X install problems
On Feb 19, 2006, at 18:56, Rod Engelsman wrote: I think Chad has a very defensible position in this argument. Exactly WHY does the project continue to beat this X11 horse for the Mac port? That would be almost exactly like having a port of OOo for Windows that is the Linux version tweaked to run under Cygwin. Or a Linux version that is really a Windows program tweaked to run under Wine. It makes no sense to me. Especially since the only point of debate between the Neo and the OOo for Mac crowd seems to be the licensing. Who cares? The only reason that OOo is LGPL instead of GPL is so that Sun can use the code in StarOffice. If Sun has no ambitions to release a Mac port of StarOffice then I fail to see what's driving the conflict. As it stands, neither side can keep up with the main development of OOo Win-Lin. I don't use a Mac, so I don't really have a dog in this fight but from my perspective it all looks pretty silly. NeoOffice/J has two problems in keeping up. Few developers, as good as they are, and that they have to wait for a version of OOo to be released or close to being finalized before they can really start doing much of the conversion. This usually puts them at least a version behind OOo. OOo only has the porting to Mac and X11 to worry about and so are usually a bit ahead of NeoOffic/J in getting the current version of OOo out. For people who only use the Mac, NeoOffic/J is a great choice as it is more Mac like and uses the Mac open and save dialogs and printing as well as the Mac's font sytem. For those who use different operating systems, OOo 2.x is much more similar to what they are used to on other platforms. OOo 2.x also can use the open document file format. OOo 2.x can read and write the odf format while NeoOffice/J in its latest version can read the odf but not write to it. Both the OOo and NeoOffice/J teams have slightly different visions. The marvelous thing is that they can both follow their visions and we all benefit from their generous efforts. Thank you gentlemen and ladies. Ross Bernheim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Help! Where are the backup files?
So you opened up file A, made changes, then 'accidentally' did a save. Now you want the version of A to be in your backup's prior to the changes you made. Unfortunately it won't be there. When you hit 'save' it wrote your changes to the file named A (I think in your case it was titled : Ex_Chapt_12.odt). What backup's do is copy the currently open file to a different location. For instance I'm working on file AB.odt in directory c:\mydirectory\ ... If I've got backup's turned on and working it will save a copy to c:\[OOo install dir]\..\backup in case the original gets corrupted. I _think_ (someone may have to confirm this) that the backup's disappear once you've closed the open file however. Not too sure there is another way of retrieving your file sorry... /paul On 2/22/06, John Jordan [EMAIL PROTECTED] wrote: OO.o 1.9-something, Ubuntu-64 Breezy. K, I screwed up just now. I opened a homework file for Chapter 12 of the textbook we are using in one of my classes (Ex_Chapt_12.odt), intending to use it as a template to start doing the homework for Chapter 13. I deleted all but the first page information, intending to do a Save As under the name Ex_Chapt_13. But without thinking I hit Ctrl-s. Oops! No problem, I thought. I know this thing is making automatic backups all the time, because sometimes it interrupts me while I am typing. I'll just go get the backup file. I assumed that every time I did a Save it deleted the old backup file, then renamed the previously saved copy as the new backup. So I carefully did a Save As of the open document to Ex_Chapt_13.odt, then opened the file manager to look for the backup file. Nothing. Nada. Not there. According to Options the backup files are supposed to be in /home/jjj/.openoffice.org2/backups. The folder is there, but it is empty. I searched the entire disk from the root forward for Ex_Chapt_12*.*. No backup files. All I found was the newly saved version. Evidently automatic backup doesn't automatically make backups. What does it actually do? As far as I can tell it does nothing at all. And can someone tell me if there is any way to retrieve the old version of this file? And what can I do to prevent this sort of thing from happening again? This setup is very dangerous. - 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] Cursor not saved to last position
On Wed, 2006-02-22 at 01:13 +1100, Ross Johnson wrote: On Tue, 2006-02-21 at 08:48 -0500, G. Roderick Singleton wrote: On Tue, 2006-02-21 at 09:48 +0100, Thomas Lange wrote: Hi all, Sorry, I should have mentioned I'm using 2.0.1, and yes, I have all my user information filled in. It's very strange. As to your supposed problem, please try setting the following: Tools Options OpenOffice.org View with any settings you personally need that are different from the default. For example, Restore Editing view. For detail, click Help on the dialogue box Help button and follow the links. There's a curious sentence in Help for Restore Editing view, which says that Write documents always open on page 1. So whatever has changed seems to have warranted a conscious statement in Help. Help is being updated constantly. If you think the wording is incorrect, I suggest that you enter an Request for Enhancement (RFE) into Issue Tracker as this is the best way to have requests such as this evaluated. If you haven't already registered, do the following: 1. To file an issue you must register with OOo by clicking the My Pages tab and selecting the Register link http://www.openoffice.org/servlets/Join 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 My Pages tab from which you can file and find issues. Thanks for bringing this to our attention. It is important that you file any examples with the issue to ensure your need is understood. ... Up to yesterday, whenever I called up a file it came up with the cursor at the last position it had been at. Since this morning, the cursor is at the very top of each document, whether old or new, when I call up the document. Which version are you using? 2.0 or 1.1.5? Have you entered your user-informations in the OOo-dialogue? Your name is necessary in OOo 2.0.x. Additionally, you'll have to select Recovery | Edit-view (or something similar - since I'm using only the German version) under Tools - Options. Hope this helps you. I don't know with which version the behaviour changed. OpenOffice used to always store the cursor position when the douments view was closed and restored the view to that position when it was opened. I also liked this a lot because it was an easy way to have a 'bookmark' of the position where to continue with reading. Unfortunately at some point it was decided that this is not what the average user would want because reading should start from the first page. So now the the documents always gets opened with the view on the first page. That is unless you are the author! In that case the last position is used because it was assumed the author usually want's to continue writing the document. That's why it should be essential if the your user info matches the one stored with the document. Unfortunately there also was no option introduced to allow the user to customize this behaviour. The only thing done was to introduce a keyboard shortcut (I think it was sth like Shift-F5) to return the cursor to the last editing position which should be pretty much what you and I wanted to have by default. I personally still would prefer the old solution though. :-/ Regards, Thomas - 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] -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] How to access MySQL DB from Open Office for a report
I'm a relative newbie to MySQL, but have been using OO for some time. Just upgraded to OO 2.x and installed MySQL 5.0.X (neither are beta versions). I have several MySQL databases, and would like to use OO to generate reports from those existing databases, but am unable to connect to the DBs. Both are nothing fancy, just single tables. I've followed the spartan directions in OO Help, and the ODBC and JODBC connections indicate they're loaded. I've searched the MySQL and OO web sites for specific assistance, but can't find anything that helps. Can anyone here point me in the right direction? Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] I can't solve for myself...
Hello! I am very grateful for the help you provide when I post my doubts in the list. My knowledge of OO improve a lot with your help. Whoever I am working in a spreadsheet and have a problem that I can't solve for myself. My spreadsheet is to count the items stored in a warehouse: I have a type of spreadsheet to add items to the stock in the warehouse, and other type of spreadsheet to remove items from the warehouse. So in the new spreadsheet I have: SHEET 1 - A list with all the possible items in the stock; SHEET 2 - Must read the files with the items added to the warehouse; SHEET 3 - Must read the files with the items removed from the warehouse; SHEET 4 - Must calculate the stock of items in the warehouse; SHEET 1: AB 1 Ref. P1 Description of P1 Z Ref. Pz Description of Pz SHEET 2: A B C DX 1 Ref. P1 Description of P1Quant. added of P2 (File A1) Total Ad of P1 2 Ref. P2 Description of P2Quant. added of P2 (File A1) Quant. added of P1 (File A2)Total Ad of P2 3 Ref. A3 Description of P3Quant. added of P3 (File A1) Quant. added of P3 (File A2) Total Ad of P3 N Ref. An Description of PnQuant. added of Pn (File A1) Total Ad of Pn Z Ref. Az Description of PzQuant. added of Pz (File A1) Quant. added of Pz (File A2) Total Ad of Pz SHEET 3: AB C D X 1 Ref. P1 Description of P1Quant. rmd of P2 (File A1) Total Rm of P1 2 Ref. P2 Description of P2Quant. rmd of P2 (File A1) Quant. rmd of P1 (File A2)Total Rm of P2 3 Ref. A3 Description of P3Quant. remd of P3 (File A1) Quant. rmd of P3 (File A2) Total Rm of P3 N Ref. An Description of Pn Total Rm of Pn Z Ref. Az Description of PzQuant. rmd of Pz (File A1) Quant. rmd of Pz (File A2) Total Rm of Pz SHEET 4 AB C 1 Ref. P1 Description of P1Total Ad of P1 - Total Rm of P1 2 Ref. P2 Description of P Total Ad of P2 - Total Rm of P2 3 Ref. A3 Description of P3Total Ad of P3 - Total Rm of P3 N Ref. An Description of Pn Total Ad of Pn - Total Rm of Pn Z Ref. Az Description of PzTotal Ad of Pz - Total Rm of Pz My problem is to write a formula that find a product, eg A3, in the file A1 and put the quantitie in in the correct line in SHEET 1. And the same for the files with the products removed. I hope my explanation (and my English) are good enough to you understand this problem. All the help will be very welcomed! Regards, EVarejão - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Styles don't match
Jonathon Blake wrote: Joe wrote: What I would like is something like a More Information button, etc. that would detail for me exactly what's not the same so I can make an informed decision. To do that, OOo would have to run a comparison of the styles as found in the document, and the styles as found in the template, then write out those differences. Depending upon those differences, the end user may, or may not understand their significance. xan jonathon -- Ethical conduct is a vice. Corrupt conduct is a virtue. Motto of Nacarima. I'm sure some of it might get pretty cryptic, but there must be some way to figure out what it's doing. I'm going to run a before and after file comparison next time it happens and see if that tells me anything. Then, maybe I'll have a clue about what's going on. Joe - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Restarting the numbering at 1
I have several numbered lists in a document. If I select the paragraphs that make up each list (one-at-a-time) and click on the adds or removes numbering icon, each list starts with 1, However, I don't know how to get the numbers right-justified or to control the spacing. If I define a numbered style so I can get right-justification and spacing, I can't get each list to start at 1. There's gotta be something simple I'm overlooking, right? Thanks. -- Pete Holsberg Columbus, NJ Treat everyone the way you want to be treated. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Impress continous sound Issue
I downloaded with dial up the latest version off OOo (twice on account that the first time when attempting install got an error message telling me install file corrupt. 2nd download of six hours worked. Guessyou get that some times) I have installed OOo 2.02 in the hope that the continuous sound issue in Impress had been addressed. If it has, I am unable to find how. Can anyone help? For my needs this feature is absolutely imperative and renders the program useless to me without it. I wish to run a series of slides with lyrics tosongs with the appropriate backing sound tracks. Sadly the sound file cuts out on changing to the second slide. Although disappointed with this one aspect, I appreciate the efforts of the program creators and am enjoying 'Writer' with no complaints. Thanks, Andy
[users] [moderated]
I have been using Open Office 2.0 since shortly after it was introduced. Before that, I used Open Office 1.5. In the past, I had no problems using the Insert Envelope feature in Open Office Writer. About a month ago, it ceased to work for me. Today, I uninstalled Open Office 2.0 (including the deletion of all remnants not taken care of by the uninstall). Then I installed Open Office 2.0.1. The Insert Envelope feature in Open Office Writer still will not work. It takes the setup, goes through the printing process, kicks out the envelope, but no printing occurs. Can you offer any suggestions? I hate to revert to Microsoft Word when I want to print an envelope. Thanks! J L Merrill Frederick, OK, USA
[users] [moderated]
Hello. I am called Javier Crespo, I am usuary of you for , the only detail that and is a year not managed to install the packages of dictionaries, would please me to know if the possibility exists that offers support me to respect, Thanks and so long... - Administradora de Servicios Planinsa Javier Crespo Auxiliar en Tecnología y Sistemas Master: +58(212) 205.50.11 Telf Directo: 205-50-66: Right Fax: 205-51-90 Ext: 255 Visite Nuestra Pagina Web: http://www.planinsa.com www.planinsa.com ---
Re: [users] Making Address Labels
kboesen wrote: I've been trying to create address lables from an existing Microsoft Excel file. From your help info I get to line #12 fairly easy. When I click on the Data to Fields icon the data from my Excel spreadsheet does not appear in the Avery 5160 label display. What am I doing wrong? Do you have any suggestions? Thanks, Ken B. How did you get the address fields into your label(s)? If you dragged and dropped them from your data source headers it should work fine: maybe you used another method and a typo occurred. The most common reason for data not to transfer to fields is when a mismatch between the data source and the fields occurs. Peter HB - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated]
On Tue, 2006-02-21 at 14:43 -0600, J L Merrill wrote: I have been using Open Office 2.0 since shortly after it was introduced. Before that, I used Open Office 1.5. In the past, I had no problems using the Insert Envelope feature in Open Office Writer. About a month ago, it ceased to work for me. Today, I uninstalled Open Office 2.0 (including the deletion of all remnants not taken care of by the uninstall). Then I installed Open Office 2.0.1. The Insert Envelope feature in Open Office Writer still will not work. It takes the setup, goes through the printing process, kicks out the envelope, but no printing occurs. Can you offer any suggestions? I hate to revert to Microsoft Word when I want to print an envelope. Have you tried using the Kit? See http://documentation.openoffice.org/HOW_TO/ -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Impress continous sound Issue
To my knowledge it doesn't do it yet, and there's very little traffic in the issue tracker of the Graphics Project for it. I'd be in heaven if it did! On Tue, 21 Feb 2006 17:04:10 -0500, Andy [EMAIL PROTECTED] wrote: I downloaded with dial up the latest version off OOo (twice on account that the first time when attempting install got an error message telling me install file corrupt. 2nd download of six hours worked. Guess you get that some times) I have installed OOo 2.02 in the hope that the continuous sound issue in Impress had been addressed. If it has, I am unable to find how. Can anyone help? For my needs this feature is absolutely imperative and renders the program useless to me without it . I wish to run a series of slides with lyrics to songs with the appropriate backing sound tracks. Sadly the sound file cuts out on changing to the second slide. Although disappointed with this one aspect, I appreciate the efforts of the program creators and am enjoying 'Writer' with no complaints. Thanks, Andy -- Steven Cox Mectek - Inetprime www.inetprime.net - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Unsubscribe problem
On Tue February 21 2006 09:20, pop.wanadoo.fr wrote: Hi, I do need no longer help on OO and the number of messages is quit important I would like to unsubscribe. Doing like is said on sending an empty email seems not to work. I did receive the reply in order to confirm my unsubscription, but it seems not to work and I receive failiure messages. You have to REPLY to the confirmation REQUEST. -- 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] Saving work in Impress
On Mon February 20 2006 16:15, + Gene wrote: I am using Open Office Ver. 2.0 It seems that when saving or resaving updated work in Impress, I get an error message trying to save, and have to File/Save/ resave a second time for it to take. The second time always works okay. Hi Gene, So what is the error message ? 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] Extra Features in Word Documents with OO 2.0.1
On Tue February 21 2006 00:32, [EMAIL PROTECTED] wrote: [ MODERATED ] *** Thankyou I will try both options. If this problem is present in the official version and the 2.0.2 version what processes do I need to go through to raise a change request to get the problem considered for rectification. You report problems in issuezilla : http://openoffice.org - My Pages - Register, then when you receive a confirmation email, Login and File an issue In this way the relevant developers will see your bug report / suggestion and you will also see the progress of this feature / bug report if it is accepted. 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]
[users] Re: Applying function returns to cell addresses
On Tue, 21 Feb 2006 12:02:13 +1100, Ross Johnson wrote: On Mon, 2006-02-20 at 18:52 -0500, Paul_B wrote: On Sun, 19 Feb 2006 20:27:22 -0500, Paul_B wrote: On Mon, 20 Feb 2006 09:31:28 +1100, Ross Johnson wrote: On Sun, 2006-02-19 at 15:29 -0500, Paul_B wrote: On Sun, 19 Feb 2006 10:59:58 -0600, Rod Engelsman wrote: Paul_B wrote: Is there any way to set up a multiple case logic test? Currently I have =IF(B27=;;B27-(14.325+(E$25-70.35)*0.28)) as a formula in a column of cells. It tests another column's cell, if it's empty the result is null, otherwise a tax approximation kicks in. However, I'd like to allow for a few tax brackets. To do so I'd need to account for the null possibility plus three other possible number ranges (as income increases, a different tax formula should be invoked). Currently I don't see how this is possible. Thanks, paul You can use nested IF() statements. =IF(B27=;;IF(B27=... Ahh. Ok, thanks. Hadn't thought of that. A case select command would be nice, but this should do what I need. Have you tried using lookup tables for this kind of thing. Functions: LOOKUP, VLOOKUP etc in Help. I use them for this purpose in my own tax sheets and they work. That indeed looks like it would do it, as it amounts to a powerful case select statement. Should be interesting working out the details. Will get on this maybe tomorrow. Thanks much, Paul Ok, I'm trying to set this up. Is there any way to use a function's return as part of a cell address? For instance: =MATCH($E$26;$H$3:$H$8) finds the row in which the H column matches cell E26. but =G(MATCH($E$26;$H$3:$H$8)) doesn't work. I want to find the row which contains the value searched for, and then use that number in the address of another value, here found under column G. Use something like =INDIRECT(GMATCH($E$26;$H$3:$H$8)+2) But LOOKUP does this for you. E.g. = LOOKUP($E$26;$H$3:$H$8;$G$3:$G$8) You definitely know your stuff, The INDIRECT formula is awesome, and you even caught the need for an offset of 2 in my MATCH formula. I was getting LOOKUP to return the row number, as does your formula above, but only because I set up column G to contain that data. But how then would I use the returned row number to specify which cells to poll for the tax data? That's where I'm stuck. Using the INDIRECT formula, I came up with =IF(B26=;;B26-( INDIRECT(iMATCH($E$25;$H$3:$H$8)+2) +INDIRECT(jMATCH($E$25;$H$3:$H$8)+2)*($E$25-LOOKUP(E$25;$H$3:$H$8;$H$3:$H$8 which successfully takes the income in B26 and then subtracts off the base tax and incremental tax bracket tax. But this is very unwieldy. If LOOKUP can do this directly, it would be a big improvement. Thanks, Paul -- Using OOo 2.0 on Win XP sp2. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated]
Hi Javier, Javier Crespo [EMAIL PROTECTED] schrieb: Hello. I am called Javier Crespo, I am usuary of you for , the only detail that and is a year not managed to install the packages of dictionaries, would please me to know if the possibility exists that offers support me to respect, Thanks and so long... Can you describe, what you've done? Which version of OOo are you using? If you're using version 2.0, go to File | Wizards | More dictionaries. Select the language and then follow the instructions. Please be sure, that a connection to the internet exists. If you prefer to do an offline-installation, please download this file http://epm.mine.nu/ooodic (provided by the German NL-team) which contains all existing dictionaries. Then run File | Wizards | More dictionaries and then select offline installation. Hope, this helps. Sigrid PS: The given link to the file works only for OOo 2.0 (and above) it won't work for OO.o 1.1.x! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Converting to HTML using Styles
On Sat February 18 2006 18:37, Pete Holsberg wrote: CPHennessy wrote: On Wed February 15 2006 16:34, Pete Holsberg wrote: I have a Heading 1 style defined in OO and when I do a Save As HTML, I get this: H1 { margin-top: 0.2in; margin-bottom: 0.08in; background: transparent; color: #00; text-align: center; text-decoration: none; page-break-before: auto } H1.western { font-family: Arial, sans-serif; font-size: 20pt } H1.cjk { font-family: MS Mincho; font-size: 16pt } H1.ctl { font-family: Tahoma; font-size: 16pt } What are the cjk and ctl classes? Where did they come from? They don't seem to be used anywhere in the HTML file; can I delete them without adverse effects? I think that they are probably related to Chinese characters. Also you may find that Export As - XHTML may be better. I did that with an ODT that had a picture, a table of contents and a couple of ordinary tables. The picture never got to the XHTML file. The page numbers were missing from the TOC. All of the tables were shmooshed against the LH margin so much that their LH border was cut off. Did I do something wrong? It does not sound like it. But what version of OpenOffice.org are you using ? Thanks. And for the record, I wasn't chiding you! :-) I did not think that you were. -- 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] Cursor not saved to last position
On Tue, 2006-02-21 at 11:18 -0500, G. Roderick Singleton wrote: On Wed, 2006-02-22 at 01:13 +1100, Ross Johnson wrote: On Tue, 2006-02-21 at 08:48 -0500, G. Roderick Singleton wrote: On Tue, 2006-02-21 at 09:48 +0100, Thomas Lange wrote: Hi all, Sorry, I should have mentioned I'm using 2.0.1, and yes, I have all my user information filled in. It's very strange. As to your supposed problem, please try setting the following: Tools Options OpenOffice.org View with any settings you personally need that are different from the default. For example, Restore Editing view. For detail, click Help on the dialogue box Help button and follow the links. There's a curious sentence in Help for Restore Editing view, which says that Write documents always open on page 1. So whatever has changed seems to have warranted a conscious statement in Help. Help is being updated constantly. If you think the wording is incorrect, I suggest that you enter an Request for Enhancement (RFE) into Issue Tracker as this is the best way to have requests such as this evaluated. ?? I wasn't suggesting that - just the opposite. OOo2.0.1 does exactly what the Help says, but this thread is saying that the behaviour has changed from earlier versions. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to access MySQL DB from Open Office for a report
On Tue February 21 2006 15:55, Bob wrote: I'm a relative newbie to MySQL, but have been using OO for some time. Just upgraded to OO 2.x and installed MySQL 5.0.X (neither are beta versions). I have several MySQL databases, and would like to use OO to generate reports from those existing databases, but am unable to connect to the DBs. Both are nothing fancy, just single tables. I've followed the spartan directions in OO Help, and the ODBC and JODBC connections indicate they're loaded. I've searched the MySQL and OO web sites for specific assistance, but can't find anything that helps. Can anyone here point me in the right direction? Did you follow the directions on http://dba.openoffice.org ? -- 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] Adding Postnet Bar Code to letter writer
On Mon February 20 2006 17:27, + [EMAIL PROTECTED] wrote: I really love the product and have no complaint.., but is there a way you could program it to print Postnet (62 bar) codes.These come in real handy for anyone generating letter mail from the system. I am not a programmer so I'm not able to do this but it is a suggestion to the rest of the eager young minds. The post office has books that explain generation of these codes in detail. This is not to say it would LOOK UP a Zip Code. The writer would simply input the proper 9 digit bar code and the system would change it to an 11 digit (62 bars) bar code. Please put this suggestion out to your people. Thank you Hi Betty, Please read all of the following before downloading anything : As you are not subscribed you may not have seen that: On Tue February 21 2006 07:17, Ross Johnson wrote: Hi Betty, I'm currently looking at adding barcodes to a database project using OOo (forms, label printing etc). I understand that all I need are appropriate barcode fonts, and these can easily be installed so that OOo can use them. I'm about to test it, so I haven't confirmed anything yet. There are lots of free barcode font sets on the web of various quality. There are also commercial font sets. E.g.: Take a look at this tutorial on installing barcode fonts for OpenOffice/StarOffice: http://www.idautomation.com/openoffice/ A quick Google search turns up the following PostNet barcode font sites: Commercial fonts: http://idautomation.com/fonts/postnet/ many others sites as well Free fonts: http://www.popularshareware.com/POSTNET-Barcode-Fonts-download-3102.htm l I was duped with this last link by the shareware notion of 'free', which must be interpreted as 'free download' of a demo or crippled version of a commercial product for which you must pay to use. However, to make up for it, I've tracked down a real 'free' Postnet barcode font. The following web page lists many sources of bar code fonts: http://www.adams1.com/pub/russadam/fonts.html and in the Postnet group there is at least one set: A Postnet TTF - author unknown. which is unconditionally free. This is a TrueType font and I ahve successfully installed it for use in my copy of OOo on Linux. The chances are that you are on Windows, so you should be able to install it following the instructions for installing fonts that come with Windows. I assume that once you've done that and shutdown all OOo windows and restarted them, the font will appear in the font list. You will need to turn off the font preview mode that OOo turns on by default in order to see the font name listed - otherwise this font set will appear as a blank entry in the list. In OOo2: Go to: Tools Options OpenOffice.org View Under 'Font Lists', uncheck 'Show preview of fonts'. In OOo1: Go to: Tools Options General View Under 'Font Lists', uncheck 'Show preview of fonts'. Now, you can type some numbers, select them, then change the font and Voila! Postnet barcode (almost - but not yet). You can't put this on your envelope as it is. The barcode on the envelope needs some additional information embedded in it. The first piece of additional information is a check digit, which is calculated from the postal code as follows (anyone, please feel free to correct this - although I know there is other info you can add, this is the simplest valid form): Postal code: '12345' (say) Sum the digits: 1+2+3+4+5 = 15 Calculate the number that you need to add to this number to make the last digit of the sum a zero (0). That is, 15 + ? = ?0 The answer in this case is: 5 I.e. 15 + 5 = 20 Add this number to the postal code as the last digit. Postnet sequence is now: 123455 Finally, wrap the digit sequence in square brackets. Your final text for the Postnet barcode is now: [123455] When you format this text using the Postnet barcode font, you will have your Postnet barcode. E.g. Type [123455] into Writer, select the whole [123455] text and change the font to the Postnet barcode font that you just installed. Your only problem now is where to calculate this sequence, and how to put it on your envelope. Perhaps others can help out with that if you need it, but if you use a database or spreadsheet to store your address list, then that is one place you could do it. I.e. have a Postnet sequence column with the addressee's pre-computed Postnet code stored there, or compute it on-the-fly, perhaps as part of a database query. This way, no OOo macros are required. One last thing. You mentioned using 9 digit Postnet codes. This will be the 5 digit zip plus 4 digit suffix. I don't know what the suffix is (I'm in Australia), but the rule is the same. Add all 9 digits, find the check digit (sum + check = ?0), append that digit to make 10 digits.
Re: [users] Re: Re: Applying function returns to cell addresses
On Tue, 2006-02-21 at 10:38 -0500, Paul_B wrote: On Tue, 21 Feb 2006 13:57:40 +1100, Ross Johnson wrote: On Mon, 2006-02-20 at 20:44 -0500, Paul_B wrote: On Tue, 21 Feb 2006 12:02:13 +1100, Ross Johnson wrote: On Mon, 2006-02-20 at 18:52 -0500, Paul_B wrote: On Sun, 19 Feb 2006 20:27:22 -0500, Paul_B wrote: On Mon, 20 Feb 2006 09:31:28 +1100, Ross Johnson wrote: On Sun, 2006-02-19 at 15:29 -0500, Paul_B wrote: On Sun, 19 Feb 2006 10:59:58 -0600, Rod Engelsman wrote: Paul_B wrote: Is there any way to set up a multiple case logic test? Currently I have =IF(B27=;;B27-(14.325+(E$25-70.35)*0.28)) as a formula in a column of cells. It tests another column's cell, if it's empty the result is null, otherwise a tax approximation kicks in. However, I'd like to allow for a few tax brackets. To do so I'd need to account for the null possibility plus three other possible number ranges (as income increases, a different tax formula should be invoked). Currently I don't see how this is possible. Thanks, paul You can use nested IF() statements. =IF(B27=;;IF(B27=... Ahh. Ok, thanks. Hadn't thought of that. A case select command would be nice, but this should do what I need. Have you tried using lookup tables for this kind of thing. Functions: LOOKUP, VLOOKUP etc in Help. I use them for this purpose in my own tax sheets and they work. That indeed looks like it would do it, as it amounts to a powerful case select statement. Should be interesting working out the details. Will get on this maybe tomorrow. Thanks much, Paul Ok, I'm trying to set this up. Is there any way to use a function's return as part of a cell address? For instance: =MATCH($E$26;$H$3:$H$8) finds the row in which the H column matches cell E26. but =G(MATCH($E$26;$H$3:$H$8)) doesn't work. I want to find the row which contains the value searched for, and then use that number in the address of another value, here found under column G. Use something like =INDIRECT(GMATCH($E$26;$H$3:$H$8)+2) But LOOKUP does this for you. E.g. = LOOKUP($E$26;$H$3:$H$8;$G$3:$G$8) You definitely know your stuff, The INDIRECT formula is awesome, and you even caught the need for an offset of 2 in my MATCH formula. I was getting LOOKUP to return the row number, as does your formula above, but only because I set up column G to contain that data. But how then would I use the returned row number to specify which cells to poll for the tax data? That's where I'm stuck. Using the INDIRECT formula, I came up with =IF(B26=;;B26-( INDIRECT(iMATCH($E$25;$H$3:$H$8)+2) +INDIRECT(jMATCH($E$25;$H$3:$H$8)+2)*($E$25-LOOKUP(E$25;$H$3:$H$8;$H$3:$H$8 which successfully takes the income in B26 and then subtracts off the base tax and incremental tax bracket tax. But this is very unwieldy. If LOOKUP can do this directly, it would be a big improvement. Hey. Compliments always work :) I guess this has turned into a bit of a tutorial on lookup tables now. I assume your tax brackets are structured the same as mine, i.e a table like this (top left at cell H3): 0 0 0 Tax free threshold 1 1 0 0.15$0 plus $0.15 for each $ over $1 2 3 15000.25 4 5 65000.30 6 8 95000.35 9 2 0.45$2 plus $0.45 for each $ over $9 $9 is the top threshold. If you don't have a tax-free threshold where you are then you can see how the table would change. The second column isn't actually needed in the formulae. Tax: =IF(B260;0;LOOKUP(B26;$H$3:$H$7;$J$3:$J$7) +(B26-LOOKUP(B26;$H$3:$H$7;$J$3:$J$7)) *LOOKUP(B26;$H$3:$H$7;$K$3:$K$7)) Of course, the formula is a lot simpler if you store the base tax amount for your income in another cell. Base Tax: B27 =LOOKUP(B26;$H$3:$H$7;$J$3:$J$7) Tax: =IF(B260;0;B27+(B26-B27)*LOOKUP(B26;$H$3:$H$7;$K$3:$K$7)) I give no warranty that these formulae won't get you a jail term :) Wow, it's so simple once I see it. I was missing the obvious step of looking up the tax bracket floor again and subtracting it from the actual income, in preparation for multiplication by the incremental rate. Thanks very much for taking the time to lay this out. Hopefully others have gained from it as much as I. Thanks for spotting the error. I incorrectly subtracted the base tax from the income instead of the income threshold for that tax. The simplified version I gave is also invalid then. The formula should be (for completeness): Tax: =IF(B260;0;LOOKUP(B26;$H$3:$H$8;$J$3:$J$8) +(B26-LOOKUP(B26;$H$3:$H$8;$H$3:$H$8)) *LOOKUP(B26;$H$3:$H$8;$K$3:$K$8)) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional
Re: [users] Can't open the program
On Sun February 19 2006 22:06, + klm3013 wrote: [ MODERATED ] *** Every time I try to open the progran (OpenOffice 2.0), just downloaded today, it tries to install itself. I want to try it, and if I like it, I will be making a contribution. Hi Ken, To try it you will obviously have to install it. Then you can start it from Start - Programs - OpenOffice.org - Writer 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] [moderated]
On Tue, 21 Feb 2006 17:15:16 -0600 Kevin Rood [EMAIL PROTECTED] wrote: I was wondering if there is a way to change the default margins in the Writer so that you do not have to change them every time you open the Writer. Currently the default is .79; however, I always use 1 margins. I would like it if I don't have to change the margins to 1 every time I open the Writer. Thanks, Kevin Rood - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This is very easy to do. You just need to modify your Default template. In writer, click the down arrow next to the New icon and select Templates and Documents. This will open a blank document. Get the margins, fonts, paper size etc. the way you like it then go File- Documents Templates- Save. Highlight the Template icon, select My Templates and save as Default From now on, every time you open a new document that default template will be used. -- God bless you, Keith Bates 4 Mooloobar St Narrabri NSW 2390 Phone: 02 67924890 Fax: 02 67925418 www.new-life.org.au If you don't have a reason to live JESUS IS THE ANSWER! Ask him into your life today... He really does make a difference. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] My open office crashed!
On Mon February 20 2006 07:32, + [EMAIL PROTECTED] wrote: I wasn't on-line at the time. I just recently downloaded the new Open Office. I was creating my first word processing document last night, when I pointed to clicked on Zoom. That crashed the document. Open Office backed itself up, though, and I was able to get right back into it even though I hadn't saved it previously -- very smooth backup, I like that. But the program asked me to contact you and let you know, and I had to wait until I was back on-line to do so. Also, I thought I would let you know that I am an extremely fast typist and find the program to be slower than I type, so if you're looking for suggestions I would suggest speeding it up. And I opened a document that had been e-mailed to me in Microsoft Word from a doctor, and the letterhead part of his stationery came out weird. Can anybody tell me how to fix that? Not that I'm complaining; hey, it's free. My computer came with Microsoft Works and THAT program won't open Word documents at all! So I'm happy. But you did ask for feedback. Hi Ellen As you are not subscribed you may not have seen that: On Mon February 20 2006 19:40, Jallan wrote: [EMAIL PROTECTED] wrote: I wasn't on-line at the time. I just recently downloaded the new Open Office. I was creating my first word processing document last night, when I pointed to clicked on Zoom. That crashed the document. Open Office backed itself up, though, and I was able to get right back into it even though I hadn't saved it previously -- very smooth backup, I like that. But the program asked me to contact you and let you know, and I had to wait until I was back on-line to do so. That message refers to allowing the program itself to send crash data to OpenOffice.org. If you are not on line, of course you cannot do it, at least not without leaving that message up until you are on line again. You will get such messages in event of a crash. If you are on line, then you click to send the crash information if you wish. Otherwise, don't worry. Also, I thought I would let you know that I am an extremely fast typist and find the program to be slower than I type, so if you're looking for suggestions I would suggest speeding it up. OpenOffice modules are noticeably slower in coming up than many other programs, but a complaint about slowness in data input is unusual. Perhaps you could provide information on the OS you are using. There was earlier a similar complaint about an earlier version of OpenOffice.org Writer. See http://www.openoffice.org/issues/show_bug.cgi?id=34401 , apparently fixed. Possibly something has slowed it down again, at least on some systems. If on most systems input is accepted more rapidly than most people can type, such a slowdown will not generally have been noticed. See also http://www.openoffice.org/issues/show_bug.cgi?id=36304 And I opened a document that had been e-mailed to me in Microsoft Word from a doctor, and the letterhead part of his stationery came out weird. Can anybody tell me how to fix that? Imports from MS Word are usually good but sometimes not perfect and the same is true about going from OpenOffice.org Writer to MS Word. (Similarly the same is true between WordPerfect and MS Word, or between Adobe In-Design and Quark Express, and so forth.) If you wish you can register and file a bug report on either or both of these problems at http://qa.openoffice.org/issue_handling/pre_submission.html 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] [moderated]
On Tue, 2006-02-21 at 17:15 -0600, Kevin Rood wrote: I was wondering if there is a way to change the default margins in the Writer so that you do not have to change them every time you open the Writer. Currently the default is .79; however, I always use 1 margins. I would like it if I don't have to change the margins to 1 every time I open the Writer. Thanks, Kevin Rood You need to modify your default template. Open the help file and search for Template Management. Hope this helps. Dave Please reply to users@openoffice.org only. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Imposing Styles
Solveig L Haugland wrote: Here's a way to bring styles from one doc to another--the PDF mentioned might cover this as well. Go to the document someone submited to you, where you need to have your styles. Choose Format Styles and Formatting. Find the far-right top icon with the downward facing black triangle, click on it, and choose Load Styles. In the styles window that appears, mark all the types of styles you want to bring in from your template, then click From File, select your template file, and click Open. (If your template file is already listed in one of the template categories shown, you don't have to click From File.) The following approach doesn't seem to work. 1) Open new file using the template that has the styles I want. 2) Copy and paste the other doc into the new file. I would have thought that the styles in the new file would override the ones in the doc being pasted but that doesn't seem to be the case. I have to select each paragraph and double-click the style name. Am I doing something wrong? -- Pete Holsberg Columbus, NJ Treat everyone the way you want to be treated. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Cannot open or save to dbf format: Read-Error. Impossible to connect,to the file.
On Sun February 12 2006 12:45, Eric Patton wrote: Opening an old dbf-4 gives the error message Read-Error. Impossible to connect to the file. I also cannot save to dbf format. I receive the same error. Western-Europe Dos/OS2-850/International encoding used during dbf import to Calc. Selecting other encoding possibilities gives the same error message. This dbf can be opened using Calc 2.0.1 on a Windows XP SP2 machine. It was created on the same machine. Using Ubuntu Breezy 5.10. Can anyone confirm this error? Hi Eric, Can you please try an official version of OpenOffice.org from http://openoffice.org to see if it is possible ? -- 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] [moderated] YOU MUST GIVE A SUMMARY HERE
On Tue, 2006-02-21 at 17:52 -0600, Judy Pratt wrote: I would like to use OpenOffice. My connection speed is too slow to download it off the netI tried for one full day and never got it on my computer. Can I purchase a CD or some way to use the product? Thanks Judy Pratt Judy Pratt Yes you can. See: http://distribution.openoffice.org/cdrom/ Hope this helps. Dave Please reply to users@openoffice.org only. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Applying function returns to cell addresses
Paul_B wrote: The formula should be (for completeness): Tax: =IF(B260;0;LOOKUP(B26;$H$3:$H$8;$J$3:$J$8) +(B26-LOOKUP(B26;$H$3:$H$8;$H$3:$H$8)) *LOOKUP(B26;$H$3:$H$8;$K$3:$K$8)) Ok, I neglected to define one more parameter on my sheet. B26 here is pre-tax net worth, rather than income, while E26 is the current level of capital gains, which is what the tax exclusively will be based on. After I determine the tax on capital gains I subtract it from B26 to get current net worth, tax liability inclusive. Sorry for the confusion. Thanks so much for your help. It appears to be working fine here, and I've learned a lot. Very powerful tool. Paul If I may add one final thought on this, do yourself a favor and use named ranges. That way your formula will be something like: =IF(Taxable0;0;LOOKUP(Taxable;Threshold;Mar_FJ)+. It makes the whole thing enormously more readable and understandable next year when you need to revise it all again. -- Rod - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Applying function returns to cell addresses
On Wed, 22 Feb 2006 11:43:55 +1100, Ross Johnson wrote: On Tue, 2006-02-21 at 10:38 -0500, Paul_B wrote: On Tue, 21 Feb 2006 13:57:40 +1100, Ross Johnson wrote: On Mon, 2006-02-20 at 20:44 -0500, Paul_B wrote: On Tue, 21 Feb 2006 12:02:13 +1100, Ross Johnson wrote: On Mon, 2006-02-20 at 18:52 -0500, Paul_B wrote: On Sun, 19 Feb 2006 20:27:22 -0500, Paul_B wrote: On Mon, 20 Feb 2006 09:31:28 +1100, Ross Johnson wrote: On Sun, 2006-02-19 at 15:29 -0500, Paul_B wrote: On Sun, 19 Feb 2006 10:59:58 -0600, Rod Engelsman wrote: Paul_B wrote: Is there any way to set up a multiple case logic test? Currently I have =IF(B27=;;B27-(14.325+(E$25-70.35)*0.28)) as a formula in a column of cells. It tests another column's cell, if it's empty the result is null, otherwise a tax approximation kicks in. However, I'd like to allow for a few tax brackets. To do so I'd need to account for the null possibility plus three other possible number ranges (as income increases, a different tax formula should be invoked). Currently I don't see how this is possible. Thanks, paul You can use nested IF() statements. =IF(B27=;;IF(B27=... Ahh. Ok, thanks. Hadn't thought of that. A case select command would be nice, but this should do what I need. Have you tried using lookup tables for this kind of thing. Functions: LOOKUP, VLOOKUP etc in Help. I use them for this purpose in my own tax sheets and they work. That indeed looks like it would do it, as it amounts to a powerful case select statement. Should be interesting working out the details. Will get on this maybe tomorrow. Thanks much, Paul Ok, I'm trying to set this up. Is there any way to use a function's return as part of a cell address? For instance: =MATCH($E$26;$H$3:$H$8) finds the row in which the H column matches cell E26. but =G(MATCH($E$26;$H$3:$H$8)) doesn't work. I want to find the row which contains the value searched for, and then use that number in the address of another value, here found under column G. Use something like =INDIRECT(GMATCH($E$26;$H$3:$H$8)+2) But LOOKUP does this for you. E.g. = LOOKUP($E$26;$H$3:$H$8;$G$3:$G$8) You definitely know your stuff, The INDIRECT formula is awesome, and you even caught the need for an offset of 2 in my MATCH formula. I was getting LOOKUP to return the row number, as does your formula above, but only because I set up column G to contain that data. But how then would I use the returned row number to specify which cells to poll for the tax data? That's where I'm stuck. Using the INDIRECT formula, I came up with =IF(B26=;;B26-( INDIRECT(iMATCH($E$25;$H$3:$H$8)+2) +INDIRECT(jMATCH($E$25;$H$3:$H$8)+2)*($E$25-LOOKUP(E$25;$H$3:$H$8;$H$3:$H$8 which successfully takes the income in B26 and then subtracts off the base tax and incremental tax bracket tax. But this is very unwieldy. If LOOKUP can do this directly, it would be a big improvement. Hey. Compliments always work :) I guess this has turned into a bit of a tutorial on lookup tables now. I assume your tax brackets are structured the same as mine, i.e a table like this (top left at cell H3): 0 0 0 Tax free threshold 1 1 0 0.15$0 plus $0.15 for each $ over $1 2 3 15000.25 4 5 65000.30 6 8 95000.35 9 2 0.45$2 plus $0.45 for each $ over $9 $9 is the top threshold. If you don't have a tax-free threshold where you are then you can see how the table would change. The second column isn't actually needed in the formulae. Tax: =IF(B260;0;LOOKUP(B26;$H$3:$H$7;$J$3:$J$7) +(B26-LOOKUP(B26;$H$3:$H$7;$J$3:$J$7)) *LOOKUP(B26;$H$3:$H$7;$K$3:$K$7)) Of course, the formula is a lot simpler if you store the base tax amount for your income in another cell. Base Tax: B27 =LOOKUP(B26;$H$3:$H$7;$J$3:$J$7) Tax: =IF(B260;0;B27+(B26-B27)*LOOKUP(B26;$H$3:$H$7;$K$3:$K$7)) I give no warranty that these formulae won't get you a jail term :) Wow, it's so simple once I see it. I was missing the obvious step of looking up the tax bracket floor again and subtracting it from the actual income, in preparation for multiplication by the incremental rate. Thanks very much for taking the time to lay this out. Hopefully others have gained from it as much as I. Thanks for spotting the error. I incorrectly subtracted the base tax from the income instead of the income threshold for that tax. The simplified version I gave is also invalid then. The formula should be (for completeness): Tax: =IF(B260;0;LOOKUP(B26;$H$3:$H$8;$J$3:$J$8) +(B26-LOOKUP(B26;$H$3:$H$8;$H$3:$H$8)) *LOOKUP(B26;$H$3:$H$8;$K$3:$K$8)) Ok, I neglected to define one more parameter on my sheet. B26 here is pre-tax net worth, rather than income, while E26 is the current level of capital gains, which is what the tax
[users] [moderated] YOU MUST GIVE A SUMMARY HERE
I would like to use OpenOffice. My connection speed is too slow to download it off the netI tried for one full day and never got it on my computer. Can I purchase a CD or some way to use the product? Thanks Judy Pratt Judy Pratt [EMAIL PROTECTED] EarthLink Revolves Around You.