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:32:21 GMT
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.

//drew



Mime
View raw message