Re: WORD COUNTER
I'll have to bookmark that for later. On Fri, May 23, 2014 at 9:32 AM, Ariel Constenla-Haile wrote: > 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" 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: email program
On 1/4/2014 12:07 PM, Keith and Leisa Ferguson wrote: I just found out about open office. It looks really great. I might be getting a new computer and did not want spend the price of the computer on MS Office. What I am needing to know is there a good email program out there similar to Outlook? By this I mean I would like to save my outlook files to a thumb drive as a .pst file and transfer them to the new program. Also I would like to use my current email address fergu...@bardstowncable.net. So many people have this email address, so g-mail wouldn't work. Thanks in advance for your insight. keith Thunderbird - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: All essay text turned to hashtags
On 1/4/2014 6:04 AM, natalie guttridge wrote: Please help My daughter has written a 2000 word essay. She saved it and then when she opened it again the whole text has turned into hashtags...can anything be done? Regards Natalie Sent from my iPad - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org What's the extension and file type? What type of computer did she create it on? What type of computer did she open it on? Was it the same computer and same program? - 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 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: 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" wrote: Hi, 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: Informal Mac OS / OpenOffice Survey
it will unsubscribe you from the entire list. On 12/12/2013 12:54 PM, Rochelle wrote: but will that unsubscribe you to just this subject or all future OO postings? Rochelle Uchibori House Manager Honolulu Theatre for Youth 808 782-1955 cell On Thu, Dec 12, 2013 at 9:25 AM, John Meyer wrote: Actually, I was pointing that out to Alan. On 12/12/2013 12:21 PM, Tom Backer Johnsen wrote: John Look at the lower part of the mails you are receiving from the list. Tom On 12. Dec 2013, at 18:53 , John Meyer wrote: On 12/12/2013 5:21 AM, Alan Rogers wrote: How does one get off of this mailing list? vvv - 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 - 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
Actually, I was pointing that out to Alan. On 12/12/2013 12:21 PM, Tom Backer Johnsen wrote: John Look at the lower part of the mails you are receiving from the list. Tom On 12. Dec 2013, at 18:53 , John Meyer wrote: On 12/12/2013 5:21 AM, Alan Rogers wrote: How does one get off of this mailing list? vvv - 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 - 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/12/2013 5:21 AM, Alan Rogers wrote: How does one get off of this mailing list? vvv - 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: 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: 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: Writer, ouline numbered list
On 11/17/2013 6:01 AM, Malcolm Doughty wrote: > I do not want these emails! > Just send an e-mail to the appropriate address below. --- > 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: 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 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 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: 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 saying"This 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: 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: 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
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: 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
SQL problem
Relevant tables and fields: Agents TSR Varchar(6) Sales SalesRep Varchar(6) neither is a primary key (I'm having problems converting it to a primary key when I import the data from a spread sheet). I want to find out how many sales each agent got. Statement: SELECT "Agents"."TSR", "Agents"."Agent", COUNT(*) FROM "Agents" INNER JOIN "Sales" ON "Agents"."TSR" = "Sales"."Sales Rep" Gives me a not in aggregate function or group by clause. Any ideas while I search for the answer? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Save big file
On 10/20/2013 7:50 AM, Alexandro Colorado wrote: I would rather think this file has large images that could be re-rendered or externally linked. If its a huge spreadsheet probably transfer to a database. In a text file? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Save big file
On 10/19/2013 7:46 AM, Henry Bohné wrote: I recently upgraded from ver3.3 to ver 4.0. I work with a big (2.2 MB) text file. With ver3.3 it took 5 to 9 minutes to save the file, with ver4.0 it takes 29 minutes. How can I speed it up? I'm using Windows 7 as OS Henry Bohné BTW, may I ask and this is totally OT to the discussion, why this file is so big and is there any way to divy up the file into smaller, quicker loading files? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
OpenOffice MSI installer build
Hey guys: I'm trying to get my office to upgrade. The IT staff says that they need an MSI installer build. Is there one available? Thanks. - 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
Re: Indirect and Address problem (SOLVED)
haven't had my first cup of coffee. On 10/3/2013 12:41 PM, Brian Barker wrote: At 12:14 03/10/2013 -0600, John Meyer wrote: Okay, so I just needed one more step with Brian's problem. Er, I don't remember having a 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) ... INT(B2) might be easier. ... and formatted that as a date. I'm not sure formatting will make any difference here. Voila, it works. Good-oh! 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 (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: 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 (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)
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
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: 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
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
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
wrote:
Derp, just saw that.
Thanks.
On Mon, Sep 30, 2013 at 2:01 PM, Johnny Rosenberg <
gurus.knu...@gmail.com>wrote:
2013/9/30 John Meyer
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
wrote:
=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
wrote:
<
- Original Message --(Start-looking-by-there)
From: John Meyer >
To:
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
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
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
wrote:
Derp, just saw that.
Thanks.
On Mon, Sep 30, 2013 at 2:01 PM, Johnny Rosenberg <
gurus.knu...@gmail.com>wrote:
2013/9/30 John Meyer
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
wrote:
=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
wrote:
<
- Original Message --(Start-looking-by-there)
From: John Meyer >
To:
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: 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: -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 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: To remove your address from the list, send a message to: Send mail to the following for info and FAQ for this list: Similar addresses exist for the digest list: To get messages 123 through 145 (a maximum of 100 per request), mail: To get an index with subject and author for messages 123-456 , mail: 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: 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: To stop subscription for this address, mail: 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: 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 ; 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=; b=OMZdk8YaOmejVWfHbUuirQO/FACD8JNn7voINojMMN3HEcMa/nIdD4Y/hUnhBYRwLY X1qMb7xbRraKTseZnKUNR5hXkHJEOTfv+KlIbsM2tDkjiV9MGJSM+NLQLfq32hPf0zlU QEjsiJPwoevkr23qy2iwpFGtKR0cEOCicDjI4xbJqIz6bTImx4PffbpTaB7kgeWfw2x7 wGOhgLlbm9GR+UndPQ1hnWEO3VRzKT3J8Mskeyc3o41iAPyU1bZaEaV8G/Y2GAUzQ1V7 2KvHO2PD//BM/G3zSImlZTO2fmEW+XtcSzkfqzV1cLzfm+1ytc49X0yXgp8Mxqc3bkRj TODg== X-Received: by 10.14.127.137 with SMTP id d9mr92279eei.90.1380133096881; Wed, 25 Sep 2013 11:18:16 -0700 (PDT) MIME-Version: 1.0 Received: by 10.15.63.193 with HTTP; Wed, 25 Sep 2013 11:17:46 -0700 (PDT) From: MIKE LISH Date: Wed,
Re: VLOOKUP vs Macros
Still doesn't work. Back to the drawing board.
On Mon, Sep 30, 2013 at 2:32 PM, John Meyer
wrote:
> Derp, just saw that.
>
> Thanks.
>
>
> On Mon, Sep 30, 2013 at 2:01 PM, Johnny Rosenberg
> wrote:
>
>> 2013/9/30 John Meyer
>>
>> > 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
>> > wrote:
>> >
>> > > =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 wrote:
>> > >>
>> > >>> <
>> > >>> - Original Message --(Start-looking-by-there)
>> > >>> From: John Meyer >
>> > >>> To:
>> > >>> 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
Derp, just saw that.
Thanks.
On Mon, Sep 30, 2013 at 2:01 PM, Johnny Rosenberg wrote:
> 2013/9/30 John Meyer
>
> > 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
> > wrote:
> >
> > > =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 wrote:
> > >>
> > >>> <
> > >>> - Original Message --(Start-looking-by-there)
> > >>> From: John Meyer >
> > >>> To:
> > >>> 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
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.
On Mon, Sep 30, 2013 at 1:22 PM, John Meyer
wrote:
> =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
>
>
> On Mon, Sep 30, 2013 at 1:18 PM, John Meyer > 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 wrote:
>>
>>> <
>>> - Original Message --(Start-looking-by-there)
>>> From: John Meyer >
>>> To:
>>> 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
=COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2) On Mon, Sep 30, 2013 at 1:18 PM, John Meyer 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 wrote: > >> < >> - Original Message --(Start-looking-by-there) >> From: John Meyer > >> To: >> 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
Thanks for that, I will be sure to try that out when I get back to the office. I've heard the Indirect and address method mentioned before, but didn't have a practical example of how to use it. On Sun, Sep 29, 2013 at 12:04 PM, Andrew Douglas Pitonyak < and...@pitonyak.org> wrote: > > =ADDRESS(1, 3, 1,, "sheet1") > > returns > > SHEET1.$C$1 > > =INDIRECT(ADDRESS(1, 3, 1,, "sheet1")) > > returns whatever is stored in the cell referenced by SHEET1.$C$1 > > > On 09/28/2013 11:30 AM, John Meyer wrote: > >> I have a spreadsheet with a number of worksheets. The first worksheet >> has the bonuses for employees in this format >> >> >> ID, Sales Agent, Sales For Date, Bonus for Date, Sales for Date(N), Bonus >> For Date (N). . . >> >> >> The rest of the spreadsheets are each named for the date of sales that >> they contain. They are in the same format as the column header for Sales >> For Date. >> >> >> I set up each row like this >> >> ID static, Agent name static, =COUNTIF(*staticdateworksheet*** >> !ColumnWithIDFirstRow:**ColumnWithIDNthRow,**Firstcolumnrowiamin),** >> BonusCalculation >> >> >> What I'd like to do is change that formula around to resolve the sheet >> name by the first row of the salescount ID (i.e. if It's 9-27-2013 it would >> pull up 9-27-2013, 9-28-2013, etc.). Is this possible? It's not a >> pressing issue, I'd just like to see if it could be done. >> >> Thanks. >> >> >> >> --**--**- >> To unsubscribe, e-mail: >> users-unsubscribe@openoffice.**apache.org >> For additional commands, e-mail: >> users-help@openoffice.apache.**org >> >> > -- > Andrew Pitonyak > My Macro Document: > http://www.pitonyak.org/**AndrewMacro.odt<http://www.pitonyak.org/AndrewMacro.odt> > Info: http://www.pitonyak.org/oo.php > > > --**--**- > To unsubscribe, e-mail: > users-unsubscribe@openoffice.**apache.org > For additional commands, e-mail: > users-help@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
VLOOKUP vs Macros
I have a spreadsheet with a number of worksheets. The first worksheet has the bonuses for employees in this format ID, Sales Agent, Sales For Date, Bonus for Date, Sales for Date(N), Bonus For Date (N). . . The rest of the spreadsheets are each named for the date of sales that they contain. They are in the same format as the column header for Sales For Date. I set up each row like this ID static, Agent name static, =COUNTIF(*staticdateworksheet*!ColumnWithIDFirstRow:ColumnWithIDNthRow,Firstcolumnrowiamin),BonusCalculation What I'd like to do is change that formula around to resolve the sheet name by the first row of the salescount ID (i.e. if It's 9-27-2013 it would pull up 9-27-2013, 9-28-2013, etc.). Is this possible? It's not a pressing issue, I'd just like to see if it could be done. Thanks. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
