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-2166) COUNTA, AVERAGEA,xxxA.... Reword to have consistent treatment of text



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

Eike Rathke updated OFFICE-2166:
--------------------------------

    Proposal: 
AVERAGEA:

Change Summary from
Average the set of numbers, including logical values inside a range.
to
Average values, including values of type Text and Logical.

Change Semantics to
Behaves similarly to the AVERAGE function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. Any N may be of type ReferenceList.


MAXA:

Change Summary from
Return the maximum from a set of numbers; logicals are always considered numbers.
to
Return the maximum from a set of values, including values of type Text and Logical.

Change Semantics to
Behaves similarly to the MAX function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. What happens when MAXA is provided 0 parameters is implementation-defined. Any N may be of type ReferenceList.


MINA:

Change Summary from
Return the minimum from a set of numbers; logicals are always considered numbers.
to
Return the minimum from a set of values, including values of type Text and Logical.

Change Semantics to
Behaves similarly to the MIN function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. What happens when MINA is provided 0 parameters is implementation-defined. Any N may be of type ReferenceList.


STDEVA:

Change Summary from
Calculates the standard deviation using a sample set of numbers.
to
Calculate the standard deviation using a sample set of values, including values of type Text and Logical.

Change Semantics from
In the sequence, only numbers and logical types are considered; cells with text are converted to 0; other types are ignored. If logical types are a distinct type, they are still included, with True considered 1 and False considered 0.
to
Behaves similarly to the STDEV function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included.

and
The handling of strings is implementation defined. Either, strings are converted to numbers, if possible and otherwise, they are treated as zero, or strings are always treated as zero.
to
The handling of string constants as parameters is implementation-defined. Either, string constants are converted to numbers, if possible and otherwise, they are treated as zero, or string constants are always treated as zero.


STDEVPA:

Change Summary from
Calculates the standard deviation using the population of a random variable.
to
Calculates the standard deviation using the population of a random variable, including values of type Text and Logical.

Change Semantics same as in STDEVA.


VARA:

Change Summary from
Estimates the variance using a sample set of numbers.
to
Estimates the variance using a sample set of values, including values of type Text and Logical.

Change Semantics same as in STDEVA.


VARPA:

Change Summary from
Calculates the variance using the population of the distribution
to
Calculates the variance using the population of the distribution, including values of type Text and Logical.

Change Semantics same as in STDEVA.


AVERAGEA semantics is wrong, it says "Computes SUMA(List) / COUNTA(List).", but SUMA is not defined.

> COUNTA, AVERAGEA, xxxA.... Reword to have consistent treatment of text
> ----------------------------------------------------------------------
>
>                 Key: OFFICE-2166
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2166
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Eric Patterson
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2
>
>
> From http://tools.oasis-open.org/issues/browse/OFFICE-662
> COUNTA, AVERAGEA, xxxA....
> Reword these xxxA functions with consistency eg treatment of text

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