Re: Functions in OpenOffice
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
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 isa...@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
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.