Hi,
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.
Eike
--
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.
