• Type: Improvement
    • Resolution: Unresolved
    • Priority: Minor
    • None
    • Affects Version/s: None
    • Component/s: None
    • None

      ODF 1.4 part4-formula specifies "Host-Defined Behaviors" in section 3.4. These properties are widely referenced in the formula semantics. On the other hand part3-schema specifies an element <table:calculation-settings> in section 9.4.1.

      The section "Host-Defined Behaviors" has the introductory wording "A Formula Evaluator operates in an execution environment (a "host").". This wording is vague and not really understandable. It should be added that this "execution environment" is determined by the <table:calculation-settings> element, among other things.

      In detail, there exist the relation-ships:

      table:case-sensitive (19.594) <=> HOST-CASE-SENSITIVE
      table:precision-as-shown (19.696) <=> HOST-PRECISION-AS-SHOWN
      table:search-criteria-must-apply-to-whole-cell (19.711) <=> HOST-SEARCH-CRITERIA-MUST-APPLY-TO-WHOLE-CELL
      table:automatic-find-labels (19.589) <=> HOST-AUTOMATIC-FIND-LABELS
      table:use-regular-expressions (19.748) <=> HOST-USE-REGULAR-EXPRESSIONS
      table:use-wildcards (19.749) <=> HOST-USE-WILDCARDS
      table:null-year (19.678) <=> HOST-NULL-YEAR
      <table:null-date> (9.4.2) <=> HOST-NULL-DATE
      <table:iteration> (9.4.3)
          table:status (19.726) <=> HOST-ITERATION-STATUS
          table:maximum-difference (19.670) <=> HOST-ITERATION-MAXIMUM-DIFFERENCE
          table:steps (19.728) <=> HOST-ITERATION-STEPS

      For these we could add a reference to the corresponding attribute of part3-schema to each of them.

      I don't know the source of HOST-LOCALE.

      I don't understand HOST-REFERENCE-RESOLVER function. It occurs only here. If it is meant to resolve different variants of how a cell reference is written as text, it would be relevant for functions INDIRECT (6.14.7) and ADDRESS (6.14.2). But both have an additional "A1Style" parameter for the text style and do not mention HOST-REFERENCE-RESOLVER.

            Assignee:
            Unassigned
            Reporter:
            Regina Henschel
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: