Mailing-List: contact ooo-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-dev@incubator.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Subject: Re: About the new spreadsheet functions
From: drew <drew@baseanswers.com>
To: ooo-dev@incubator.apache.org
In-Reply-To: <1336829541.4514.8.camel@sybil-gnome>
References: 
	 <CAEtvNKd9D7bjkniUebS97nNzfN0i4KuCw3rR77Q95gU0unkJVg@mail.gmail.com>
	 <4FAE6508.7050307@t-online.de>  <1336829541.4514.8.camel@sybil-gnome>
Content-Type: text/plain; charset="UTF-8"
Date: Sat, 12 May 2012 09:36:15 -0400
Message-ID: <1336829775.4514.10.camel@sybil-gnome>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

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
> 
> 
>