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:

In 9.4.3 <table:iteration>

If this iterative calculations are not enabled, a formula with an iterative reference in a table causes an error message.
If iterative calculations are not enabled, a formula expression containing a cyclic cell reference returns an error.

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]