Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2 Part 2 CD 3
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      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-SENSITIVE: 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-MUST-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.

      Throughout the entire text, replace "table:* attribute" with the corresponding "HOST-* property".

      Show
      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-SENSITIVE: 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-MUST-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. Throughout the entire text, replace "table:* attribute" with the corresponding "HOST-* property".

      Attachments

        Activity

          People

          • Assignee:
            rcweir Robert Weir (Inactive)
            Reporter:
            rcweir Robert Weir (Inactive)
          • Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: