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

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

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


Subject: [OASIS Issue Tracker] Updated: (OFFICE-2030) 6.15.59 SUBTOTAL -Fuction definition doesn't mention hidden rows or additional parameters



     [ http://tools.oasis-open.org/issues/browse/OFFICE-2030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Robert Weir  updated OFFICE-2030:
---------------------------------

       Issue Type: Bug  (was: Task)
         Proposal: The treatment of hidden cells needs to be described clearly.  Excel ignores cells hidden by autofilter when the function arguments are in the range 1 to 11.  When the function argument is in the range 101 to 111, cells hidden by other methods (manually hidden, table filter) are also excluded.  (was: The treatment of hidden cells needs to be decribed clearly.  Excel ignores cells hidden by autofilter when the function arguments are in the range 1 to 11.  When the function argument is in the range 101 to 111, cells hidden by other methods (manually hidden, table filter) are also excluded.)
    Fix Version/s: ODF 1.2

> 6.15.59 SUBTOTAL - Fuction definition doesn't mention hidden rows or additional parameters
> ------------------------------------------------------------------------------------------
>
>                 Key: OFFICE-2030
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2030
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Eric Patterson
>             Fix For: ODF 1.2
>
>
> One of the primary reasons for having a SUBTOTAL function is the special behavior of ignoring hidden rows and other subtotal functions within the input range.  Also, some implementations also support values for functions in the range 101 to 111.  

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        


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