[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-formula] 6.15.59 SUBTOTAL
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.
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]