incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From drew <d...@baseanswers.com>
Subject Re: About the new spreadsheet functions
Date Sat, 12 May 2012 13:36:15 GMT
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
> 
> 
> 



Mime
View raw message