Re: [office-formula] 6.15.59 SUBTOTAL

["Andreas J. Guelzow" <aguelzow@math.concordia.ab.ca>]

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