[OASIS Issue Tracker] Issue Comment Edited: (OFFICE-1167) PublicComment: Re: [office-comment] ODFF: list of suggestions

[ http://tools.oasis-open.org/issues/browse/OFFICE-1167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15129#action_15129 ] 

Eike Rathke edited comment on OFFICE-1167 at 10/23/09 2:00 PM:
---------------------------------------------------------------

Many topics already resolved, things to check against reality:

> PERCENTRANK=20
> "as a percentage of the data set" - this phrase is surely=20
> meaningless - needs a rigorous description.

[ed:] TODO: new phrasing?


> LINEST=20
> needs a rewrite into clear English - it's actually wrong about=20
> multiple x values as well

[ed:] TODO: new phrasing, that's OFFICE-1185


> COUNTA, AVERAGEA, xxxA....
> Reword these xxxA functions with consistency eg treatment of text

[ed:] TODO: reword that.


> FIND=20
> Needs examples with more than one character in 'find' parameter,=20
> to show how it matches.

[ed:] TODO: add examples, additional to test cases?


> SEARCH=20
> The examples should make it clear when regexp / wildcards are on.=20
> Also show example to match literal question mark / dot etc.?=20

[ed:] TODO: add examples, additional to test cases?


> 'DateSequence' is undefined.

[ed:] TODO: still the case?


> 'NumberSequence' is not properly defined - it does not specify=20
> what happens in an array, nor what happens for a rectangular=20
> range (more than one row / column). There is no section actually=20
> defining it - merely a 'Conversion to...' section.

[ed:] again the NumberSequence, that's OFFICE-1187


      was (Author: erack):
    Many topics already resolved, things to check against reality:

> PERCENTRANK=20
> "as a percentage of the data set" - this phrase is surely=20
> meaningless - needs a rigorous description.

[ed:] TODO: new phrasing?


> LINEST=20
> needs a rewrite into clear English - it's actually wrong about=20
> multiple x values as well

[ed:] TODO: new phrasing?


> COUNTA, AVERAGEA, xxxA....
> Reword these xxxA functions with consistency eg treatment of text

[ed:] TODO: reword that.


> FIND=20
> Needs examples with more than one character in 'find' parameter,=20
> to show how it matches.

[ed:] TODO: add examples, additional to test cases?


> SEARCH=20
> The examples should make it clear when regexp / wildcards are on.=20
> Also show example to match literal question mark / dot etc.?=20

[ed:] TODO: add examples, additional to test cases?


> 'DateSequence' is undefined.

[ed:] TODO: still the case?


> 'NumberSequence' is not properly defined - it does not specify=20
> what happens in an array, nor what happens for a rectangular=20
> range (more than one row / column). There is no section actually=20
> defining it - merely a 'Conversion to...' section.

[ed:] again the NumberSequence, that's OFFICE-1187

  
> Public Comment: Re: [office-comment] ODFF: list of suggestions
> --------------------------------------------------------------
>
>                 Key: OFFICE-1167
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1167
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Robert Weir 
>            Assignee: Eike Rathke
>            Priority: Blocker
>             Fix For: ODF 1.2
>
>
> Copied from office-comment list
> Original author: Eike Rathke <> 
> Original date: 21 Dec 2008 19:54:33 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200812/msg00026.html

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