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