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-2216) Clarify patterns(regular expressions and wildcards)

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

Eike Rathke updated OFFICE-2216:

Add a section (as 2.4.1 after 2.4 Document Settings):
Where stated the match of search criteria is affected by table:use-regular-expressions or table:use-wildcards settings.

For the individual functions COUNTIF, COUNTIFS, HLOOKUP, LOOKUP, MATCH, VLOOKUP, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS and SEARCH add a reference to then 2.4.1 in normative text and remove the TODO paragraphs.

For 3.11.9 Criteria:

Bullet "A text value beginning with a comparator ...":
Change to "A value beginning with a comparator ...".
Change "For = and <>, if calculation setting ..." to "For = and <>, if the value can not be interpreted as a Number type or one of its subtypes and calculation setting ...".
Add "For = and <>, if the value can not be interpreted as a Number type or one of its subtypes 2.4.1 applies."

Add to bullet "Other text value.":
2.4.1 applies.

    Assignee: Eike Rathke  (was: Dennis Hamilton)

In ODF part1 definitions are given in sections 19.745 table:use-regular-expressions and 19.746 table:use-wildcards. OpenFormula uses these regex and wildcards definitions.

Functions affected by those settings currently have this stated in a TODO paragraph, except in 3.11.9 Criteria for database functions. The content needs to be converted to normative text. Provide a section about table:use-regular-expressions and table:use-wildcards and for the individual functions use references in normative text.

Regarding the "strange statement" in 8.4 Variances, in the context of that section I don't see anything wrong with that.

> Clarify patterns (regular expressions and wildcards)
> ----------------------------------------------------
>                 Key: OFFICE-2216
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2216
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Improvement
>          Components: Database, OpenFormula, Table
>    Affects Versions: ODF 1.2 Part 2 CD 1
>         Environment: This issue applies to OpenFormula, how open formula is profiled for ODF 1.2, and also how regular expression and wildcard patterns are used as features in OpenFormula and in unrelated parts of ODF 1.2 Part 1.
>            Reporter: David Wheeler 
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2 Part 2 CD 2
> Clarify the specification of pattern processing (regular expressions and wildcards).
> Section 3.3 briefly notes wildcards; need to define more clearly.
> Need to clearly note that table:use-regular-expressions and table:use-wildcards are mutually exclusive (at most one can be true).
> Database criteria specification (section 4.9.8) needs to be clearer.
> Each function affected by patterns (other than the database functions which are governed by the database criteria text) need to be clearly identified as such.
> David A. Wheeler will help with this.

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]