RE: [office-formula] 6.15.59 SUBTOTAL

[Eric Patterson <ericpa@exchange.microsoft.com>]

The purpose of the SUBTOTAL function is to treat hidden rows differently otherwise the primary function (Sum, Average, etc.) could be used instead.  For this reason, explicit values don't make sense as a parameter.

-Eric

-----Original Message-----
From: Andreas J. Guelzow [mailto:aguelzow@math.concordia.ab.ca]
Sent: Tuesday, March 10, 2009 11:19 AM
To: office-formula@lists.oasis-open.org
Subject: Re: [office-formula] 6.15.59 SUBTOTAL

On Tue, 2009-03-10 at 16:35 +0000, Eric Patterson wrote:
> There are a few issues with the definition of the SUBTOTAL function in current drafts of the spec:
>
> 1.  I believe that the 2nd parameter of the function should be of type reference.  This is not reflected in the syntax or the test cases.

Why shouldn't explicit values be allowed for argument 2?
>
> 2.  The definition should describe how to handle hidden rows.  Current
> implementers of SUBTOTAL functions (Calc, Excel) ignore rows hidden by
> Autofilter, but not manually hidden rows.

Gnumeric also implements SUBTOTAL and ignores neither rows hdden by an
autofilter nor manually hidden rows.
>
> Can someone confirm this?

Nope

Andreas

--
Andreas J. Guelzow, PhD, FTICA
Coordinator, Mathematical & Computing Sciences
Concordia University College of Alberta


---------------------------------------------------------------------
To unsubscribe from this mail list, you must leave the OASIS TC that
generates this mail.  Follow this link to all your TCs in OASIS at:
https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php