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

*Subject*: **[OASIS Issue Tracker] Updated: (OFFICE-1911) Public Comment:[office-formula] Problems in evaluating MULTIPLE.OPERATIONS**

*From*:**OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>***To*: office@lists.oasis-open.org*Date*: Sun, 11 Apr 2010 18:32:15 -0400 (EDT)

[ http://tools.oasis-open.org/issues/browse/OFFICE-1911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eike Rathke updated OFFICE-1911: -------------------------------- Proposal: To Semantics add: If further calls to MULTIPLE.OPERATIONS are encountered in the dependencies, replacements of target cells shall occur in queued order, with each replacement using the result of the previous replacement. Description: Copied from office-comment list Original author: Regina Henschel <rb.henschel@t-online.de> Original date: 22 Jun 2009 19:23:14 -0000 Original URL: http://lists.oasis-open.org/archives/office-comment/200906/msg00031.html Some details: Example, data and formulas in cells: A1: 2 A2: 3 A3: =A1+A2 A4: 30 A5: =MULTIPLE.OPERATIONS(A3;A2;A4) A6: 700 A7: =MULTIPLE.OPERATIONS(A5;A2;A6) What is the result of A7? Original author's comment: Evaluating the MULTIPLE.OPERATIONS in A7 means to use the referenced formula from A5 and replace A2 there with A6 and remember to replace all A2 with A6 in its precedents. So A7 is evaluated as if it contains the formula =MULTIPLE.OPERATIONS(A3;A6;A4) with additional remark to replace A2 with A6 in further evaluation. This MULTIPLE.OPERATIONS(A3;A6;A4) now is evaluated using the referenced formula from A3 with replacing all A6 with A4 in the formula itself and all its precedents. Looking at the referenced formula in A3 we see =A1+A2. We remember to replace A2 with A6 (from A7) and remember to replace A6 with A4 (from A5). But in what order? First from A7, then from A5 results in the replacement =A1+A6 and then =A1+A4, and the final result 32. First from A5, then from A7 results in the replacement =A1+A2 (no A6 no replacement) and then =A1+A6, and the final result 702. I cannot determine from the spec, which is the correct result. was: Copied from office-comment list Original author: Regina Henschel <rb.henschel@t-online.de> Original date: 22 Jun 2009 19:23:14 -0000 Original URL: http://lists.oasis-open.org/archives/office-comment/200906/msg00031.html Some details: Example, data and formulas in cells: A1: 2 A2: 3 A3: =A1+A2 A4: 30 A5: =MULTIPLE.OPERATIONS(A3;A2;A4) A6: 700 A7: =MULTIPLE.OPERATIONS(A5;A2;A6) What is the result of A7? Original author's comment: Evaluating the MULTIPLE.OPERATIONS in A7 means to use the referenced formula from A5 and replace A2 there with A6 and remember to replace all A2 with A6 in its precedents. So A7 is evaluated as if it contains the formula =MULTIPLE.OPERATIONS(A3;A6;A4) with additional remark to replace A2 with A6 in further evaluation. This MULTIPLE.OPERATIONS(A3;A6;A4) now is evaluated using the referenced formula from A3 with replacing all A6 with A4 in the formula itself and all its precedents. Looking at the referenced formula in A3 we see =A1+A2. We remember to replace A2 with A6 (from A7) and remember to replace A6 with A4 (from A5). But in what order? First from A7, then from A5 results in the replacement =A1+A6 and then =A1+A4, and the final result 32. First from A5, then from A7 results in the replacement =A1+A2 (no A6 no replacement) and then =A1+A6, and the final result 702. I cannot determine from the spec, which is the correct result. The replacement shall occur in the order the MULTIPLE.OPERATIONS calls are encountered. In the example the replacement would be first from A7 replacing A2 with A6 (=A1+A6), then from A5 replacing A6 with A4 (=A1+A4), the result would be 32. Note: OOo currently (3.2) does only one replacement, for this example from A7 replacing A2 with A6 (=A1+A6) and the result is 702. > Public Comment: [office-formula] Problems in evaluating MULTIPLE.OPERATIONS > --------------------------------------------------------------------------- > > Key: OFFICE-1911 > URL: http://tools.oasis-open.org/issues/browse/OFFICE-1911 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: Bug > Components: OpenFormula > Affects Versions: ODF 1.2 Part 2 CD 1 > Environment: This issue applies to 5.14.10 in OpenDocument-part2-draft18-editor-revision.odt. > Reporter: Robert Weir > Assignee: Eike Rathke > Priority: Blocker > Fix For: ODF 1.2 Part 2 CD 2 > > > Copied from office-comment list > Original author: Regina Henschel <rb.henschel@t-online.de> > Original date: 22 Jun 2009 19:23:14 -0000 > Original URL: http://lists.oasis-open.org/archives/office-comment/200906/msg00031.html > Some details: > Example, data and formulas in cells: > A1: 2 > A2: 3 > A3: =A1+A2 > A4: 30 > A5: =MULTIPLE.OPERATIONS(A3;A2;A4) > A6: 700 > A7: =MULTIPLE.OPERATIONS(A5;A2;A6) > What is the result of A7? > Original author's comment: > Evaluating the MULTIPLE.OPERATIONS in A7 means to use the referenced formula from A5 and replace A2 there with A6 and remember to replace all A2 with A6 in its precedents. > So A7 is evaluated as if it contains the formula =MULTIPLE.OPERATIONS(A3;A6;A4) with additional remark to replace A2 with A6 in further evaluation. > This MULTIPLE.OPERATIONS(A3;A6;A4) now is evaluated using the referenced formula from A3 with replacing all A6 with A4 in the formula itself and all its precedents. > Looking at the referenced formula in A3 we see =A1+A2. We remember to replace A2 with A6 (from A7) and remember to replace A6 with A4 (from A5). But in what order? > First from A7, then from A5 results in the replacement =A1+A6 and then =A1+A4, and the final result 32. > First from A5, then from A7 results in the replacement =A1+A2 (no A6 no replacement) and then =A1+A6, and the final result 702. > I cannot determine from the spec, which is the correct result. -- 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]