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-2680) Part 2 changes neededto connect Parts 1 and 2

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

Robert Weir  updated OFFICE-2680:

In Part 2, replace the current section 2.4 with this:

2.4 Host-Defined Behaviors

A Formula Evaluator operates in an execution environment (a "host").  The behavior of the Formula Evaluator is parametrized by host-defined properties and functions.

The following properties are host-defined:

1.HOST-CASE-SENSISTIVE: if true, text comparisons are case-sensitive. This influences the operators =, <>, <, <=, >, and >=, as well as database query functions that use them. Note that the EXACT function is always case-sensitive, regardless of this calculation setting.

2.HOST-PRECISION-AS-SHOWN: If true, calculations are performed using rounded values of those displayed; otherwise, calculations are performed using the precision of the underlying numeric representation.  Note: This does not impose a particular numeric model.  Since implementations may use binary representations, this rounding may be inexact for decimal value.

3.HOST-SEARCH-CRITERIA_MIST-APPLY-TO-WHOLE-CELL If true, the specified search criteria shall apply to the entire cell contents if it is a text match using = or <>; if not, only the initial text needs to match.

4.HOST-AUTOMATIC-FIND-LABELS: if true, row and column labels are automatically found.

5.HOST-USE_REGULAR-EXPRESSIONS: If true, regular expressions are used for character string comparisons and when searching

6.HOST-USE-WILDCARDS: If true, wildcards question mark '?' and asterisk '*' are used for character string comparisons and when searching. Wildcards may be escaped with a tilde '~' character.

7.HOST-NULL_YEAR: This defines how to convert a two-digit year into a four-digit year. All two-digit year values are interpreted as a year that equals or follows this year.

8.HOST-NULL-DATE: Defines the beginning of the epoch; a numeric date of 0 equals this date.

9.HOST-LOCALE: The locale to be used for locale-dependent operations, such as conversion of text to dates, or text to numbers.

The following functions are host-defined

1.HOST-REFERENCE-RESOLVER(Reference): This function takes as input a Unicode string containing a Reference according to section 4.8 and returns a resolved value.

> Part 2 changes needed to connect Parts 1 and 2
> ----------------------------------------------
>                 Key: OFFICE-2680
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2680
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Sub-task
>          Components: OpenFormula
>            Reporter: Robert Weir 
>            Assignee: Robert Weir 
>             Fix For: ODF 1.2 Part 2 CD 2

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]