Suggestion for future versions of OpenOffice Calc
in [Open Office]
|
Prev: [discuss] OpenOffice.org and OpenDocument Format
Next: [discuss] OpenOffice.org Splash Screen (was Re: [discuss] OOo and Oracle)
From: Niklas Nebel on 15 Apr 2010 04:42 On 04/13/10 21:48, Glenn M. Reed wrote: > COUNTIFS is like nested COUNTIF statements. Counting an occurance > based on more than one criteria. For a spreadsheet I'm working on > this is very important. I know there are workarounds for but since > this spreadsheet will be maintained by others, I need to make it > simple. The COUNTIFS statement does that. We have an open enhancement issue for COUNTIFS (http://www.openoffice.org/issues/show_bug.cgi?id=90269). But an equivalent formula with SUMPRODUCT really isn't much more complicated, see http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Conditional_Counting_and_Summation. Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org For additional commands, e-mail: discuss-help(a)openoffice.org
From: "Glenn M. Reed" on 15 Apr 2010 11:41 Niklas, Thank you very much for the reply and the information. I reviewed the documentation that you suggested and that appears to be very promising. I'm very happy to see that the Community is constantly working to make OpenOffice a better application. There are some things in the review that I was not aware that OpenOffice did not do, but is being implemented. Can you tell me, typically how long it takes for these modifications to be implemented? I'm aware that there is the process of development, testing, then release, I just wondered if there was a time frame that typically applies to these sort of things. Again, thank you for the reply and working to make OpenOffice a better and more complete application. --Glenn -----Original Message----- >From: Niklas Nebel <Niklas.Nebel(a)Sun.COM> >Sent: Apr 15, 2010 4:42 AM >To: discuss(a)openoffice.org >Cc: gmreed(a)mindspring.com >Subject: Re: [discuss] Suggestion for future versions of OpenOffice Calc > >On 04/13/10 21:48, Glenn M. Reed wrote: >> COUNTIFS is like nested COUNTIF statements. Counting an occurance >> based on more than one criteria. For a spreadsheet I'm working on >> this is very important. I know there are workarounds for but since >> this spreadsheet will be maintained by others, I need to make it >> simple. The COUNTIFS statement does that. > >We have an open enhancement issue for COUNTIFS >(http://www.openoffice.org/issues/show_bug.cgi?id=90269). But an >equivalent formula with SUMPRODUCT really isn't much more complicated, >see >http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Conditional_Counting_and_Summation. > >Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org For additional commands, e-mail: discuss-help(a)openoffice.org
From: Niklas Nebel on 18 Apr 2010 08:43 Glenn M. Reed schrieb: > Can you tell me, typically how long it takes for these modifications > to be implemented? I'm aware that there is the process of > development, testing, then release, I just wondered if there was a > time frame that typically applies to these sort of things. Implementation of COUNTIFS hasn't started yet, so there's no estimation when it will be finished. The issue has target 3.x, we will try to add it to one of the next versions. Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org For additional commands, e-mail: discuss-help(a)openoffice.org
From: "Glenn M. Reed" on 18 Apr 2010 20:19
Thank you very much. I look forward to seeing it and again, thank you for making OOo better and better. Take care! On 4/18/2010 8:43 AM, Niklas Nebel wrote: > Glenn M. Reed schrieb: >> Can you tell me, typically how long it takes for these modifications >> to be implemented? I'm aware that there is the process of >> development, testing, then release, I just wondered if there was a >> time frame that typically applies to these sort of things. > > Implementation of COUNTIFS hasn't started yet, so there's no > estimation when it will be finished. The issue has target 3.x, we will > try to add it to one of the next versions. > > Niklas > > |