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 Tuesday, 2009-03-10 12:19:01 -0600, Andreas J. Guelzow wrote:

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

I also see no reason to disallow them.

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

Ignoring filtered rows is a feature of SUBTOTAL calls. And yes, the
draft clearly misses a definition for this.


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature

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