You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@community.apache.org by Bob McElmurry <bm...@yahoo.com> on 2013/10/12 20:59:35 UTC
Functions in OpenOffice
Currently I am using Microsoft Office 2010 and am working in a small school. I would like to use OpenOffice or LibreOffice but I have not found some of the functions that I like such as countifs, sumifs, and averageifs. Because of using these functions, I do not feel that it would be an asset to change to OpenOffice. Any suggestions?
Bob
Re: Functions in OpenOffice
Posted by Alexei Fedotov <al...@gmail.com>.
BTW, I was able to find countif:
http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_COUNTIF_function
--
With best regards / с наилучшими пожеланиями,
Alexei Fedotov / Алексей Федотов,
http://dataved.ru/
+7 916 562 8095
[1] Start using Apache Openmeetings today, http://openmeetings.apache.org/
[2] Join Alexei Fedotov @linkedin, http://ru.linkedin.com/in/dataved/
[3] Join Alexei Fedotov @facebook, http://www.facebook.com/openmeetings
On Sun, Oct 13, 2013 at 2:09 PM, Isabel Drost-Fromm <is...@apache.org> wrote:
> On Saturday, October 12, 2013 11:59:35 AM Bob McElmurry wrote:
>> Currently I am using Microsoft Office 2010 and am working in a small school.
>> I would like to use OpenOffice or LibreOffice but I have not found some of
>> the functions that I like such as countifs, sumifs, and averageifs.
>> Because of using these functions, I do not feel that it would be an asset
>> to change to OpenOffice. Any suggestions?
>
> You have directed your question to the general Apache Community development
> group. I'm sure the people over on the Apache Open Office user list are in a
> much better position to answer all your questions:
>
> http://openoffice.apache.org/mailing-lists.html#users-mailing-list-public
>
> For more information on which mailing lists Open Office has (including various
> localised lists), check out
>
> http://openoffice.apache.org/mailing-lists.html
>
>
> Hope this helps,
>
> Isabel
>
Re: Functions in OpenOffice
Posted by Andrea Pescetti <pe...@apache.org>.
On 13/10/2013 Isabel Drost-Fromm wrote:
> On Saturday, October 12, 2013 11:59:35 AM Bob McElmurry wrote:
>> I have not found some of
>> the functions that I like such as countifs, sumifs, and averageifs.
>> Because of using these functions, I do not feel that it would be an asset
>> to change to OpenOffice. Any suggestions?
> You have directed your question to the general Apache Community development
> group. I'm sure the people over on the Apache Open Office user list are in a
> much better position to answer all your questions:
> http://openoffice.apache.org/mailing-lists.html#users-mailing-list-public
Indeed, that list and http://forum.openoffice.org are the best place for
user support. Bob, please use those channels in future.
Anyway, while at it, I can tell Bob that COUNTIFS, SUMIFS, AVERAGEIFS
are supported as of Apache OpenOffice 4.0 (and of course the current
4.0.1 supports them too). See
https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+4.0+Release+Notes
Regards,
Andrea.
Re: Functions in OpenOffice
Posted by Isabel Drost-Fromm <is...@apache.org>.
On Saturday, October 12, 2013 11:59:35 AM Bob McElmurry wrote:
> Currently I am using Microsoft Office 2010 and am working in a small school.
> I would like to use OpenOffice or LibreOffice but I have not found some of
> the functions that I like such as countifs, sumifs, and averageifs.
> Because of using these functions, I do not feel that it would be an asset
> to change to OpenOffice. Any suggestions?
You have directed your question to the general Apache Community development
group. I'm sure the people over on the Apache Open Office user list are in a
much better position to answer all your questions:
http://openoffice.apache.org/mailing-lists.html#users-mailing-list-public
For more information on which mailing lists Open Office has (including various
localised lists), check out
http://openoffice.apache.org/mailing-lists.html
Hope this helps,
Isabel