OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

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?



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

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]