[office-formula] 6.15.59 SUBTOTAL

[Eric Patterson <ericpa@exchange.microsoft.com>]

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.

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.

Can someone confirm this?

Thanks,
Eric