OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Ambiguity in ODFF 'forced recalculation' definition


In ODF v3 part 4 section 3.5 "When recalculation occurs" [1], there is a mention of "forced recalculation marker" that is said to "indicate that (formulas) should always be recalculated during a recalculation process" (note the "always").

Later, in section 5.2 "Basic Expressions", the "forced recalculation" marker is defined as an extra EQUALS SIGN after the first one that starts formula; and is documented to indicate that the formula "should be recalculated whenever one of its predecessors it depends on changes".

Note how the second definition of the effect ("whenever one of its predecessors it depends on changes") differs from the first one ("always"). In addition, the second definition seems largely unneeded, because it would only make difference between the cases where a formula is in a cell that is *not* displayed, and is not a dependency of any displayed formula, and the implementation does not generally recalculate such formulas; while the first definition is more general, and allows to convert any formula into volatile formula.

I believe that a decision should be made, which definition is the correct one, and the two occurrences should be synchronized (or probably the redundancy in definition should be removed, by using something like "In addition, a forced recalculation marker may be used to modify when recalculation occurs, as described in the syntax below").

[1] https://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#Recalculation

Best regards,
Mike Kaganski

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]