[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-3178) 9.4.3<table:iteration>
[ http://tools.oasis-open.org/issues/browse/OFFICE-3178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eike Rathke updated OFFICE-3178:
--------------------------------
Proposal:
In 9.4.3 <table:iteration>
Replace
"
If this iterative calculations are not enabled, a formula with an iterative reference in a table causes an error message.
"
with
"
If iterative calculations are not enabled, a formula expression containing a cyclic cell reference returns an error.
"
Add
"
If table:status is true and iterating through the cyclic dependencies does not deliver a result that satisfies the condition specified with table:maximum-difference within a number of iterations specified with table:steps for all cells in the cyclic dependencies, an error is returned.
"
TBD: add HOST-... to part 1 19.644 table:formula and to part 2 3.4 Host-Defined Behaviors
Component/s: OpenFormula
There is no conflict with "iterations set in the formula", as a formula expression can't have any iterations, there are no for(;;) constructs in OpenFormula. The case here are cyclic references as in
B5: 100
B6: =B5-B7
B7: =B6*0.15
B6 references B7 and B7 references B6. With table:status='false' both formula expressions return an error. With table:status='true' a result is calculated.
We also need to add these setting to HOST-... in part 1 and part 2.
> 9.4.3 <table:iteration>
> -----------------------
>
> Key: OFFICE-3178
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-3178
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Components: OpenFormula, Table
> Affects Versions: ODF 1.2 CD 05
> Reporter: Patrick Durusau
> Assignee: Eike Rathke
> Priority: Blocker
> Fix For: ODF 1.2 CD 06
>
>
> Reads: "The <table:iteration> element enables formulas with iterative (or cyclic) references to be calculated after a specific number of iterations. If this iterative calculations are not enabled, a formula with an iterative reference in a table causes an error message."
> What is the status of this element in light of the formula proposal?
> When you look at the attributes:
> table:status - true/false on enabling iterations
> table:maximum-difference - different in values where iteration stops
> table:steps - maximum number of iterations (defaults to 100)
> Think about what happens if these conflict with the iterations set in the formula. By a user who is quite unaware that these attributes even exist.
> What to do about the error message part as well. (Bonus problem)
--
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]