On Sat, 2012-05-12 at 09:32 -0400, drew wrote: > On Sat, 2012-05-12 at 15:26 +0200, Regina Henschel wrote: > > Hi Ricardo, > > > > RGB ES schrieb: > > > The release notes mention "ODF Spreadsheet supports new Conditional > > > Functions": COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIF. > > > > > > As far as I understand it, the support was only implemented on ODF, > > > not on Calc, but some users on the forums are confused about those > > > functions not working on AOO 3.4. Which is the right answer to their > > > questions? > > > > I think, that the release note is wrong for this functions. According to > > https://issues.apache.org/ooo/show_bug.cgi?id=90269 the implementation > > was in cws calcishmakkica. But I do not see, that this cws had been > > integrated. > > > > Eike Rathke has mentored Marina (makkica), so he should now the state of > > the work. Perhaps ask him? > > > > The cws itself is in https://bitbucket.org/mst/ooo340 > > > > Kind regards > Hi Regina > > I think you are correct - I've been fiddling since reading Ricardo's > email. Went to the ODF 1.2 document: > http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#COUNTIFS > > and constructed an example spreadsheet - I don't think countfs is being > recognized as a function at all. Countif for a single range works fine, > but swtich to countfs and add a second range, same criteria, and all it > gives is #Name error.
BTW - I did spell it correctly in the spreadsheet, countifs ;-/ > > //drew > > >
