[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**

*From*:**OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>***To*: office@lists.oasis-open.org*Date*: Thu, 31 Dec 2009 14:25:15 -0500 (EST)

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