Re: WORD COUNTER
I'll have to bookmark that for later. On Fri, May 23, 2014 at 9:32 AM, Ariel Constenla-Haile arie...@apache.orgwrote: Hello Jennifer, On Wed, May 21, 2014 at 04:00:19PM +, Mayers, Jennifer A. wrote: We noticed that there does not seem to be a word counter. This is required for essays and some research papers my son is doing, so we do not want to download this program in unless it has the word counter. Could you let us know about this? You can try this extension http://aoo-ui-extras.apache-extras.org.codespot.com/git/downloads/WordCountStatusbarController-0.0.1-windows-x86.oxt It adds a word counter on the status bar. Regards -- Ariel Constenla-Haile La Plata, Argentina
Re: Reminder on list policy
On 1/8/2014 1:47 PM, Robert Holtzman wrote: On Wed, Jan 08, 2014 at 08:44:26AM -0600, TN Patriot wrote: On Tue, 7 Jan 2014 19:47:54 -0500 Think thinkta...@gmail.com wrote: The fact that... You go on, and on, and on, and on, blathering and whining when someone disagrees with you, yet anything you seem to want to say is just fine. You're one of those 'do as I say, not as I do' types. That's the reason you start spewing about law and censoring and threatening the moment anyone disagrees with you in any way you deem not stroking your ego nicely or softly enough. It's all you have - threats of censorhip, laws, getting someone shut down, yada yada. You believe you can scare-tactic people with your threats, but I don't scare and have been around people like you for a long time. He/she is exhibiting typical troll behavior. They will drag the thread out as long as possible. They want as many replies as they can get. It's an ego trip. Hence the frequent warning don't feed the trolls. I do have to admit that this one's good. He/she is more irritating than most. If it keeps up I really wish the moderators would do something about it. BTW, I say he/she because a troll can always mask their identity/gender. Best response is typically a good plonking. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: OpenOffice 4.0.1
I think troll ist troll auf Deutsch odor English. Frisst du die Troll nicht bitte! On 12/19/2013 5:41 AM, TN Patriot wrote: On Thu, 19 Dec 2013 09:29:33 +0100 Stöver, Hans-Werner hans.stoe...@kark.de wrote: Hi, snip The same happened to OpenOffice. From a nice and good program you made a pack of shit. So keep it and I will use Microsoft Office in future. In Germany we call this Kundenverarschung Only my minor opinion. It's okay, we think as little of people like you too...shit. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: OpenOffice 4.0.1
Are you asking if you can ask OpenOffice to natively save in MSO format? On 12/19/2013 11:47 AM, Johnny Rosenberg wrote: 2013/12/19 James Knott james.kn...@rogers.com Johnny Rosenberg wrote: By the way, isn't there a setting somewhere where you can choose between Apache OpenOffice file browser and your operating system's file browser? Or was that LibreOffice? I have used both of them a lot so I might be a little confused there. The old StarOffice incuded a browser, but I haven't heard of one in OO or LO. I mean the FILE browser, for instance in the save and load dialogue. My native language is not English, maybe I just picked the wrong word. Sorry. So what did I mean? File manager? ”Explorer”? Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Informal Mac OS / OpenOffice Survey
On 12/11/2013 5:41 PM, Jonathan Kalan wrote: Please - everyone. It would be much better if you would stop using reply all for this survey. We don't all need to see every single response. Thank you. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org The reply button goes to the exact same place as reply all or reply list. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Open Office 4
On 11/21/2013 10:09 PM, Jim Shirley wrote: I do not like the change in the new Open Office 4. To change the entire screen to a new colored venue is distracting and delays both the installation and the close of the program. It is pretty but not useful. Please change it back to its prior screen. JNGreene Don't these people seem the type that would ask you to change the MOTD back in the day because they didn't like it? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: please take me off this chatter
On 11/20/2013 7:13 AM, karen nonnecke wrote: - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: OOo then and now
On 11/20/2013 4:07 PM, Joan Grey wrote: Hi, My OS is WIN 8 ( ugh!) and as a user of open office on a WIN 7 (gateway tablet) I chose to load it onto my new ASUS laptop. This pc has been into the shop 2 X since purchase 5 months ago and was wiped clean of ‘stuff’. When first in use I loaded ALL files and and accessed my MS office docs w/o a problem. Now w/ newest OO version I can’t get into my docs and/unless I solve the access problem I’ll have to dump OO and sign onto MS O. because I have important personal files to deal with. W/Thx, Joan Are you having an access issue, unable to open files issue, unable to find files issue. . . - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Gatekeeper adjustment to allow use of OpenOffice.org
On 11/14/2013 3:31 PM, Dennis Tuchler wrote: Please read the attached document about a Mac program called Gatekeeper. Adjust Gatekeeper as suggested and OO.org will be useable. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org I think the list strips attachments. Use a link.
Re: essential remark for majority of OO users - incompatibility of Math formula editor.
e-mail the address you included in the OP On 11/13/2013 2:46 AM, Yolanda Lowery wrote: No. It is me that wants to unsub. Thanks for asking. Please tell me what else I need to do. Thanks, Yolanda LaCombe Lowery Glendale, California 91201 From: Peter Junge peter.ju...@gmx.org To: users@openoffice.apache.org Sent: Tuesday, November 12, 2013 8:47 PM Subject: Re: essential remark for majority of OO users - incompatibility of Math formula editor. Yolanda, are you trying to ask for getting unsubscribed yourself or are you giving somebody else a hint how to do that? Peter On 11/13/2013 11:40 AM, Yolanda Lowery wrote: users-unsubscr...@openoffice.apache.org Yolanda LaCombe Lowery Glendale, California 91201 From: John Meyer johnme...@pueblocomputing.com To: users@openoffice.apache.org Sent: Tuesday, November 12, 2013 1:27 PM Subject: Re: essential remark for majority of OO users - incompatibility of Math formula editor. On 11/12/2013 2:11 PM, Urmas wrote: M. Fioretti: may I respectfully suggest that a former VP/CIO of IT and Telecom may be expected to know better than highjacking threads on a mailing list... It's just seasonal relapse. Not to completely hijack this thread, but I don't think execs at that level really think about technical issues like hijacking threads. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: essential remark for majority of OO users - incompatibility of Math formula editor.
On 11/12/2013 2:11 PM, Urmas wrote: M. Fioretti: may I respectfully suggest that a former VP/CIO of IT and Telecom may be expected to know better than highjacking threads on a mailing list... It's just seasonal relapse. Not to completely hijack this thread, but I don't think execs at that level really think about technical issues like hijacking threads. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: unable to open office document on mac
On 11/12/2013 1:56 PM, Toni Caprari wrote: I'm unable to open a text document that I drafted using office and saved in a word 97 format. This problem occurred after inserting table in various sections of the document. Now I get a pop up error message sayingThis is not a winword 97 file Did you save the original in ODF? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: SQL problem
Semi-solved, I think. I managed to join the following: SELECT AGENTS.AGENT_ID, COUNT(*) AS Total Sales FROM AGENTS INNER JOIN SALES ON AGENTS.AGENT_ID=SALES.SALES_REP GROUP BY AGENTS.AGENT_ID The only problem is I can't seem to add the agent's name. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: SQL problem (SOLVED)
On 10/20/2013 1:14 PM, John Meyer wrote: Semi-solved, I think. I managed to join the following: SELECT AGENTS.AGENT_ID, COUNT(*) AS Total Sales FROM AGENTS INNER JOIN SALES ON AGENTS.AGENT_ID=SALES.SALES_REP GROUP BY AGENTS.AGENT_ID The only problem is I can't seem to add the agent's name. I ended up solving the problem by breaking up the query into two subqueries: one to count the results and the other to join the information with the name. It isn't the most elegant solution int he world, but it works! - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: how to rotate a table
On 10/20/2013 1:54 PM, Uwe Brauer wrote: Hi I googled a bit but found no solution to the problem of rotating a table such that | 1 | 2 | 3 | | 4 | 3 | 4 | becomes | 4 | 1 | | 3 | 2 | | 4 | 3 | Thanks Uwe Brauer http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_TRANSPOSE_function - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
OpenOffice MSI
Has anybody created a deployable MSI for OpenOffice? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Indirect and Address problem (from VLOOKUP and Macros)
http://i174.photobucket.com/albums/w108/pueblonative/FormulaError2_zps27abcf42.png http://i174.photobucket.com/albums/w108/pueblonative/Formulaerror1_zpsda33a4c4.png Here are the worksheet names and the formula I am using.
Re: Indirect and Address problem (from VLOOKUP and Macros)
Thanks for the help. After looking over this problem a bit, I decided to scrap the sheet name idea and just have all sales on one sheet. sales are in this format: DummyField, Date, DummyField, DummyField, SalesRep For this table, I want to get the number of sales generated for a particular agent by date. Sales Rep10/1/13 10/2/13 10/3/13 12345 ## #### 45678 ## ## ## Would this lend itself to a DCOUNT solution (and to answer the obvious question, I can't use a database at work). On 10/3/2013 10:36 AM, Brian Barker wrote: At 08:47 03/10/2013 -0600, John Meyer wrote: http://i174.photobucket.com/albums/w108/pueblonative/FormulaError2_zps27abcf42.png http://i174.photobucket.com/albums/w108/pueblonative/Formulaerror1_zpsda33a4c4.png Here are the worksheet names and the formula I am using. I haven't been following this thread, so take this with a pinch of salt, but I think I can see the problems here. Your source value in cell C1 of sheet Bonuses may look like 09-27-2013 but it is actually a date value formatted to look like that. I can see this from its right alignment (unless you have set this cell formatting manually). Your INDIRECT(ADDRESS... will retrieve this value, but not with the date formatting applied. I'm guessing, but I think the most obvious result would be the underlying date value (possibly 41544), the numbers of days from the date origin. Now your sheet is actually named 09-27-2013 - as text - and there is no sheet named 41544. Hence the error. You could enter the date in C1 as text. Type an apostrophe before the value and it will be interpreted as text (and left aligned by default). The result of your INDIRECT(ADDRESS... will now be the same text string and this will match the sheet name. But that's not the whole story. The result of the INDIRECT function is a text string representing the sheet name, but you cannot just append .$E$1 ... to this. Instead you need to concatenate these text strings as INDIRECT(ADDRESS(1;3;1;;Bonuses)).$E$1 ... but then you have another text string and you need to use INDIRECT() again to convert it to a reference. Try: =COUNTIF(INDIRECT(INDIRECT(ADDRESS(1;3;1;;Bonuses)).$E$1:$E$2000);A2) If you wanted to retain the values in C1 and so on as genuine dates, you may be able to convert the date value to the appropriate text explicitly using TEXT(...;MM-DD-) within your formula. But I can't get this to work; I think the problem is that sheet names that are numerical or perhaps start with a number need in this context to be surrounded by quotes - and it's difficult to see how you could add these. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Indirect and Address problem (from VLOOKUP and Macros)
On 10/3/2013 11:42 AM, Brian Barker wrote: At 10:59 03/10/2013 -0600, John Meyer wrote: After looking over this problem a bit, I decided to scrap the sheet name idea and just have all sales on one sheet. sales are in this format: DummyField, Date, DummyField, DummyField, SalesRep For this table, I want to get the number of sales generated for a particular agent by date. Sales Rep10/1/13 10/2/13 10/3/13 12345 ## ## ## 45678 ## ## ## Would this lend itself to a DCOUNT solution (and to answer the obvious question, I can't use a database at work). I think I'd use SUMPRODUCT(). Suppopse your second table starts in AA1. Then try something like: =SUMPRODUCT($B$2:$B$999=AB$1;$E$2:$E$999=$AA2) The individual parameters are logical expressions, and taking the product of these ANDs them. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Thanks, though I'll have to look this up more: =SUMPRODUCT(Sales.$B$2:$B$655=C$1;Sales.$E$2:$E$655=$A2) returns zero even when there is data Sales has the Sales data C1 has the date to check B is the column in sales with the date A2 has the Emp ID E is the column in sales with the Employee ID. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Indirect and Address problem (from VLOOKUP and Macros)
Strike that last e-mail, it worked. On 10/3/2013 11:57 AM, John Meyer wrote: On 10/3/2013 11:42 AM, Brian Barker wrote: At 10:59 03/10/2013 -0600, John Meyer wrote: After looking over this problem a bit, I decided to scrap the sheet name idea and just have all sales on one sheet. sales are in this format: DummyField, Date, DummyField, DummyField, SalesRep For this table, I want to get the number of sales generated for a particular agent by date. Sales Rep10/1/13 10/2/13 10/3/13 12345 ## ## ## 45678 ## ## ## Would this lend itself to a DCOUNT solution (and to answer the obvious question, I can't use a database at work). I think I'd use SUMPRODUCT(). Suppopse your second table starts in AA1. Then try something like: =SUMPRODUCT($B$2:$B$999=AB$1;$E$2:$E$999=$AA2) The individual parameters are logical expressions, and taking the product of these ANDs them. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Thanks, though I'll have to look this up more: =SUMPRODUCT(Sales.$B$2:$B$655=C$1;Sales.$E$2:$E$655=$A2) returns zero even when there is data Sales has the Sales data C1 has the date to check B is the column in sales with the date A2 has the Emp ID E is the column in sales with the Employee ID. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Indirect and Address problem (SOLVED)
Okay, so I just needed one more step with Brian's problem. When I imported the date from the web site, it also had the time portion. So, I created another column and put a formula of QUOTIENT(B2;1) and formatted that as a date. Voila, it works. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Delivery Status Notification (Failure)
Thou must unsubscribe thyself. Hearken to the instructions below, for they shall lead you in the path of a less cluttered inbox. On 9/30/2013 9:53 PM, Victor Nobert wrote: Please unsuscribe me from the users open.office list. thank you. V. Nobert From: emell...@gmail.com Date: Fri, 27 Sep 2013 11:54:24 +0100 Subject: Re: Fwd: Delivery Status Notification (Failure) To: users@openoffice.apache.org Hi Peter, I'm only acting on instructions sent to me (see below) : confirm unsubscribe from users@openoffice.apache.org Inbox x users-h...@openoffice.apache.org 25 Sep (2 days ago) to me Hi! This is the ezmlm program. I'm managing the users@openoffice.apache.org mailing list. I'm working for my owner, who can be reached at users-ow...@openoffice.apache.org. To confirm that you would like emell...@gmail.com removed from the users mailing list, please send a short reply to this address: users-uc.1380133124.jclbmlenhilcfpnhgemc-emellish= gmail@openoffice.apache.org Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. or click here: mailto:users-uc.1380133124.jclbmlenhilcfpnhgemc-emellish= gmail@openoffice.apache.org I haven't checked whether your address is currently on the mailing list. To see what address you used to subscribe, look at the messages you are receiving from the mailing list. Each message has your address hidden inside its return path; for example, m...@xdd.ff.com receives messages with return path: users-return-number-mary= xdd.ff@openoffice.apache.org. Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to users-requ...@openoffice.apache.org and put the entire address listed above into the Subject: line. --- Administrative commands for the users list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: users-subscr...@openoffice.apache.org To remove your address from the list, send a message to: users-unsubscr...@openoffice.apache.org Send mail to the following for info and FAQ for this list: users-i...@openoffice.apache.org users-...@openoffice.apache.org Similar addresses exist for the digest list: users-digest-subscr...@openoffice.apache.org users-digest-unsubscr...@openoffice.apache.org To get messages 123 through 145 (a maximum of 100 per request), mail: users-get.123_...@openoffice.apache.org To get an index with subject and author for messages 123-456 , mail: users-index.123_...@openoffice.apache.org They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send a short message to: users-thread.12...@openoffice.apache.org The messages should contain one line or word of text to avoid being treated as sp@m, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example john@host.domain, just add a hyphen and your address (with '=' instead of '@') after the command word: users-subscribe-john=host.dom...@openoffice.apache.org To stop subscription for this address, mail: users-unsubscribe-john=host.dom...@openoffice.apache.org In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at users-ow...@openoffice.apache.org. Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: emell...@gmail.com Received: (qmail 33882 invoked by uid 99); 25 Sep 2013 18:18:43 - Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Sep 2013 18:18:43 + X-ASF-Spam-Status: No, hits=-10.5 required=10.0 tests=ASF_LIST_OPS,ASF_LIST_UNSUB_A,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of emell...@gmail.com designates 209.85.215.176 as permitted sender) Received: from [209.85.215.176] (HELO mail-ea0-f176.google.com) (209.85.215.176) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Sep 2013 18:18:37 + Received: by mail-ea0-f176.google.com with SMTP id q16so20292ead.7 for users-unsubscr...@openoffice.apache.org; Wed, 25 Sep 2013 11:18:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=x7YmHN4Ky/9n/OUb8cQZq/At9AO9parpZj4d+/7cjG8=;
Re: VLOOKUP vs Macros
Same Err:501. I'll post up more in the office. On 10/1/2013 8:11 AM, Johnny Rosenberg wrote: 2013/9/30 John Meyer johnme...@pueblocomputing.com Still doesn't work. Back to the drawing board. Exactly what does your current formula look like and what error message do you get? Still 501? Johnny Rosenberg On Mon, Sep 30, 2013 at 2:32 PM, John Meyer johnme...@pueblocomputing.comwrote: Derp, just saw that. Thanks. On Mon, Sep 30, 2013 at 2:01 PM, Johnny Rosenberg gurus.knu...@gmail.comwrote: 2013/9/30 John Meyer johnme...@pueblocomputing.com Sorry, that e-mail got sent off too quickly. I'm trying this formula =COUNTIF(INDIRECT(ADDRESS(1,3,1,,Bonuses)).$E$1:$E2000,A2) C1 contains the name of the worksheet (09-27-13) and I'm trying to use it. However, it keeps giving me an err:501. Hint 1: Use the builtin help and search for 501. It will take you to the error codes. 501 means something like ”invalid character”. In this case it seems like you use ”,” instead of ”;” as parameter separators. I thought that there was a setting for that somewhere, but now I can't find it, so I guess that is a LibreOffice feature, but I'm not sure. I used LibreOffice for a couple of years but I am back with Apache OpenOffice again, since LibreOffice was way too unstable for me. It actually destroyed one of my spreadsheets but Apache OpenOffice fixed it for me, that's why I'm back… :D Anyway, replace those commas with semi-colons and I think it will work. Hint 2: If you are working with a big formula and it doesn't work, hit Ctrl+F2 (select the cell that you are working with first) and you are able to study your formula a little better. For instance you can see sub values by placing the cursor on different places in the formula. That way it's a little easier to find WHERE the error is. Regards Johnny Rosenberg On Mon, Sep 30, 2013 at 1:22 PM, John Meyer johnme...@pueblocomputing.comwrote: =COUNTIF(INDIRECT(ADDRESS(1,3,1,,Bonuses)).$E$1:$E2000,A2) On Mon, Sep 30, 2013 at 1:18 PM, John Meyer johnme...@pueblocomputing.com wrote: So I guess I'm doing something wrong here. =COUNTIF(INDIRECT(ADDRESS(1,3,1,,Bonuses)).$E$1:$E2000,A2) Returns an Err:501. On Sun, Sep 29, 2013 at 10:59 PM, Coreurus coreu...@aol.com wrote: - Original Message --(Start-looking-by-there) From: John Meyer To: users@openoffice.apache.org Sent: Saturday, 28 September, 2013 04:40 PM Subject: Re: VLOOKUP vs Macros I sent that a little too soon. The title refers to the fact that I was looking into another solution. the sales sheet for each day is broken down with the following information: Date, EmpID Currently, what I am doing is separating them by date. However, I was thinking a much less cluttered solution would involve pulling the date from the bonus calculation field and then doing either a VLOOKUP with a count or Macro. Where would I start looking if I wanted to do either one of those solutions? Back to searching for the answer. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: VLOOKUP vs Macros
Okay, I've put up two screenshots. the first contains the formula and what is listed in C1. The next is the names of the individual sheets. On 10/1/2013 8:21 AM, John Meyer wrote: Same Err:501. I'll post up more in the office. On 10/1/2013 8:11 AM, Johnny Rosenberg wrote: 2013/9/30 John Meyer johnme...@pueblocomputing.com Still doesn't work. Back to the drawing board. Exactly what does your current formula look like and what error message do you get? Still 501? Johnny Rosenberg On Mon, Sep 30, 2013 at 2:32 PM, John Meyer johnme...@pueblocomputing.comwrote: Derp, just saw that. Thanks. On Mon, Sep 30, 2013 at 2:01 PM, Johnny Rosenberg gurus.knu...@gmail.comwrote: 2013/9/30 John Meyer johnme...@pueblocomputing.com Sorry, that e-mail got sent off too quickly. I'm trying this formula =COUNTIF(INDIRECT(ADDRESS(1,3,1,,Bonuses)).$E$1:$E2000,A2) C1 contains the name of the worksheet (09-27-13) and I'm trying to use it. However, it keeps giving me an err:501. Hint 1: Use the builtin help and search for 501. It will take you to the error codes. 501 means something like ”invalid character”. In this case it seems like you use ”,” instead of ”;” as parameter separators. I thought that there was a setting for that somewhere, but now I can't find it, so I guess that is a LibreOffice feature, but I'm not sure. I used LibreOffice for a couple of years but I am back with Apache OpenOffice again, since LibreOffice was way too unstable for me. It actually destroyed one of my spreadsheets but Apache OpenOffice fixed it for me, that's why I'm back… :D Anyway, replace those commas with semi-colons and I think it will work. Hint 2: If you are working with a big formula and it doesn't work, hit Ctrl+F2 (select the cell that you are working with first) and you are able to study your formula a little better. For instance you can see sub values by placing the cursor on different places in the formula. That way it's a little easier to find WHERE the error is. Regards Johnny Rosenberg On Mon, Sep 30, 2013 at 1:22 PM, John Meyer johnme...@pueblocomputing.comwrote: =COUNTIF(INDIRECT(ADDRESS(1,3,1,,Bonuses)).$E$1:$E2000,A2) On Mon, Sep 30, 2013 at 1:18 PM, John Meyer johnme...@pueblocomputing.com wrote: So I guess I'm doing something wrong here. =COUNTIF(INDIRECT(ADDRESS(1,3,1,,Bonuses)).$E$1:$E2000,A2) Returns an Err:501. On Sun, Sep 29, 2013 at 10:59 PM, Coreurus coreu...@aol.com wrote: - Original Message --(Start-looking-by-there) From: John Meyer To: users@openoffice.apache.org Sent: Saturday, 28 September, 2013 04:40 PM Subject: Re: VLOOKUP vs Macros I sent that a little too soon. The title refers to the fact that I was looking into another solution. the sales sheet for each day is broken down with the following information: Date, EmpID Currently, what I am doing is separating them by date. However, I was thinking a much less cluttered solution would involve pulling the date from the bonus calculation field and then doing either a VLOOKUP with a count or Macro. Where would I start looking if I wanted to do either one of those solutions? Back to searching for the answer. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: File won't open
On 10/1/2013 5:16 PM, Doug wrote: I've just received an attachment consisting of an important legal document as a .docx file. I downloaded Apache 4.0.1 and it won't open the file. (Neither will Textmaker 2012 or WordPerfect 6.) Since this is a personal file, I can't send it to you, but do you have any comment? (It comes from a law office, and they are NOT going to switch to OpenOffice!) --doug Is there any particular error that comes up? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: VLOOKUP vs Macros
Still doesn't work. Back to the drawing board. On Mon, Sep 30, 2013 at 2:32 PM, John Meyer johnme...@pueblocomputing.comwrote: Derp, just saw that. Thanks. On Mon, Sep 30, 2013 at 2:01 PM, Johnny Rosenberg gurus.knu...@gmail.comwrote: 2013/9/30 John Meyer johnme...@pueblocomputing.com Sorry, that e-mail got sent off too quickly. I'm trying this formula =COUNTIF(INDIRECT(ADDRESS(1,3,1,,Bonuses)).$E$1:$E2000,A2) C1 contains the name of the worksheet (09-27-13) and I'm trying to use it. However, it keeps giving me an err:501. Hint 1: Use the builtin help and search for 501. It will take you to the error codes. 501 means something like ”invalid character”. In this case it seems like you use ”,” instead of ”;” as parameter separators. I thought that there was a setting for that somewhere, but now I can't find it, so I guess that is a LibreOffice feature, but I'm not sure. I used LibreOffice for a couple of years but I am back with Apache OpenOffice again, since LibreOffice was way too unstable for me. It actually destroyed one of my spreadsheets but Apache OpenOffice fixed it for me, that's why I'm back… :D Anyway, replace those commas with semi-colons and I think it will work. Hint 2: If you are working with a big formula and it doesn't work, hit Ctrl+F2 (select the cell that you are working with first) and you are able to study your formula a little better. For instance you can see sub values by placing the cursor on different places in the formula. That way it's a little easier to find WHERE the error is. Regards Johnny Rosenberg On Mon, Sep 30, 2013 at 1:22 PM, John Meyer johnme...@pueblocomputing.comwrote: =COUNTIF(INDIRECT(ADDRESS(1,3,1,,Bonuses)).$E$1:$E2000,A2) On Mon, Sep 30, 2013 at 1:18 PM, John Meyer johnme...@pueblocomputing.com wrote: So I guess I'm doing something wrong here. =COUNTIF(INDIRECT(ADDRESS(1,3,1,,Bonuses)).$E$1:$E2000,A2) Returns an Err:501. On Sun, Sep 29, 2013 at 10:59 PM, Coreurus coreu...@aol.com wrote: - Original Message --(Start-looking-by-there) From: John Meyer To: users@openoffice.apache.org Sent: Saturday, 28 September, 2013 04:40 PM Subject: Re: VLOOKUP vs Macros I sent that a little too soon. The title refers to the fact that I was looking into another solution. the sales sheet for each day is broken down with the following information: Date, EmpID Currently, what I am doing is separating them by date. However, I was thinking a much less cluttered solution would involve pulling the date from the bonus calculation field and then doing either a VLOOKUP with a count or Macro. Where would I start looking if I wanted to do either one of those solutions? Back to searching for the answer. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: VLOOKUP vs Macros
I sent that a little too soon. The title refers to the fact that I was looking into another solution. the sales sheet for each day is broken down with the following information: Date, EmpID Currently, what I am doing is separating them by date. However, I was thinking a much less cluttered solution would involve pulling the date from the bonus calculation field and then doing either a VLOOKUP with a count or Macro. Where would I start looking if I wanted to do either one of those solutions? Back to searching for the answer. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org