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

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[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 enable 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.
"

To part 1 19.644 table:formula add:
HOST-ITERATION-STATUS  table:status  disable
HOST-ITERATION-MAXIMUM-DIFFERENCE  table:maximum-difference  0.001
HOST-ITERATION-STEPS  table:steps  100

To part 2 3.4 Host-Defined Behaviors add:

10) HOST-ITERATION-STATUS: If enabled, iterative calculations of cyclic references are performed.

11) HOST-ITERATION-MAXIMUM-DIFFERENCE: If iterative calculations of cyclic references are enabled, the maximum absolute difference between calculation steps that all involved formula cells must yield for the iteration to end and yield a result.

12) HOST-ITERATION-STEPS: If iterative calculations of cyclic references are enabled, the maximum number of steps iterations are performed if the results are not within HOST-ITERATION-MAXIMUM-DIFFERENCE.


  was:
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


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